public static List <qualification> getQualifications() { MCenterDBContext db = new MCenterDBContext(); List <qualification> qualifications = db.qualifications.ToList(); return(qualifications); }
public user_data getUserByID(int id) { using (MCenterDBContext db = new MCenterDBContext()) { user_data user = db.user_data.Where(x => x.user_id == id).SingleOrDefault(); return(user); } }
public static instructor getInstructorByID(int id) { using (MCenterDBContext db = new MCenterDBContext()) { instructor instructor = db.instructors.Where(x => x.instructor_id == id).SingleOrDefault(); return(instructor); } }
public static void UpdateInstructor(instructorQualificationPhoneViewModel instructorvm) { MCenterDBContext db = new MCenterDBContext(); instructor updataedInstructor = getInstructorByID(instructorvm.instructor_id); updataedInstructor.instructor_name = instructorvm.instructor_name; updataedInstructor.NameOf_ItsUnit = instructorvm.NameOf_ItsUnit; updataedInstructor.TrainningTopic = instructorvm.TrainningTopic; db.SaveChanges(); }
public static void DeleteInstructor(int id) { MCenterDBContext db = new MCenterDBContext(); instructor deletedIns = getInstructorByID(id); //delete from qualification instructor //delete from phone instructor DeletePhoneInstructor(id); }
public void DeleteUser(int id) { using (MCenterDBContext db = new MCenterDBContext()) { user_data deletedIns = getUserByID(id); // db.instructors.Remove(deletedIns); db.Entry(deletedIns).State = EntityState.Deleted; db.SaveChanges(); } }
public static void DeletePhoneInstructor(int insid) { MCenterDBContext db = new MCenterDBContext(); List <instructor_phone> instructor_Phones = db.instructor_phone.Where(x => x.instructor_id == insid).ToList(); foreach (var item in instructor_Phones) { db.instructor_phone.Remove(item); db.SaveChanges(); } }
public static List <instructorQualificationPhoneViewModel> getAllIstructors() { MCenterDBContext db = new MCenterDBContext(); List <instructorQualificationPhoneViewModel> lstInstructors = db.instructors.Select(x => new instructorQualificationPhoneViewModel { instructor_name = x.instructor_name, Current_JobTitle = x.Current_JobTitle, TrainningTopic = x.TrainningTopic, NameOf_ItsUnit = x.NameOf_ItsUnit, instructor_id = x.instructor_id }).ToList(); return(lstInstructors); }
//fatma public List <qualificationVM> getQualifications() { using (MCenterDBContext db = new MCenterDBContext()) { List <qualificationVM> lstQualifiaction = db.qualifications.Select(x => new qualificationVM { qualification_name = x.qualification_name, qualification_id = x.qualification_id, organization = x.organization, qualification_date = x.qualification_date, }).ToList(); return(lstQualifiaction); } }
public static void UpdateInstructor(instructorVM instructorvm) { using (MCenterDBContext db = new MCenterDBContext()) { instructor updataedInstructor = getInstructorByID(instructorvm.instructor_id); updataedInstructor.instructor_name = instructorvm.instructor_name; updataedInstructor.NameOf_ItsUnit = instructorvm.NameOf_ItsUnit; updataedInstructor.TrainningTopic = instructorvm.TrainningTopic; updataedInstructor.Current_JobTitle = instructorvm.Current_JobTitle; updataedInstructor.Mobile = instructorvm.Mobile; updataedInstructor.phone = instructorvm.phone; updataedInstructor.Email = instructorvm.Email; updataedInstructor.QualificationsName = instructorvm.QualificationsName; db.Entry(updataedInstructor).State = EntityState.Modified; db.SaveChanges(); } }
public static void AddInstructor(instructorVM instructorvm) { using (MCenterDBContext db = new MCenterDBContext()) { instructor newInstructor = new instructor(); newInstructor.instructor_name = instructorvm.instructor_name; newInstructor.NameOf_ItsUnit = instructorvm.NameOf_ItsUnit; newInstructor.TrainningTopic = instructorvm.TrainningTopic; newInstructor.Current_JobTitle = instructorvm.Current_JobTitle; newInstructor.Mobile = instructorvm.Mobile; newInstructor.phone = instructorvm.phone; newInstructor.Email = instructorvm.Email; newInstructor.QualificationsName = instructorvm.QualificationsName; db.instructors.Add(newInstructor); db.SaveChanges(); } }
public static instructor getInstructorByID(int id) { MCenterDBContext db = new MCenterDBContext(); // instructorQualificationPhoneViewModel instructor = db.instructors.Where(x => x.instructor_id == id).Select(x => //new instructorQualificationPhoneViewModel //{ // instructor_name = x.instructor_name, // Current_JobTitle = x.Current_JobTitle, // TrainningTopic = x.TrainningTopic, // NameOf_ItsUnit = x.NameOf_ItsUnit, // instructor_id = x.instructor_id //}).SingleOrDefault(); instructor instructor = db.instructors.Where(x => x.instructor_id == id).SingleOrDefault(); return(instructor); }
public static void AddInstructor(instructorQualificationPhoneViewModel instructorvm) { MCenterDBContext db = new MCenterDBContext(); instructor newInstructor = new instructor(); newInstructor.instructor_name = instructorvm.instructor_name; newInstructor.NameOf_ItsUnit = instructorvm.NameOf_ItsUnit; newInstructor.TrainningTopic = instructorvm.TrainningTopic; newInstructor.Current_JobTitle = instructorvm.Current_JobTitle; db.instructors.Add(newInstructor); db.SaveChanges(); instructor_phone newPhone = new instructor_phone(); newPhone.phone = instructorvm.phone; newPhone.instructor_id = newInstructor.instructor_id; db.instructor_phone.Add(newPhone); db.SaveChanges(); }
public UsersVM getUserBYName(string loginName) { using (MCenterDBContext db = new MCenterDBContext()) { UsersVM user = db.user_data.Where(x => x.loginUserName == loginName).Select(x => new UsersVM { user_name = x.user_name, address = x.address, age = x.age, email = x.email, national_id = x.national_id.ToString(), phone = x.phone, qualification_id = x.qualification.qualification_id, role = x.role }).SingleOrDefault(); return(user); } }
public void UpdateUser(UsersVM userVm) { using (MCenterDBContext db = new MCenterDBContext()) { user_data updataedUser = getUserByID(userVm.user_id); updataedUser.user_name = userVm.user_name; updataedUser.age = userVm.age; updataedUser.email = userVm.email; updataedUser.national_id = userVm.national_id; updataedUser.address = userVm.address; updataedUser.phone = userVm.phone; updataedUser.qualification_id = userVm.qualification_id; updataedUser.loginUserName = userVm.loginUserName; updataedUser.password = userVm.password; db.Entry(updataedUser).State = EntityState.Modified; db.SaveChanges(); } }
public static List <instructorVM> getAllIstructors() { using (MCenterDBContext db = new MCenterDBContext()) { List <instructorVM> lstInstructors = db.instructors.Select(x => new instructorVM { instructor_name = x.instructor_name, Current_JobTitle = x.Current_JobTitle, TrainningTopic = x.TrainningTopic, NameOf_ItsUnit = x.NameOf_ItsUnit, instructor_id = x.instructor_id, Mobile = x.Mobile, phone = x.phone, Email = x.Email, QualificationsName = x.QualificationsName }).ToList(); return(lstInstructors); } }
public static instructorVM getInstructorByID2(int id) { using (MCenterDBContext db = new MCenterDBContext()) { instructorVM instructor = db.instructors.Where(x => x.instructor_id == id).Select(x => new instructorVM { instructor_name = x.instructor_name, Current_JobTitle = x.Current_JobTitle, TrainningTopic = x.TrainningTopic, NameOf_ItsUnit = x.NameOf_ItsUnit, instructor_id = x.instructor_id, Mobile = x.Mobile, phone = x.phone, Email = x.Email, QualificationsName = x.QualificationsName }).SingleOrDefault(); return(instructor); } }
public UsersVM checkUserLogin(LoginVM login) { using (MCenterDBContext db = new MCenterDBContext()) { UsersVM user = db.user_data.Where(x => x.user_name == login.user_name && x.password == login.password).Select(x => new UsersVM { user_name = x.user_name, user_id = x.user_id, address = x.address, age = x.age, email = x.email, national_id = x.national_id.ToString(), phone = x.phone, qualification_id = x.qualification.qualification_id, role = x.role }).SingleOrDefault(); return(user); } }
public List <UsersVM> getAllUsers() { using (MCenterDBContext db = new MCenterDBContext()) { List <UsersVM> lstUsers = db.user_data.Select(x => new UsersVM { user_name = x.user_name, address = x.address, age = x.age, email = x.email, national_id = x.national_id.ToString(), role = x.role, user_id = x.user_id, phone = x.phone, qualification_name = x.qualification.qualification_name, loginUserName = x.loginUserName, password = x.password, qualification_id = x.qualification_id }).ToList(); return(lstUsers); } }