processpayment

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Text.RegularExpressions;

namespace Parkinglotmanagementsystem
{
    public partial class b : Form
    {
        public b()
        {
            InitializeComponent();
        }

        private bool isNotEmpty()
        {
            bool flag = true;
            //return (cbtype.Text != string.Empty && txtplate.Text != string.Empty &&
            //        txtTimeIn.Text != string.Empty && txtpayment.Text != string.Empty);
            if (cbtype.Text != string.Empty && txtplate.Text != string.Empty &&
                    txtTimeIn.Text != string.Empty && txtpayment.Text != string.Empty)
            {
                flag = true;
            }
            else
            {
                flag = false;
            }
            return flag;
        }

        private void Clear()
        {
            txtticket.Text = p.Generate_TicketNo();
            Load_Datas();
            txtplate.Clear();
            cbtype.Text = string.Empty;
            txtplate.Clear();
            txtTimeIn.Clear();
            txtTimeOut.Clear();
            txtconsume.Clear();
            txtpayment.Clear();
            txtcash.Clear();
            txtchange.Clear();
            cbtype.Focus();
        }

        private void btnadd_Click(object sender, EventArgs e)
        {
            //insert..
            if (plate())
            {
                if (isNotEmpty())
                {
                    p.Insert(txtticket.Text, cbtype.Text, txtplate.Text, txtTimeIn.Text, txtTimeOut.Text, txtconsume.Text,
                        txtpayment.Text, txtcash.Text, txtchange.Text);
                    MessageBox.Show("Successfully added", string.Empty, MessageBoxButtons.OK, MessageBoxIcon.Information);
                    Clear();
                }
            }
            else
            {
                MessageBox.Show("The plate number must contain 3 Uppercase and 3 numeric!");
            }
        }

        Payments p = new Payments(clsDbconnection.Connect());
        private void txtticket_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                //
            }
        }

        private void Load_Datas()
        {
            lvipayment.Items.Clear();
            DataTable dt = p.Load_Datas();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                lvipayment.Items.Add(new ListViewItem(new string[]
                {
                    DateTime.Parse(dt.Rows[i]["Date"].ToString()).ToShortDateString(),
                    dt.Rows[i]["TicketID"].ToString(),
                    dt.Rows[i]["VehicleType"].ToString(),
                    dt.Rows[i]["Platenumber"].ToString(),
                    dt.Rows[i]["Timein"].ToString(),
                    dt.Rows[i]["Timeout"].ToString(),
                    dt.Rows[i]["HoursConsumed"].ToString(),
                    dt.Rows[i]["TotalPayment"].ToString(),
                    dt.Rows[i]["Cash"].ToString(),
                    dt.Rows[i]["Change"].ToString()
                }));
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            CheckForIllegalCrossThreadCalls = false;
            txtticket.Text = p.Generate_TicketNo();
            Load_Datas();
            timer1.Interval = 1000;
            timer1.Enabled = true;
            timer1.Start();
        }
        private bool plate()
        {
            bool flag = true;
            if (Regex.IsMatch(txtplate.Text, @"^(?=.*[A-Z])(?=.*\d).{6,6}$"))
            {
                flag = true;
            }
            else
            {
                flag = false;
            }
            return flag;
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            txtTimeIn.Text = DateTime.Now.ToShortTimeString();
        }



        private void btnclear_Click(object sender, EventArgs e)
        {
            //update...
            p.Update(txtticket.Text, txtTimeOut.Text, txtconsume.Text, txtpayment.Text, txtcash.Text, txtchange.Text);
            MessageBox.Show("Successfully paid");
            Clear();
            timer1.Enabled = true;
            timer1.Start();
        }

        private void cbtype_SelectedIndexChanged(object sender, EventArgs e)
        {
            switch (cbtype.Text)
            {
                case "Truck":
                    {
                        txtpayment.Text = "0.00";
                        txtTimeOut.Text = "0";
                    }
                    break;
                case "Jeep":
                    {
                        txtpayment.Text = "0.00";
                        txtTimeOut.Text = "0";
                    }
                    break;
                case "Car":
                    {
                        txtpayment.Text = "0.00";
                        txtTimeOut.Text = "0";
                    }
                    break;
                default:
                    {
                        txtpayment.Text = "0.00";
                        txtTimeOut.Text = "0";
                    }
                    break;
            }
        }

        private void txtcash_TextChanged(object sender, EventArgs e)
        {
            try
            {
                if (txtcash.Text.Length > 0 && !txtcash.Text.Equals("0") && double.Parse(txtcash.Text) >= double.Parse(txtpayment.Text))
                {
                    txtchange.Text = double.Parse(txtcash.Text) >= double.Parse(txtpayment.Text) ?
                                     (double.Parse(txtcash.Text) - double.Parse(txtpayment.Text)).ToString() : "0";
                    txtchange.Text = double.Parse(txtchange.Text) < 0 ? "0" : txtchange.Text;
                    btnupdate.Enabled = true;
                }
                else
                {
                    btnupdate.Enabled = false;
                }
            }
            catch {
                btnupdate.Enabled = false; }
        }

        private void txtsearch_TextChanged(object sender, EventArgs e)
        {
            if (txtsearch.Text.Length > 0)
            {
                lvipayment.Items.Clear();
                DataTable dt = p.Load_Details(txtsearch.Text);
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        lvipayment.Items.Add(new ListViewItem(new string[]
                {
                    DateTime.Parse(dt.Rows[i]["Date"].ToString()).ToShortDateString(),
                    dt.Rows[i]["TicketID"].ToString(),
                    dt.Rows[i]["VehicleType"].ToString(),
                    dt.Rows[i]["Platenumber"].ToString(),
                    dt.Rows[i]["Timein"].ToString(),
                    dt.Rows[i]["Timeout"].ToString(),
                    dt.Rows[i]["HoursConsumed"].ToString(),
                    dt.Rows[i]["TotalPayment"].ToString(),
                    dt.Rows[i]["Cash"].ToString(),
                    dt.Rows[i]["Change"].ToString()
                }));
                    }
                }
                else
                {
                    MessageBox.Show("No result found");
                }

            }
        }

        private void txtsearch_KeyDown(object sender, KeyEventArgs e)
        {

            if (e.KeyValue.Equals(13))
            {
                timer1.Enabled = false;
                timer1.Stop();

                DataTable dt = p.Search_Load_Details(txtsearch.Text);
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    txtticket.Text = dt.Rows[i]["TicketID"].ToString();
                    cbtype.Text = dt.Rows[i]["VehicleType"].ToString();
                    txtplate.Text = dt.Rows[i]["Platenumber"].ToString();
                    txtTimeOut.Text = DateTime.Now.ToShortTimeString();
                    txtTimeIn.Text = dt.Rows[i]["Timein"].ToString();
                    string hour = DateTime.Parse(DateTime.Now.ToShortTimeString()).Subtract(DateTime.Parse(txtTimeIn.Text)).TotalHours.ToString();
                    string[] time = hour.Split(new char[] { '.' });
                    txtconsume.Text = int.Parse(time[1].Substring(0,1)) > 4 ? (int.Parse(time[0]) + 1).ToString() :
                                      int.Parse(time[0]).Equals(0) ? "1" : time[0];
                    txtpayment.Text = (int.Parse(txtconsume.Text) * 30).ToString();
                    btnadd.Enabled = false;
                }
            }
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            switch (comboBox1.Text)
            {
                case "All":
                    {
                        lvipayment.Items.Clear();
                        DataTable dt = p.Load_All_Datas();
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            lvipayment.Items.Add(new ListViewItem(new string[]
                            {
                                DateTime.Parse(dt.Rows[i]["Date"].ToString()).ToShortDateString(),
                                dt.Rows[i]["TicketID"].ToString(),
                                dt.Rows[i]["VehicleType"].ToString(),
                                dt.Rows[i]["Platenumber"].ToString(),
                                dt.Rows[i]["Timein"].ToString(),
                                dt.Rows[i]["Timeout"].ToString(),
                                dt.Rows[i]["HoursConsumed"].ToString(),
                                dt.Rows[i]["TotalPayment"].ToString(),
                                dt.Rows[i]["Cash"].ToString(),
                                dt.Rows[i]["Change"].ToString()
                            }));
                        }
                    }
                    break;
                case "Unpaid":
                    {
                        lvipayment.Items.Clear();
                        DataTable dt = p.Load_Datas_Unpaid();
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            lvipayment.Items.Add(new ListViewItem(new string[]
                            {
                                DateTime.Parse(dt.Rows[i]["Date"].ToString()).ToShortDateString(),
                                dt.Rows[i]["TicketID"].ToString(),
                                dt.Rows[i]["VehicleType"].ToString(),
                                dt.Rows[i]["Platenumber"].ToString(),
                                dt.Rows[i]["Timein"].ToString(),
                                dt.Rows[i]["Timeout"].ToString(),
                                dt.Rows[i]["HoursConsumed"].ToString(),
                                dt.Rows[i]["TotalPayment"].ToString(),
                                dt.Rows[i]["Cash"].ToString(),
                                dt.Rows[i]["Change"].ToString()
                            }));
                        }
                    }
                    break;
                default:
                    {
                        lvipayment.Items.Clear();
                        DataTable dt = p.Load_Datas_Paid();
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            lvipayment.Items.Add(new ListViewItem(new string[]
                            {
                                DateTime.Parse(dt.Rows[i]["Date"].ToString()).ToShortDateString(),
                                dt.Rows[i]["TicketID"].ToString(),
                                dt.Rows[i]["VehicleType"].ToString(),
                                dt.Rows[i]["Platenumber"].ToString(),
                                dt.Rows[i]["Timein"].ToString(),
                                dt.Rows[i]["Timeout"].ToString(),
                                dt.Rows[i]["HoursConsumed"].ToString(),
                                dt.Rows[i]["TotalPayment"].ToString(),
                                dt.Rows[i]["Cash"].ToString(),
                                dt.Rows[i]["Change"].ToString()
                            }));
                        }
                    }
                    break;
            }
        }
    }
}
class
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace Parkinglotmanagementsystem
{
    class Payments
    {
        private SqlConnection connect;
        private int count;
        private SqlCommand cmd;
        private SqlDataAdapter da;
        private DataSet ds;
        private DataTable dt;
        public Payments(SqlConnection con)
        {
            connect = con;
        }

        public string Generate_TicketNo()
        {
            if (connect.State == ConnectionState.Closed)
            {
                connect.Open();
            }
            cmd = new SqlCommand("select count(*) from tblpayment",connect);
            count = (int)cmd.ExecuteScalar();
            connect.Close();

            da = new SqlDataAdapter("select TOP 1 * from tblpayment order by TicketID desc", connect);
            ds = new DataSet();
            da.Fill(ds, "tblpayment");
            dt = new DataTable ();
            dt = ds.Tables[0];
            string last_id = string.Empty;
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                last_id = dt.Rows[i]["TicketID"].ToString().Remove(0,4);
            }
            return count.Equals(0) ? "T" + DateTime.Now.Year.ToString().Substring(2, 2) + "-" +
                                       (count + 1).ToString().PadLeft(4, '0') :
                                       "T" + DateTime.Now.Year.ToString().Substring(2, 2) + "-" +
                                       (int.Parse(last_id) + 1).ToString().PadLeft(4, '0');
        }

        public void Insert(string ticketID, string vehicleType, string plateNo,
                           string timeIN, string timeOut, string hoursConsumed,
                           string totalPayment, string cash, string change)
        {
            if (connect.State == ConnectionState.Closed)
            {
                connect.Open();
            }
            cmd = new SqlCommand("insert into tblpayment values(@TicketID,@VehicleType,@Platenumber,@Timein," +
                                 "@Timeout,@HoursConsumed,@TotalPayment,@Cash,@Change,@Date,'Unpaid')",connect);
            cmd.Parameters.AddWithValue("@TicketID", ticketID);
            cmd.Parameters.AddWithValue("@VehicleType", vehicleType);
            cmd.Parameters.AddWithValue("@Platenumber", plateNo);
            cmd.Parameters.AddWithValue("@Timein", timeIN);
            cmd.Parameters.AddWithValue("@Timeout", timeOut);
            cmd.Parameters.AddWithValue("@HoursConsumed", hoursConsumed);
            cmd.Parameters.AddWithValue("@TotalPayment", totalPayment);
            cmd.Parameters.AddWithValue("@Cash", cash);
            cmd.Parameters.AddWithValue("@Change", change);
            cmd.Parameters.AddWithValue("@Date", DateTime.Now);
            cmd.ExecuteNonQuery();
            connect.Close();
        }

        public void Update(string ticketID,string timeOut, string hoursConsumed,
                           string totalPayment, string cash, string change)
        {
            if (connect.State == ConnectionState.Closed)
            {
                connect.Open();
            }
            cmd = new SqlCommand("update tblpayment set Timeout =@Timeout, HoursConsumed = @HoursConsumed, " +
                                 "TotalPayment = @TotalPayment,Cash = @Cash,Change = @Change,Status = 'Paid' where TicketID = @TicketID", connect);//values(@TicketID
            cmd.Parameters.AddWithValue("@TicketID", ticketID);
            cmd.Parameters.AddWithValue("@Timeout", timeOut);
            cmd.Parameters.AddWithValue("@HoursConsumed", hoursConsumed);
            cmd.Parameters.AddWithValue("@TotalPayment", totalPayment);
            cmd.Parameters.AddWithValue("@Cash", cash);
            cmd.Parameters.AddWithValue("@Change", change);
            cmd.ExecuteNonQuery();
            connect.Close();
        }

        public DataTable Load_Datas()
        {
            da = new SqlDataAdapter("select * from tblpayment where Status = 'Unpaid'",connect);
            ds = new DataSet();
            da.Fill(ds);
            return ds.Tables[0];
        }

        public DataTable Load_Datas_Unpaid()
        {
            da = new SqlDataAdapter("select * from tblpayment where Status = 'Unpaid'", connect);
            ds = new DataSet();
            da.Fill(ds);
            return ds.Tables[0];
        }

        public DataTable Load_Datas_Paid()
        {
            da = new SqlDataAdapter("select * from tblpayment where Status = 'Paid'", connect);
            ds = new DataSet();
            da.Fill(ds);
            return ds.Tables[0];
        }


        public DataTable Load_All_Datas()
        {
            da = new SqlDataAdapter("select * from tblpayment", connect);
            ds = new DataSet();
            da.Fill(ds);
            return ds.Tables[0];
        }

        public DataTable Load_Details(string ticket_id)
        {
            if (ticket_id.Contains("'"))
            {
                ticket_id = ticket_id.Replace("'", string.Empty);
            }
            da = new SqlDataAdapter("select * from tblpayment where TicketID like '" + ticket_id + "%' or " +
                                    "VehicleType like '@id%' and Status = 'Unpaid'", connect);
            da.SelectCommand.Parameters.AddWithValue("@id", ticket_id);
            ds = new DataSet();
            da.Fill(ds);
            return ds.Tables[0];
        }


        public DataTable Search_Load_Details(string ticket_id)
        {
            da = new SqlDataAdapter("select * from tblpayment where TicketID = @ticket_id and Status = 'Unpaid'", connect);
            da.SelectCommand.Parameters.AddWithValue("@ticket_id", ticket_id);
            ds = new DataSet();
            da.Fill(ds,"tblpayment");
            return ds.Tables[0];
        }
        //
    }
}