public bool Save(EmployeeModel em, out string msg)
{
try
{
using (masterDBEntities obj = new masterDBEntities())
{
var temp = obj.Employee.Find(em.EmployeeId);
Employee emp = temp == null ? new Employee() : temp;
emp.Name = em.Name;
emp.Email = em.Email;
emp.Designation = em.Designation;
emp.Salary = em.Salary;
emp.DateOfJoining = em.DateOfJoining;
emp.Status = em.Status;
if (temp == null)
{
obj.Employee.Add(emp);
msg = "Saved Successfully";
}
else
{
msg = "Updated Successfully";
}
obj.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult LoadData(string status)
{
try
{
using (masterDBEntities obj = new masterDBEntities())
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault();
//Paging Size (10,20,50,100)
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
// Getting all data
var v = (from m in obj.Employee select m).Where(m => m.Status == status);
//Sorting
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir)))
{
v = v.OrderBy(sortColumn + " " + sortColumnDir);
}
//Search
if (!string.IsNullOrEmpty(searchValue))
{
v = v.Where(a => a.Name.Contains(searchValue) || a.Email.Contains(searchValue) || a.Designation.Contains(searchValue) || a.Salary.ToString().Contains(searchValue) || a.DateOfJoining.ToString().Contains(searchValue));
}
//total number of rows count
recordsTotal = v.Count();
//Paging
var data = v.Skip(skip).Take(pageSize).ToList();
// Returning Json Data
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool Delete(Int64?id)
{
try
{
using (masterDBEntities obj = new masterDBEntities())
{
var v = obj.Employee.Find(id);
if (v == null)
{
return(false);
}
obj.Employee.Remove(v);
obj.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public EmployeeModel AddEdit(Int64?id)
{
try
{
using (masterDBEntities obj = new masterDBEntities())
{
return(obj.Employee.Where(x => x.EmployeeId == id).Select(x => new EmployeeModel
{
EmployeeId = x.EmployeeId,
Name = x.Name,
Email = x.Email,
Designation = x.Designation,
Salary = x.Salary,
DateOfJoining = x.DateOfJoining,
Status = x.Status
}).FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
