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