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 DeleteData()
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ClientData dr = Mdb.ClientDatas.Single(a => a.Code == long.Parse(txtCode.Text));
Mdb.ClientDatas.Remove(dr);
Mdb.SaveChanges();
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.ClientData dr = Mdb.ClientDatas.Single(a => a.Code == long.Parse(txtCode.Text) && a.EmployeeId == long.Parse(ddlSalesRepresentative.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.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.SaveChanges();
Response.Write("<script>alert('تمت عملية التعديل بنجاح')</script>");
}
else
{
Response.Write("<script>alert('هذا الكود غير موجود بقاعدة البيانات')</script>");
}
}
}
catch { Response.Write("<script>alert('خطأ أثناء التعديل من فضلك تأكد من ادخال البيانات بشكل صحيح او الاتصال بقاعدة البيانات ')</script>"); }
}
protected void ddlClientName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ClientData dr = mdb.ClientDatas.Single(a => a.Id == long.Parse(ddlClientName.SelectedValue));
txtClienCode.Text = dr.Code.ToString();
}
catch
{
return;
}
}
protected void txtClientName_TextChanged(object sender, EventArgs e)
{
try
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ClientData dr = mdb.ClientDatas.Single(a => a.Code == long.Parse(txtClienCode.Text));
ddlClientName.SelectedValue = dr.Id.ToString();
}
catch
{
Response.Write("<script>alert('من فضلك تأكد من كود العميل')</script>");
return;
}
}
private void GetNum()
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Rows = from a in mdb.ClientDatas where a.EmployeeId == long.Parse(ddlSalesRepresentative.SelectedValue) orderby a.Id descending select a;
if (Rows.Count() == 0)
{
txtCode.Text = "1";
}
else
{
ADAM.DataBase.ClientData dr = Rows.First();
txtCode.Text = (dr.Code + 1).ToString();
}
}
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();
}
}
