public void IsExamCompletion(UserExamCompletion objExamCompletion)
{
tbl_txn_Test_Completion objTestCompletion = new tbl_txn_Test_Completion();
using (var objContext = new IPTSE_EXAMEntities())
{
using (var dbcxtransaction = objContext.Database.BeginTransaction())
{
try
{
objTestCompletion.CandidateId = Convert.ToInt32(objExamCompletion.CandidateId);
objTestCompletion.IsExamCompleted = objExamCompletion.IsExamCompleted;
objTestCompletion.CreatedBy = objExamCompletion.CreatedBy;
objTestCompletion.CreatedDateTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"));
objContext.tbl_txn_Test_Completion.Add(objTestCompletion);
objContext.SaveChanges();
dbcxtransaction.Commit();
}
catch (Exception ex)
{
throw ex;
}
}
}
}
public bool IsExamGiven(login_table objUProfile)
{
tbl_txn_Test_Completion objTestCompletion = new tbl_txn_Test_Completion();
using (var objContext = new IPTSE_EXAMEntities())
{
using (var dbcxtransaction = objContext.Database.BeginTransaction())
{
try
{
var isCompletion = objContext.tbl_txn_Test_Completion.Where(t => t.CreatedBy == objUProfile.email && t.CandidateId == objUProfile.Id).Select(t1 => t1).FirstOrDefault();
if (isCompletion != null)
{
return(true);
}
else
{
return(false);
}
}
catch { return(false); }
}
}
}
