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