public void MapEFToBO() { var mapper = new DALEmployeeMapper(); Employee entity = new Employee(); entity.SetProperties(DateTime.Parse("1/1/1987 12:00:00 AM"), 1, true, "A", DateTime.Parse("1/1/1987 12:00:00 AM"), "A", "A", "A", DateTime.Parse("1/1/1987 12:00:00 AM"), "A", 1, Guid.Parse("8420cdcf-d595-ef65-66e7-dff9f98764da"), true, 1, 1); BOEmployee response = mapper.MapEFToBO(entity); response.BirthDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM")); response.BusinessEntityID.Should().Be(1); response.CurrentFlag.Should().Be(true); response.Gender.Should().Be("A"); response.HireDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM")); response.JobTitle.Should().Be("A"); response.LoginID.Should().Be("A"); response.MaritalStatu.Should().Be("A"); response.ModifiedDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM")); response.NationalIDNumber.Should().Be("A"); response.OrganizationLevel.Should().Be(1); response.Rowguid.Should().Be(Guid.Parse("8420cdcf-d595-ef65-66e7-dff9f98764da")); response.SalariedFlag.Should().Be(true); response.SickLeaveHour.Should().Be(1); response.VacationHour.Should().Be(1); }
public long ChangePassword(BOEmployee objBO) { try { string sql = "SET NOCOUNT ON SELECT pin_number FROM dbo.user_t WHERE pin_number='" + objBO.Pin + "' AND Password='******'"; DataTable dt = iPBSDBUtility.GetDataBySQLString(sql); if (dt.Rows.Count > 0) { Hashtable ht = new Hashtable(); ht.Add("pin_number", objBO.Pin); ht.Add("Oldpassword", objBO.OldPassword); ht.Add("Newpassword", objBO.Password); return(Convert.ToInt64(iPBSDBUtility.ExecuteCommand(ht, "dbo.Update_aa"))); } else { return(0); } } catch (Exception ex) { throw ex; } }
public FrmEmployee(ApplicationPresenter ap, BOEmployee model) : base(ap) { InitializeComponent(); mModel = model; mViewModel = new BOViewModel(mModel); mViewModel.ErrorProvider = errorProvider; BindViews(); RegisterEventHandlers(); }
public void AddEmployee(BOEmployee boEmployee) { try { Employee employee = BusinessLayerHelper.ConvertBOEmployeeToEmployee(boEmployee); dataLayer.AddEmployee(employee); } catch (Exception ex) { throw ex; } }
public void MapBOToModelList() { var mapper = new BOLEmployeeMapper(); BOEmployee bo = new BOEmployee(); bo.SetProperties(1, DateTime.Parse("1/1/1987 12:00:00 AM"), true, "A", DateTime.Parse("1/1/1987 12:00:00 AM"), "A", "A", "A", DateTime.Parse("1/1/1987 12:00:00 AM"), "A", 1, Guid.Parse("8420cdcf-d595-ef65-66e7-dff9f98764da"), true, 1, 1); List <ApiEmployeeResponseModel> response = mapper.MapBOToModel(new List <BOEmployee>() { { bo } }); response.Count.Should().Be(1); }
public void MapBOToModelList() { var mapper = new BOLEmployeeMapper(); BOEmployee bo = new BOEmployee(); bo.SetProperties(1, "A", true, true, "A"); List <ApiEmployeeResponseModel> response = mapper.MapBOToModel(new List <BOEmployee>() { { bo } }); response.Count.Should().Be(1); }
public void MapModelToBO() { var mapper = new BOLEmployeeMapper(); ApiEmployeeRequestModel model = new ApiEmployeeRequestModel(); model.SetProperties("A", true, true, "A"); BOEmployee response = mapper.MapModelToBO(1, model); response.FirstName.Should().Be("A"); response.IsSalesPerson.Should().Be(true); response.IsShipper.Should().Be(true); response.LastName.Should().Be("A"); }
public static List <BOEmployee> ConvertEmployeeListToBOEmployeeList(List <Employee> employees) { List <BOEmployee> businessEmployees = new List <BOEmployee>(); foreach (Employee employee in employees) { BOEmployee boEmployee = ConvertEmployeeToBOEmployee(employee); businessEmployees.Add(boEmployee); } return(businessEmployees); }
// POST api/employee public string Post([FromBody] BOEmployee employeeDetails) { try { //TODO : needto veryfy insert and update int id = employeeDetails != null ? employeeDetails.EmployeeID : 0; int ret = BLLEmployee.Save(employeeDetails, id > 0 ? false : true); return(ret > 0 ? "Record saved successfully" : "There is a problem while saving record"); } catch (Exception ex) { return(ex.Message); } }
public void MapBOToModel() { var mapper = new BOLEmployeeMapper(); BOEmployee bo = new BOEmployee(); bo.SetProperties(1, "A", true, true, "A"); ApiEmployeeResponseModel response = mapper.MapBOToModel(bo); response.FirstName.Should().Be("A"); response.Id.Should().Be(1); response.IsSalesPerson.Should().Be(true); response.IsShipper.Should().Be(true); response.LastName.Should().Be("A"); }
private static BOEmployee FillDataRecord(DataRow dr) { BOEmployee itemObj = new BOEmployee(); if (dr["EmployeeID"] != DBNull.Value) { itemObj.EmployeeID = Int32.Parse(dr["EmployeeID"].ToString()); } if (dr["FirstName"] != DBNull.Value) { itemObj.FirstName = dr["FirstName"].ToString(); } if (dr["LastName"] != DBNull.Value) { itemObj.LastName = dr["LastName"].ToString(); } if (dr["EmailAddress"] != DBNull.Value) { itemObj.EmailAddress = dr["EmailAddress"].ToString(); } if (dr["Password"] != DBNull.Value) { itemObj.Password = dr["Password"].ToString(); } if (dr["EmployeeType"] != DBNull.Value) { itemObj.EmployeeType = Boolean.Parse(dr["EmployeeType"].ToString()); } if (dr["CreatedOn"] != DBNull.Value) { itemObj.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString()); } if (dr["CreatedByID"] != DBNull.Value) { itemObj.CreatedByID = Int32.Parse(dr["CreatedByID"].ToString()); } if (dr["ModifiedOn"] != DBNull.Value) { itemObj.ModifiedOn = DateTime.Parse(dr["ModifiedOn"].ToString()); } if (dr["ModifiedByID"] != DBNull.Value) { itemObj.ModifiedByID = Int32.Parse(dr["ModifiedByID"].ToString()); } if (dr["IsActive"] != DBNull.Value) { itemObj.IsActive = Boolean.Parse(dr["IsActive"].ToString()); } return(itemObj); }
public static BOEmployee CheckLogin(string username, string password) { BOEmployee itemObj = null; var ds = spCheckLogin.ExecuteDataset(username, password); if (ds != null && ds.Tables[0].Rows.Count > 1) { throw new Exception("More than one row returned"); } if (ds != null && ds.Tables[0].Rows.Count == 1) { itemObj = FillDataRecord(ds.Tables[0].Rows[0]); } return(itemObj); }
public void MapBOToEF() { var mapper = new DALEmployeeMapper(); var bo = new BOEmployee(); bo.SetProperties(1, "A", true, true, "A"); Employee response = mapper.MapBOToEF(bo); response.FirstName.Should().Be("A"); response.Id.Should().Be(1); response.IsSalesPerson.Should().Be(true); response.IsShipper.Should().Be(true); response.LastName.Should().Be("A"); }
public void MapEFToBO() { var mapper = new DALEmployeeMapper(); Employee entity = new Employee(); entity.SetProperties("A", 1, true, true, "A"); BOEmployee response = mapper.MapEFToBO(entity); response.FirstName.Should().Be("A"); response.Id.Should().Be(1); response.IsSalesPerson.Should().Be(true); response.IsShipper.Should().Be(true); response.LastName.Should().Be("A"); }
public static BOEmployee GetEmployeeDetailsByID(int id) { BOEmployee itemObjs = null; var ds = spGetEmployeeDetailsByID.ExecuteDataset(id); if (ds != null && ds.Tables[0].Rows.Count > 1) { throw new Exception("More than one row returned"); } if (ds != null && ds.Tables[0].Rows.Count == 1) { itemObjs = FillDataRecord(ds.Tables[0].Rows[0]); } return(FillData(itemObjs, ds.Tables[0].Rows[0])); }
public long InsertEmployeeDetails(BOEmployee objBO) { try { Hashtable ht = new Hashtable(); ht.Add("code", objBO.Code); ht.Add("name", objBO.Name); ht.Add("login_name", objBO.Login_Id); ht.Add("address", objBO.Address); return(Convert.ToInt64(iPBSDBUtility.InsertData(ht, "dbo.insert_bb"))); } catch (Exception ex) { throw ex; } }
public static BOEmployee GetItem(Int32 id) { BOEmployee itemObj = null; tblEmployee tblObj = new tblEmployee(); DataTable dt = tblObj.GetAllData(tblEmployee.PRIMARYKEY_FIELD1 + " = " + id); if (dt.Rows.Count > 1) { throw new Exception("More than one row returned"); } if (dt.Rows.Count == 1) { itemObj = FillDataRecord(dt.Rows[0]); } return(itemObj); }
public void AddEmployee() { try { BOEmployee boEmployee = new BOEmployee(); boEmployee.DepartmentId = 1; boEmployee.DesignationId = Convert.ToInt32(CMEnum.Designation.DepartmentHead); boEmployee.AddressId = 3; boEmployee.FirstName = "John"; boEmployee.LastName = "kipson"; businessLayer.AddEmployee(boEmployee); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public static BOEmployee ConvertEmployeeToBOEmployee(Employee employee) { BOEmployee boEmployee = new BOEmployee(); boEmployee.EmployeeId = employee.EmployeeId; boEmployee.DepartmentId = employee.DepartmentId; boEmployee.DesignationId = employee.DesignationId; boEmployee.AddressId = employee.AddressId; boEmployee.FirstName = employee.FirstName; boEmployee.MiddleName = employee.MiddleName; boEmployee.LastName = employee.LastName; boEmployee.Email = employee.Email; boEmployee.Phone = employee.Phone; boEmployee.Salary = employee.Salary; boEmployee.JoinDate = employee.JoinDate; boEmployee.Dob = employee.Dob; return(boEmployee); }
public static Employee ConvertBOEmployeeToEmployee(BOEmployee boEmployee) { Employee employee = new Employee(); employee.EmployeeId = boEmployee.EmployeeId; employee.DepartmentId = boEmployee.DepartmentId; employee.DesignationId = boEmployee.DesignationId; employee.AddressId = boEmployee.AddressId; employee.FirstName = boEmployee.FirstName; employee.MiddleName = boEmployee.MiddleName; employee.LastName = boEmployee.LastName; employee.Email = boEmployee.Email; employee.Phone = boEmployee.Phone; employee.Salary = boEmployee.Salary; employee.JoinDate = boEmployee.JoinDate; employee.Dob = boEmployee.Dob; return(employee); }
public static EmployeeList GetEmployeeAsaList() { EmployeeList objList = new EmployeeList(); DAEmployee objDA = new DAEmployee(); DataTable table = objDA.GetAllEmployeeList(); foreach (DataRow dr in table.Rows) { BOEmployee objBO = new BOEmployee(); objBO.Code = dr["code"].ToString(); objBO.Pin = dr["pin_number"].ToString(); objBO.Name = dr["name"].ToString(); objBO.Email = dr["email"].ToString(); // objBO.Password = dr["password"].ToString(); objList.AddToList(objBO); } return(objList); }
public long InsertEmployee(BOEmployee objBO) { try { Hashtable ht = new Hashtable(); ht.Add("pin_number", objBO.Pin); ht.Add("name", objBO.Name); ht.Add("login_id", objBO.Login_Id); ht.Add("password", objBO.Password); ht.Add("email", objBO.Email); ht.Add("creator", objBO.Creator); ht.Add("modifier", objBO.Modifier); ht.Add("is_active", objBO.IsActive); return(Convert.ToInt64(iPBSDBUtility.InsertData(ht, "dbo.insert_update_user_t"))); } catch (Exception ex) { throw ex; } }
public static int Save(BOEmployee entry, bool adding) { tblEmployee tblObj = new tblEmployee(); DataRow newRow = tblObj.Table().NewRow(); newRow[tblEmployee.EMPLOYEEID_FIELD] = entry.EmployeeID; newRow[tblEmployee.FIRSTNAME_FIELD] = entry.FirstName; newRow[tblEmployee.LASTNAME_FIELD] = entry.LastName; newRow[tblEmployee.EMAILADDRESS_FIELD] = entry.EmailAddress; newRow[tblEmployee.PASSWORD_FIELD] = entry.Password; newRow[tblEmployee.EMPLOYEETYPE_FIELD] = entry.EmployeeType; if (entry.CreatedOn.Equals(new DateTime())) { newRow[tblEmployee.CREATEDON_FIELD] = DBNull.Value; } else { newRow[tblEmployee.CREATEDON_FIELD] = entry.CreatedOn; } newRow[tblEmployee.CREATEDBYID_FIELD] = entry.CreatedByID; if (entry.ModifiedOn.Equals(new DateTime())) { newRow[tblEmployee.MODIFIEDON_FIELD] = DBNull.Value; } else { newRow[tblEmployee.MODIFIEDON_FIELD] = entry.ModifiedOn; } newRow[tblEmployee.MODIFIEDBYID_FIELD] = entry.ModifiedByID; newRow[tblEmployee.ISACTIVE_FIELD] = entry.IsActive; if (adding) { return(tblObj.AddToTable(newRow)); } else { return(tblObj.UpdateTable(newRow)); } }
public void AddToList(BOEmployee objBO) { InnerList.Add(objBO); }
public List <SimpleEmployee> getEmployees() { BOEmployee bo = new BOEmployee(); return(bo.getEmployees()); }
// GET api/<controller>/5 public IEnumerable <SimpleEmployee> Get() { BOEmployee bo = new BOEmployee(); return(bo.getEmployees()); }
public static int Save(BOEmployee entry, bool adding) { return(tblEmployeeDBManager.Save(entry, adding)); }
public static int Save(BOEmployee entry) { return(tblEmployeeDBManager.Save(entry, true)); }
public static int Update(BOEmployee entry) { return(tblEmployeeDBManager.Save(entry, false)); }
public static BOEmployee FillData(BOEmployee itemObj, DataRow dr) { if (dr["EmployeeDetailsID"] != DBNull.Value) { itemObj.EmployeeDetailsID = Int32.Parse(dr["EmployeeDetailsID"].ToString()); } if (dr["EmpProfileImage"] != DBNull.Value) { itemObj.EmpProfileImage = dr["EmpProfileImage"].ToString(); } if (dr["EmployeeID"] != DBNull.Value) { itemObj.EmployeeID = Int32.Parse(dr["EmployeeID"].ToString()); } if (dr["gender"] != DBNull.Value) { itemObj.gender = dr["gender"].ToString(); } if (dr["MaritalStatus"] != DBNull.Value) { itemObj.MaritalStatus = dr["MaritalStatus"].ToString(); } if (dr["DateOfBirth"] != DBNull.Value) { itemObj.DateOfBirth = DateTime.Parse(dr["DateOfBirth"].ToString()); } if (dr["DateOfAniversary"] != DBNull.Value) { itemObj.DateOfAniversary = DateTime.Parse(dr["DateOfAniversary"].ToString()); } if (dr["ContactNumber"] != DBNull.Value) { itemObj.ContactNumber = Int32.Parse(dr["ContactNumber"].ToString()); } if (dr["Landline"] != DBNull.Value) { itemObj.Landline = Int32.Parse(dr["Landline"].ToString()); } if (dr["CompanyProfile"] != DBNull.Value) { itemObj.CompanyProfile = dr["CompanyProfile"].ToString(); } if (dr["JoinningDate"] != DBNull.Value) { itemObj.JoinningDate = DateTime.Parse(dr["JoinningDate"].ToString()); } if (dr["CreatedOn"] != DBNull.Value) { itemObj.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString()); } if (dr["CreatedByID"] != DBNull.Value) { itemObj.CreatedByID = Int32.Parse(dr["CreatedByID"].ToString()); } if (dr["ModifiedOn"] != DBNull.Value) { itemObj.ModifiedOn = DateTime.Parse(dr["ModifiedOn"].ToString()); } if (dr["ModifiedByID"] != DBNull.Value) { itemObj.ModifiedByID = Int32.Parse(dr["ModifiedByID"].ToString()); } if (dr["IsActive"] != DBNull.Value) { itemObj.IsActive = Boolean.Parse(dr["IsActive"].ToString()); } return(itemObj); }