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;
}
