public POSystem(string name) { InitializeComponent(); Cr_L_User.Text = name; DateTime today = DateTime.Today; int PO_Number = 0; POConn conn = new POConn(); DataTable PO = conn.SelectQuery("SELECT MAX(PO_NUMBER) FROM PURCHASE_ORDERS"); //MessageBox.Show(PO.Rows.Count.ToString()); foreach (DataRow row in PO.Rows) { if (row[0] != DBNull.Value) { PO_Number = Convert.ToInt32(row[0].ToString()) + 1; } else { PO_Number = 1; } } Cr_L_PO.Text = PO_Number.ToString(); }
public int CreatePO() { int PO = Convert.ToInt32(Cr_L_PO.Text); String store = Cr_DD_Store.Text.ToUpper(); String company_name = Cr_TB_Company.Text.ToUpper(); String address = IsEmpty(Cr_TB_Address.Text) ? "N/A": Cr_TB_Address.Text.ToUpper(); DateTime PODate = Cr_DD_PODate.Value.Date; DateTime DueDate = Cr_DD_DueDate.Value.Date; String del_address = IsEmpty(Cr_TB_Delivery.Text) ? "N/A" : Cr_TB_Delivery.Text.ToUpper(); String terms = IsEmpty(Cr_TB_Terms.Text) ? "N/A" : Cr_TB_Terms.Text.ToUpper(); POConn conn = new POConn(); int POId = conn.InsertPO(PODate, PO, store, company_name, address, DueDate, terms, del_address, Cr_L_User.Text, DateTime.Now); string outputrowid = ""; foreach (DataGridViewRow row in Cr_DGV_Order.Rows) { outputrowid += conn.InsertOrder( PODate, PO, Convert.ToInt32(row.Cells[0].Value.ToString()), row.Cells[1].Value.ToString(), row.Cells[2].Value.ToString(), Convert.ToDouble(row.Cells[3].Value.ToString()), Convert.ToDouble(row.Cells[4].Value.ToString()), DateTime.Now, POId); } return(POId); }
public void Retrieve_info() { POConn conn = new POConn(); DataTable result = conn.RetrievePODetails(Cr_L_PO.Text); if (result.Rows.Count > 0) { DataRow row = result.Rows[0]; Cr_DD_PODate.Value = DateTime.Parse(row[0].ToString()); Cr_TB_Terms.Text = row[6].ToString(); Cr_DD_Store.Text = row[2].ToString(); Cr_TB_Company.Text = row[3].ToString(); Cr_TB_Address.Text = row[4].ToString(); Cr_DD_DueDate.Value = DateTime.Parse(row[5].ToString()); Cr_TB_Delivery.Text = row[7].ToString(); Cr_L_User.Text = row[8].ToString(); DataTable order_result = conn.RetrievePO_Order_Details(Cr_L_PO.Text); foreach (DataRow rows in order_result.Rows) { Cr_DGV_Order.Rows.Add( rows[0].ToString(), rows[1].ToString(), rows[2].ToString(), rows[3].ToString(), rows[4].ToString()); } } }
private void V_B_Search_Click(object sender, EventArgs e) { V_DGV_Results.Rows.Clear(); POConn conn = new POConn(); DataTable PO_List = conn.SearchPO(V_DD_PODate.Value.Date.ToString("yyyy-MM-dd"), V_V_PO.Text, V_DD_Company.Text, V_DD_Store.Text); foreach (DataRow item in PO_List.Rows) { V_DGV_Results.Rows.Add(item[0].ToString(), item[1].ToString(), item[2].ToString(), item[3].ToString()); } }
private void Cr_B_Save_Click(object sender, EventArgs e) { if (!IsEmpty(Cr_TB_Company.Text)) { if (!IsDGVEmpty(Cr_DGV_Order)) { POConn conn = new POConn(); conn.DeletePO(Cr_L_PO.Text); CreatePO(); MessageBox.Show("PO #:" + Cr_L_PO.Text + " has been saved."); this.Close(); } else { MessageBox.Show("Item list cannot be empty."); } } else { MessageBox.Show("Company name cannot be empty."); } }
private void L_B_OK_Click(object sender, EventArgs e) { string name = L_TB_User.Text; string pw = L_TB_Password.Text; POConn L_Conn = new POConn(); DataTable cred = L_Conn.SelectQuery("SELECT USER_NAME, PASSWORD FROM USERS WHERE USER_NAME=LOWER('" + name + "') AND PASSWORD=('" + pw + "')"); if (cred.Rows.Count > 0) { POSystem POSystem = new POSystem(name); POSystem.Show(); this.Hide(); POSystem.FormClosing += POSystem_Closing; } else { MessageBox.Show("Incorrect User Name and/or Password"); } }
private void Cr_B_Save_Click(object sender, EventArgs e) { //MessageBox.Show(Cr_DGV_Order.Rows.Count.ToString()); if (!IsEmpty(Cr_TB_Company.Text)) { if (!IsDGVEmpty(Cr_DGV_Order)) { POConn conn = new POConn(); CreatePO(); MessageBox.Show("PO #:" + Cr_L_PO.Text + " has been saved."); Cr_L_PO.Text = (Convert.ToInt32(Cr_L_PO.Text) + 1).ToString(); Cr_DGV_Order.Rows.Clear(); } else { MessageBox.Show("Item list cannot be empty."); } } else { MessageBox.Show("Company name cannot be empty."); } }