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();
}
}
