protected void btnReActive_Click(object sender, EventArgs e)
{
Button btn = sender as Button;
BOAssignExamUser _boaeu = new BOAssignExamUser();
BAAssignExamUser _baaeu = new BAAssignExamUser();
_boaeu.ExamId = Convert.ToInt32(btn.CommandArgument);
_boaeu.UserId = Convert.ToInt32(btn.ToolTip);
_boaeu.TestOnce = true;
_boaeu.UpdatedBy = Convert.ToInt32(btn.ToolTip);
_boaeu.UpdatedDate = DateTime.UtcNow;
_boaeu.Event = "UpdateByUser";
_baaeu.IUD(_boaeu);
}
internal int IUDAssignExamUser(BOAssignExamUser _boaeu)
{
int returnValue = default(int);
using (SqlConnection _sqlconnection = ConnectionInfo.GetConnection())
{
_sqlcommand = new SqlCommand();
_sqlcommand.Connection = _sqlconnection;
_sqlcommand.CommandText = "SP_IUDAssignExamUser";
_sqlcommand.CommandType = CommandType.StoredProcedure;
_sqlconnection.Open();
_sqlcommand.Parameters.AddWithValue("@UserId", _boaeu.UserId);
_sqlcommand.Parameters.AddWithValue("@ExamId", _boaeu.ExamId);
_sqlcommand.Parameters.AddWithValue("@SecondCatId", _boaeu.SecondCatId);
_sqlcommand.Parameters.AddWithValue("@OnlineTest", _boaeu.OnlineTest);
_sqlcommand.Parameters.AddWithValue("@OfflineSimulator", _boaeu.OfflineSimulator);
_sqlcommand.Parameters.AddWithValue("@TestOnce", _boaeu.TestOnce);
_sqlcommand.Parameters.AddWithValue("@IsActive", _boaeu.IsActive);
_sqlcommand.Parameters.AddWithValue("@IsDelete", _boaeu.IsDelete);
_sqlcommand.Parameters.AddWithValue("@CreatedBy", _boaeu.CreatedBy);
_sqlcommand.Parameters.AddWithValue("@CreatedDate", _boaeu.CreatedDate);
_sqlcommand.Parameters.AddWithValue("@UpdatedBy", _boaeu.UpdatedBy);
_sqlcommand.Parameters.AddWithValue("@UpdatedDate", _boaeu.UpdatedDate);
_sqlcommand.Parameters.AddWithValue("@Event", _boaeu.Event);
_sqlcommand.Parameters.AddWithValue("@returnValue", 0).Direction = System.Data.ParameterDirection.InputOutput;
try
{
_sqlcommand.ExecuteNonQuery();
returnValue = Convert.ToInt32(_sqlcommand.Parameters["@returnValue"].Value);
}
catch (SqlException sqlex)
{ Common.LogError(sqlex); }
catch (StackOverflowException stackex)
{ Common.LogError(stackex); }
catch (Exception ex)
{
Common.LogError(ex);
}
finally
{
_sqlconnection.Close();
_sqlcommand.Dispose();
}
}
return(returnValue);
}
private void AssignExamUser(int UserId, int SecondCatId, string parentEvent)
{
BOAssignExamUser _boaeu = new BOAssignExamUser();
BAAssignExamUser _baaeu = new BAAssignExamUser();
foreach (ListItem item in chkcheckdECL.Items)
{
//if (item.Selected)
//{
_boaeu.UserId = UserId;
_boaeu.ExamId = Convert.ToInt32(item.Value);
_boaeu.SecondCatId = SecondCatId;
if (chklistAccessoption.Items.FindByValue("2").Selected)
{
_boaeu.OnlineTest = true;
}
else
{
_boaeu.OnlineTest = false;
}
if (chklistAccessoption.Items.FindByValue("3").Selected)
{
_boaeu.OfflineSimulator = true;
}
else
{
_boaeu.OfflineSimulator = false;
}
if (chklistAccessoption.Items.FindByValue("4").Selected)
{
_boaeu.TestOnce = true;
}
else
{
_boaeu.TestOnce = false;
}
_boaeu.IsActive = true;
_boaeu.IsDelete = false;
_boaeu.CreatedBy = MerchantId;
_boaeu.CreatedDate = DateTime.UtcNow;
_boaeu.UpdatedBy = MerchantId;
_boaeu.UpdatedDate = DateTime.UtcNow;
_boaeu.Event = parentEvent;
_baaeu.Insert(_boaeu);
// }
}
}
private void UpdateExamManage(BOExamManage _boexammanage)
{
//BOExamManage _boexmnge = new BOExamManage();
//BAExamManage _baexmmng = new BAExamManage();
//_boexmnge.ExamCodeId = _boexammanage.ExamCodeId;
//_boexmnge.OnlyTestOnce = false;
//_boexmnge.UpdatedBy = _bouserDetail.UserId;
//_boexmnge.UpdatedDate = DateTime.UtcNow;
//_boexmnge.Event = "UpdateByUser";
//_baexmmng.IUD(_boexmnge);
///6June2018 New table for TestOnce permission
BOAssignExamUser _boaeu = new BOAssignExamUser();
BAAssignExamUser _baaeu = new BAAssignExamUser();
_boaeu.ExamId = _boexammanage.ExamCodeId;
_boaeu.UserId = _bouserDetail.UserId;
_boaeu.TestOnce = false;
_boaeu.UpdatedBy = _bouserDetail.UserId;
_boaeu.UpdatedDate = DateTime.UtcNow;
_boaeu.Event = "UpdateByUser";
_baaeu.IUD(_boaeu);
}
internal int IUD(BOAssignExamUser _boaeu)
{
return(_daaeu.IUD(_boaeu));
}
internal int Insert(BOAssignExamUser _boaeu)
{
return(_daaeu.IUDAssignExamUser(_boaeu));
}
