public static bool UserTestCtrl(int UserID) { PIKCV.DAL.UserTestResults obj = new PIKCV.DAL.UserTestResults(); obj.Where.UserID.Value = UserID; obj.Query.Load(); if (obj.RowCount < 1) { return(true); } return(false); }
public static bool SaveUserTestResults(int UserID, PIKCV.COM.EnumDB.TestTypeCode TestTypeCode, DataTable dtResults) { PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr(); PIKCV.DAL.UserTestResults obj = new PIKCV.DAL.UserTestResults(); obj.Where.UserID.Value = UserID; obj.Query.Load(); if (!obj.EOF) { return(false); } try { Tran.BeginTransaction(); obj = new PIKCV.DAL.UserTestResults(); PIKCV.DAL.UserCVs objUserCV = new PIKCV.DAL.UserCVs(); objUserCV.Where.UserID.Value = UserID; objUserCV.Query.Load(); objUserCV.TestMatDate = DateTime.Now; objUserCV.Save(); foreach (DataRow dr in dtResults.Rows) { obj.AddNew(); obj.TestTypeCode = (int)TestTypeCode; obj.UserID = UserID; obj.QuestionNo = Convert.ToInt32(dr["QuestionNo"]); obj.TestQuestionID = Convert.ToInt32(dr["TestQuestionID"]); obj.TestAnswerID = Convert.ToInt32(dr["TestAnswerID"]); obj.Save(); } Tran.CommitTransaction(); return(true); } catch (Exception) { Tran.RollbackTransaction(); PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset(); return(false); } }