//get role by Id
 public RolesAndResponsibilities GetRolesAndResponsibilitiesById(int roleID)
 {
     try
     {
         RolesAndResponsibilities roles = db.RolesAndResponsibilities.Find(roleID);
         return(roles);
     }
     catch
     {
         throw;
     }
 }
 //Edit Roles And responsibilities
 public int EditRolesAndResponsibilities(RolesAndResponsibilities rolesAndResponsibilities)
 {
     try
     {
         db.Entry(rolesAndResponsibilities).State = EntityState.Modified;
         db.SaveChanges();
         return(1);
     }
     catch
     {
         throw;
     }
 }
 //Add Roles and responsibilities
 public int AddRolesAndResponsibilities(RolesAndResponsibilities rolesAndResponsibilities)
 {
     try
     {
         db.RolesAndResponsibilities.Add(rolesAndResponsibilities);
         db.SaveChanges();
         return(1);
     }
     catch
     {
         throw;
     }
 }
 //delete roles and Responsibilities
 public int DeleteRolesAndResponsibilities(int roleID)
 {
     try
     {
         RolesAndResponsibilities roles = db.RolesAndResponsibilities.Find(roleID);
         db.RolesAndResponsibilities.Remove(roles);
         db.SaveChanges();
         return(1);
     }
     catch
     {
         throw;
     }
 }