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