public static bool Delete(int id, string curentUsername, string role)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_User obj = exMana.HDS_User.First(temp => temp.Usr_ID == id);
if (curentUsername == obj.Usr_Username)
{
errMsg = "You can't to delete yourself !";
return false;
}
if (!role.Equals("AdmExastExaor") || !role.Equals("Manager"))
{
errMsg = "You don't permission to delete this user !";
return false;
}
exMana.DeleteObject(obj);
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool checkLogin(string user, string pass, ref string role)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
role = exMana.HDS_User.First(temp => temp.Usr_Username == user && temp.Usr_Password == pass).Usr_Role;
//role = NexMana.Employee.First(temp => temp.Username == user && temp.Password == pass).Role;
}
catch (Exception)
{
role = "";
return false;
}
return true;
}
public static bool AddNew(HDS_TypeQuestion Typ)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
exMana.AddToHDS_TypeQuestion(Typ);
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool AddNew(HDS_StandardRating Rat)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
exMana.AddToHDS_StandardRating(Rat);
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool AddNew(HDS_InitExamDetail Iexd)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
exMana.AddToHDS_InitExamDetail(Iexd);
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Update(HDS_Employee Emp)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_Employee obj = exMana.HDS_Employee.First(temp => temp.Emp_ID == Emp.Emp_ID);
obj.Emp_Name = Emp.Emp_Name;
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Update(HDS_TypeQuestion Typ)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_TypeQuestion obj = exMana.HDS_TypeQuestion.First(temp => temp.typ_ID == Typ.typ_ID);
obj.Typ_Name = Typ.Typ_Name;
obj.Typ_Description = Typ.Typ_Description;
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Update(HDS_Lever lev)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_Lever obj = exMana.HDS_Lever.First(temp => temp.Lev_ID == lev.Lev_ID);
obj.Lev_Name = lev.Lev_Name;
obj.Lev_Description = lev.Lev_Description;
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Update(HDS_ExamDetailAnswer Exda)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_ExamDetailAnswer obj = exMana.HDS_ExamDetailAnswer.First(temp => temp.Exda_ID == Exda.Exda_ID);
obj.Exd_ID = Exda.Exd_ID;
obj.Exda_Answer = Exda.Exda_Answer;
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Update(HDS_Category cat)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_Category obj = exMana.HDS_Category.First(temp => temp.Cat_ID == cat.Cat_ID);
obj.Cat_Name = cat.Cat_Name;
obj.Cat_Description = cat.Cat_Description;
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Update(HDS_InitExamDetail Iexd)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_InitExamDetail obj = exMana.HDS_InitExamDetail.First(temp => temp.Iex_ID == Iexd.Iex_ID);
obj.Iex_ID = Iexd.Iex_ID;
obj.Lev_ID = Iexd.Lev_ID;
obj.Iexd_NumQuestion = Iexd.Iexd_NumQuestion;
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Update(HDS_Answer Ans)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_Answer obj = exMana.HDS_Answer.First(temp => temp.Ans_ID == Ans.Ans_ID);
obj.Que_ID = Ans.Que_ID;
obj.Ans_Answer = Ans.Ans_Answer;
obj.Ans_IsTrue = Ans.Ans_IsTrue;
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Update(HDS_StandardRating Rat)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_StandardRating obj = exMana.HDS_StandardRating.First(temp => temp.Iex_ID == Rat.Iex_ID);
obj.Iex_ID = Rat.Iex_ID;
obj.Rat_FromMark = Rat.Rat_FromMark;
obj.Rat_ToMark = Rat.Rat_ToMark;
obj.Rat_Name = Rat.Rat_Name;
obj.Rat_Description = Rat.Rat_Description;
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Update(HDS_Exam Exa)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_Exam obj = exMana.HDS_Exam.First(temp => temp.Exa_ID == Exa.Exa_ID);
obj.Emp_ID = Exa.Emp_ID;
obj.Exa_FromDate = Exa.Exa_FromDate;
obj.Exa_ToDate = Exa.Exa_ToDate;
obj.Res_rating = Exa.Res_rating;
obj.Res_Result = Exa.Res_Result;
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Update(HDS_Question Que)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_Question obj = exMana.HDS_Question.First(temp => temp.Que_ID == Que.Que_ID);
obj.Lev_ID = Que.Lev_ID;
obj.Cat_ID = Que.Cat_ID;
obj.Typ_ID = Que.Typ_ID;
obj.Que_Title = Que.Que_Title;
obj.Que_Description = Que.Que_Description;
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Delete(int id, string role)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_StandardRating obj = exMana.HDS_StandardRating.First(temp => temp.Rat_ID == id);
if (!role.Equals("AdmRatstrator") || !role.Equals("Manager"))
{
errMsg = "You don't permission to delete this user !";
return false;
}
exMana.DeleteObject(obj);
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Update(HDS_InitExam Ini)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_InitExam obj = exMana.HDS_InitExam.First(temp => temp.Iex_ID == Ini.Iex_ID);
obj.Iex_Name = Ini.Iex_Name;
obj.Iex_Description = Ini.Iex_Description;
obj.Iex_Date = Ini.Iex_Date;
obj.Lev_ID = Ini.Lev_ID;
obj.Cat_ID = Ini.Cat_ID;
obj.Typ_ID = Ini.Typ_ID;
obj.Iex_NumQuestion = Ini.Iex_NumQuestion;
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static bool Update(HDS_User Usr)
{
try
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
HDS_User obj = exMana.HDS_User.First(temp => temp.Usr_ID == Usr.Usr_ID);
obj.Emp_ID = Usr.Emp_ID;
obj.Usr_Username = Usr.Usr_Username;
obj.Usr_Password = Usr.Usr_Password;
obj.Usr_Role = Usr.Usr_Role;
obj.Usr_Avata = Usr.Usr_Avata;
exMana.SaveChanges();
}
catch (Exception e)
{
errMsg = e.Message;
return false;
}
errMsg = "";
return true;
}
public static List<HDS_StandardRating> getAll()
{
ExamSystemManagerDBEntities ExMana = new ExamSystemManagerDBEntities();
List<HDS_StandardRating> Lst = ExMana.HDS_StandardRating.ToList();
return Lst;
}
public static List<HDS_Category> getAll()
{
ExamSystemManagerDBEntities ExMana = new ExamSystemManagerDBEntities();
List<HDS_Category> catLst = ExMana.HDS_Category.ToList();
return catLst;
}
public static List<HDS_InitExamDetail> getAll()
{
ExamSystemManagerDBEntities ExMana = new ExamSystemManagerDBEntities();
List<HDS_InitExamDetail> Lst = ExMana.HDS_InitExamDetail.ToList();
return Lst;
}
public static HDS_Lever getById(int id)
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
return exMana.HDS_Lever.First(temp => temp.Lev_ID == id);
}
public static List<HDS_Lever> getAll()
{
ExamSystemManagerDBEntities ExMana = new ExamSystemManagerDBEntities();
List<HDS_Lever> Lst = ExMana.HDS_Lever.ToList();
return Lst;
}
public static object getAll()
{
ExamSystemManagerDBEntities ExMana = new ExamSystemManagerDBEntities();
return (from sc in ExMana.HDS_User.Include("HDS_Employee") select new { id = sc.Usr_ID, emp = sc.HDS_Employee.Emp_Name, username = sc.Usr_Username, pass = sc.Usr_Password, role = sc.Usr_Role, img = sc.Usr_Avata }).ToList();
}
public static HDS_TypeQuestion getById(int id)
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
return exMana.HDS_TypeQuestion.First(temp => temp.typ_ID == id);
}
public static List<HDS_TypeQuestion> getAll()
{
ExamSystemManagerDBEntities ExMana = new ExamSystemManagerDBEntities();
List<HDS_TypeQuestion> Lst = ExMana.HDS_TypeQuestion.ToList();
return Lst;
}
public static HDS_User getByUsername(string UserName)
{
ExamSystemManagerDBEntities exMana = new ExamSystemManagerDBEntities();
return exMana.HDS_User.First(temp => temp.Usr_Username == UserName);
}