public void Update(CapgeminiDetails c)
{
int qn;
string update = "balaji.SP_UPDATE_CapgeminiDetails_HR_Batch4";
try
{
cmd = new SqlCommand(update, con);
cmd.Parameters.AddWithValue("@aEmployeeID", c.EmployeeId);
cmd.Parameters.AddWithValue("@aEmail", c.Email);
cmd.Parameters.AddWithValue("@aLevelId", c.LevelId);
cmd.Parameters.AddWithValue("@aDateHired", c.DateHired);
cmd.Parameters.AddWithValue("@aSpecialityId", c.SpecialityId);
cmd.Parameters.AddWithValue("@aStatusId", c.StatusId);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
qn = cmd.ExecuteNonQuery();
}
catch (CapgeminiDetailsException)
{
throw;
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
try
{
CapgeminiDetails c = new CapgeminiDetails();
c = (CapgeminiDetails)lsSearch.SelectedValue;
cbEmployeeId.ItemsSource = bll.GetAllEmployee();
cbEmployeeId.DisplayMemberPath = "EmployeeID";
cbEmployeeId.Text = (bll.SelectEmployee(c.EmployeeId)).EmployeeID.ToString();
txtEmail.Text = c.Email;
cbLevel.ItemsSource = bll.GetAllLevel();
cbLevel.DisplayMemberPath = "LevelDescription";
cbLevel.Text = (bll.SelectLevel(c.LevelId)).LevelDescription;
dpDateHired.Text = c.DateHired.ToString();
cbSpeciality.ItemsSource = bll.GetAllSpeciality();
cbSpeciality.DisplayMemberPath = "SpecialityName";
cbSpeciality.Text = (bll.SelectSpeciality(c.SpecialityId)).SpecialityName;
cbStatus.ItemsSource = bll.GetAllStatus();
cbStatus.DisplayMemberPath = "StatusDescription";
cbStatus.Text = (bll.SelectStatus(c.StatusId)).StatusDescription;
dgRecords.ItemsSource = bll.GetAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//Method to Add Employee to Database
public static int AddEmployee(Employee newEmp, CapgeminiDetails capg)
{
int rowsAffected = 0;
try
{
//Creating command object
SqlCommand empCommand = DataConnections.GenerateCommand();
//Assigning command text
empCommand.CommandText = "Group4.usp_AddEmployee";
//Adding parameters to command
empCommand.Parameters.AddWithValue("@Employee_Id", capg.EmployeeId);
empCommand.Parameters.AddWithValue("@First_Name", newEmp.FirstName);
empCommand.Parameters.AddWithValue("@Middle_Name", newEmp.MiddleName);
empCommand.Parameters.AddWithValue("@Last_Name", newEmp.LastName);
empCommand.Parameters.AddWithValue("@Birth_Date", newEmp.BirthDate);
empCommand.Parameters.AddWithValue("@Age", newEmp.Age);
empCommand.Parameters.AddWithValue("@Gender", newEmp.Gender);
empCommand.Parameters.AddWithValue("@Civil_Status", newEmp.CivilStatusId);
empCommand.Parameters.AddWithValue("@Religion", newEmp.Religion);
empCommand.Parameters.AddWithValue("@Citizenship", newEmp.Citizenship);
empCommand.Parameters.AddWithValue("@Mobile_No", newEmp.MobileNo);
empCommand.Parameters.AddWithValue("@Home_Phone_No", newEmp.HomePhoneNo);
empCommand.Parameters.AddWithValue("@Address_", newEmp.Address);
empCommand.Parameters.AddWithValue("@City", newEmp.City);
empCommand.Parameters.AddWithValue("@State_", newEmp.State);
empCommand.Parameters.AddWithValue("@Pincode", newEmp.Pincode);
empCommand.Parameters.AddWithValue("@Country", newEmp.Country);
empCommand.Parameters.AddWithValue("@Project_Id", newEmp.Project_Id);
empCommand.Parameters.AddWithValue("@Skill_Id", newEmp.SkillId);
empCommand.Parameters.AddWithValue("@Educational_Background", newEmp.EducationalBackground);
empCommand.Parameters.AddWithValue("@Email", capg.Email);
empCommand.Parameters.AddWithValue("@Level_Id", capg.LevelId);
empCommand.Parameters.AddWithValue("@Date_Hired", capg.DateHired);
empCommand.Parameters.AddWithValue("@Speciality", capg.SpecialityId);
//Executing command
empCommand.Connection.Open();
rowsAffected = empCommand.ExecuteNonQuery();
empCommand.Connection.Close();
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return(rowsAffected);
}
public void Modify(CapgeminiDetails c)
{
try
{
if (validateCapDetails(c))
{
dal.Update(c);
}
else
{
throw new CapgeminiDetailsException("Invalid Data");
}
}
catch (Exception)
{
throw;
}
}
public IEnumerable SelectAll()
{
List <CapgeminiDetails> capgeminiDetailslist = new List <CapgeminiDetails>();
string selectAll = "balaji.SP_SELECTALL_CapgeminiDetails_HR_Batch4";
try
{
cmd = new SqlCommand(selectAll, con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
CapgeminiDetails c = new CapgeminiDetails();
c.EmployeeId = (int)dr[0];
c.Email = dr[1].ToString();
c.LevelId = (int)dr[2];
c.DateHired = DateTime.Parse(dr[3].ToString());
c.SpecialityId = (int)dr[4];
c.StatusId = (int)dr[5];
capgeminiDetailslist.Add(c);
}
}
}
catch (CapgeminiDetailsException)
{
throw;
}
catch (Exception)
{
throw;
}
finally
{
dr.Close();
con.Close();
}
return(capgeminiDetailslist);
}
private void btnUpdate_Click(object sender, RoutedEventArgs e)
{
try
{
CapgeminiDetails c = new CapgeminiDetails();
c.EmployeeId = ((Employee)cbEmployeeId.SelectedItem).EmployeeID;
c.Email = txtEmail.Text;
c.LevelId = ((Level)cbLevel.SelectedItem).LevelId;
c.DateHired = DateTime.Parse(dpDateHired.Text);
c.SpecialityId = ((Speciality)cbSpeciality.SelectedItem).SpecialityID;
c.StatusId = ((CivilStatus)cbStatus.SelectedItem).StatusId;
bll.Modify(c);
MessageBox.Show("Updated Sucessfully");
lsSearch.ItemsSource = bll.GetAll();
lsSearch.DisplayMemberPath = "EmployeeId";
cbEmployeeId.ItemsSource = bll.GetAllEmployee();
cbEmployeeId.DisplayMemberPath = "EmployeeID";
cbStatus.ItemsSource = bll.GetAllStatus();
cbStatus.DisplayMemberPath = "StatusDescription";
cbSpeciality.ItemsSource = bll.GetAllSpeciality();
cbSpeciality.DisplayMemberPath = "SpecialityName";
cbLevel.ItemsSource = bll.GetAllLevel();
cbLevel.DisplayMemberPath = "LevelDescription";
dgRecords.ItemsSource = bll.GetAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//Calling Update Employee
public static int UpdateEmployee_BL(Employee newEmp, CapgeminiDetails capg)
{
int rowsAffected = 0;
try
{
if (ValidatEmployee(newEmp))
{
rowsAffected = Employee_DAL.UpdateEmployee(newEmp, capg);
}
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(rowsAffected);
}
public void Add(CapgeminiDetails c)
{
try
{
if (validateCapDetails(c))
{
dal.Insert(c);
}
else
{
throw new CapgeminiDetailsException("Invalid Data");
}
}
catch (CapgeminiDetailsException ex)
{
throw;
}
catch (SystemException ex)
{
throw;
}
}
public bool validateCapDetails(CapgeminiDetails cap)
{
bool validate = true;
StringBuilder builderObj = new StringBuilder();
try
{
if (cap.Email.ToString() == string.Empty)
{
builderObj.AppendLine("Email ID Should be Provided..");
validate = false;
}
if (cap.DateHired == DateTime.MinValue)
{
builderObj.AppendLine("Hired Date Should be Provided..");
validate = false;
}
if (validate == false)
{
throw new CapgeminiDetailsException(builderObj.ToString());
}
}
catch (CapgeminiDetailsException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return(validate);
}
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);
}
}
