/// <summary>
/// Bind Employee Details List.
/// </summary>
/// <returns></returns>
public CallResponse GetEmployeeDetailsList(AppFilters filter)
{
CallResponse callResponse = new CallResponse();
try
{
using (var context = new DBEntities(ConnectionString))
{
var empList = (from ED in context.EmployeeDetails
select new AppEmployeeDetails
{
EmpId = ED.EmpId,
Name = ED.Name,
Age = ED.Age,
MaritalStatus = ED.MaritalStatus,
Salary = ED.Salary,
Location = ED.Location,
}).ToList();
if (!string.IsNullOrEmpty(filter.Name))
{
//empList = empList.Where(b => b.Name.Contains(filter.Name)).ToList();
empList = empList.Where(c => !string.IsNullOrEmpty(c.Name) && c.Name.ToLower().IndexOf(filter.Name.ToLower()) >= 0).ToList();
}
if (!string.IsNullOrEmpty(filter.Age))
{
empList = empList.Where(b => b.Age.ToString().StartsWith(filter.Age)).ToList();
}
if (!string.IsNullOrEmpty(filter.Salary))
{
empList = empList.Where(b => b.Salary.ToString().StartsWith(filter.Salary)).ToList();
}
if (!string.IsNullOrEmpty(filter.Location) && filter.Location != "")
{
empList = empList.Where(b => b.Location.ToString().StartsWith(filter.Location)).ToList();
}
callResponse.Data = empList;
callResponse.Status = true;
callResponse.Message = "Success";
}
}
catch (Exception ex)
{
callResponse.Status = false;
callResponse.Message = "Error :" + ex.Message;
}
return(callResponse);
}
/// <summary>
/// This Method use hard delete.
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public CallResponse DeleteEmployee(AppFilters filter)
{
CallResponse callResponse = new CallResponse();
try
{
using (var context = new DBEntities(ConnectionString))
{
using (var dbTrans = context.Database.BeginTransaction())
{
try
{
var deleteRecord = context.EmployeeDetails.Where(c => c.EmpId == filter.EmpId).FirstOrDefault();
if (deleteRecord != null)
{
context.Entry(deleteRecord).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
dbTrans.Commit();
callResponse.Status = true;
callResponse.Message = "Employee deleted successfully.";
}
catch (Exception ex)
{
dbTrans.Rollback();
callResponse.Status = false;
callResponse.Message = "Error :" + ex.Message;
}
}
}
}
catch (Exception ex)
{
callResponse.Status = false;
callResponse.Message = "Error :" + ex.Message;
}
return(callResponse);
}
public CallResponse DeleteEmployee([FromBody] AppFilters filter)
{
CallResponse callResponse = _service.DeleteEmployee(filter);
return(callResponse);
}
public CallResponse GetEmployeeDetailsList([FromBody] AppFilters filter)
{
CallResponse callResponse = _service.GetEmployeeDetailsList(filter);
return(callResponse);
}
