protected void BtnNew_Click(object sender, EventArgs e) { ClearAll(); GridView1.DataSource = null; clsReceive Dal = new clsReceive(); DataSet obj = new DataSet(); obj = Dal.GenerateNewReceiveId(); txtRecId.Text = (obj.Tables[0].Rows[0][0]).ToString(); }
protected void BtnUpdate_Click(object sender, EventArgs e) { BLayer.Receive obj = InitalizeObject(); clsReceive Dal = new clsReceive(); Dal.UpdateReceive(obj); Dal.UpdateProductDetail(obj); LoadGrid(); ClearAll(); }
private void LoadManuf() { clsReceive Dal = new clsReceive(); DataSet Manuf = Dal.FillManufacturer(); ddlProdManfacturer.DataTextField = "ManufacturerName"; ddlProdManfacturer.DataValueField = "ManufacturerID"; ddlProdManfacturer.DataSource = Manuf.Tables[0]; ddlProdManfacturer.DataBind(); ddlProdManfacturer.Items.Insert(0, "--Please Make Selection--"); ddlProdManfacturer.Items[0].Value = "0"; }
private void LoadSupplier() { clsReceive Dal = new clsReceive(); DataSet supplier = Dal.FillSupplier(); ddlSupplier.DataTextField = "SupplierName"; ddlSupplier.DataValueField = "SupplierId"; ddlSupplier.DataSource = supplier.Tables[0]; ddlSupplier.DataBind(); ddlSupplier.Items.Insert(0, "--Please Make Selection--"); ddlSupplier.Items[0].Value = "0"; }
protected void BtnSave_Click(object sender, EventArgs e) { //BLayer.Receive obj = InitalizeObject(); //receives.Add(obj); //LoadGridinMemory(); //ClearAll(); clsReceive Dal = new clsReceive(); BLayer.Receive obj = InitalizeObject(); Dal.AddNewReceive(obj); Dal.AddNewProductDetail(obj); LoadGrid(); clearAfterSave(); }
protected void BtnDelete_Click(object sender, EventArgs e) { clsReceive Dal = new clsReceive(); string Recid = txtRecId.Text; bool IsPriced = Dal.IsProductsGotPrice(Recid); if (IsPriced == false) { Dal.DeleteReceive(Recid); Dal.DeleteReceiveDetail(Recid); ClearAll(); GridView1.DataSource = null; GridView1.DataBind(); } else { errorLabel.Text = " you are unable to delete. Those products ready for sale"; } }
private void FindReceiveByRecId(string recId) { clsReceive Dal = new clsReceive(); DataSet recevie = Dal.LoadReceiveFromDB(recId); GridView1.DataSource = recevie.Tables[0]; GridView1.DataBind(); decimal total = recevie.Tables[0].AsEnumerable().Sum(row => row.Field <decimal>("UnitCost")); if (total != 0) { GridView1.FooterRow.Cells[5].Text = "Total"; GridView1.FooterRow.Cells[5].HorizontalAlign = HorizontalAlign.Right; GridView1.FooterRow.Cells[6].Text = total.ToString("N2"); } else { errorLabel.Text = "No Record related to this Id"; } }