public EmployeeVM GetById(int id)
{
var _db = new CodeSampleContext();
var data = (
from e in _db.Employees
where e.ID == id && e.IsDeleted == false
select new EmployeeVM
{
ID = e.ID,
DepartmentId = e.DepartmentId,
FirstName = e.FirstName,
LastName = e.LastName,
Email = e.Email,
Mobile = e.Mobile,
DOB = e.DOB,
Gender = e.Gender,
Country = e.Country,
State = e.State,
City = e.City,
ZipCode = e.ZipCode,
Address = e.Address,
LastActivityOn = e.LastActivityOn,
IsActive = e.IsActive,
}
).FirstOrDefault();
return(data);
}
public List <TitleVM> GetDepartments()
{
var _db = new CodeSampleContext();
return((from c in _db.Departments select new TitleVM {
ID = c.ID, Title = c.Title
}).ToList());
}
public List <TitleVM> GetCountries()
{
var _db = new CodeSampleContext();
return((from c in _db.Countries select new TitleVM {
ID = c.ID, Title = c.Name
}).ToList());
}
public IPagedList <EmployeeVM> GetList(string country, string q, string orderBy, bool asc, int page, int pageSize, int departmentId)
{
var _db = new CodeSampleContext();
var obj = (from e in _db.Employees
join d in _db.Departments on e.DepartmentId equals d.ID
where
(departmentId == 0 || e.DepartmentId == departmentId) &&
(string.IsNullOrEmpty(country) || e.Country == country) &&
(string.IsNullOrEmpty(q) || (e.FirstName + " " + e.LastName + " " + e.Email + " " + e.Mobile).Contains(q)) &&
e.IsDeleted == false
orderby e.ID descending
select new EmployeeVM
{
ID = e.ID,
DepartmentId = e.DepartmentId,
FirstName = e.FirstName,
LastName = e.LastName,
Email = e.Email,
Mobile = e.Mobile,
DOB = e.DOB,
Gender = e.Gender,
Country = e.Country,
State = e.State,
City = e.City,
ZipCode = e.ZipCode,
Address = e.Address,
LastActivityOn = e.LastActivityOn,
IsActive = e.IsActive,
DepartmentTitle = d.Title,
});
if (!string.IsNullOrEmpty(orderBy))
{
switch (orderBy.ToLower())
{
case "firstname":
obj = asc ? obj.OrderBy(x => x.FirstName) : obj.OrderByDescending(x => x.FirstName);
break;
case "email":
obj = asc ? obj.OrderBy(x => x.Email) : obj.OrderByDescending(x => x.Email);
break;
case "mobile":
obj = asc ? obj.OrderBy(x => x.Mobile) : obj.OrderByDescending(x => x.Mobile);
break;
case "lastactivityon":
obj = asc ? obj.OrderBy(x => x.LastActivityOn) : obj.OrderByDescending(x => x.LastActivityOn);
break;
}
}
return(obj.ToPagedList(page, pageSize));
}
public List <TitleVM> GetStates(string countryname)
{
var _db = new CodeSampleContext();
var country = _db.Countries.FirstOrDefault(x => x.Name == countryname);
if (country != null)
{
return((from c in _db.CountryStates.Where(x => x.CountryID == country.ID) select new TitleVM {
ID = c.ID, Title = c.Name
}).ToList());
}
else
{
return(new List <TitleVM>());
}
}
public int SaveData(EmployeeVM model)
{
var _db = new CodeSampleContext();
var obj = _db.Employees.FirstOrDefault(x => x.ID == model.ID && x.IsDeleted == false);
if (obj == null)
{
obj = new Employee();
obj.IsDeleted = false;
}
obj.DepartmentId = model.DepartmentId;
obj.FirstName = model.FirstName;
obj.LastName = model.LastName;
obj.Email = model.Email;
obj.Mobile = model.Mobile;
obj.DOB = model.DOB;
obj.Gender = model.Gender;
obj.Country = model.Country;
obj.State = model.State;
obj.City = model.City;
obj.ZipCode = model.ZipCode;
obj.Address = model.Address;
obj.IsActive = model.IsActive;
obj.LastActivityBy = model.LastActivityBy;
obj.LastActivityOn = Helper.GetCurrentDateTime();
#region Update Section
if (obj.ID > 0)
{
_db.Employees.Attach(obj);
_db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
}
else
{
_db.Employees.Add(obj);
}
#endregion
return(_db.SaveChanges() > 0 ? obj.ID : 0);
}
public int Remove(int id, int?lastActivityBy)
{
var _db = new CodeSampleContext();
var obj = _db.Employees.FirstOrDefault(x => x.ID == id && x.IsDeleted == false);
if (obj != null)
{
obj.LastActivityBy = lastActivityBy;
obj.LastActivityOn = Helper.GetCurrentDateTime();
obj.IsActive = false;
obj.IsDeleted = true;
_db.Employees.Attach(obj);
_db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
return(_db.SaveChanges() > 0 ? obj.ID : 0);
}
else
{
return(0);
}
}
