protected void btnEditPurchaseItem_Click(object sender, ImageClickEventArgs e) { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.DierctSellDetail PurcahseOrderdetaildr = Mdb.DierctSellDetails.Single(a => a.Id == long.Parse(hfPurchaseDetailsId.Value)); PurcahseOrderdetaildr.ItemColorId = int.Parse(ddlItemColor.SelectedValue); PurcahseOrderdetaildr.ItemId = long.Parse(ddlItemName.SelectedValue); PurcahseOrderdetaildr.Note = txtPurchaseNote.Text; PurcahseOrderdetaildr.Qty = decimal.Parse(txtQty.Text); Mdb.SaveChanges(); gvPurchaseDetailsData.DataBind(); }
protected void gvPurchaseDetailsData_SelectedIndexChanged(object sender, EventArgs e) { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.DierctSellDetail PurchaseDetailsdr = Mdb.DierctSellDetails.Single(a => a.Id == long.Parse(gvPurchaseDetailsData.SelectedDataKey.Value.ToString())); hfPurchaseDetailsId.Value = PurchaseDetailsdr.Id.ToString(); GetItemDatabyID(PurchaseDetailsdr.ItemId); ddlItemColor.SelectedValue = PurchaseDetailsdr.ItemColorId.ToString(); txtQty.Text = PurchaseDetailsdr.Qty.ToString(); txtPurchaseNote.Text = PurchaseDetailsdr.Note; ddlItemColor_SelectedIndexChanged(sender, e); }
protected void btndeletePurchaseItem_Click(object sender, ImageClickEventArgs e) { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.DierctSellDetail PurcahseOrderdetaildr = Mdb.DierctSellDetails.Single(a => a.Id == long.Parse(hfPurchaseDetailsId.Value)); Mdb.DierctSellDetails.Remove(PurcahseOrderdetaildr); Mdb.SaveChanges(); gvPurchaseDetailsData.DataBind(); var PurchaseOrderHeaderRows = from a in Mdb.DierctSellDetails where a.DirectSellHeaderId == long.Parse(hfId.Value) select a; if (PurchaseOrderHeaderRows.Count() <= 0) { ADAM.DataBase.DirectSellData PurchaseHeadedr = Mdb.DirectSellDatas.Single(a => a.Id == long.Parse(hfId.Value)); Mdb.DirectSellDatas.Remove(PurchaseHeadedr); Mdb.SaveChanges(); btnNew_Click(sender, e); } }