public override string[] GetRolesForUser(string username) { using (LearningDBEntities db = new LearningDBEntities()) { return(db.Users.Where(u => u.UserName == username).Select(u => u.Roles.RoleName).ToArray()); } }
public JsonResult GetEmployee() { using (LearningDBEntities db = new LearningDBEntities()) { List <Employee> empList = db.Employees.ToList(); return(Json(empList, JsonRequestBehavior.AllowGet)); } }
public JsonResult Delete(int id) { using (LearningDBEntities db = new LearningDBEntities()) { Employee employee = db.Employees.Find(id); if (employee == null) { return(Json(new { success = false })); } db.Employees.Remove(employee); db.SaveChanges(); return(Json(new { success = true })); } }
public JsonResult Insert(Employee employee) { if (employee != null) { using (LearningDBEntities db = new LearningDBEntities()) { db.Employees.Add(employee); db.SaveChanges(); return(Json(new { success = true })); } } else { return(Json(new { success = false })); } }
public JsonResult Update(Employee updatedEmployee) { using (LearningDBEntities db = new LearningDBEntities()) { Employee existingEmployee = db.Employees.Find(updatedEmployee.EmpID); if (existingEmployee == null) { return(Json(new { success = false })); } else { existingEmployee.EmpName = updatedEmployee.EmpName; existingEmployee.DeptName = updatedEmployee.DeptName; existingEmployee.Email = updatedEmployee.Email; existingEmployee.Designation = updatedEmployee.Designation; db.SaveChanges(); return(Json(new { success = true })); } } }
public NotificationRepository(LearningDBEntities db) { _db = db; }
public CoursesRepository(LearningDBEntities db) { _db = db; }
public SelectedCategoryRepository(LearningDBEntities db) { _db = db; }
public TeacherRepository(LearningDBEntities db) { _db = db; }