private void ShowData()
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var Rows = from a in Mdb.DirectSellDatas where a.DirectSellNo == long.Parse(txtDirectSellOrderNo.Text) select a;
if (Rows.Count() > 0)
{
#region ShowHeader
ADAM.DataBase.DirectSellData dr = Mdb.DirectSellDatas.Single(a => a.DirectSellNo == long.Parse(txtDirectSellOrderNo.Text));
txtDirectSellOrderNo.Text = dr.DirectSellNo.ToString();
txtDate.Text = dr.DirectSellDate.ToString("yyyy-MM-dd");
ADAM.DataBase.EmployeeData Empdr = Mdb.EmployeeDatas.Single(a => a.Id == dr.EmpId);
ADAM.DataBase.division divdr = Mdb.divisions.Single(a => a.Id == Empdr.DivisionId);
ADAM.DataBase.Department depId = Mdb.Departments.Single(a => a.Id == divdr.DepartmentId);
ddlDepartment.SelectedValue = depId.Id.ToString();
ddlDivision.DataBind();
ddlDivision.SelectedValue = divdr.Id.ToString();
ddlEmployee.DataBind();
ddlEmployee.SelectedValue = dr.EmpId.ToString();
ddlItemType.SelectedValue = dr.ItemType.ToString();
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 DeleteData()
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.EmployeeData dr = Mdb.EmployeeDatas.Single(a => a.Code == long.Parse(txtCode.Text));
Mdb.EmployeeDatas.Remove(dr);
Mdb.SaveChanges();
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.EmployeeDatas orderby a.Id descending select a;
if (Rows.Count() == 0)
{
txtCode.Text = "1";
}
else
{
ADAM.DataBase.EmployeeData dr = Rows.First();
txtCode.Text = (dr.Code + 1).ToString();
}
}
private void ShowData()
{
try
{
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var Rows = from a in Mdb.DeliveryDataHeaders where a.DeliveryNo == long.Parse(txtDeliveryOrderNo.Text) select a;
if (Rows.Count() > 0)
{
var detailsRow = from a in Mdb.DeliveryDataDetails
where a.Status == 0 && a.DeliveryDataHeader.DeliveryNo == long.Parse(txtDeliveryOrderNo.Text)
select a;
if (detailsRow.Count() <= 0)
{
Response.Write("<script>alert('لقد تم تسليم هذا الطلب بالكامل من قبل')</script>");
return;
}
#region ShowHeader
ADAM.DataBase.DeliveryDataHeader dr = Mdb.DeliveryDataHeaders.Single(a => a.DeliveryNo == long.Parse(txtDeliveryOrderNo.Text));
txtDeliveryOrderNo.Text = dr.DeliveryNo.ToString();
txtDate.Text = dr.DeliveryDate.ToString("yyyy-MM-dd");
ddlItemType.SelectedValue = dr.ItemTypeId.ToString();
ddlProductionLine.SelectedValue = dr.ProductionLineId.ToString();
hfId.Value = dr.Id.ToString();
ddlItemType.Enabled = false;
var EmpRows = from a in Mdb.EmployeeDatas where a.Id == dr.EmpId select a;
if (EmpRows.Count() > 0)
{
ADAM.DataBase.EmployeeData Empdr = Mdb.EmployeeDatas.Single(a => a.Id == dr.EmpId);
ddlDepartment.SelectedValue = Empdr.DepartmentId.ToString();
ddlDivision.DataBind();
ddlDivision.SelectedValue = Empdr.DivisionId.ToString();
ddlEmployee.DataBind();
ddlEmployee.SelectedValue = Empdr.Id.ToString();
}
#endregion
gvDeliveryData.DataBind();
}
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>"); }
}
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>"); }
}
