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