protected void gvSupplyOrder_SelectedIndexChanged(object sender, EventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 1;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
try
{
if (string.IsNullOrEmpty(txtSupplyOrderNo.Text))
{
Response.Write("<script>alert('من فضلك ادخل كود امر التوريد')</script>");
return;
}
TextBox txtQtyPrice = gvSupplyOrder.SelectedRow.FindControl("txtQtyPrice") as TextBox;
TextBox txtFQtyPrice = gvSupplyOrder.SelectedRow.FindControl("txtFQtyPrice") as TextBox;
if (string.IsNullOrEmpty(txtFQtyPrice.Text))
{
txtFQtyPrice.Text = "0";
}
if (string.IsNullOrEmpty(txtQtyPrice.Text) || decimal.Parse(txtQtyPrice.Text) == 0)
{
Response.Write("<script>alert('من فضلك يجب ان يكون سعر الصنف اكبر من صفر')</script>");
return;
}
if (decimal.Parse(gvSupplyOrder.SelectedRow.Cells[10].Text) > 0)
{
if (string.IsNullOrEmpty(txtFQtyPrice.Text) || decimal.Parse(txtFQtyPrice.Text) == 0)
{
Response.Write("<script>alert('من فضلك يجب ان يكون سعر tester اكبر من صفر')</script>");
return;
}
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.IncommingOrderData dr = mdb.IncommingOrderDatas.Single(a => a.Id == long.Parse(gvSupplyOrder.SelectedDataKey.Value.ToString()));
dr.ItemPrice = decimal.Parse(txtQtyPrice.Text);
dr.FreeItemPrice = decimal.Parse(txtFQtyPrice.Text);
mdb.SaveChanges();
}
catch { }
}
private long GetIncoOrderData(long ItemType)
{
long IncommingOrder = 0;
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var IncRows = from a in Mdb.IncommingOrderDatas where a.ItemTypeId == ItemType orderby a.Id descending select a;
if (IncRows.Count() == 0)
{
IncommingOrder = 1;
}
else
{
ADAM.DataBase.IncommingOrderData dr = IncRows.First();
IncommingOrder = dr.IncommingOrderNo + 1;
}
return(IncommingOrder);
}
protected void gvItemMovement_SelectedIndexChanged(object sender, EventArgs e)
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ItemMovement movdr = Mdb.ItemMovements.Single(a => a.Id == long.Parse(gvItemMovement.SelectedDataKey.Value.ToString()));
TextBox txtQtyOut = gvItemMovement.SelectedRow.FindControl("txtQtyOut") as TextBox;
TextBox txtfreeQtyOut = gvItemMovement.SelectedRow.FindControl("txtfreeQtyOut") as TextBox;
if ((movdr.MainQtyOut + decimal.Parse(txtQtyOut.Text) <= movdr.MainQty) && (movdr.AdditionalQtyOut + decimal.Parse(txtfreeQtyOut.Text) <= movdr.AdditionalQty))
{
movdr.MainQtyOut = movdr.MainQtyOut + decimal.Parse(txtQtyOut.Text);
movdr.AdditionalQtyOut = movdr.AdditionalQtyOut + decimal.Parse(txtfreeQtyOut.Text);
var ExchangeRequestOrderRows = from a in Mdb.ExchangeRequestDetailsDatas
where a.ExchangeRequestHeaderData.OrderType == long.Parse(ddlExchangeRequestType.SelectedValue) &&
a.Status == 1
orderby a.ExchangeRequestOrder descending
select a;
if (ExchangeRequestOrderRows.Count() <= 0)
{
hfExchangeRequestOrder.Value = "1";
}
else
{
if (hfExchangeRequestOrder.Value == "0")
{
hfExchangeRequestOrder.Value = (ExchangeRequestOrderRows.First().ExchangeRequestOrder + 1).ToString();
}
}
ADAM.DataBase.ExchangeRequestDetailsData Exdr = Mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(hfDetailsId.Value));
if ((decimal.Parse(txtQtyOut.Text)) > (Exdr.Qty + Exdr.Bounce))
{
Response.Write("<script>alert('لا يمكن ان يكون الكمية المنصرفة اكبر من كمية طلب الصرف')</script>");
return;
}
if ((decimal.Parse(txtfreeQtyOut.Text)) > (Exdr.FreeQty))
{
Response.Write("<script>alert('لا يمكن ان يكون الكمية Tester المنصرفة اكبر من كمية طلب الصرف')</script>");
return;
}
Exdr.ExchangeRequestOrder = long.Parse(hfExchangeRequestOrder.Value);
Exdr.Status = 1;
if (movdr.IncommingOrderNo != 0)
{
ADAM.DataBase.IncommingOrderData incdr = Mdb.IncommingOrderDatas.Single(a => a.IncommingOrderNo == movdr.IncommingOrderNo && a.AuditDetailsId == movdr.AuditDetailsId);
Exdr.IncommingOrderId = incdr.Id;
Exdr.LocationId = movdr.LocatioId;
}
ADAM.DataBase.ItemMovement dr = new DataBase.ItemMovement();
dr.AdditionalQty = decimal.Parse(txtfreeQtyOut.Text) * -1;
dr.AdditionalQtyOut = 0;
dr.AuditDetailsId = movdr.AuditDetailsId;
dr.DocmentId = Exdr.Id;
dr.IncommingOrderNo = movdr.IncommingOrderNo;
dr.ItemColorId = movdr.ItemColorId;
dr.ItemId = movdr.ItemId;
dr.ItemUnitId = movdr.ItemUnitId;
dr.LocatioId = movdr.LocatioId;
dr.MainQty = decimal.Parse(txtQtyOut.Text) * -1;
dr.MainQtyOut = 0;
dr.MovementDate = DateTime.Now;
dr.MovmentnameId = int.Parse(ddlExchangeRequestType.Text);
dr.RecDate = DateTime.Now;
dr.StoreId = movdr.StoreId;
dr.SupplyOrderDetailsId = movdr.SupplyOrderDetailsId;
dr.ParentItemMoveMentId = movdr.Id;
Mdb.ItemMovements.Add(dr);
Exdr.IncommingOrderNo = movdr.IncommingOrderNo;
Mdb.SaveChanges();
Exdr.MovementId = dr.Id;
gvExchangeRequestData.DataBind();
}
else
{
Response.Write("<script>alert('لا يمكن ان يكون الكمية المنصرفة اكبر من كمية الرصيد الحالي')</script>");
return;
}
}
