private void GetExchangeRequestCode() { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); var Rows = from a in Mdb.ExchangeRequestHeaderDatas where a.OrderType == long.Parse(ddlExchangeRequestType.SelectedValue) orderby a.Id descending select a; if (Rows.Count() == 0) { txtExchangeRequestNo.Text = "1"; } else { ADAM.DataBase.ExchangeRequestHeaderData dr = Rows.First(); txtExchangeRequestNo.Text = (dr.ExchangeRequestNo + 1).ToString(); } }
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 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 { } }
private void GetExchangeOrderData() { lblExchangeOrderType.Visible = ddlExchangeRequestType.Visible = true; ddlSupplierName.Visible = lblSupplierName.Visible = false; lblOrderName.Text = "رقم أذن الصرف"; lblDate.Text = "تاريخ طلب الصرف"; if (!string.IsNullOrEmpty(txtPurchaseOrExchangeOrderNo.Text)) { ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString(); #region GetExchangeOrderHeader var Rows = from a in mdb.ExchangeRequestDetailsDatas where a.ExchangeRequestOrder == long.Parse(txtPurchaseOrExchangeOrderNo.Text) && a.ExchangeRequestHeaderData.OrderType == int.Parse(ddlExchangeRequestType.SelectedValue) orderby a.Id descending select a; if (Rows.Count() > 0) { ADAM.DataBase.ExchangeRequestHeaderData Headerdr = mdb.ExchangeRequestHeaderDatas.Single(a => a.Id == Rows.First().ExchangeRequestHeaderDataId); ADAM.DataBase.division div = mdb.divisions.Single(a => a.Id == Headerdr.DivisionId); ddlDepartment.SelectedValue = div.DepartmentId.ToString(); ddlDivision.DataBind(); ddlDivision.SelectedValue = Headerdr.DivisionId.ToString(); ddlEmployee.DataBind(); ddlEmployee.SelectedValue = Headerdr.EmpId.ToString(); txtDate.Text = Headerdr.ExchangeRequestDate.ToString("yyyy-MM-dd"); hfPurchaseHeaderId.Value = "0"; hfExchangeRequestHeaderId.Value = Headerdr.Id.ToString(); gvExchangeRequestData.DataBind(); } else { Response.Write("<script>alert('من تأكد من رقم طلب الصرف')</script>"); return; } #endregion } }
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.ExchangeRequestDetailsData Detailsdr = Mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(hfDetailsId.Value)); if (Detailsdr.Status == 0) { Mdb.ExchangeRequestDetailsDatas.Remove(Detailsdr); Mdb.SaveChanges(); gvExchangeRequestData.DataBind(); var Rows = from a in Mdb.ExchangeRequestDetailsDatas where a.ExchangeRequestHeaderDataId == long.Parse(hfId.Value) select a; if (Rows.Count() <= 0) { ADAM.DataBase.ExchangeRequestHeaderData Hdr = Mdb.ExchangeRequestHeaderDatas.Single(a => a.Id == long.Parse(hfId.Value)); Mdb.ExchangeRequestHeaderDatas.Remove(Hdr); Mdb.SaveChanges(); Response.Redirect("~/StoreData/webUpdateExchangeRequest.aspx"); } } else { Response.Write("<script>alert('لقد تم صرف هذا الصنف من المخزن')</script>"); return; } }
protected void btnShowData_Click(object sender, ImageClickEventArgs e) { 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(); ADAM.DataBase.ClientData client = mdb.ClientDatas.Single(a => a.Id == Hdr.ClientId); 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"); txtClientAddress.Text = client.Address; txtClientMob.Text = client.FirstMobile; txtClientName.Text = client.FirstName + " " + client.LastName; txtClientPhone.Text = client.FirstPhone; gvExchangeRequestData.DataBind(); } }
protected void btnShowData_Click(object sender, ImageClickEventArgs e) { try { if (ddlExchangeRequestType.SelectedValue == "0") { Response.Write("<script>alert('من فضلك أختر نوع طلب الصرف')</script>"); return; } if (ddlExchangeRequestType.SelectedValue == "10") { hfExchangeRequestType.Value = "8"; } if (ddlExchangeRequestType.SelectedValue == "11") { hfExchangeRequestType.Value = "9"; } if (ddlExchangeRequestType.SelectedValue == "12") { hfExchangeRequestType.Value = "10"; } if (ddlExchangeRequestType.SelectedValue == "13") { hfExchangeRequestType.Value = "11"; } if (ddlExchangeRequestType.SelectedValue == "14") { hfExchangeRequestType.Value = "12"; } if (string.IsNullOrEmpty(txtExchangeRequestNo.Text)) { Response.Write("<script>alert('من فضلك أدخل رقم طلب الصرف')</script>"); return; } ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString(); var ExchangeRequestRow = from a in db.ExchangeRequestHeaderDatas where a.ExchangeRequestNo == long.Parse(txtExchangeRequestNo.Text) && a.OrderType == long.Parse(hfExchangeRequestType.Value) select a; if (ExchangeRequestRow.Count() > 0) { ADAM.DataBase.ExchangeRequestHeaderData ERHdr = db.ExchangeRequestHeaderDatas.Single(a => a.ExchangeRequestNo == long.Parse(txtExchangeRequestNo.Text) && a.OrderType == long.Parse(hfExchangeRequestType.Value));; if (ERHdr.Posted == 1) { Response.Write("<script>alert('لقد تم انشاء فاتورة لهذا الطلب من قبل')</script>"); hfExchangeheaderId.Value = "0"; gvExchangeData.DataBind(); return; } txtExchangeRequestDate.Text = ERHdr.ExchangeRequestDate.ToString("yyyy-MM-dd"); ddlClient.SelectedValue = ERHdr.ClientId.ToString(); txtClientCode.Text = db.ClientDatas.Single(a => a.Id == ERHdr.ClientId).Code.ToString(); hfExchangeheaderId.Value = ERHdr.Id.ToString(); gvExchangeData.DataBind(); decimal AllPrice = 0; decimal AllItemCost = 0; ADAM.DataBase.IncommingOrderData incomdr = new DataBase.IncommingOrderData(); for (int GRow = 0; GRow < gvExchangeData.Rows.Count; GRow++) { decimal Qty = 0; decimal Price = 0; decimal Tester = 0; decimal TPrice = 0; Qty = decimal.Parse(gvExchangeData.Rows[GRow].Cells[3].Text); Price = decimal.Parse(gvExchangeData.Rows[GRow].Cells[4].Text); Tester = decimal.Parse(gvExchangeData.Rows[GRow].Cells[5].Text); TPrice = decimal.Parse(gvExchangeData.Rows[GRow].Cells[6].Text); incomdr = db.IncommingOrderDatas.Single(a => a.Id == long.Parse(gvExchangeData.DataKeys[GRow].Value.ToString())); AllItemCost += incomdr.ItemPrice * Qty; AllPrice += (Qty * Price) + (Tester * TPrice); } lblBillPrice.Text = AllPrice.ToString(); txtExchangeRequestNo.Enabled = false; ViewState["AllItemCost"] = AllItemCost.ToString(); } else { Response.Write("<script>alert('من فضلك تأكد من رقم طلب الصرف')</script>"); return; } } catch { } }