public static bool UserTestPerfectionCtrl(int UserID) { PIKCV.DAL.UserTestPerfectionResults obj = new PIKCV.DAL.UserTestPerfectionResults(); obj.Where.UserID.Value = UserID; obj.Query.Load(); if (obj.RowCount < 1) { return(true); } return(false); }
public static bool SaveUserTestPerfection(int UserID, DataTable dtResults) { PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr(); PIKCV.DAL.UserTestPerfectionResults obj = new PIKCV.DAL.UserTestPerfectionResults(); obj.Where.UserID.Value = UserID; obj.Query.Load(); if (!obj.EOF) { return(false); } try { obj = new PIKCV.DAL.UserTestPerfectionResults(); Tran.BeginTransaction(); obj = new PIKCV.DAL.UserTestPerfectionResults(); PIKCV.DAL.UserCVs objUserCV = new PIKCV.DAL.UserCVs(); objUserCV.Where.UserID.Value = UserID; objUserCV.Query.Load(); objUserCV.TestYetDate = DateTime.Now; objUserCV.Save(); foreach (DataRow dr in dtResults.Rows) { obj.AddNew(); obj.UserID = UserID; obj.TestPerfectionID = Convert.ToInt32(dr["TestPerfectionID"]); obj.AnswerPoint = Convert.ToInt32(dr["AnswerPoint"]); obj.Save(); } Tran.CommitTransaction(); return(true); } catch (Exception) { Tran.RollbackTransaction(); PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset(); return(false); } }