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