public List <EmployeeAccountsDTO> GetAllEmployeeAccounts(EmplyoeeAccountsGetDTO objGetAccount)
{
List <EmployeeAccountsDTO> accounts = new List <EmployeeAccountsDTO>();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectAccount");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@ActionBy", objGetAccount.ActionBy);
accounts = dbLayer.GetEntityList <EmployeeAccountsDTO>(SqlCmd);
}
return(accounts);
}
public List <EmployeeAccountsDTO> GetInActiveEmployeeAccount(EmplyoeeAccountsGetDTO objInActive)
{
List <EmployeeAccountsDTO> inActiveList = new List <EmployeeAccountsDTO>();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectAccount");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@Active", 0);
SqlCmd.Parameters.AddWithValue("@ActionBy", objInActive.ActionBy);
inActiveList = dbLayer.GetEntityList <EmployeeAccountsDTO>(SqlCmd);
}
return(inActiveList);
}
public EmployeeAccountsDTO GetEmployeeAccountsById(EmplyoeeAccountsGetDTO objGetAccById)
{
EmployeeAccountsDTO accounts = new EmployeeAccountsDTO();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectAccount");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@Id", objGetAccById.Id);
SqlCmd.Parameters.AddWithValue("@ActionBy", objGetAccById.ActionBy);
accounts = dbLayer.GetEntityList <EmployeeAccountsDTO>(SqlCmd).FirstOrDefault();
}
return(accounts);
}
public List <GetEmployeeDTO> GetEmployee(EmplyoeeAccountsGetDTO objGetEmp)
{
List <GetEmployeeDTO> empList = new List <GetEmployeeDTO>();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectEmployeeAccount");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@Active", 1);
SqlCmd.Parameters.AddWithValue("@ActionBy", objGetEmp.ActionBy);
empList = dbLayer.GetEntityList <GetEmployeeDTO>(SqlCmd);
}
return(empList);
}
public HttpResponseMessage GetEmployeeAccountById(EmplyoeeAccountsGetDTO objGetAccById)
{
HttpResponseMessage message;
try
{
// EmployeeAccountsDataAccessLayer dal = new EmployeeAccountsDataAccessLayer();
var dynObj = new { result = _employee.GetEmployeeAccountsById(objGetAccById) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
ErrorLog.CreateErrorMessage(ex, "EmployeeAccount", "GetEmployeeAccounById");
}
return(message);
}
