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