public static async Task <bool> updateEmployee(Employee employee)
{
bool isSuccess = false;
using (SampleEntities entity = new SampleEntities())
{
var emp = await entity.Employees.Where(x => x.Id != employee.Id && x.EmailId == employee.EmailId).FirstOrDefaultAsync();
if (emp == null)
{
emp = await entity.Employees.Where(x => x.Id == employee.Id).FirstOrDefaultAsync();
emp.FirstName = employee.FirstName;
emp.LastName = employee.LastName;
emp.EmailId = employee.EmailId;
emp.DepartmentId = employee.DepartmentId;
emp.CityId = employee.CityId;
emp.Gender = employee.Gender;
await entity.SaveChangesAsync();
isSuccess = true;
return(isSuccess);
}
else
{
return(isSuccess);
}
}
}
public static async Task <List <Department> > GetDepartments()
{
using (SampleEntities entity = new SampleEntities())
{
return(await entity.Departments.ToListAsync());
}
}
public static async Task <List <sp_GetEmployee_Result> > getAllEmployee()
{
using (SampleEntities entity = new SampleEntities())
{
var employeeList = await entity.Database.SqlQuery <sp_GetEmployee_Result>("exec sp_GetEmployee").ToListAsync();
return(employeeList);
}
}
public static async Task <sp_GetEmployeeById_Result> getEmployeeById(long id)
{
using (SampleEntities entity = new SampleEntities())
{
SqlParameter paraId = new SqlParameter("@Id", System.Data.SqlDbType.BigInt);
paraId.Value = id;
var employeeList = await entity.Database.SqlQuery <sp_GetEmployeeById_Result>("exec sp_GetEmployeeById @Id", paraId).FirstOrDefaultAsync();
return(employeeList);
}
}
public static async Task <bool> isEmailExist(string email)
{
using (SampleEntities entity = new SampleEntities())
{
bool isExsit = true;
Employee emp = await entity.Employees.Where(x => x.EmailId == email).FirstOrDefaultAsync();
if (emp == null)
{
isExsit = false;
}
return(isExsit);
}
}
public static async Task <List <sp_GetEmployee_for_datatable_Result> > getEmployees(string SearchValue, int FirstRow, int LastRow, string SortColumn, string SortOrder)
{
using (SampleEntities entity = new SampleEntities())
{
var employeeList = await entity.Database.SqlQuery <sp_GetEmployee_for_datatable_Result>
("exec sp_GetEmployee_for_datatable @SearchValue, @FirstRow, @LastRow, @SortColumn, @SortOrder ", new SqlParameter[] {
new SqlParameter("@SearchValue", SearchValue),
new SqlParameter("@FirstRow", FirstRow),
new SqlParameter("LastRow", LastRow),
new SqlParameter("@SortColumn", SortColumn),
new SqlParameter("@SortOrder", SortOrder)
}).ToListAsync();
return(employeeList);
}
}
public static async Task <long> addEmployee(Employee employee)
{
long employeeId = 0;
using (SampleEntities entity = new SampleEntities())
{
if (!await isEmailExist(employee.EmailId))
{
entity.Employees.Add(employee);
await entity.SaveChangesAsync();
employeeId = employee.Id;
}
}
return(employee.Id);
}