public ActionResult Add(FormCollection collection)
{
try
{
if (ModelState.IsValid)
{
var employee = new Employee();
bool ok = TryUpdateModel(employee, collection);
using (PracticalTestEntities pt = new PracticalTestEntities())
{
if (employee.EmployeeId == 0)
{
pt.Employees.Add(employee);
}
else
{
pt.Entry(employee).State = EntityState.Modified;
}
pt.SaveChanges();
}
}
return(RedirectToAction("List"));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Department(FormCollection collection)
{
try
{
if (ModelState.IsValid)
{
DepartmentMaster d = new DepartmentMaster();
bool ok = TryUpdateModel(d, collection);
using (PracticalTestEntities pt = new PracticalTestEntities())
{
if (d.DepartmentId == 0)
{
pt.DepartmentMasters.Add(d);
}
else
{
pt.Entry(d).State = EntityState.Modified;
}
pt.SaveChanges();
}
}
return(RedirectToAction("Department", new { id = 0 }));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult DeleteDepartment(int id)
{
try
{
using (PracticalTestEntities pt = new PracticalTestEntities())
{
var Data = pt.DepartmentMasters.Where(x => x.DepartmentId == id).FirstOrDefault();
pt.DepartmentMasters.Remove(Data);
pt.SaveChanges();
}
return(RedirectToAction("Department", new { id = 0 }));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Delete(int id)
{
try
{
using (PracticalTestEntities pt = new PracticalTestEntities())
{
var Data = pt.Employees.Include("EmployeeDepartments").Where(x => x.EmployeeId == id).FirstOrDefault();
pt.Employees.Remove(Data);
pt.SaveChanges();
}
return(RedirectToAction("List"));
}
catch (Exception ex)
{
throw ex;
}
}
public bool InsertOrUpdate(UserViewModel User)
{
bool isUpdated = false;
using (PracticalTestEntities _context = new PracticalTestEntities())
{
if (User.Id == null || User.Id == Guid.Empty)
{
// Insert
tbl_usermaster _RetObj = new tbl_usermaster();
_RetObj.Id = Guid.NewGuid();
_RetObj.Name = User.Name;
_RetObj.Birthdate = Convert.ToDateTime(User.Birthdate);
_RetObj.Email = User.Email;
_RetObj.Mobile = User.Mobile;
_RetObj.Age = User.Age;
_RetObj.Gender = User.Gender;
_RetObj.RoleId = User.RoleId;
_RetObj.ProfileUrl = User.ProfileUrl;
_RetObj.IsActive = true;
_RetObj.CreatedAt = DateTime.Now;
_RetObj.UpdatedAt = DateTime.Now;
_context.tbl_usermaster.Add(_RetObj);
}
else
{
// Update
tbl_usermaster _RetObj = _context.tbl_usermaster.AsEnumerable().FirstOrDefault(q => q.Id == User.Id);
_RetObj.Id = User.Id;
_RetObj.Name = User.Name;
_RetObj.Birthdate = Convert.ToDateTime(User.Birthdate);
_RetObj.Email = User.Email;
_RetObj.Mobile = User.Mobile;
_RetObj.Age = User.Age;
_RetObj.Gender = User.Gender;
_RetObj.RoleId = User.RoleId;
_RetObj.ProfileUrl = User.ProfileUrl;
_RetObj.UpdatedAt = DateTime.Now;
}
_context.SaveChanges();
isUpdated = true;
}
return(isUpdated);
}
public bool Delete(string Id)
{
bool isUpdated = false;
using (PracticalTestEntities _context = new PracticalTestEntities())
{
var _id = Guid.Parse(Id);
tbl_usermaster _RetObj = _context.tbl_usermaster.AsEnumerable().FirstOrDefault(q => q.Id == _id);
if (_RetObj.IsActive == true)
{
_RetObj.IsActive = false;
}
else
{
_RetObj.IsActive = true;
}
_context.SaveChanges();
isUpdated = true;
return(isUpdated);
}
}
