public EmployeeBo Create(EmployeeBo item) { try { item.RegDate = DateTime.Now; Employee obj = Mapper.Map <Employee>(item); dba.Employees.Add(obj); dba.SaveChanges(); return(Mapper.Map <EmployeeBo>(obj)); } catch { throw; } }
static void Main() { //int recordCount = GetRecordCount(); //Employee[] employees = new Employee[recordCount]; //for (int i = 0; i < employees.Length; i++) //{ PrintMenu(); int choice = GetChoice(); //Console.WriteLine($"\nRecord# {(i + 1)}"); Employee employee = Create(choice); EmployeeBo bo = new EmployeeBo(); bo.Insert(employee); }
public static EmployeeBo ToEmployeeBo(this Employee employee) { if (employee == null) { return(null); } EmployeeBo employeeBo = new EmployeeBo(); employeeBo.EmployeeID = employee.EmployeeID; employeeBo.FirstName = employee.FirstName; employeeBo.LastName = employee.LastName; employeeBo.WorkExperience = employee.WorkExperience; employeeBo.Salary = employee.Salary; employeeBo.DepartmentId = employee.DepartmentId; return(employeeBo); }
public void Update(EmployeeBo item, int key) { try { var obj = dba.Employees.SingleOrDefault(p => p.Id == key); if (obj == null) { throw new ObjectNotFoundException("Employee not founded"); } obj.Name = item.Name; obj.Phone = item.Phone; obj.Email = item.Email; dba.SaveChanges(); } catch { throw; } }
public void AddNewEmployeeDataToDb() { #region Preconditions Random random = new Random(); Int32 changesMark = random.Next(100, 999); String departmentName = "Service"; EmployeeBo employeeNewData = new EmployeeBo { FirstName = $"Artem {changesMark}", LastName = $"Ivanov {changesMark}", WorkExperience = 4, Salary = 1200, DepartmentId = 2 }; #endregion Int32 employeeCountForServiceDepartment = EmployeeService.GetEmployeeInfoByDepartment(departmentName).Count; EmployeeService.CreateNewEmployee(employeeNewData); Int32 employeeCountAfterAddNewEmployee = EmployeeService.GetEmployeeInfoByDepartment(departmentName).Count; EmployeeBo addedEmployee = EmployeeService.GetEmployeeInfo() .Where(x => x.FirstName == employeeNewData.FirstName).FirstOrDefault(); Assert.AreEqual(employeeCountAfterAddNewEmployee - 1, employeeCountForServiceDepartment, "Count of employee for Service Department has been changed."); Assert.AreEqual(employeeNewData.FirstName, addedEmployee.FirstName, "Data was added to DB with appropriate First Name."); Assert.AreEqual(employeeNewData.LastName, addedEmployee.LastName, "Data was added to DB with appropriate Last Name."); }
public void CreateNewEmployee(EmployeeBo employee) { EmployeeRepository.CreateNewEmployeeInfo(employee.ToEmployee()); }
protected void btnSave_Click(object sender, EventArgs e) { try { if (hfIsUser.Value != "1") { rfUserName.Enabled = false; rfPassword.Enabled = false; rfRePassword.Enabled = false; cvRePassword.Enabled = false; } if (Page.IsValid) { EmployeeBo objEmployeeBO = new EmployeeBo(); EmployeeBl objEmployeeBL = new EmployeeBl(); objEmployeeBO.Name = txtName.Text.Trim(); objEmployeeBO.Code = txtCode.Text.Trim(); objEmployeeBO.RoleId = Convert.ToInt32(ddlRole.SelectedValue); objEmployeeBO.Address = txtAddress.Text.Trim(); objEmployeeBO.ContactNo = txtContactNo.Text.Trim(); objEmployeeBO.MobileNo = txtMobileNo.Text.Trim(); objEmployeeBO.Email = txtEmail.Text.Trim(); objEmployeeBO.UserName = txtUserName.Text.Trim(); objEmployeeBO.Password = txtPassword.Text.Trim(); objEmployeeBO.JoinDate = txtJoinDate.Text.Trim(); objEmployeeBO.BirthDate = txtBirthDate.Text.Trim(); objEmployeeBO.MarriageDate = txtMarriageDate.Text.Trim(); objEmployeeBO.AllowAccountAccess = 0; if (ViewState["Mode"].ToString() == "Save") { objEmployeeBO.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objEmployeeBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToShortDateString(); var objResult = objEmployeeBL.Employee_Insert(objEmployeeBO); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully!');</script>"); BindEmployee(); ClearAll(); PanelVisibilityMode(1); ViewState["Mode"] = "Save"; } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record already exist.');</script>"); } } else if (ViewState["Mode"].ToString() == "Edit") { objEmployeeBO.Id = Convert.ToInt32(ViewState["Id"].ToString()); objEmployeeBO.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objEmployeeBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); var objResult = objEmployeeBL.Employee_Update(objEmployeeBO); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>"); BindEmployee(); ClearAll(); PanelVisibilityMode(1); ViewState["Mode"] = "Save"; } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record already exist.');</script>"); } } } } catch (Exception ex) { log.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
static void Main() { EmployeeBo employeeBo = null; try { char toContinue = 'n'; do { ShowMenu(); int choice = GetManinMenuChoice(); employeeBo = new EmployeeBo(); switch (choice) { case 1: ShowEmployeeSubMenu(); int empChoice = GetEmployeeChoice(); Employee newEmployee = Create(empChoice); bool status = employeeBo.AddRecord(newEmployee); Console.WriteLine($"{(status ? "Record added successfully" : "Either record exists or some other error. could not add record")}"); break; case 2: int empId = GetEmployeeIdFromUser(); Employee employee = employeeBo.FetchARecord(empId); Console.WriteLine($"{(employee != null ? $"found record of {employee.EmployeeName}" : $"No record found with id: {empId}")}"); break; case 3: ShowSortMenu(); int sortChoice = GetSortChoice(); List <Employee> records = employeeBo.FetchAllRecords(sortChoice); if (records.Count > 0) { foreach (Employee e in records) { Console.WriteLine(e); } } else { Console.WriteLine("No records found..."); } break; default: break; } Decide(ref toContinue); } while (toContinue != 'n' && toContinue == 'y'); } catch (NullReferenceException ex) { System.Console.WriteLine(ex); } catch (Exception ex) { System.Console.WriteLine(ex); } }
/// <summary> /// To Update details of Employee in Employee table /// Created By : Nirmal, 27-04-2015 /// Modified By : /// </summary> public ApplicationResult Employee_Update(EmployeeBo objEmployeeBo) { try { pSqlParameter = new SqlParameter[25]; pSqlParameter[0] = new SqlParameter("@Id", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objEmployeeBo.Id; pSqlParameter[1] = new SqlParameter("@Name", SqlDbType.NVarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objEmployeeBo.Name; pSqlParameter[2] = new SqlParameter("@Code", SqlDbType.NVarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objEmployeeBo.Code; pSqlParameter[3] = new SqlParameter("@BranchId", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objEmployeeBo.BranchId; pSqlParameter[4] = new SqlParameter("@OrganisationId", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objEmployeeBo.OrganisationId; pSqlParameter[5] = new SqlParameter("@RoleId", SqlDbType.Int); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objEmployeeBo.RoleId; pSqlParameter[6] = new SqlParameter("@DepartmentId", SqlDbType.Int); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objEmployeeBo.DepartmentId; pSqlParameter[7] = new SqlParameter("@DesignationId", SqlDbType.Int); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objEmployeeBo.DesignationId; pSqlParameter[8] = new SqlParameter("@ReportingToId", SqlDbType.Int); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objEmployeeBo.ReportingToId; pSqlParameter[9] = new SqlParameter("@Address", SqlDbType.NVarChar); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objEmployeeBo.Address; pSqlParameter[10] = new SqlParameter("@ContactNo", SqlDbType.VarChar); pSqlParameter[10].Direction = ParameterDirection.Input; pSqlParameter[10].Value = objEmployeeBo.ContactNo; pSqlParameter[11] = new SqlParameter("@MobileNo", SqlDbType.VarChar); pSqlParameter[11].Direction = ParameterDirection.Input; pSqlParameter[11].Value = objEmployeeBo.MobileNo; pSqlParameter[12] = new SqlParameter("@Email", SqlDbType.VarChar); pSqlParameter[12].Direction = ParameterDirection.Input; pSqlParameter[12].Value = objEmployeeBo.Email; pSqlParameter[13] = new SqlParameter("@IsUser", SqlDbType.Int); pSqlParameter[13].Direction = ParameterDirection.Input; pSqlParameter[13].Value = objEmployeeBo.IsUser; pSqlParameter[14] = new SqlParameter("@UserName", SqlDbType.NVarChar); pSqlParameter[14].Direction = ParameterDirection.Input; pSqlParameter[14].Value = objEmployeeBo.UserName; pSqlParameter[15] = new SqlParameter("@Password", SqlDbType.NVarChar); pSqlParameter[15].Direction = ParameterDirection.Input; pSqlParameter[15].Value = objEmployeeBo.Password; pSqlParameter[16] = new SqlParameter("@JoinDate", SqlDbType.VarChar); pSqlParameter[16].Direction = ParameterDirection.Input; pSqlParameter[16].Value = objEmployeeBo.JoinDate; pSqlParameter[17] = new SqlParameter("@BirthDate", SqlDbType.VarChar); pSqlParameter[17].Direction = ParameterDirection.Input; pSqlParameter[17].Value = objEmployeeBo.BirthDate; pSqlParameter[18] = new SqlParameter("@MarriageDate", SqlDbType.VarChar); pSqlParameter[18].Direction = ParameterDirection.Input; pSqlParameter[18].Value = objEmployeeBo.MarriageDate; pSqlParameter[19] = new SqlParameter("@AllowAccountAccess", SqlDbType.Int); pSqlParameter[19].Direction = ParameterDirection.Input; pSqlParameter[19].Value = objEmployeeBo.AllowAccountAccess; pSqlParameter[20] = new SqlParameter("@IsResigned", SqlDbType.Int); pSqlParameter[20].Direction = ParameterDirection.Input; pSqlParameter[20].Value = objEmployeeBo.IsResigned; pSqlParameter[21] = new SqlParameter("@ResignationDate", SqlDbType.VarChar); pSqlParameter[21].Direction = ParameterDirection.Input; pSqlParameter[21].Value = objEmployeeBo.ResignationDate; pSqlParameter[22] = new SqlParameter("@LastWorkingDate", SqlDbType.VarChar); pSqlParameter[22].Direction = ParameterDirection.Input; pSqlParameter[22].Value = objEmployeeBo.LastWorkingDate; pSqlParameter[23] = new SqlParameter("@LastModifiedBy", SqlDbType.Int); pSqlParameter[23].Direction = ParameterDirection.Input; pSqlParameter[23].Value = objEmployeeBo.LastModifiedBy; pSqlParameter[24] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[24].Direction = ParameterDirection.Input; pSqlParameter[24].Value = objEmployeeBo.LastModifiedDate; sSql = "usp_tbl_Employee_Update"; int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter); if (iResult > 0) { ApplicationResult objResults = new ApplicationResult(); objResults.Status = ApplicationResult.CommonStatusType.Success; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(); objResults.Status = ApplicationResult.CommonStatusType.Failure; return(objResults); } } catch (Exception ex) { throw ex; } finally { objEmployeeBo = null; } }