private void btn_Employee_Reset_Click(object sender, RoutedEventArgs e)
{
textBox_Employee_Id.Text = EmployeeValidation.GetAutogeneratedEmployeeID_BL().ToString();
textBox_Employee_Firstname.Clear();
textBox_Employee_Middlename.Clear();
textBox_Employee_Lastname.Clear();
dtpkr_Employee_DOB.SelectedDate = null;
textBox_Employee_Age.Clear();
rdb_Employee_Male.IsChecked = false;
rdb_Employee_Female.IsChecked = false;
//cmb_Employee_CivilStatus.Items.Clear();
textBox_Employee_Religion.Clear();
textBox_Employee_Citizenship.Clear();
textBox_Employee_MobilNumber.Clear();
textBox_Employee_HomePhoneNumber.Clear();
textBox_Employee_Address.Clear();
textBox_Employee_City.Clear();
textBox_Employee_State.Clear();
textBox_Employee_Pincode.Clear();
textBox_Employee_Country.Clear();
//cmb_Employee_ProjectID.Items.Clear();
// cmb_Employee_SkillID.Items.Clear();
textBox_Employee_EduBg.Clear();
textBox_Employee_EmailID.Clear();
//cmb_Employee_LevelID.Items.Clear();
dtpkr_Employee_DateHired.SelectedDate = null;
//cmb_Employee_Speciality.Items.Clear();
}
public EmployeeController(IEmployeeLogic employeeLogic, EmployeeValidation employeeValidation, ICommonLogic commonLogic, CommonValidation commonValidation)
{
_employeeLogic = employeeLogic;
_employeeValidation = employeeValidation;
_commonLogic = commonLogic;
_commonValidation = commonValidation;
}
private void btn_Employee_Search_Click(object sender, RoutedEventArgs e)
{
try
{
int empId = Convert.ToInt32(txt_SearchEmp.Text);
DataTable sEd = EmployeeValidation.SearchEmployeeById_BL(empId);
DataRow dr = sEd.Rows[0];
if (!dr.IsNull("Employee_Id"))
{
textBox_Employee_Id.Text = dr["Employee_Id"].ToString();
textBox_Employee_Firstname.Text = dr["First_Name"].ToString();
textBox_Employee_Middlename.Text = dr["Middle_Name"].ToString();
textBox_Employee_Lastname.Text = dr["Last_Name"].ToString();
dtpkr_Employee_DOB.Text = dr["Birth_Date"].ToString();
textBox_Employee_Age.Text = dr["Age"].ToString();
if (dr["Gender"].ToString() == "Male")
{
rdb_Employee_Male.IsChecked = true;
}
else if (dr["Gender"].ToString() == "Female")
{
rdb_Employee_Female.IsChecked = true;
}
cmb_Employee_CivilStatus.SelectedValue = dr["Civil_Status"].ToString();
textBox_Employee_Religion.Text = dr["Religion"].ToString();
textBox_Employee_Citizenship.Text = dr["Citizenship"].ToString();
textBox_Employee_MobilNumber.Text = dr["Mobile_No"].ToString();
textBox_Employee_HomePhoneNumber.Text = dr["Home_Phone_No"].ToString();
textBox_Employee_Address.Text = dr["Address_"].ToString();
textBox_Employee_City.Text = dr["City"].ToString();
textBox_Employee_State.Text = dr["State_"].ToString();
textBox_Employee_Pincode.Text = dr["Pincode"].ToString();
textBox_Employee_Country.Text = dr["Country"].ToString();
cmb_Employee_ProjectID.SelectedValue = dr["Project_Id"].ToString();
cmb_Employee_SkillID.SelectedValue = dr["Skill_Id"].ToString();
textBox_Employee_EduBg.Text = dr["Educational_Background"].ToString();
textBox_Employee_EmailID.Text = dr["Email"].ToString();
cmb_Employee_LevelID.SelectedValue = dr["Level_Id"].ToString();
dtpkr_Employee_DateHired.Text = dr["Date_Hired"].ToString();
cmb_Employee_Speciality.SelectedValue = dr["Speciality_Id"].ToString();
}
else
{
MessageBox.Show("No Records found with Emp Id : " + empId);
}
}
catch (HRMSException ex)
{
MessageBox.Show(ex.Message);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btn_Employee_Delete_Click(object sender, RoutedEventArgs e)
{
try
{
int empId = Convert.ToInt32(txt_SearchEmp.Text);
int rowsAffected = EmployeeValidation.DeleteEmployee_BL(empId);
if (rowsAffected > 0)
{
MessageBox.Show("Employee Details Deleted !!");
}
else
{
MessageBox.Show("Error!!! Employee Record not found");
}
}
catch (HRMSException ex)
{
MessageBox.Show(ex.Message);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private bool UpdateFillEntity()
{
this.Emp = new Employee
{
Email = this.txtEmail.Text,
FullName = this.txtEmpName.Text,
Gender = this.cmbGender.Text,
Address = this.txtAddress.Text,
BirthDate = this.dtpBirthdate.Text,
PhoneNumber = this.txtPhonenumber.Text,
JoinDate = this.dtpJoindate.Text,
Salary = this.txtSalary.Text,
UserId = this.txtUserId.Text
};
EmployeeValidation validator = new EmployeeValidation();
ValidationResult results = validator.Validate(Emp);
IList <ValidationFailure> failures = results.Errors;
if (!(results.IsValid))
{
foreach (ValidationFailure failure in failures)
{
MessageBox.Show(failure.ErrorMessage, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
return(true);
}
public EmployeeBLL(IEmployeeDAL employeeDAL, EmployeeValidation employeeValidation,
IMapper mapper, IAddressBLL addressBLL) : base(employeeDAL)
{
_employeeDAL = employeeDAL;
_employeeValidation = employeeValidation;
_mapper = mapper;
_addressBLL = addressBLL;
}
private void buttonList_Click(object sender, EventArgs e)
{
Employee emp = new Employee();
if (EmployeeValidation.isValidID(textboxEmployeeId) && EmployeeValidation.isValidName(textboxName))
{
emp.EmployeeID = Convert.ToInt32(textboxEmployeeId.Text);
emp.Name = textboxName.Text;
emp.PhoneNumber = maskedtextboxPhoneNumber.Text;
EmployeeDA.Add(emp);
ClearAll();
}
}
public IActionResult Post(string values)
{
var newEmployee = new EmployeeValidation();
JsonConvert.PopulateObject(values, newEmployee);
if (!TryValidateModel(newEmployee))
{
return(BadRequest(ModelState.GetFullErrorMessage()));
}
_data.Employees.Add(newEmployee);
_data.SaveChanges();
return(Ok());
}
private void btn_Employee_Display_Click(object sender, RoutedEventArgs e)
{
try
{
DataTable dtEmp = EmployeeValidation.DisplayEmployee_BL();
dg_Employee_Details.ItemsSource = dtEmp.DefaultView;
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void ValidateNewEmployee(object e)
{
var employeeValidator = new EmployeeValidation();
if (SelectedEmployee != null)
{
var results = employeeValidator.Validate(SelectedEmployee);
if (results.IsValid == false)
{
foreach (ValidationFailure failure in results.Errors)
{
ValidationErrors.Add($"{failure.PropertyName }: {failure.ErrorMessage}");
}
MessageBox.Show("Mistakes were made.");
}
}
}
public HttpResponseMessage Post(FormDataCollection form)
{
var values = form.Get("values");
var newEmployee = new EmployeeValidation();
JsonConvert.PopulateObject(values, newEmployee);
Validate(newEmployee);
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState.GetFullErrorMessage()));
}
db.Employees.Add(newEmployee);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
public IActionResult Put(int id, [FromBody] EmployeeValidation value)
{
if (value != null)
{
int status = repo.AddEmployeeValidation(id, value);
if (status == 2)
{
return(NotFound());
}
if (status == 1) //error in sql
{
return(BadRequest());
}
else
{
Uri uri = new Uri("https://localhost:44397/api/Training/");
return(Created(uri, value));
}
}
else
{
return(BadRequest());
}
}
//OnLoad Event
private void Window_Loaded(object sender, RoutedEventArgs e)
{
textBox_Employee_Id.Text = EmployeeValidation.GetAutogeneratedEmployeeID_BL().ToString();
textBox_Project_ID.Text = Project_BL.GetAutogeneratedProjectID_BL().ToString();
textBox_Category_ID.Text = Category_BL.GetAutogeneratedCategoryID_BL().ToString();
textBox_Skill_ID.Text = Skill_BL.GetAutogeneratedSkillID_BL().ToString();
//Load Civil Status Data from Database
DataTable dtCivil = EmployeeValidation.LoadCivilStatus_BL();
if (dtCivil.Rows.Count >= 0)
{
cmb_Employee_CivilStatus.ItemsSource = dtCivil.DefaultView;
cmb_Employee_CivilStatus.DisplayMemberPath = "Status_Description";
cmb_Employee_CivilStatus.SelectedValuePath = "Status_Id";
}
//Load Level Data from Database
DataTable dtLvl = EmployeeValidation.LoadLevel_BL();
if (dtLvl.Rows.Count >= 0)
{
cmb_Employee_LevelID.ItemsSource = dtLvl.DefaultView;
cmb_Employee_LevelID.DisplayMemberPath = "Level_Description";
cmb_Employee_LevelID.SelectedValuePath = "Level_Id";
}
//Load Projects Data from Database
DataTable dtProj = EmployeeValidation.LoadProject_BL();
if (dtProj.Rows.Count >= 0)
{
cmb_Employee_ProjectID.ItemsSource = dtProj.DefaultView;
cmb_Employee_ProjectID.DisplayMemberPath = "Project_Name";
cmb_Employee_ProjectID.SelectedValuePath = "Project_Id";
}
//Load Speciality Data from Database
DataTable dtSpec = EmployeeValidation.LoadSeciality_BL();
if (dtSpec.Rows.Count >= 0)
{
cmb_Employee_Speciality.ItemsSource = dtSpec.DefaultView;
cmb_Employee_Speciality.DisplayMemberPath = "Speciality_Name";
cmb_Employee_Speciality.SelectedValuePath = "Speciality_Id";
}
//Load Skills Data from Database
DataTable dtSkill = EmployeeValidation.LoadSkill_BL();
if (dtSkill.Rows.Count >= 0)
{
cmb_Employee_SkillID.ItemsSource = dtSkill.DefaultView;
cmb_Employee_SkillID.DisplayMemberPath = "Skill_Name";
cmb_Employee_SkillID.SelectedValuePath = "Skill_Id";
}
//Load Category Data from Database
DataTable dtCat = Skill_BL.LoadCatSkill_BL();
if (dtCat.Rows.Count >= 0)
{
cmb_Category_ID.ItemsSource = dtCat.DefaultView;
cmb_Category_ID.DisplayMemberPath = "Category_Name";
cmb_Category_ID.SelectedValuePath = "Category_Id";
}
}
private void btn_Employee_Update_Click(object sender, RoutedEventArgs e)
{
try
{
Employee newEmp = new Employee();
CapgeminiDetails capgDet = new CapgeminiDetails();
newEmp.EmployeeId = Convert.ToInt32(textBox_Employee_Id.Text);
newEmp.FirstName = textBox_Employee_Firstname.Text;
newEmp.MiddleName = textBox_Employee_Middlename.Text;
newEmp.LastName = textBox_Employee_Lastname.Text;
newEmp.BirthDate = Convert.ToDateTime(dtpkr_Employee_DOB.Text);
newEmp.Age = Convert.ToInt32(textBox_Employee_Age.Text);
if (rdb_Employee_Male.IsChecked == true)
{
newEmp.Gender = Convert.ToString(rdb_Employee_Male.Content);
}
else if (rdb_Employee_Female.IsChecked == true)
{
newEmp.Gender = Convert.ToString(rdb_Employee_Female.Content);
}
newEmp.CivilStatusId = int.Parse(cmb_Employee_CivilStatus.SelectedValue.ToString());
newEmp.Religion = textBox_Employee_Religion.Text;
newEmp.Citizenship = textBox_Employee_Citizenship.Text;
newEmp.MobileNo = Convert.ToInt64(textBox_Employee_MobilNumber.Text);
newEmp.HomePhoneNo = Convert.ToInt64(textBox_Employee_HomePhoneNumber.Text);
newEmp.Address = textBox_Employee_Address.Text;
newEmp.City = textBox_Employee_City.Text;
newEmp.State = textBox_Employee_State.Text;
newEmp.Pincode = Convert.ToInt64(textBox_Employee_Pincode.Text);
newEmp.Country = textBox_Employee_Country.Text;
newEmp.Project_Id = int.Parse(cmb_Employee_ProjectID.SelectedValue.ToString());
newEmp.SkillId = cmb_Employee_SkillID.SelectedValue.ToString();
newEmp.EducationalBackground = textBox_Employee_EduBg.Text;
capgDet.EmployeeId = Convert.ToInt32(textBox_Employee_Id.Text);
capgDet.Email = textBox_Employee_EmailID.Text;
capgDet.LevelId = int.Parse(cmb_Employee_LevelID.SelectedValue.ToString());
capgDet.DateHired = Convert.ToDateTime(dtpkr_Employee_DateHired.Text);
capgDet.SpecialityId = int.Parse(cmb_Employee_Speciality.SelectedValue.ToString());
int rowsAffected = EmployeeValidation.UpdateEmployee_BL(newEmp, capgDet);
if (rowsAffected > 0)
{
MessageBox.Show("Employee Details Updated !!");
}
else
{
MessageBox.Show("Error!!! Employee Record not Updated");
}
}
catch (HRMSException ex)
{
MessageBox.Show(ex.Message);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
