protected void btndeletePurchaseItem_Click(object sender, ImageClickEventArgs e) { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.DeliveryDataDetail PurcahseOrderdetaildr = Mdb.DeliveryDataDetails.Single(a => a.Id == long.Parse(hfPurchaseDetailsId.Value)); if (PurcahseOrderdetaildr.Status > 1) { Response.Write("<script>alert('لا يمكن حذف هذا الصنف حيث انه قد تم تسليمه')</script>"); return; } else { Mdb.DeliveryDataDetails.Remove(PurcahseOrderdetaildr); Mdb.SaveChanges(); gvDeliveryData.DataBind(); var PurchaseOrderHeaderRows = from a in Mdb.DeliveryDataDetails where a.DeliveryDataHeaderId == long.Parse(hfId.Value) select a; if (PurchaseOrderHeaderRows.Count() <= 0) { ADAM.DataBase.DeliveryDataHeader PurchaseHeadedr = Mdb.DeliveryDataHeaders.Single(a => a.Id == long.Parse(hfId.Value)); Mdb.DeliveryDataHeaders.Remove(PurchaseHeadedr); Mdb.SaveChanges(); btnNew_Click(sender, e); } } }
protected void gvPurchaseDetailsData_SelectedIndexChanged(object sender, EventArgs e) { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.DeliveryDataDetail PurchaseDetailsdr = Mdb.DeliveryDataDetails.Single(a => a.Id == long.Parse(gvDeliveryData.SelectedDataKey.Value.ToString())); hfPurchaseDetailsId.Value = PurchaseDetailsdr.Id.ToString(); GetItemDatabyID(PurchaseDetailsdr.ItemId); ddlItemColor.SelectedValue = PurchaseDetailsdr.ItemColorId.ToString(); txtQty.Text = PurchaseDetailsdr.Qty.ToString(); }
protected void gvPurchaseDetailsData_SelectedIndexChanged(object sender, EventArgs e) { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.DeliveryDataDetail PurchaseDetailsdr = Mdb.DeliveryDataDetails.Single(a => a.Id == long.Parse(gvDeliveryData.SelectedDataKey.Value.ToString())); hfPurchaseDetailsId.Value = PurchaseDetailsdr.Id.ToString(); PurchaseDetailsdr.Status = 1; DropDownList ddlLoction = gvDeliveryData.SelectedRow.FindControl("ddlLocation") as DropDownList; if (ddlLoction.SelectedValue == "0") { Response.Write("<script>alert('من فضلك أدخل الـ Location')</script>"); return; } TextBox txtQty = gvDeliveryData.SelectedRow.FindControl("txtRealQty") as TextBox; TextBox txtRealTester = gvDeliveryData.SelectedRow.FindControl("txtRealTester") as TextBox; if (string.IsNullOrEmpty(txtQty.Text) || (decimal.Parse(txtQty.Text) == 0 && PurchaseDetailsdr.Qty > 0)) { Response.Write("<script>alert('من فضلك أدخل الكمية بشكل صحيح')</script>"); return; } #region Insert Into Movement ADAM.DataBase.ItemMovement itmmovdr = new DataBase.ItemMovement(); itmmovdr.AdditionalQty = decimal.Parse(txtRealTester.Text); itmmovdr.AdditionalQtyOut = 0; itmmovdr.AuditDetailsId = 0; itmmovdr.DocmentId = PurchaseDetailsdr.Id; itmmovdr.IncommingOrderNo = 0; itmmovdr.ItemColorId = PurchaseDetailsdr.ItemColorId; itmmovdr.ItemId = PurchaseDetailsdr.ItemId; ADAM.DataBase.Item itmdr = Mdb.Items.Single(a => a.Id == PurchaseDetailsdr.ItemId); itmmovdr.ItemUnitId = itmdr.ItemunitId; itmmovdr.LocatioId = long.Parse(ddlLoction.SelectedValue); itmmovdr.MainQty = decimal.Parse(txtQty.Text); itmmovdr.MainQtyOut = 0; itmmovdr.MovementDate = DateTime.Now; itmmovdr.MovmentnameId = 16; itmmovdr.RecDate = DateTime.Now; itmmovdr.StoreId = 2; itmmovdr.SupplyOrderDetailsId = 0; itmmovdr.ParentItemMoveMentId = 0; Mdb.ItemMovements.Add(itmmovdr); Mdb.SaveChanges(); #endregion gvDeliveryData.DataBind(); }
protected void btnEditPurchaseItem_Click(object sender, ImageClickEventArgs e) { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.DeliveryDataDetail PurcahseOrderdetaildr = Mdb.DeliveryDataDetails.Single(a => a.Id == long.Parse(hfPurchaseDetailsId.Value)); if (PurcahseOrderdetaildr.Status > 1) { Response.Write("<script>alert('لا يمكن تعديل هذا الصنف حيث انه تم تسليمه')</script>"); return; } else { PurcahseOrderdetaildr.ItemColorId = int.Parse(ddlItemColor.SelectedValue); PurcahseOrderdetaildr.ItemId = long.Parse(ddlItemName.SelectedValue); PurcahseOrderdetaildr.Qty = decimal.Parse(txtQty.Text); PurcahseOrderdetaildr.Tester = decimal.Parse(txtTester.Text); Mdb.SaveChanges(); gvDeliveryData.DataBind(); } }