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