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