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