public void LoadAll() { string sql = "SELECT * FROM Sold_Product"; this.dt = DataAccess.GetDataTable(sql); this.count = dt.Rows.Count; this.arr = new SoldProductcs[this.count]; for (int i = 0; i < this.count; i++) { SoldProductcs p = new SoldProductcs(); p.BranchID = Convert.ToInt32(dt.Rows[i]["Branch_ID"]); p.ProductId = Convert.ToInt32(dt.Rows[i]["PID"]); p.Pname = dt.Rows[i]["PName"].ToString(); p.ProductSalesUnitPrice = Convert.ToInt32(dt.Rows[i]["P_Sales_Unit_Price"]); p.Ptype = dt.Rows[i]["P_Type"].ToString(); p.ProdducExpDate = dt.Rows[i]["P_EXP_Date"].ToString(); p.MfgDate = dt.Rows[i]["P_MFG_Date"].ToString(); p.Quantity = Convert.ToInt32(dt.Rows[i]["P_Quantity"]); p.TotalPrice = Convert.ToInt32(dt.Rows[i]["P_Total_Price"]); p.CashMemoNo = Convert.ToInt32(dt.Rows[i]["Cash_Memo_NO"]); p.SoldDate = dt.Rows[i]["Sold_Date"].ToString(); this.arr[i] = p; } }
public bool searchbybid(int temp2) { string sql = "select * from Sold_Product where Branch_ID=" + temp2; this.dt = DataAccess.GetDataTable(sql); this.count = dt.Rows.Count; this.arr = new SoldProductcs[this.count]; if (this.count > 0) { for (int i = 0; i < this.count; i++) { SoldProductcs p = new SoldProductcs(); p.BranchID = Convert.ToInt32(dt.Rows[i]["Branch_ID"]); p.ProductId = Convert.ToInt32(dt.Rows[i]["PID"]); p.Pname = dt.Rows[i]["PName"].ToString(); p.ProductSalesUnitPrice = Convert.ToInt32(dt.Rows[i]["P_Sales_Unit_Price"]); p.Ptype = dt.Rows[i]["P_Type"].ToString(); p.ProdducExpDate = dt.Rows[i]["P_EXP_Date"].ToString(); p.MfgDate = dt.Rows[i]["P_MFG_Date"].ToString(); p.Quantity = Convert.ToInt32(dt.Rows[i]["P_Quantity"]); p.TotalPrice = Convert.ToInt32(dt.Rows[i]["P_Total_Price"]); p.CashMemoNo = Convert.ToInt32(dt.Rows[i]["Cash_Memo_NO"]); p.SoldDate = dt.Rows[i]["Sold_Date"].ToString(); this.arr[i] = p; } return(true); } else { return(false); } }
private void button2_Click(object sender, EventArgs e) { CashMemo cm = new CashMemo(); cm.CustomerName = textBoxCname.Text; cm.CustomerPhone = Convert.ToInt32(textBoxcPhone.Text); cm.Date = DateTime.Today.ToShortDateString(); cm.newentry(); cm.CashMemoNO = cm.returnid(); for (int i = 0; i <= Rowcount - 1; i++) { SoldProductcs sp = new SoldProductcs(); sp.BranchID = LoginForm.BRCHID; sp.ProductId = Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value); Branch_Product bp1 = new Branch_Product(); bp1.Productid = sp.ProductId; bp1.BranchId = sp.BranchID; bp1.ptype2(); sp.Pname = bp1.ProductName; sp.ProductSalesUnitPrice = bp1.SalesPrice; sp.Ptype = bp1.ProductType; sp.ProdducExpDate = bp1.ProductExpdate; sp.MfgDate = bp1.ProductMfgdate; sp.Quantity = Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value); bp1.Quantity -= sp.Quantity; bp1.proupdate2(bp1.Quantity); sp.TotalPrice = Convert.ToInt32(dataGridView1.Rows[i].Cells[4].Value); sp.CashMemoNo = cm.CashMemoNO; sp.SoldDate = DateTime.Today.ToShortDateString(); sp.newentry(); } }