private void EditData()
{
try
{
if (string.IsNullOrEmpty(txtDate.Text) || string.IsNullOrEmpty(txtNote.Text) || string.IsNullOrEmpty(txtPurchaseOrderNo.Text) ||
ddlDivision.SelectedValue == "0" || ddlDepartment.SelectedValue == "0" || ddlEmployee.SelectedValue == "0" || ddlItemType.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك تأكد من ادخال كل البيانات بشكل صحيح')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.PurchaseOrderHeader dr = Mdb.PurchaseOrderHeaders.Single(a => a.PurchaseOrderNo == long.Parse(txtPurchaseOrderNo.Text));
if (Validation())
{
dr.DepartmentId = long.Parse(ddlDepartment.SelectedValue);
dr.DivisionId = long.Parse(ddlDivision.SelectedValue);
dr.EmployeeId = long.Parse(ddlEmployee.SelectedValue);
dr.ItemTypeId = long.Parse(ddlItemType.SelectedValue);
dr.Note = txtNote.Text;
dr.PurchaseDate = DateTime.Parse(txtDate.Text);
dr.PurchaseOrderNo = long.Parse(txtPurchaseOrderNo.Text);
dr.SupplierId = long.Parse(ddlSupplierName.SelectedValue);
dr.RecoredDate = DateTime.Now;
Mdb.SaveChanges();
Response.Write("<script>alert('تمت عملية التعديل بنجاح')</script>");
}
else
{
Response.Write("<script>alert('هذا الكود غير موجود بقاعدة البيانات')</script>");
}
}
catch { Response.Write("<script>alert('خطأ أثناء التعديل من فضلك تأكد من ادخال البيانات بشكل صحيح او الاتصال بقاعدة البيانات ')</script>"); }
}
private void DeleteData()
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.PurchaseOrderHeader dr = Mdb.PurchaseOrderHeaders.Single(a => a.PurchaseOrderNo == long.Parse(txtPurchaseOrderNo.Text));
var PurchaseOrderDetailsRows = from a in Mdb.PurchaseOredrDetails where a.PurchaseOredeHeaderId == dr.Id select a;
foreach (ADAM.DataBase.PurchaseOredrDetail ddr in PurchaseOrderDetailsRows)
{
if (ddr.Status != 1)
{
Response.Write("<script>alert('لا يمكن الحذف الان لانه اصبح في مرحلة غير مرحلة الانشاء')</script>");
return;
}
}
foreach (ADAM.DataBase.PurchaseOredrDetail ddr in PurchaseOrderDetailsRows)
{
if (ddr.Status == 1)
{
Mdb.PurchaseOredrDetails.Remove(ddr);
}
Mdb.SaveChanges();
}
Mdb.PurchaseOrderHeaders.Remove(dr);
Mdb.SaveChanges();
txtDate.Text = txtNote.Text = txtPurchaseOrderNo.Text = "";
ddlEmployee.SelectedValue = ddlDepartment.SelectedValue = ddlDivision.SelectedValue = ddlItemType.SelectedValue = "0";
Response.Write("<script>alert('تمت عملية الحذف نجاح')</script>");
}
catch { Response.Write("<script>alert('خطأ أثناء الحذف من فضلك تأكد من ادخال البيانات بشكل صحيح او من الاتصال بقاعدة البيانات')</script>"); }
}
private void ShowData()
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var Rows = from a in Mdb.PurchaseOrderHeaders where a.PurchaseOrderNo == long.Parse(txtPurchaseOrderNo.Text) select a;
if (Rows.Count() > 0)
{
#region ShowHeader
ADAM.DataBase.PurchaseOrderHeader dr = Mdb.PurchaseOrderHeaders.Single(a => a.PurchaseOrderNo == long.Parse(txtPurchaseOrderNo.Text));
txtPurchaseOrderNo.Text = dr.PurchaseOrderNo.ToString();
txtDate.Text = dr.PurchaseDate.ToString("yyyy-MM-dd");
ddlDepartment.SelectedValue = dr.DepartmentId.ToString();
dbDivision.DataBind();
ddlDivision.DataBind();
ddlDivision.SelectedValue = dr.DivisionId.ToString();
ddlEmployee.SelectedValue = dr.EmployeeId.ToString();
ddlItemType.SelectedValue = dr.ItemTypeId.ToString();
ddlSupplierName.SelectedValue = dr.SupplierId.ToString();
txtNote.Text = dr.Note;
hfId.Value = dr.Id.ToString();
ddlItemType.Enabled = false;
#endregion
gvPurchaseDetailsData.DataBind();
}
else
{
Response.Write("<script>alert('من فضلك تأكد من رقم طلب الشراء')</script>");
}
}
catch { Response.Write("<script>alert('خطأ أثناء عرض البيانات من فضلك تأكد من الكود او من الاتصال بقاعدة البيانات')</script>"); }
}
private void GetNum()
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Rows = from a in mdb.PurchaseOrderHeaders orderby a.Id descending select a;
if (Rows.Count() == 0)
{
txtPurchaseOrderNo.Text = "1";
}
else
{
ADAM.DataBase.PurchaseOrderHeader dr = Rows.First();
txtPurchaseOrderNo.Text = (dr.PurchaseOrderNo + 1).ToString();
}
}
private void GetPurchaseOrderData()
{
lblExchangeOrderType.Visible = ddlExchangeRequestType.Visible = false;
ddlSupplierName.Visible = lblSupplierName.Visible = true;
lblOrderName.Text = "رقم طلب الشراء";
lblDate.Text = "تاريخ طلب الشراء";
if (!string.IsNullOrEmpty(txtPurchaseOrExchangeOrderNo.Text))
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
#region GetPurchaseOrderHeader
var Rows = from a in mdb.PurchaseOrderHeaders where a.PurchaseOrderNo == long.Parse(txtPurchaseOrExchangeOrderNo.Text) select a;
if (Rows.Count() > 0)
{
ADAM.DataBase.PurchaseOrderHeader Headerdr = mdb.PurchaseOrderHeaders.Single(a => a.PurchaseOrderNo == long.Parse(txtPurchaseOrExchangeOrderNo.Text));
var DetailsRows = from a in mdb.PurchaseOredrDetails where a.Status != 0 && a.PurchaseOredeHeaderId == Headerdr.Id && a.ConformQty > 0 select a;
if (DetailsRows.Count() > 0)
{
ddlDepartment.SelectedValue = Headerdr.DepartmentId.ToString();
ddlDivision.DataBind();
ddlDivision.SelectedValue = Headerdr.DivisionId.ToString();
ddlEmployee.DataBind();
ddlEmployee.SelectedValue = Headerdr.EmployeeId.ToString();
ddlItemType.SelectedValue = Headerdr.ItemTypeId.ToString();
txtDate.Text = Headerdr.PurchaseDate.ToString("yyyy-MM-dd");
hfPurchaseHeaderId.Value = Headerdr.Id.ToString();
ddlSupplierName.SelectedValue = Headerdr.SupplierId.ToString();
hfExchangeRequestHeaderId.Value = "0";
//gvPurchaseDetailsData.DataBind();
gvExchangeRequestData.DataBind();
}
else
{
Response.Write("<script>alert('هذا الطلب لم يعتمد من قبل')</script>");
return;
}
}
else
{
Response.Write("<script>alert('من تأكد من رقم طلب الشراء')</script>");
return;
}
#endregion
}
}
private void EditData()
{
if (ddlRefluxType.SelectedValue == "0")
{
Response.Write("<script>alert('من فضلك اختر نوع الصرف')</script>");
return;
}
if (string.IsNullOrEmpty(txtRefluxNo.Text))
{
Response.Write("<script>alert('من فضلك ادخل رقم الارتجاع')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Rows = from a in mdb.RefluxHeaderDatas
where a.OrderType == int.Parse(ddlRefluxType.SelectedValue) &&
a.RefluxNo == long.Parse(txtRefluxNo.Text)
select a;
if (Rows.Count() > 0)
{
ADAM.DataBase.RefluxHeaderData dr = mdb.RefluxHeaderDatas.Single(a => a.OrderType == int.Parse(ddlRefluxType.SelectedValue) &&
a.RefluxNo == long.Parse(txtRefluxNo.Text));
RefluxHeaderId.Value = dr.Id.ToString();
gvReflux.DataBind();
if (dr.OrderType == 1)
{
ADAM.DataBase.PurchaseOrderHeader Pdr = mdb.PurchaseOrderHeaders.Single(a => a.Id == dr.ExchangeOrPurchaseHeaderId);
txtPurchaseOrExchangeOrderNo.Text = Pdr.PurchaseOrderNo.ToString();
ddlItemType.SelectedValue = dr.ItemTypeId.ToString();
txtReason.Text = dr.Reason;
txtRefluxDate.Text = dr.RefluxDate.ToString("yyyy-MM-dd");
ShowData(dr.OrderType);
}
}
else
{
Response.Write("<script>alert('من فضلك تأكد من رقم الارتجاع')</script>");
return;
}
}
protected void txtPurchaseOrderNo_TextChanged(object sender, EventArgs e)
{
try {
ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString();
var POHRow = from a in db.PurchaseOrderHeaders where a.PurchaseOrderNo == long.Parse(txtPurchaseOrderNo.Text) select a;
if (POHRow.Count() > 0)
{
ADAM.DataBase.PurchaseOrderHeader POHdr = db.PurchaseOrderHeaders.Single(a => a.PurchaseOrderNo == long.Parse(txtPurchaseOrderNo.Text));
txtPurchaseOrderDate.Text = POHdr.PurchaseDate.ToString("yyyy-MM-dd");
ddlSupplier.SelectedValue = POHdr.SupplierId.ToString();
txtSupplierCode.Text = db.SupplierDatas.Single(a => a.Id == POHdr.SupplierId).Code.ToString();
gvSupplyOrder.DataBind();
}
else
{
Response.Write("<script>alert('من فضلك تأكد من رقم طلب الشراء')</script>");
return;
}
}
catch { }
}
private void ShowData()
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var Rows = from a in Mdb.PurchaseOrderHeaders where a.PurchaseOrderNo == long.Parse(txtPurchaseOrderNo.Text) select a;
if (Rows.Count() > 0)
{
ADAM.DataBase.PurchaseOrderHeader dr = Mdb.PurchaseOrderHeaders.Single(a => a.PurchaseOrderNo == long.Parse(txtPurchaseOrderNo.Text));
var Drows = from a in Mdb.PurchaseOredrDetails where a.Status == 1 && a.PurchaseOredeHeaderId == dr.Id select a;
if (Drows.Count() > 0)
{
txtPurchaseOrderNo.Text = dr.PurchaseOrderNo.ToString();
txtDate.Text = dr.PurchaseDate.ToString("yyyy-MM-dd");
ddlDepartment.SelectedValue = dr.DepartmentId.ToString();
dbDivision.DataBind();
ddlDivision.DataBind();
ddlDivision.SelectedValue = dr.DivisionId.ToString();
ddlEmployee.SelectedValue = dr.EmployeeId.ToString();
ddlSupplierName.SelectedValue = dr.SupplierId.ToString();
ddlItemType.SelectedValue = dr.ItemTypeId.ToString();
txtNote.Text = dr.Note;
gvPurchaseData.DataBind();
}
else
{
txtPurchaseOrderNo.Text = "";
Response.Write("<script>alert('لقد تم اعتماد كافه اصناف هذا الطلب')</script>");
}
}
else
{
Response.Write("<script>alert('من فضلك تأكد من رقم طلب الشراء')</script>");
}
}
catch { Response.Write("<script>alert('خطأ أثناء عرض البيانات من فضلك تأكد من الكود او من الاتصال بقاعدة البيانات')</script>"); }
}
protected void btndeletePurchaseItem_Click(object sender, ImageClickEventArgs e)
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.PurchaseOredrDetail PurcahseOrderdetaildr = Mdb.PurchaseOredrDetails.Single(a => a.Id == long.Parse(hfPurchaseDetailsId.Value));
if (PurcahseOrderdetaildr.Status > 1)
{
Response.Write("<script>alert('لا يمكن حذف هذا الصنف حيث انه لم يعُد جديد')</script>");
return;
}
else
{
Mdb.PurchaseOredrDetails.Remove(PurcahseOrderdetaildr);
Mdb.SaveChanges();
gvPurchaseDetailsData.DataBind();
var PurchaseOrderHeaderRows = from a in Mdb.PurchaseOredrDetails where a.PurchaseOredeHeaderId == long.Parse(hfId.Value) select a;
if (PurchaseOrderHeaderRows.Count() <= 0)
{
ADAM.DataBase.PurchaseOrderHeader PurchaseHeadedr = Mdb.PurchaseOrderHeaders.Single(a => a.Id == long.Parse(hfId.Value));
Mdb.PurchaseOrderHeaders.Remove(PurchaseHeadedr);
Mdb.SaveChanges();
btnNew_Click(sender, e);
}
}
}
protected void btnShowReport_Click(object sender, ImageClickEventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtPurchaseOrderNo.Text))
{
Response.Write("<script>alert('من فضلك تأكد من رقم طلب الشراء')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var Rows = from a in Mdb.PurchaseOrderHeaders where a.PurchaseOrderNo == long.Parse(txtPurchaseOrderNo.Text) select a;
if (Rows.Count() > 0)
{
ADAM.DataBase.PurchaseOrderHeader dr = Mdb.PurchaseOrderHeaders.Single(a => a.PurchaseOrderNo == long.Parse(txtPurchaseOrderNo.Text));
var DRows = from a in Mdb.PurchaseOredrDetails where a.PurchaseOredeHeaderId == dr.Id select a;
foreach (ADAM.DataBase.PurchaseOredrDetail ddr in DRows)
{
if (ddr.Status != 1)
{
continue;
}
else
{
ShowReport();
}
}
Response.Write("<script>alert('لا يوجد اصناف غير معتمدة لطباعتها')</script>");
}
else
{
Response.Write("<script>alert('من فضلك تأكد من رقم طلب الشراء')</script>");
return;
}
}
catch { Response.Write("<script>alert('خطأ أثناء تحميل التقرير')</script>"); }
}
