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