protected void btnSave_Click(object sender, ImageClickEventArgs 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(txtName.Text))
{
Response.Write("<script>alert('من فضلك ادخل نوع المنتج')</script>");
return;
}
SaveData();
}
catch { }
}
protected void btnShowData_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 3;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
if (string.IsNullOrEmpty(txtOrderNo.Text))
{
Response.Write("<script>alert('من فضلك تأكد من ادخال رقم الطلب')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ProductionHeaderOrder hdr = mdb.ProductionHeaderOrders.Single(a => a.ProductionNo == long.Parse(txtOrderNo.Text));
txtDate.Text = hdr.ProductionDate.ToString("yyyy-MM-dd");
gvProducionOrder.DataBind();
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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
{
ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString();
long SupplierAccount = db.SupplierDatas.Single(a => a.Id == long.Parse(ddlVendorName.SelectedValue)).AccountId;
long BoxAccount = long.Parse(ddlBoxName.SelectedValue);
csJournal csAddjournal = new csJournal();
long JournalHeaderId = csAddjournal.InsertIntoJournalHeader(0, DateTime.Now, 15, "قيد فاتورة شراء", 0, long.Parse(hfSupplyheaderId.Value));
csAddjournal.InsertIntoJournalDetails(SupplierAccount, long.Parse(ddlCostCenterName.SelectedValue), decimal.Parse(lblBillPrice.Text), 0, JournalHeaderId, "من حـ / المورد");
csAddjournal.InsertIntoJournalDetails(BoxAccount, long.Parse(ddlCostCenterName.SelectedValue), 0, decimal.Parse(lblBillPrice.Text), JournalHeaderId, "الي حـ / الصندوق");
ADAM.DataBase.SupplyOrderHeader SOHdr = db.SupplyOrderHeaders.Single(a => a.Id == long.Parse(hfSupplyheaderId.Value.ToString()));
SOHdr.Posted = 1;
db.SaveChanges();
}
catch { }
}
protected void btnShowData_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 3;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
if (string.IsNullOrEmpty(txtCode.Text))
{
Response.Write("<script>alert('من فضلك ادخل الكود')</script>");
return;
}
if (ddlItemType.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك اختر نوع الصنف')</script>");
return;
}
txtCode.Enabled = false;
ShowData();
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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
{
GetNum();
if (ValidationData())
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var RepCode = from a in Mdb.EmployeeDatas where a.Code == long.Parse(txtCode.Text) select a;
if (RepCode.Count() > 0)
{
Response.Write("<script>alert('لا يمكن تكرار الكود')</script>");
return;
}
SaveData();
}
}
catch { }
}
protected void btnDelete_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 6;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.RefluxDetailsData ddr = mdb.RefluxDetailsDatas.Single(a => a.Id == long.Parse(RefluxDetailsId.Value));
long HeaderId = ddr.RefluxHeaderId;
mdb.RefluxDetailsDatas.Remove(ddr);
mdb.SaveChanges();
var Rows = from a in mdb.RefluxHeaderDatas where a.Id == HeaderId select a;
if (Rows.Count() <= 0)
{
ADAM.DataBase.RefluxHeaderData dr = mdb.RefluxHeaderDatas.Single(a => a.Id == HeaderId);
mdb.RefluxHeaderDatas.Remove(dr);
mdb.SaveChanges();
}
}
protected void btnShowReport_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 7;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString();
for (int Row = 0; Row < gvSupplyOrder.Rows.Count; Row++)
{
TextBox txtPrice = gvSupplyOrder.Rows[Row].FindControl("txtPrice") as TextBox;
if (!string.IsNullOrEmpty(txtPrice.Text))
{
long SupplyOrderDetailsId = long.Parse(gvSupplyOrder.DataKeys[Row].Value.ToString());
ADAM.DataBase.SupplyOrderDetail dr = db.SupplyOrderDetails.Single(a => a.Id == SupplyOrderDetailsId);
dr.ItemPrice = decimal.Parse(txtPrice.Text);
}
}
db.SaveChanges();
gvSupplyOrder.DataBind();
}
protected void btnEdit_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 2;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
try
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ItemContentDetail details = mdb.ItemContentDetails.Single(a => a.Id == long.Parse(hfItemContentDetailsId.Value));
details.ItemColorId = int.Parse(ddlItemColor.SelectedValue);
details.ItemContentHeaderId = long.Parse(hfItemContentHeaderId.Value);
details.ItemId = long.Parse(ddlItemName.SelectedValue);
details.ItemTypeId = long.Parse(ddlItemType.SelectedValue);
details.ProductionLineId = long.Parse(ddlProductionLine.SelectedValue);
details.Qty = decimal.Parse(txtQty.Text);
mdb.SaveChanges();
gvItemContentData.DataBind();
}
catch
{
}
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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
{
ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString();
ADAM.DataBase.JournalHeader dr = db.JournalHeaders.Single(a => a.Id == long.Parse(gvJorunal.SelectedDataKey.Value.ToString()));
dr.Posted = 1;
db.SaveChanges();
gvJorunal.DataBind();
hfJournalHeaderId.Value = "0";
gvJorunalDetails.DataBind();
}
catch { }
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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
{
GetNum();
if (string.IsNullOrEmpty(txtRecordReceiptNo.Text))
{
Response.Write("<script>alert('من فضلك ادخل رقم محضر الاستلام')</script>");
return;
}
if (string.IsNullOrEmpty(txtRecordReceiptDate.Text))
{
Response.Write("<script>alert('من فضلك ادخل التاريخ')</script>");
return;
}
if (ddlItemType.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك اختر نوع الصنف')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var RepCode = from a in Mdb.RecordReceiptHeaders where a.RecordReceiptNo == long.Parse(txtRecordReceiptNo.Text) select a;
if (RepCode.Count() > 0)
{
Response.Write("<script>alert('لا يمكن تكرار الكود')</script>");
return;
}
if (!CheckgvRecordReceipt())
{
return;
}
else
{
SaveData();
}
}
catch { }
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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
{
GetNum();
if (string.IsNullOrEmpty(txtSupplyOrderNo.Text))
{
Response.Write("<script>alert('من فضلك ادخل رقم امر التوريد')</script>");
return;
}
if (string.IsNullOrEmpty(txtDate.Text))
{
Response.Write("<script>alert('من فضلك ادخل تاريخ طلب الشراء')</script>");
return;
}
if (ddlSupplier.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك ادخل المورد')</script>");
return;
}
if (string.IsNullOrEmpty(txtSupplierCode.Text))
{
Response.Write("<script>alert('من فضلك ادخل كود المورد')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var RepCode = from a in Mdb.SupplyOrderHeaders where a.SupplyOrderNo == long.Parse(txtSupplyOrderNo.Text) select a;
if (RepCode.Count() > 0)
{
Response.Write("<script>alert('لا يمكن تكرار رقم طلب التوريد')</script>");
return;
}
SaveData();
gvSupplyOrder.DataBind();
}
catch { }
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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
{
GetNum();
if (string.IsNullOrEmpty(txtDate.Text))
{
Response.Write("<script>alert('من فضلك ادخل تاريخ طلب التسليم')</script>");
return;
}
if (ddlItemType.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك ادخل نوع الصنف')</script>");
return;
}
if (ddlProductionLine.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك أختر خط الانتاج')</script>");
return;
}
if (string.IsNullOrEmpty(txtQty.Text) || decimal.Parse(txtQty.Text) <= 0)
{
Response.Write("<script>alert('من فضلك أدخل الكميات بشكل صحيح')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var RepCode = from a in Mdb.DeliveryDataHeaders where a.DeliveryNo == long.Parse(txtDeliveryOrderNo.Text) select a;
if (RepCode.Count() > 0)
{
Response.Write("<script>alert('لا يمكن تكرار رقم طلب التسليم')</script>");
return;
}
SaveData();
}
catch { }
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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
{
GetNum();
if (string.IsNullOrEmpty(txtCode.Text))
{
Response.Write("<script>alert('من فضلك ادخل كود المخزن')</script>");
return;
}
if (string.IsNullOrEmpty(txtName.Text))
{
Response.Write("<script>alert('من فضلك ادخل اسم المخزن')</script>");
return;
}
if (string.IsNullOrEmpty(txtPhone.Text))
{
Response.Write("<script>alert('من فضلك ادخل رقم الهاتف')</script>");
return;
}
if (string.IsNullOrEmpty(txtNote.Text))
{
Response.Write("<script>alert('من فضلك ادخل الملاحظات')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var RepCode = from a in Mdb.StoreDatas where a.Code == long.Parse(txtCode.Text) select a;
if (RepCode.Count() > 0)
{
Response.Write("<script>alert('لا يمكن تكرار الكود')</script>");
return;
}
SaveData();
}
catch { }
}
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 { }
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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");
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ProductionHeaderOrder headerdr = new DataBase.ProductionHeaderOrder();
if (hfHeaderId.Value != "0")
{
headerdr = mdb.ProductionHeaderOrders.Single(a => a.Id == long.Parse(hfHeaderId.Value));
}
else
{
headerdr.ProductionDate = DateTime.Now;
headerdr.ProductionNo = long.Parse(txtOrderNo.Text);
mdb.ProductionHeaderOrders.Add(headerdr);
mdb.SaveChanges();
hfHeaderId.Value = headerdr.Id.ToString();
}
for (int GRow = 0; GRow < gvProductionOrderData.Rows.Count; GRow++)
{
TextBox txtQty = gvProductionOrderData.Rows[GRow].FindControl("txtQty") as TextBox;
if (!string.IsNullOrEmpty(txtQty.Text))
{
if (decimal.Parse(txtQty.Text) <= 0)
{
Response.Write("<script>alert('من فضلك يجب ان تكون الكمية اكبر من الصفر')</script>");
return;
}
long ItemContentHeaderId = long.Parse(gvProductionOrderData.DataKeys[GRow].Value.ToString());
ADAM.DataBase.ProductionDetailsOrder detailsdr = new DataBase.ProductionDetailsOrder();
detailsdr.ProductionHeaderOrderId = long.Parse(hfHeaderId.Value);
detailsdr.ContentHeaderId = ItemContentHeaderId;
detailsdr.Qty = decimal.Parse(txtQty.Text);
detailsdr.Status = 0;
mdb.ProductionDetailsOrders.Add(detailsdr);
}
}
mdb.SaveChanges();
btnNew_Click(sender, e);
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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 (ddlItemColor.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك اختر لون الصنف')</script>");
return;
}
if (ddlProdctionLine.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك أختر خط الانتاج')</script>");
return;
}
if (ddlItems.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك أختر الصنف')</script>");
return;
}
if (ddlItemType.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك أختر المخزن')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var RepCode = from a in Mdb.ItemColorSelecteds where a.ItemId == long.Parse(ddlItems.SelectedValue) && a.ItemColorId == long.Parse(ddlItemColor.SelectedValue) select a;
if (RepCode.Count() > 0)
{
Response.Write("<script>alert('لقد تم ادخال هذا اللون لهذا الصنف من قبل')</script>");
return;
}
SaveData();
}
catch { }
}
protected void btnShowData_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 3;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
if (string.IsNullOrEmpty(txtOrderNo.Text))
{
Response.Write("<script>alert('من فضلك تأكد من ادخال رقم الطلب')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Row = from a in mdb.ProductionHeaderOrders where a.ProductionNo == long.Parse(txtOrderNo.Text) select a;
if (Row.Count() > 0)
{
ADAM.DataBase.ProductionHeaderOrder headerdr = mdb.ProductionHeaderOrders.Single(a => a.ProductionNo == long.Parse(txtOrderNo.Text));
hfHeaderId.Value = headerdr.Id.ToString();
txtDate.Text = headerdr.ProductionDate.ToString("yyyy-MM-dd");
for (int GRow = 0; GRow < gvProductionOrderData.Rows.Count; GRow++)
{
TextBox txtQty = gvProductionOrderData.Rows[GRow].FindControl("txtQty") as TextBox;
long ItemContentHeaderId = long.Parse(gvProductionOrderData.DataKeys[GRow].Value.ToString());
var dRows = from a in mdb.ProductionDetailsOrders
where a.ContentHeaderId == ItemContentHeaderId &&
a.ProductionHeaderOrderId == long.Parse(hfHeaderId.Value)
select a;
if (dRows.Count() > 0)
{
ADAM.DataBase.ProductionDetailsOrder ddr = mdb.ProductionDetailsOrders.Single(a => a.ContentHeaderId == ItemContentHeaderId &&
a.ProductionHeaderOrderId == long.Parse(hfHeaderId.Value));
txtQty.Text = ddr.Qty.ToString();
}
}
}
else
{
Response.Write("<script>alert('من فضلك تأكد من رقم الطلب')</script>");
return;
}
}
protected void btnEditOrderItem_Click(object sender, ImageClickEventArgs e)
{
try
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 2;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.RefluxDetailsData ddr = mdb.RefluxDetailsDatas.Single(a => a.Id == long.Parse(RefluxDetailsId.Value));
if (ddr.RefluxHeaderData.OrderType == 1)
{
ADAM.DataBase.PurchaseOredrDetail purchasedr = mdb.PurchaseOredrDetails.Single(a => a.Id == ddr.ExchangeOrPurchaseDetailsId);
if (decimal.Parse(txtQty.Text) > purchasedr.ConformQty)
{
Response.Write("<script>alert('لا يمكن ان تكون الكمية المرتجعة اكبر من الكمية الموجوده في طلب الشراء')</script>");
return;
}
}
if (ddr.RefluxHeaderData.OrderType == 2)
{
ADAM.DataBase.ExchangeRequestDetailsData detailsdr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == ddr.ExchangeOrPurchaseDetailsId);
if (decimal.Parse(txtQty.Text) > detailsdr.Qty)
{
Response.Write("<script>alert('لا يمكن ان تكون الكمية المرتجعة اكبر من الكمية الموجوده في طلب الصرف')</script>");
return;
}
if (decimal.Parse(txtFreeQty.Text) > detailsdr.FreeQty)
{
Response.Write("<script>alert('لا يمكن ان تكون الكمية المجانية المرتجعة اكبر من الكمية الموجوده في طلب الصرف')</script>");
return;
}
}
ddr.RefluxQty = decimal.Parse(txtQty.Text);
ddr.RefluxFreeQty = decimal.Parse(txtFreeQty.Text);
mdb.SaveChanges();
gvReflux.DataBind();
}
catch { }
}
protected void btnEdit_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
Response.Redirect("~/BasicData/webLogIn.aspx");
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 2;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
Response.Redirect("~/BasicData/webHomePage.aspx");
EditData();
}
private void SaveData(string Qty, long ItemId, int ItemColorId)
{
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");
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
if (hfItemContentHeaderId.Value == "0")
{
ADAM.DataBase.ItemContentHeader Hdr = new DataBase.ItemContentHeader();
Hdr.ProductionLineId = long.Parse(ddlProductProductionLine.SelectedValue);
Hdr.ProductItemColor = int.Parse(ddlProductionItemcolor.SelectedValue);
Hdr.ProductItemId = long.Parse(ddlProductionItem.SelectedValue);
Hdr.ItemType = int.Parse(ddlProductionItemType.SelectedValue);
mdb.ItemContentHeaders.Add(Hdr);
mdb.SaveChanges();
hfItemContentHeaderId.Value = Hdr.Id.ToString();
}
var Rows = from a in mdb.ItemContentDetails where a.ItemId == ItemId && a.ItemColorId == ItemColorId select a;
if (Rows.Count() > 0)
{
Response.Write("<script>alert('لا يمكن ادخال نفس الصنف واللون اكثر من مرة في التركيبة الواحدة')</script>");
return;
}
ADAM.DataBase.ItemContentDetail ddr = new DataBase.ItemContentDetail();
ddr.ItemColorId = ItemColorId;
ddr.ItemContentHeaderId = long.Parse(hfItemContentHeaderId.Value);
ddr.ItemId = ItemId;
ddr.ItemTypeId = long.Parse(ddlItemType.SelectedValue);
ddr.ProductionLineId = long.Parse(ddlProductionLine.SelectedValue);
ddr.Qty = decimal.Parse(Qty);
mdb.ItemContentDetails.Add(ddr);
mdb.SaveChanges();
gvItemContentData.DataBind();
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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 (ddlPages.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك اختر الشاشة')</script>");
return;
}
if (ddlOperation.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك اختر الصلاحية')</script>");
return;
}
if (ddlUser.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك اختر المستخدم')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString Mdb = new ADAM.DataBase.ADAMConnectionString();
var RepCode = from a in Mdb.Permissions
where a.OperationId == long.Parse(ddlOperation.SelectedValue) &&
a.PageId == long.Parse(ddlPages.SelectedValue) && a.UserId == long.Parse(ddlUser.SelectedValue)
select a;
if (RepCode.Count() > 0)
{
Response.Write("<script>alert('لقد تم تسجيل هذه الصلاحية من قبل')</script>");
return;
}
SaveData();
gvUserPermission.DataBind();
}
catch { }
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 5;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
}
protected void btnShowData_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 3;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
if (string.IsNullOrEmpty(txtExchangeRequestNo.Text))
{
Response.Write("<script>alert('من فضلك ادخل رقم طلب الصرف')</script>");
return;
}
txtExchangeRequestNo.Enabled = false;
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var HRows = from a in mdb.ExchangeRequestHeaderDatas
where a.OrderType == int.Parse(ddlExchangeRequestType.SelectedValue) &&
a.ExchangeRequestNo == int.Parse(txtExchangeRequestNo.Text)
select a;
if (HRows.Count() > 0)
{
ADAM.DataBase.ExchangeRequestHeaderData Hdr = mdb.ExchangeRequestHeaderDatas.Single(a => a.ExchangeRequestNo == int.Parse(txtExchangeRequestNo.Text) &&
a.OrderType == int.Parse(ddlExchangeRequestType.SelectedValue));
hfId.Value = Hdr.Id.ToString();
ddlClient.SelectedValue = Hdr.ClientId.ToString();
ADAM.DataBase.division Ddr = mdb.divisions.Single(a => a.Id == Hdr.DivisionId);
ADAM.DataBase.Department Depdr = mdb.Departments.Single(a => a.Id == Ddr.DepartmentId);
ddlDepartment.SelectedValue = Depdr.Id.ToString();
ddlDivision.DataBind();
ddlDivision.SelectedValue = Ddr.Id.ToString();
ddlEmployee.DataBind();
ddlEmployee.SelectedValue = Hdr.EmpId.ToString();
txtDate.Text = Hdr.ExchangeRequestDate.ToString("yyyy-MM-dd");
//gvExchangeRequestData.DataBind();
}
}
protected void btnEdit_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 2;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
try
{
if (ddlItemColor.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك اختر لون الصنف')</script>");
return;
}
if (ddlProdctionLine.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك أختر خط الانتاج')</script>");
return;
}
if (ddlItems.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك أختر الصنف')</script>");
return;
}
if (ddlItemType.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك أختر المخزن')</script>");
return;
}
EditData();
}
catch { }
}
protected void btnShowReport_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 5;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
Response.Redirect("~/MainReport/webJobsReport.aspx");
}
protected void btnSaveOrderItem_Click(object sender, ImageClickEventArgs 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
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ItemContentDetail details = new DataBase.ItemContentDetail();
var Rows = from a in mdb.ItemContentDetails where a.ItemId == long.Parse(ddlItemName.SelectedValue) &&
a.ItemColorId == long.Parse(ddlItemColor.SelectedValue) select a;
if (Rows.Count() > 0)
{
Response.Write("<script>alert('لا يمكن ادخال نفس الصنف واللون اكثر من مرة في التركيبة الواحدة')</script>");
return;
}
details.ItemColorId = int.Parse(ddlItemColor.SelectedValue);
details.ItemContentHeaderId = long.Parse(hfItemContentHeaderId.Value);
details.ItemId = long.Parse(ddlItemName.SelectedValue);
details.ItemTypeId = long.Parse(ddlItemType.SelectedValue);
details.ProductionLineId = long.Parse(ddlProductionLine.SelectedValue);
details.Qty = decimal.Parse(txtQty.Text);
mdb.ItemContentDetails.Add(details);
mdb.SaveChanges();
gvItemContentData.DataBind();
}
catch
{
}
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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
{
ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString();
long SalesCost = db.AccountHelpers.Single(a => a.Id == 2).AccountId;
long StoreAccount = db.ItemTypes.Single(a => a.Id == db.ExchangeRequestDetailsDatas.Single(aa => aa.ExchangeRequestHeaderDataId == long.Parse(hfExchangeheaderId.Value.ToString())).ItemTypeId).AccountId;
long ClientAccount = db.ClientDatas.Single(a => a.Id == long.Parse(ddlClient.SelectedValue)).AccountId;
long SalesAccount = db.AccountHelpers.Single(a => a.Id == 1).AccountId;
csJournal csAddjournal = new csJournal();
long JournalHeaderId = csAddjournal.InsertIntoJournalHeader(0, DateTime.Now, int.Parse(ddlExchangeRequestType.SelectedValue), "قيد فاتورة بيع", 0, long.Parse(hfExchangeheaderId.Value));
csAddjournal.InsertIntoJournalDetails(SalesAccount, long.Parse(ddlCostCenterName.SelectedValue), decimal.Parse(ViewState["AllItemCost"].ToString()), 0, JournalHeaderId, "من حـ / تكلفة المبيعات");
csAddjournal.InsertIntoJournalDetails(StoreAccount, long.Parse(ddlCostCenterName.SelectedValue), 0, decimal.Parse(ViewState["AllItemCost"].ToString()), JournalHeaderId, "الي حـ / المخزن");
csAddjournal.InsertIntoJournalDetails(ClientAccount, long.Parse(ddlCostCenterName.SelectedValue), decimal.Parse(lblBillPrice.Text), 0, JournalHeaderId, "من حـ / العميل");
csAddjournal.InsertIntoJournalDetails(SalesAccount, long.Parse(ddlCostCenterName.SelectedValue), 0, decimal.Parse(lblBillPrice.Text), JournalHeaderId, "الي حـ / المبيعات");
ADAM.DataBase.ExchangeRequestHeaderData ERHdr = db.ExchangeRequestHeaderDatas.Single(a => a.Id == long.Parse(hfExchangeheaderId.Value));
ERHdr.Posted = 1;
db.SaveChanges();
hfExchangeheaderId.Value = "0";
gvExchangeData.DataBind();
}
catch { }
}
protected void btnSave_Click(object sender, ImageClickEventArgs 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");
}
if (string.IsNullOrEmpty(txtDebit.Text) || txtDebit.Text == "0")
{
if (string.IsNullOrEmpty(txtCredit.Text) || txtCredit.Text == "0")
{
Response.Write("<script>alert('من فضلك تأكد من أدخال قيمة في المدين او الدائن')</script>");
return;
}
}
if (string.IsNullOrEmpty(txtCredit.Text) || txtCredit.Text == "0")
{
if (string.IsNullOrEmpty(txtDebit.Text) || txtDebit.Text == "0")
{
Response.Write("<script>alert('من فضلك تأكد من أدخال قيمة في المدين او الدائن')</script>");
return;
}
}
BasicData.csJournal InsertJournal = new csJournal();
if (hfJournalHeaderId.Value == "0")
{
long JournalHeaderId = InsertJournal.InsertIntoJournalHeader(long.Parse(txtjournalCode.Text), DateTime.Parse(txtjournalDate.Text), int.Parse(ddlJournaType.SelectedValue), txtJournalNote.Text, 0, 0);
hfJournalHeaderId.Value = JournalHeaderId.ToString();
}
InsertJournal.InsertIntoJournalDetails(long.Parse(ddlAccountName.SelectedValue), long.Parse(ddlCostCenter.SelectedValue), decimal.Parse(txtDebit.Text), decimal.Parse(txtCredit.Text), long.Parse(hfJournalHeaderId.Value), txtNote.Text);
gvJournalDetails.DataBind();
EmpData();
}
protected void btnShowData_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 3;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
txtCode.Enabled = false;
ShowData();
}
protected void btnShowData_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 3;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
ShowData(int.Parse(ddlRefluxType.SelectedValue));
btnGetExchageNo.Visible = false;
}