public MCQDTO InsertUpdateMCQUserStatus(string i_sConnectionString, MCQDTO i_objMCQDTO) { #region Paramters List <MCQDTO> res = null; string sErrCode = string.Empty; PetaPoco.Database db = null; int out_nReturnValue; int out_nSQLErrCode; string out_sSQLErrMessage; #endregion Paramters try { #region Output Param var nReturnValue = new SqlParameter("@out_nReturnValue", System.Data.SqlDbType.Int); nReturnValue.Direction = System.Data.ParameterDirection.Output; nReturnValue.Value = 0; var nSQLErrCode = new SqlParameter("@out_nSQLErrCode", System.Data.SqlDbType.Int); nSQLErrCode.Direction = System.Data.ParameterDirection.Output; nSQLErrCode.Value = 0; var sSQLErrMessage = new SqlParameter("@out_sSQLErrMessage", System.Data.SqlDbType.VarChar); sSQLErrMessage.Direction = System.Data.ParameterDirection.Output; sSQLErrMessage.Size = 500; sSQLErrMessage.Value = ""; #endregion Output Param using (db = new PetaPoco.Database(i_sConnectionString, "System.Data.SqlClient") { EnableAutoSelect = false }) { using (var scope = db.GetTransaction()) { res = db.Fetch <MCQDTO>("exec st_MCQ_UsrStatusSave @UserInfoID,@MCQStatus,@MCQPerioEndDate " + ",@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT", new { UserInfoID = i_objMCQDTO.UserInfoID, MCQStatus = i_objMCQDTO.MCQStatus, MCQPerioEndDate = i_objMCQDTO.MCQPerioEndDate, out_nReturnValue = nReturnValue, out_nSQLErrCode = nSQLErrCode, out_sSQLErrMessage = sSQLErrMessage }).ToList(); if (Convert.ToInt32(nReturnValue.Value) != 0) { #region Error Code Exception e = new Exception(); out_nReturnValue = Convert.ToInt32(nReturnValue.Value); string sReturnValue = sLookUpPrefix + out_nReturnValue; e.Data[0] = sReturnValue; if (nSQLErrCode.Value != System.DBNull.Value) { out_nSQLErrCode = Convert.ToInt32(nSQLErrCode.Value); e.Data[1] = out_nSQLErrCode; } if (sSQLErrMessage.Value != System.DBNull.Value) { out_sSQLErrMessage = Convert.ToString(sSQLErrMessage.Value); e.Data[2] = out_sSQLErrMessage; } Exception ex = new Exception(db.LastSQL.ToString(), e); throw ex; #endregion Error Code } else { scope.Complete(); return(res.FirstOrDefault()); } } } } catch (Exception exp) { throw exp; } }
public MCQDTO InsertUpdateMCQDetails(string i_sConnectionString, MCQDTO i_objMCQDTO, string Flag) { #region Paramters List <MCQDTO> res = null; string sErrCode = string.Empty; PetaPoco.Database db = null; int out_nReturnValue; int out_nSQLErrCode; string out_sSQLErrMessage; #endregion Paramters try { #region Output Param var nReturnValue = new SqlParameter("@out_nReturnValue", System.Data.SqlDbType.Int); nReturnValue.Direction = System.Data.ParameterDirection.Output; nReturnValue.Value = 0; var nSQLErrCode = new SqlParameter("@out_nSQLErrCode", System.Data.SqlDbType.Int); nSQLErrCode.Direction = System.Data.ParameterDirection.Output; nSQLErrCode.Value = 0; var sSQLErrMessage = new SqlParameter("@out_sSQLErrMessage", System.Data.SqlDbType.VarChar); sSQLErrMessage.Direction = System.Data.ParameterDirection.Output; sSQLErrMessage.Size = 500; sSQLErrMessage.Value = ""; #endregion Output Param using (db = new PetaPoco.Database(i_sConnectionString, "System.Data.SqlClient") { EnableAutoSelect = false }) { using (var scope = db.GetTransaction()) { res = db.Fetch <MCQDTO>("exec st_MCQSettingSave @MCQS_ID OUTPUT,@inp_FirstTimeLogin,@inp_IsSpecificPeriodWise,@inp_FrequencyOfMCQ,@inp_IsDatewise,@inp_FrequencyDate,@inp_FrequencyDuration" + ",@inp_BlockUserAfterDuration,@inp_NoOfQuestionForDisplay,@inp_AccessTOApplicationForWriteAnswer,@inp_NoOfAttempts,@inp_BlockuserAfterExceedAtempts,@inp_UnblockForNextFrequency,@inp_iOperation,@inp_CreatedBy" + ",@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT", new { MCQS_ID = i_objMCQDTO.MCQS_ID, inp_FirstTimeLogin = i_objMCQDTO.FirstTimeLogin, inp_IsSpecificPeriodWise = i_objMCQDTO.IsSpecificPeriodWise, inp_FrequencyOfMCQ = i_objMCQDTO.FrequencyOfMCQ, inp_IsDatewise = i_objMCQDTO.IsDatewise, inp_FrequencyDate = i_objMCQDTO.FrequencyDate, inp_FrequencyDuration = i_objMCQDTO.FrequencyDuration, inp_BlockUserAfterDuration = i_objMCQDTO.BlockUserAfterDuration, inp_NoOfQuestionForDisplay = i_objMCQDTO.NoOfQuestionForDisplay, inp_AccessTOApplicationForWriteAnswer = i_objMCQDTO.AccessTOApplicationForWriteAnswer, inp_NoOfAttempts = i_objMCQDTO.NoOfAttempts, inp_BlockuserAfterExceedAtempts = i_objMCQDTO.BlockuserAfterExceedAtempts, inp_UnblockForNextFrequency = i_objMCQDTO.UnblockForNextFrequency, inp_iOperation = Flag, inp_CreatedBy = 1, out_nReturnValue = nReturnValue, out_nSQLErrCode = nSQLErrCode, out_sSQLErrMessage = sSQLErrMessage }).ToList(); if (Convert.ToInt32(nReturnValue.Value) != 0) { #region Error Code Exception e = new Exception(); out_nReturnValue = Convert.ToInt32(nReturnValue.Value); string sReturnValue = sLookUpPrefix + out_nReturnValue; e.Data[0] = sReturnValue; if (nSQLErrCode.Value != System.DBNull.Value) { out_nSQLErrCode = Convert.ToInt32(nSQLErrCode.Value); e.Data[1] = out_nSQLErrCode; } if (sSQLErrMessage.Value != System.DBNull.Value) { out_sSQLErrMessage = Convert.ToString(sSQLErrMessage.Value); e.Data[2] = out_sSQLErrMessage; } Exception ex = new Exception(db.LastSQL.ToString(), e); throw ex; #endregion Error Code } else { scope.Complete(); return(res.FirstOrDefault()); } } } } catch (Exception exp) { throw exp; } }