private void حذفToolStripMenuItem_Click(object sender, EventArgs e) { if (MaterialMessageBox.Show("تاكيد الحذف", MessageBoxButtons.YesNo) == DialogResult.OK) { Employee_View xx = gvEmployeeCard.GetFocusedRow() as Employee_View; Employee _Employees = new Employee(); using (DB_A65D4E_SolarEnergyEntities context2 = new DB_A65D4E_SolarEnergyEntities()) { Employee employee = new Employee(); _Employees = context2.Employees.Where(item => item.Employee_Code == xx.Employee_Code && item.IsDeleted == 0).SingleOrDefault(); _Employees.IsDeleted = 1; context2.SaveChanges(); FillGride(); } } }
private void btnAdd_Click_2(object sender, EventArgs e) { #region Validation if (string.IsNullOrWhiteSpace(TxtEmpName.Text)) { MaterialMessageBox.Show("برجاء ادخال اسم الموظف", MessageBoxButtons.OK); //TxtEmpName.Properties.ver return; } else if (string.IsNullOrWhiteSpace(slkGender.Text)) { MaterialMessageBox.Show("برجاء اختيار الجنس", MessageBoxButtons.OK); TxtEmpName.Focus(); return; } else if (string.IsNullOrWhiteSpace(dtBrithDay.Text)) { MaterialMessageBox.Show("برجاءاختيار ناريخ الميلاد", MessageBoxButtons.OK); dtBrithDay.Focus(); return; } else if (string.IsNullOrWhiteSpace(TxtEmpNataionalId.Text)) { MaterialMessageBox.Show("برجاء ادخال الرقم القومي للموظف", MessageBoxButtons.OK); TxtEmpNataionalId.Focus(); return; } else if (string.IsNullOrWhiteSpace(slkNational.Text)) { MaterialMessageBox.Show("برجاءاختيار الجنسية ", MessageBoxButtons.OK); slkNational.Focus(); return; } else if (string.IsNullOrWhiteSpace(slkJop.Text)) { MaterialMessageBox.Show("برجاء اختيار الوظيفة", MessageBoxButtons.OK); slkJop.Focus(); return; } else if (string.IsNullOrWhiteSpace(slkBranch.Text)) { MaterialMessageBox.Show("برجاء اختيار الفرع", MessageBoxButtons.OK); slkBranch.Focus(); return; } else if (string.IsNullOrWhiteSpace(dtHiringDate.Text)) { MaterialMessageBox.Show("برجاء اختيار تاريخ التوظيف", MessageBoxButtons.OK); dtHiringDate.Focus(); return; } #endregion if (Application.OpenForms.OfType <frmEmployees>().Any()) { frmEmployees frm = (frmEmployees)Application.OpenForms["frmEmployees"]; Int64 EmpCode = Convert.ToInt64(txtEmpCode.Text); using (DB_A65D4E_SolarEnergyEntities ForCheck = new DB_A65D4E_SolarEnergyEntities()) { bool TestUserName = ForCheck.Employees.Any(Emp => Emp.EmployeeName == TxtEmpName.Text && Emp.Employee_Code != EmpCode && Emp.IsDeleted == 0); if (TestUserName) { MaterialMessageBox.Show("تم تسجيل هذا الاسم لموظف اخر", MessageBoxButtons.OK); return; } bool TestNatId = ForCheck.Employees.Any(Emp => Emp.National_Id == TxtEmpNataionalId.Text && Emp.IsDeleted == 0); if (TestUserName) { MaterialMessageBox.Show("تم تسجيل رقم البطاقة لموظف اخر", MessageBoxButtons.OK); return; } } Employee _Employee; _Employee = context.Employees.Where(Employee => Employee.Employee_Code == EmpCode && Employee.IsDeleted == 0).SingleOrDefault(); _Employee.EmployeeName = TxtEmpName.Text; _Employee.Natinality_Code = Convert.ToInt32(slkNational.EditValue); _Employee.National_Id = TxtEmpNataionalId.Text; _Employee.Email = txtEmail.Text; _Employee.EmployeeAddress1 = txtAdress1.Text; _Employee.EmployeeAddress2 = txtAdress2.Text; _Employee.Birthdate = Convert.ToDateTime(dtBrithDay.EditValue); _Employee.HiringDate = Convert.ToDateTime(dtHiringDate.EditValue); _Employee.Phone = txtMob1.Text; _Employee.Phone2 = txtMob2.Text; _Employee.Job_Code = Convert.ToInt64(slkJop.EditValue); _Employee.Gender_Id = Convert.ToInt16(slkGender.EditValue); _Employee.Branch_Code = Convert.ToInt64(slkBranch.EditValue); _Employee.LandLine = txtLandLine.Text; _Employee.Last_Modified_Date = DateTime.Now; _Employee.Last_Modified_User = st.User_Code(); context.SaveChanges(); frmEmployees frmEmpMain = new frmEmployees(); using (DB_A65D4E_SolarEnergyEntities NewReco = new DB_A65D4E_SolarEnergyEntities()) { var EmpData = NewReco.Employee_View.Where(x => x.IsDeleted == 0).ToList(); frmEmpMain.gcEmployeeCard.DataSource = EmpData; frmEmpMain.gcEmployeeCard.RefreshDataSource(); Employee_View result2 = EmpData.Where(x => x.Employee_Code == EmpCode && x.IsDeleted == 0).FirstOrDefault(); frm.gvEmployeeCard.SetFocusedRowCellValue("EmployeeName", result2.EmployeeName); frm.gvEmployeeCard.SetFocusedRowCellValue("Gender_Name", result2.Gender_Name); frm.gvEmployeeCard.SetFocusedRowCellValue("National_Id", result2.National_Id); frm.gvEmployeeCard.SetFocusedRowCellValue("Email", result2.Email); frm.gvEmployeeCard.SetFocusedRowCellValue("Phone", result2.Phone); frm.gvEmployeeCard.SetFocusedRowCellValue("Phone", result2.Phone2); frm.gvEmployeeCard.SetFocusedRowCellValue("JobName", result2.JobName); frm.gvEmployeeCard.SetFocusedRowCellValue("HiringDate", result2.HiringDate); frm.gvEmployeeCard.SetFocusedRowCellValue("LandLine", result2.LandLine); frm.gvEmployeeCard.SetFocusedRowCellValue("EmployeeAddress1", result2.EmployeeAddress1); frm.gvEmployeeCard.SetFocusedRowCellValue("EmployeeAddress2", result2.EmployeeAddress2); frm.gvEmployeeCard.SetFocusedRowCellValue("Birthdate", result2.Birthdate); frm.gvEmployeeCard.SetFocusedRowCellValue("National_Name", result2.National_Name); frm.gvEmployeeCard.SetFocusedRowCellValue("BranchName", result2.BranchName); frm.gvEmployeeCard.SetFocusedRowCellValue("DepartmentName", result2.DepartmentName); frm.gvEmployeeCard.RefreshData(); HelperClass.HelperClass.ClearValues(tableLayoutPanel2); } this.Close(); } }
private void windowsUIButtonPanel_ButtonClick(object sender, DevExpress.XtraBars.Docking2010.ButtonEventArgs e) { WindowsUIButton btn = e.Button as WindowsUIButton; if (btn.Caption == "جديد") { FrmAddEmployees frm = new FrmAddEmployees(); try { var result = _Jop.Where(Job => Job.IsDeleted == 0).ToList(); if (result.Count > 0 && result != null) { frm.slkJop.Properties.DataSource = result; frm.slkJop.Properties.ValueMember = "Jop_Code"; frm.slkJop.Properties.DisplayMember = "JobName"; frm.slkJop.EditValue = result[0].Jop_Code; } } catch { } try { var result = _branches.Where(Branche => Branche.IsDeleted == 0).ToList(); if (result.Count > 0 && result != null) { frm.slkBranch.Properties.DataSource = result; frm.slkBranch.Properties.ValueMember = "Branch_Code"; frm.slkBranch.Properties.DisplayMember = "BranchName"; frm.slkBranch.EditValue = result[0].Branch_Code; } } catch { } try { var result = _Gender.ToList(); if (result.Count > 0 && result != null) { frm.slkGender.Properties.DataSource = result; frm.slkGender.Properties.ValueMember = "Gender_Id"; frm.slkGender.Properties.DisplayMember = "Gender_Name"; frm.slkGender.EditValue = result[0].Gender_Id; } } catch { } try { var result = _Nationality.Where(Nationalitie => Nationalitie.IsDeleted == 0).ToList(); if (result.Count > 0 && result != null) { frm.slkNational.Properties.DataSource = result; frm.slkNational.Properties.ValueMember = "National_Code"; frm.slkNational.Properties.DisplayMember = "National_Name"; frm.slkNational.EditValue = result[0].Id; } } catch { } Int64?MaxCode = 1; if (_Employee_View != null && _Employee_View.Count > 0) { MaxCode = _Employee_View.Where(xx => xx.IsDeleted == 0).Max(u => (Int64?)u.Employee_Code + 1); } frm.txtEmpCode.Text = MaxCode.ToString(); frm._Employee_View = _Employee_View; frm.ShowDialog(); } else if (btn.Caption == "تعديل") { if (gvEmployeeCard.RowCount <= 0) { return; } frmEditeEmployees frm = new frmEditeEmployees(); var x = gvEmployeeCard.GetFocusedRow() as Employee_View; using (DB_A65D4E_SolarEnergyEntities context4 = new DB_A65D4E_SolarEnergyEntities()) { var emp = context.Employee_View.Where(xx => xx.IsDeleted == 0 && xx.Employee_Code == x.Employee_Code).SingleOrDefault(); frm.txtEmpCode.Text = emp.Employee_Code.ToString(); frm.TxtEmpName.Text = emp.EmployeeName.ToString(); frm.dtBrithDay.EditValue = emp.Birthdate; frm.TxtEmpNataionalId.Text = emp.National_Id.ToString(); frm.txtAdress1.Text = emp.EmployeeAddress1.ToString(); frm.txtAdress2.Text = emp.EmployeeAddress2.ToString(); frm.txtMob1.Text = emp.Phone.ToString(); frm.txtMob2.Text = emp.Phone2.ToString(); frm.txtLandLine.Text = emp.LandLine.ToString(); frm.txtEmail.Text = emp.Email.ToString(); frm.dtHiringDate.EditValue = emp.HiringDate; try { var result = _Jop.Where(Job => Job.IsDeleted == 0).ToList(); if (result.Count > 0 && result != null) { frm.slkJop.Properties.DataSource = result; frm.slkJop.Properties.ValueMember = "Jop_Code"; frm.slkJop.Properties.DisplayMember = "JobName"; frm.slkJop.EditValue = emp.Job_Code; } } catch { } try { var result = _branches.Where(Branche => Branche.IsDeleted == 0).ToList(); if (result.Count > 0 && result != null) { frm.slkBranch.Properties.DataSource = result; frm.slkBranch.Properties.ValueMember = "Branch_Code"; frm.slkBranch.Properties.DisplayMember = "BranchName"; frm.slkBranch.EditValue = emp.Branch_Code; } } catch { } try { var result = _Gender.ToList(); if (result.Count > 0 && result != null) { frm.slkGender.Properties.DataSource = result; frm.slkGender.Properties.ValueMember = "Gender_Id"; frm.slkGender.Properties.DisplayMember = "Gender_Name"; frm.slkGender.EditValue = emp.Gender_Id; } } catch { } try { var result = _Nationality.Where(Nationalitie => Nationalitie.IsDeleted == 0).ToList(); if (result.Count > 0 && result != null) { frm.slkNational.Properties.DataSource = result; frm.slkNational.Properties.ValueMember = "National_Code"; frm.slkNational.Properties.DisplayMember = "National_Name"; frm.slkNational.EditValue = emp.Natinality_Code; } } catch { } } frm.ShowDialog(); } else if (btn.Caption == "خروج") { this.Close(); } else if (btn.Caption == "حذف") { if (gvEmployeeCard.RowCount <= 0) { return; } if (MaterialMessageBox.Show("تاكيد الحذف", MessageBoxButtons.YesNo) == DialogResult.OK) { Employee_View xx = gvEmployeeCard.GetFocusedRow() as Employee_View; Employee _Employees = new Employee(); using (DB_A65D4E_SolarEnergyEntities context2 = new DB_A65D4E_SolarEnergyEntities()) { Employee employee = new Employee(); _Employees = context2.Employees.SingleOrDefault(item => item.Employee_Code == xx.Employee_Code && item.IsDeleted == 0); _Employees.IsDeleted = 1; context2.SaveChanges(); } } FillGride(); } else if (btn.Caption == "تحديث") { using (DB_A65D4E_SolarEnergyEntities refershContext = new DB_A65D4E_SolarEnergyEntities()) { _branches = refershContext.Branches.Where(x => x.IsDeleted == 0).ToList(); _Jop = refershContext.Jobs.Where(x => x.IsDeleted == 0).ToList(); _Nationality = refershContext.Nationalities.Where(x => x.IsDeleted == 0).ToList(); _Employee_View = refershContext.Employee_View.Where(x => x.IsDeleted == 0).ToList(); if (_Employee_View.Count > 0 && _Employee_View != null) { gcEmployeeCard.DataSource = null; gcEmployeeCard.DataSource = _Employee_View; gcEmployeeCard.RefreshDataSource(); } else { gcEmployeeCard.Enabled = false; windowsUIButtonPanel.Buttons.ForEach(x => { if (x.Properties.Caption == "تعديل" || x.Properties.Caption == "طباعة" || x.Properties.Caption == "حذف") { x.Properties.Enabled = false; } if (x.Properties.Caption == "جديد") { x.Properties.Enabled = true; } }); } } } //else if (btn.Caption == "طباعة") //{ //} }
public void Save() { #region Validation if (string.IsNullOrWhiteSpace(TxtEmpName.Text)) { MaterialMessageBox.Show("برجاء ادخال اسم الموظف", MessageBoxButtons.OK); //TxtEmpName.Properties.ver return; } else if (string.IsNullOrWhiteSpace(slkGender.Text)) { MaterialMessageBox.Show("برجاء اختيار الجنس", MessageBoxButtons.OK); TxtEmpName.Focus(); return; } else if (string.IsNullOrWhiteSpace(dtBrithDay.Text)) { MaterialMessageBox.Show("برجاءاختيار ناريخ الميلاد", MessageBoxButtons.OK); dtBrithDay.Focus(); return; } else if (string.IsNullOrWhiteSpace(TxtEmpNataionalId.Text)) { MaterialMessageBox.Show("برجاء ادخال الرقم القومي للموظف", MessageBoxButtons.OK); TxtEmpNataionalId.Focus(); return; } else if (string.IsNullOrWhiteSpace(slkNational.Text)) { MaterialMessageBox.Show("برجاءاختيار الجنسية ", MessageBoxButtons.OK); slkNational.Focus(); return; } else if (string.IsNullOrWhiteSpace(slkJop.Text)) { MaterialMessageBox.Show("برجاء اختيار الوظيفة", MessageBoxButtons.OK); slkJop.Focus(); return; } else if (string.IsNullOrWhiteSpace(slkBranch.Text)) { MaterialMessageBox.Show("برجاء اختيار الفرع", MessageBoxButtons.OK); slkBranch.Focus(); return; } else if (string.IsNullOrWhiteSpace(dtHiringDate.Text)) { MaterialMessageBox.Show("برجاء اختيار تاريخ التوظيف", MessageBoxButtons.OK); dtHiringDate.Focus(); return; } #endregion if (Application.OpenForms.OfType <frmEmployees>().Any()) { Int64 EmpCode = Convert.ToInt64(txtEmpCode.Text); bool TestUpdate = context.Employees.Any(customer => customer.Employee_Code == EmpCode && customer.IsDeleted == 0); frmEmployees frm = (frmEmployees)Application.OpenForms["frmEmployees"]; if (TestUpdate) { using (DB_A65D4E_SolarEnergyEntities ForCheck = new DB_A65D4E_SolarEnergyEntities()) { bool TestUserName = ForCheck.Employees.Any(Emp => Emp.EmployeeName == TxtEmpName.Text && Emp.Employee_Code != EmpCode && Emp.IsDeleted == 0); if (TestUserName) { MaterialMessageBox.Show("تم تسجيل هذا الاسم لموظف اخر", MessageBoxButtons.OK); return; } bool TestNatId = ForCheck.Employees.Any(Emp => Emp.National_Id == TxtEmpNataionalId.Text && Emp.IsDeleted == 0); if (TestUserName) { MaterialMessageBox.Show("تم تسجيل رقم البطاقة لموظف اخر", MessageBoxButtons.OK); return; } } } else { using (DB_A65D4E_SolarEnergyEntities ForCheck = new DB_A65D4E_SolarEnergyEntities()) { List <Employee> _EmpList = ForCheck.Employees.Where(x => x.IsDeleted == 0).ToList(); bool TestEmpCode = _EmpList.Any(Emp => Emp.Employee_Code == EmpCode && Emp.IsDeleted == 0); if (TestEmpCode) { MaterialMessageBox.Show("! تم تسجيل هذا كود الموظف لموظف اخر برجاء تحديث البيانات", MessageBoxButtons.OK); return; } bool TestEmprName = _EmpList.Any(Emp => Emp.EmployeeName == TxtEmpName.Text && Emp.IsDeleted == 0); if (TestEmprName) { MaterialMessageBox.Show("تم تسجيل هذا الاسم لموظف اخر", MessageBoxButtons.OK); return; } bool TestEmpNatId = _EmpList.Any(Emp => Emp.National_Id == TxtEmpNataionalId.Text && Emp.IsDeleted == 0); if (TestEmpNatId) { MaterialMessageBox.Show("تم تسجيل رقم البطاقة لموظف اخر", MessageBoxButtons.OK); return; } }; Employee _Employee = new Employee() { Employee_Code = EmpCode, EmployeeName = TxtEmpName.Text, Phone = txtMob1.Text, Phone2 = txtMob2.Text, EmployeeAddress1 = txtAdress1.Text, EmployeeAddress2 = txtAdress2.Text, National_Id = TxtEmpNataionalId.Text, Email = txtEmail.Text, Birthdate = Convert.ToDateTime(dtBrithDay.EditValue), HiringDate = Convert.ToDateTime(dtHiringDate.EditValue), LandLine = LandLine.Text, Last_Modified_Date = DateTime.Now, Last_Modified_User = 1, Branch_Code = Convert.ToInt64(slkBranch.EditValue), //Department_Code = Convert.ToInt64(slkDepartment.EditValue), Gender_Id = Convert.ToInt32(slkGender.EditValue), Job_Code = Convert.ToInt32(slkJop.EditValue), Natinality_Code = Convert.ToInt32(slkNational.EditValue), Created_Date = DateTime.Now, Created_User = 1, }; context.Employees.Add(_Employee); context.SaveChanges(); Rest(); using (DB_A65D4E_SolarEnergyEntities NewContext = new DB_A65D4E_SolarEnergyEntities()) { _Employee_View = null; _Employee_View = NewContext.Employee_View.Where(x => x.IsDeleted == 0).ToList(); frm.gcEmployeeCard.DataSource = _Employee_View; frm.gcEmployeeCard.RefreshDataSource(); frm.gcEmployeeCard.Enabled = true; GetLastEmployeeCode(); } } } }