public string GetAccountCode(long Id) { try { ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString(); ADAM.DataBase.Account dr = db.Accounts.Single(a => a.Id == Id); return(dr.AccountCode.ToString()); } catch { return(""); } }
protected void ddlBoxName_SelectedIndexChanged(object sender, EventArgs e) { try { ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString(); ADAM.DataBase.Account accdr = db.Accounts.Single(a => a.Id == long.Parse(ddlBoxName.SelectedValue)); txtBoxNo.Text = accdr.AccountCode.ToString(); } catch { } }
protected void gvAcccount_SelectedIndexChanged(object sender, EventArgs e) { ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString(); ADAM.DataBase.Account accdr = db.Accounts.Single(a => a.Id == long.Parse(gvAcccount.SelectedDataKey.Value.ToString())); ddlAccountName.SelectedValue = accdr.Id.ToString(); txtAccountNo.Text = accdr.AccountCode.ToString(); divData.Visible = true; divCostCenter.Visible = divAccount.Visible = false; }
private void ShowData() { try { if (ddlSalesRepresentative.SelectedValue == "0") { txtCode.Enabled = true; Response.Write("<script>alert('من فضلك أختر المندوب اولاً')</script>"); return; } ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); var Rows = from a in Mdb.ClientDatas where a.Code == long.Parse(txtCode.Text) && a.EmployeeId == long.Parse(ddlSalesRepresentative.SelectedValue) select a; if (Rows.Count() > 0) { ADAM.DataBase.ClientData dr = Mdb.ClientDatas.Single(a => a.Code == long.Parse(txtCode.Text) && a.EmployeeId == long.Parse(ddlSalesRepresentative.SelectedValue)); txtFirstName.Text = dr.FirstName; txtLastName.Text = dr.LastName; txtFirstPhone.Text = dr.FirstPhone; txtSecondPhone.Text = dr.SecondPhone; txtFirstMobile.Text = dr.FirstMobile; txtSecondMobile.Text = dr.SecondMobile; txtFax.Text = dr.Fax; txtEmail.Text = dr.Email; txtAddress.Text = dr.Address; txtIdNo.Text = dr.IdNo; ddlJob.SelectedValue = dr.JobId.ToString(); ddlSex.SelectedValue = dr.Sex.ToString(); ddlCountry.SelectedValue = dr.CountryId.ToString(); ddlCity.DataBind(); ddlCity.SelectedValue = dr.CityId.ToString(); ddlGovernorate.DataBind(); ddlGovernorate.SelectedValue = dr.GovernorateId.ToString(); ddlArea.DataBind(); ddlArea.SelectedValue = dr.AreaId.ToString(); txtAccountCode.Text = dr.AccountId.ToString(); var AccountRow = from a in Mdb.Accounts where a.Id == dr.AccountId select a; if (AccountRow.Count() > 0) { ADAM.DataBase.Account accdr = Mdb.Accounts.Single(a => a.Id == dr.AccountId); txtAccountCode.Text = accdr.AccountCode.ToString(); } else { Response.Write("<script>alert('هذا العميل ليس له حساب من فضلك تأكد من انشاء حساب لهذا العميل')</script>"); } } else { Response.Write("<script>alert('من فضلك تأكد من كود العميل')</script>"); } } catch { Response.Write("<script>alert('خطأ أثناء عرض البيانات من فضلك تأكد من الكود او من الاتصال بقاعدة البيانات')</script>"); } }
private void EditData() { try { if (ValidationData()) { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.SupplierData dr = Mdb.SupplierDatas.Single(a => a.Code == long.Parse(txtCode.Text) && a.SupplierTypeId == long.Parse(ddlSupplierType.SelectedValue)); if (Validation()) { dr.Address = txtAddress.Text; dr.Email = txtEmail.Text; dr.Fax = txtFax.Text; dr.FirstMobile = txtFirstMobile.Text; dr.FirstName = txtFirstName.Text; dr.FirstPhone = txtFirstPhone.Text; dr.IdNo = txtIdNo.Text; dr.LastName = txtLastName.Text; dr.SecondMobile = txtSecondMobile.Text; dr.SecondPhone = txtSecondPhone.Text; dr.JobId = long.Parse(ddlJob.SelectedValue); dr.Sex = int.Parse(ddlSex.SelectedValue); dr.CountryId = long.Parse(ddlCountry.SelectedValue); dr.CityId = long.Parse(ddlCity.SelectedValue); dr.Status = int.Parse(ddlStatus.SelectedValue); dr.GovernorateId = long.Parse(ddlGovernorate.SelectedValue); dr.SupplierTypeId = long.Parse(ddlSupplierType.SelectedValue); dr.AreaId = long.Parse(ddlArea.SelectedValue); var AccountRow = from a in Mdb.Accounts where a.AccountCode == long.Parse(txtAccountCode.Text) select a; if (AccountRow.Count() > 0) { ADAM.DataBase.Account accdr = Mdb.Accounts.Single(a => a.AccountCode == long.Parse(txtAccountCode.Text)); dr.AccountId = accdr.Id; } else { Response.Write("<script>alert('هذا المورد ليس له حساب من فضلك تأكد من انشاء حساب اولا قبل التعديل')</script>"); return; } Mdb.SaveChanges(); Response.Write("<script>alert('تمت عملية التعديل بنجاح')</script>"); } else { Response.Write("<script>alert('هذا الكود غير موجود بقاعدة البيانات')</script>"); } } } catch { Response.Write("<script>alert('خطأ أثناء التعديل من فضلك تأكد من ادخال البيانات بشكل صحيح او الاتصال بقاعدة البيانات ')</script>"); } }
protected void txtAccountCode_TextChanged(object sender, EventArgs e) { try { ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString(); var Rows = from a in db.Accounts where a.AccountCode == long.Parse(txtAccountCode.Text) select a; if (Rows.Count() > 0) { ADAM.DataBase.Account dr = db.Accounts.Single(a => a.AccountCode == long.Parse(txtAccountCode.Text)); ddlAccount.SelectedValue = dr.Id.ToString(); } } catch { } }
private void ShowData() { try { ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString(); ADAM.DataBase.Account dr = db.Accounts.Single(a => a.Id == long.Parse(hfParentId.Value)); txtAccountCode.Text = dr.AccountCode.ToString(); txtAccountName.Text = dr.AccountName; ddlAccountType.SelectedValue = dr.AccountType.ToString(); ddlCurrency.SelectedValue = dr.AccountCurrency.ToString(); hfID.Value = dr.Id.ToString(); } catch { } }
protected void txtDetailsAccountNo_TextChanged(object sender, EventArgs e) { try { ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString(); var Rows = from a in db.Accounts where a.AccountCode == long.Parse(txtDetailsAccountNo.Text) select a; if (Rows.Count() > 0) { ADAM.DataBase.Account accdr = db.Accounts.Single(a => a.AccountCode == long.Parse(txtDetailsAccountNo.Text)); ddlDetailsAccountName.SelectedValue = accdr.Id.ToString(); } else { Response.Write("<script>alert('من فضلك تأكد من رقم الحساب')</script>"); return; } } catch { } }
public string GetAccountId(string Code) { try { long AccountCode = long.Parse(Code); ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString(); var Rows = from a in db.Accounts where a.AccountCode == AccountCode select a; if (Rows.Count() > 0) { ADAM.DataBase.Account dr = db.Accounts.Single(a => a.AccountCode == AccountCode); return(dr.Id.ToString()); } else { return(""); } } catch { return(""); } }
private void SaveData() { try { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.ClientData dr = new DataBase.ClientData(); dr.Code = long.Parse(txtCode.Text); dr.Address = txtAddress.Text; dr.Email = txtEmail.Text; dr.Fax = txtFax.Text; dr.FirstMobile = txtFirstMobile.Text; dr.FirstName = txtFirstName.Text; dr.FirstPhone = txtFirstPhone.Text; dr.IdNo = txtIdNo.Text; dr.LastName = txtLastName.Text; dr.SecondMobile = txtSecondMobile.Text; dr.SecondPhone = txtSecondPhone.Text; dr.JobId = long.Parse(ddlJob.SelectedValue); dr.Sex = int.Parse(ddlSex.SelectedValue); dr.CountryId = long.Parse(ddlCountry.SelectedValue); dr.CityId = long.Parse(ddlCity.SelectedValue); dr.GovernorateId = long.Parse(ddlGovernorate.SelectedValue); dr.AreaId = long.Parse(ddlArea.SelectedValue); dr.EmployeeId = long.Parse(ddlSalesRepresentative.SelectedValue); var AccountRow = from a in Mdb.Accounts where a.AccountCode == long.Parse(txtAccountCode.Text) select a; if (AccountRow.Count() > 0) { ADAM.DataBase.Account accdr = Mdb.Accounts.Single(a => a.AccountCode == long.Parse(txtAccountCode.Text)); dr.AccountId = accdr.Id; } else { Response.Write("<script>alert('هذا العميل ليس له حساب من فضلك تأكد من انشاء حساب اولا لهذاالعميل قبل الحفظ')</script>"); return; } Mdb.ClientDatas.Add(dr); Mdb.SaveChanges(); Response.Redirect("~/MainData/webClientData.aspx"); } catch { Response.Write("<script>alert('خطأ أثناء الحفظ من فضلك تأكد من ادخال البيانات بشكل صحيح او الاتصال بقاعدة البيانات')</script>"); } }
protected void gvAcccount_SelectedIndexChanged(object sender, EventArgs e) { ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString(); ADAM.DataBase.Account dr = db.Accounts.Single(a => a.Id == long.Parse(gvAcccount.SelectedDataKey.Value.ToString())); if (hfControlName.Value == "ddlHeaderAccountName") { ddlHeaderAccountName.SelectedValue = dr.Id.ToString(); txtHeaderAccountNo.Text = dr.AccountCode.ToString(); } if (hfControlName.Value == "ddlDetailsAccountName") { ddlDetailsAccountName.SelectedValue = dr.Id.ToString(); txtDetailsAccountNo.Text = dr.AccountCode.ToString(); } divAccount.Visible = divCostCenter.Visible = false; divData.Visible = true; }
private void ShowData() { try { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); var Rows = from a in Mdb.BoxDatas where a.BoxCode == long.Parse(txtCode.Text) select a; if (Rows.Count() > 0) { ADAM.DataBase.BoxData dr = Mdb.BoxDatas.Single(a => a.BoxCode == long.Parse(txtCode.Text)); txtName.Text = dr.BoxName; txtNote.Text = dr.Note; ADAM.DataBase.Account accdr = Mdb.Accounts.Single(a => a.Id == dr.AccountId); txtAccount.Text = accdr.AccountCode.ToString(); } else { Response.Write("<script>alert('من فضلك تأكد من كود الصندوق')</script>"); } } catch { Response.Write("<script>alert('خطأ أثناء عرض البيانات من فضلك تأكد من الكود او من الاتصال بقاعدة البيانات')</script>"); } }
private void EditData() { try { if (string.IsNullOrEmpty(txtCode.Text) || string.IsNullOrEmpty(txtName.Text)) { Response.Write("<script>alert('من فضلك تأكد من ادخال كل البيانات بشكل صحيح')</script>"); return; } ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.SupplierType dr = Mdb.SupplierTypes.Single(a => a.SupplierTypeCode == long.Parse(txtCode.Text)); if (Validation()) { dr.SupplierTypeName = txtName.Text; var AccountRow = from a in Mdb.Accounts where a.AccountCode == long.Parse(txtAccountCode.Text) select a; if (AccountRow.Count() > 0) { ADAM.DataBase.Account accdr = Mdb.Accounts.Single(a => a.AccountCode == long.Parse(txtAccountCode.Text)); dr.AccountId = accdr.Id; } else { Response.Write("<script>alert('نوع الموردين ليس له حساب من فضلك تأكد من انشاء حساب اولا قبل التعديل')</script>"); return; } Mdb.SaveChanges(); Response.Write("<script>alert('تمت عملية التعديل بنجاح')</script>"); } else { Response.Write("<script>alert('هذا الكود غير موجود بقاعدة البيانات')</script>"); } } catch { Response.Write("<script>alert('خطأ أثناء التعديل من فضلك تأكد من ادخال البيانات بشكل صحيح او الاتصال بقاعدة البيانات ')</script>"); } }
private void EditData() { try { if (string.IsNullOrEmpty(txtCode.Text) || string.IsNullOrEmpty(txtName.Text) || string.IsNullOrEmpty(txtAccount.Text)) { Response.Write("<script>alert('من فضلك تأكد من ادخال كل البيانات بشكل صحيح')</script>"); return; } ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.BoxData dr = Mdb.BoxDatas.Single(a => a.BoxCode == long.Parse(txtCode.Text)); if (Validation()) { dr.BoxName = txtName.Text; dr.Note = txtNote.Text; var Rows = from a in Mdb.Accounts where a.AccountCode == long.Parse(txtAccount.Text) select a; if (Rows.Count() > 0) { ADAM.DataBase.Account accdr = Mdb.Accounts.Single(a => a.AccountCode == long.Parse(txtAccount.Text)); dr.AccountId = accdr.Id; } else { Response.Write("<script>alert('من فضلك تأكد من رقم الحساب')</script>"); return; } Mdb.SaveChanges(); Response.Write("<script>alert('تمت عملية التعديل بنجاح')</script>"); } else { Response.Write("<script>alert('هذا الكود غير موجود بقاعدة البيانات')</script>"); } } catch { Response.Write("<script>alert('خطأ أثناء التعديل من فضلك تأكد من ادخال البيانات بشكل صحيح او الاتصال بقاعدة البيانات ')</script>"); } }
private void EditData() { try { if (ValidationData()) { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.EmployeeData dr = Mdb.EmployeeDatas.Single(a => a.Code == long.Parse(txtCode.Text)); if (Validation()) { dr.Address = txtAddress.Text; dr.BirthDate = DateTime.Parse(txtBirthDate.Text); dr.Email = txtEmail.Text; dr.FaxNo = txtFaxNo.Text; dr.FirstMobileNo = txtFirstMobileNo.Text; dr.FirstName = txtFirstName.Text; dr.FirstPhone = txtFirstPhone.Text; dr.IdNo = txtIdNo.Text; dr.LastName = txtLastName.Text; dr.SecondMobileNo = txtSecondMobileNo.Text; dr.SecondPhone = txtSecondPhone.Text; dr.StartJobDate = DateTime.Parse(txtStartJobDate.Text); dr.ContractType = int.Parse(ddlContractType.SelectedValue); dr.DepartmentId = long.Parse(ddlDepartment.SelectedValue); dr.DivisionId = long.Parse(ddlDivision.SelectedValue); dr.InsuranceStatus = int.Parse(ddlInsuranceStatus.SelectedValue); dr.JobId = long.Parse(ddlJob.SelectedValue); dr.MaritalStatus = int.Parse(ddlMaritalStatus.SelectedValue); dr.MilitaryStatus = int.Parse(ddlMilitaryStatus.SelectedValue); dr.QualificationId = long.Parse(ddlQualification.SelectedValue); dr.Religion = int.Parse(ddlReligion.SelectedValue); dr.Sex = int.Parse(ddlSex.SelectedValue); dr.CountryId = long.Parse(ddlCountry.SelectedValue); dr.CityId = long.Parse(ddlCity.SelectedValue); dr.GovernorateId = long.Parse(ddlGovernorate.SelectedValue); dr.AreaId = long.Parse(ddlArea.SelectedValue); if (chkISSalesRepresentative.Checked) { dr.ISSalesRepresentative = true; } else { dr.ISSalesRepresentative = false; } var AccountRow = from a in Mdb.Accounts where a.AccountCode == long.Parse(txtAccountCode.Text) select a; if (AccountRow.Count() > 0) { ADAM.DataBase.Account accdr = Mdb.Accounts.Single(a => a.AccountCode == long.Parse(txtAccountCode.Text)); dr.AccountId = accdr.Id; } else { Response.Write("<script>alert('هذا الموظف ليس له حساب من فضلك تأكد من انشاء حساب اولا قبل التعديل')</script>"); return; } Mdb.SaveChanges(); Response.Write("<script>alert('تمت عملية التعديل بنجاح')</script>"); } else { Response.Write("<script>alert('هذا الكود غير موجود بقاعدة البيانات')</script>"); } } } catch { Response.Write("<script>alert('خطأ أثناء التعديل من فضلك تأكد من ادخال البيانات بشكل صحيح او الاتصال بقاعدة البيانات ')</script>"); } }
protected void gvAcccount_SelectedIndexChanged(object sender, EventArgs e) { ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString(); ADAM.DataBase.Account dr = db.Accounts.Single(a => a.Id == long.Parse(gvAcccount.SelectedDataKey.Value.ToString())); if (hfControlName.Value == "btnSalesAccount") { ddlSalesAccount.SelectedValue = dr.Id.ToString(); txtSalesAccount.Text = dr.AccountCode.ToString(); } if (hfControlName.Value == "btnSalesCost") { ddlSalesCost.SelectedValue = dr.Id.ToString(); txtSalesCost.Text = dr.AccountCode.ToString(); } if (hfControlName.Value == "btnReturnSalesAccount") { ddlReturnSalesAccount.SelectedValue = dr.Id.ToString(); txtReturnSalesAccount.Text = dr.AccountCode.ToString(); } if (hfControlName.Value == "btnAllowedDiscount") { ddlAllowedDiscount.SelectedValue = dr.Id.ToString(); txtAllowedDiscount.Text = dr.AccountCode.ToString(); } if (hfControlName.Value == "btnReturnOldeYears") { ddlReturnOldeYears.SelectedValue = dr.Id.ToString(); txtReturnOldeYears.Text = dr.AccountCode.ToString(); } if (hfControlName.Value == "btnRetuenYearsCost") { ddlRetuenYearsCost.SelectedValue = dr.Id.ToString(); txtRetuenYearsCost.Text = dr.AccountCode.ToString(); } if (hfControlName.Value == "btnReturnPurchase") { ddlReturnPurchase.SelectedValue = dr.Id.ToString(); txtReturnPurchase.Text = dr.AccountCode.ToString(); } if (hfControlName.Value == "btnWinDiscount") { ddlWinDiscount.SelectedValue = dr.Id.ToString(); txtWinDiscount.Text = dr.AccountCode.ToString(); } if (hfControlName.Value == "btnFreeQty") { ddlFreeQty.SelectedValue = dr.Id.ToString(); txtFreeQty.Text = dr.AccountCode.ToString(); } divAccount.Visible = false; divData.Visible = true; }
protected void ddlAccount_SelectedIndexChanged(object sender, EventArgs e) { ADAM.DataBase.ADAMConnectionString db = new DataBase.ADAMConnectionString(); ADAM.DataBase.Account dr = db.Accounts.Single(a => a.Id == long.Parse(ddlAccount.SelectedValue)); txtAccountCode.Text = dr.AccountCode.ToString(); }
private void ShowData() { try { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); var Rows = from a in Mdb.EmployeeDatas where a.Code == long.Parse(txtCode.Text) select a; if (Rows.Count() > 0) { ADAM.DataBase.EmployeeData dr = Mdb.EmployeeDatas.Single(a => a.Code == long.Parse(txtCode.Text)); txtAddress.Text = dr.Address; txtEmail.Text = dr.Email; txtFaxNo.Text = dr.FaxNo; txtFirstMobileNo.Text = dr.FirstMobileNo; txtFirstName.Text = dr.FirstName; txtFirstPhone.Text = dr.FirstPhone; txtIdNo.Text = dr.IdNo; txtLastName.Text = dr.LastName; txtSecondMobileNo.Text = dr.SecondMobileNo; txtSecondPhone.Text = dr.SecondPhone; txtBirthDate.Text = dr.BirthDate.ToString("yyyy-MM-dd"); txtStartJobDate.Text = dr.StartJobDate.ToString("yyyy-MM-dd"); ddlContractType.SelectedValue = dr.ContractType.ToString(); ddlDepartment.SelectedValue = dr.DepartmentId.ToString(); dbDivision.DataBind(); ddlDivision.DataBind(); ddlDivision.SelectedValue = dr.DivisionId.ToString(); ddlInsuranceStatus.SelectedValue = dr.InsuranceStatus.ToString(); ddlJob.SelectedValue = dr.JobId.ToString(); ddlMaritalStatus.SelectedValue = dr.MaritalStatus.ToString(); ddlMilitaryStatus.SelectedValue = dr.MilitaryStatus.ToString(); ddlQualification.SelectedValue = dr.QualificationId.ToString(); ddlReligion.SelectedValue = dr.Religion.ToString(); ddlSex.SelectedValue = dr.Sex.ToString(); ddlCountry.SelectedValue = dr.CountryId.ToString(); ddlCity.DataBind(); ddlCity.SelectedValue = dr.CityId.ToString(); ddlGovernorate.DataBind(); ddlGovernorate.SelectedValue = dr.GovernorateId.ToString(); ddlArea.DataBind(); ddlArea.SelectedValue = dr.AreaId.ToString(); if (dr.ISSalesRepresentative) { chkISSalesRepresentative.Checked = true; } else { chkISSalesRepresentative.Checked = false; } txtAccountCode.Text = dr.AccountId.ToString(); var AccountRow = from a in Mdb.Accounts where a.Id == dr.AccountId select a; if (AccountRow.Count() > 0) { ADAM.DataBase.Account accdr = Mdb.Accounts.Single(a => a.Id == dr.AccountId); txtAccountCode.Text = accdr.AccountCode.ToString(); } else { Response.Write("<script>alert('هذا الموظف ليس له حساب من فضلك تأكد من انشاء حساب')</script>"); } } else { Response.Write("<script>alert('من فضلك تأكد من كود الموظف')</script>"); } } catch { Response.Write("<script>alert('خطأ أثناء عرض البيانات من فضلك تأكد من الكود او من الاتصال بقاعدة البيانات')</script>"); } }