public ActivityDTO SaveDetails(ActivityDTO m_objActivityDTO, string sConnectionString, int nLoggedInUserId) { #region Paramters int out_nReturnValue; int out_nSQLErrCode; string out_sSQLErrMessage; #endregion Paramters try { #region Out Paramter var nout_nReturnValue = new SqlParameter("@out_nReturnValue", System.Data.SqlDbType.Int); nout_nReturnValue.Direction = System.Data.ParameterDirection.Output; nout_nReturnValue.Value = 0; var nout_nSQLErrCode = new SqlParameter("@out_nSQLErrCode", System.Data.SqlDbType.Int); nout_nSQLErrCode.Direction = System.Data.ParameterDirection.Output; nout_nSQLErrCode.Value = 0; var sout_sSQLErrMessage = new SqlParameter("@out_sSQLErrMessage", System.Data.SqlDbType.NVarChar); sout_sSQLErrMessage.Direction = System.Data.ParameterDirection.Output; sout_sSQLErrMessage.Value = string.Empty; #endregion Out Paramter using (var db = new PetaPoco.Database(sConnectionString, "System.Data.SqlClient") { EnableAutoSelect = false }) { var res = db.Query <ActivityDTO>("exec st_usr_ActivitySave @inp_iActivityID,@inp_sScreenName,@inp_sActivityName,@inp_iModuleCodeID,@inp_sControlName,@inp_sDescription,@inp_iStatusCodeID,@inp_nUserInfoId,@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT", new { @inp_iActivityID = m_objActivityDTO.ActivityID, @inp_sScreenName = m_objActivityDTO.ScreenName, @inp_sActivityName = m_objActivityDTO.ActivityName, @inp_iModuleCodeID = m_objActivityDTO.ModuleCodeID, @inp_sControlName = m_objActivityDTO.ControlName, @inp_sDescription = m_objActivityDTO.Description, @inp_iStatusCodeID = m_objActivityDTO.StatusCodeID, @inp_nUserInfoId = nLoggedInUserId, out_nReturnValue = nout_nReturnValue, out_nSQLErrCode = nout_nSQLErrCode, out_sSQLErrMessage = sout_sSQLErrMessage, }).Single <ActivityDTO>(); #region Error Values if (Convert.ToInt32(nout_nReturnValue.Value) != 0) { Exception e = new Exception(); out_nReturnValue = Convert.ToInt32(nout_nReturnValue.Value); e.Data[0] = out_nReturnValue; if (nout_nSQLErrCode.Value != System.DBNull.Value) { out_nSQLErrCode = Convert.ToInt32(nout_nSQLErrCode.Value); e.Data[1] = out_nSQLErrCode; } if (sout_sSQLErrMessage.Value != System.DBNull.Value) { out_sSQLErrMessage = Convert.ToString(sout_sSQLErrMessage.Value); e.Data[2] = out_sSQLErrMessage; } Exception ex = new Exception(db.LastCommand.ToString(), e); throw ex; } else { return(res); } #endregion Error Values } } catch (Exception exp) { throw exp; } finally { } }
public bool Delete(ActivityDTO m_objActivityDTO, string sConnectionString, int nLoggedInUserId) { #region Paramters int out_nReturnValue; int out_nSQLErrCode; string out_sSQLErrMessage; bool bReturn = true; #endregion Paramters try { #region Out Paramter var nout_nReturnValue = new SqlParameter("@out_nReturnValue", System.Data.SqlDbType.Int); nout_nReturnValue.Direction = System.Data.ParameterDirection.Output; nout_nReturnValue.Value = 0; var nout_nSQLErrCode = new SqlParameter("@out_nSQLErrCode", System.Data.SqlDbType.Int); nout_nSQLErrCode.Direction = System.Data.ParameterDirection.Output; nout_nSQLErrCode.Value = 0; var sout_sSQLErrMessage = new SqlParameter("@out_sSQLErrMessage", System.Data.SqlDbType.NVarChar); sout_sSQLErrMessage.Direction = System.Data.ParameterDirection.Output; sout_sSQLErrMessage.Value = string.Empty; #endregion Out Paramter using (var db = new PetaPoco.Database(sConnectionString, "System.Data.SqlClient") { EnableAutoSelect = false }) { var res = db.Query <ActivityDTO>("exec st_usr_ActivityDelete @inp_iActivityID,@inp_nUserInfoId,@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT", new { @inp_iActivityID = m_objActivityDTO.ActivityID, @inp_nUserInfoId = nLoggedInUserId, //@out_nReturnValue = nReturnValue, //@out_nSQLErrCode = nSQLErrCode, //@out_sSQLErrMessage = sSQLErrMessage }); #region Error Values if (Convert.ToInt32(nout_nReturnValue.Value) != 0) { Exception e = new Exception(); out_nReturnValue = Convert.ToInt32(nout_nReturnValue.Value); e.Data[0] = out_nReturnValue; if (nout_nSQLErrCode.Value != System.DBNull.Value) { out_nSQLErrCode = Convert.ToInt32(nout_nSQLErrCode.Value); e.Data[1] = out_nSQLErrCode; } if (sout_sSQLErrMessage.Value != System.DBNull.Value) { out_sSQLErrMessage = Convert.ToString(sout_sSQLErrMessage.Value); e.Data[2] = out_sSQLErrMessage; } bReturn = false; Exception ex = new Exception(db.LastCommand.ToString(), e); throw ex; } else { bReturn = true; } #endregion Error Values } } catch (Exception exp) { throw exp; } finally { } return(bReturn); }