public TradingWindowEventDTO SaveOtherEventDetails(string sConnectionString, TradingWindowEventDTO m_objTradingWindowEventDTO, int i_nLoggedInUserID)
{
#region Paramters
//bool bReturn = false;
int out_nReturnValue;
int out_nSQLErrCode;
string out_sSQLErrMessage;
TradingWindowEventDTO res = null;
#endregion Paramters
try
{
#region Paramter
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.Value = "";
sSQLErrMessage.Size = 1000;
#endregion Paramter
using (var db = new PetaPoco.Database(sConnectionString, "System.Data.SqlClient")
{
EnableAutoSelect = false
})
{
using (var scope = db.GetTransaction())
{
res = db.Query <TradingWindowEventDTO>("exec st_rul_TradingWindowEventOtherSave @inp_iTradingWindowEventId, @inp_sTradingWindowId, @inp_iTradingWindowEventCodeId,@inp_dtResultDeclarationDate,@inp_dtWindowCloseDate,@inp_dtWindowOpenDate ,@inp_iDaysPriorToResultDeclaration,@inp_iWindowClosesBeforeHours,@inp_iWindowClosesBeforeMinutes,@inp_iDaysPostResultDeclaration,@inp_iWindowOpensAfterHours,@inp_iWindowOpensAfterMinutes ,@inp_iTradingWindowStatusCodeId, @inp_iLoggedInUserId ,@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT",
new
{
@inp_iTradingWindowEventId = m_objTradingWindowEventDTO.TradingWindowEventId,
@inp_sTradingWindowId = m_objTradingWindowEventDTO.TradingWindowId,
@inp_iTradingWindowEventCodeId = m_objTradingWindowEventDTO.TradingWindowEventCodeId,
@inp_dtResultDeclarationDate = m_objTradingWindowEventDTO.ResultDeclarationDate,
@inp_dtWindowCloseDate = m_objTradingWindowEventDTO.WindowCloseDate,
@inp_dtWindowOpenDate = m_objTradingWindowEventDTO.WindowOpenDate,
@inp_iDaysPriorToResultDeclaration = m_objTradingWindowEventDTO.DaysPriorToResultDeclaration,
@inp_iWindowClosesBeforeHours = m_objTradingWindowEventDTO.WindowClosesBeforeHours,
@inp_iWindowClosesBeforeMinutes = m_objTradingWindowEventDTO.WindowClosesBeforeMinutes,
@inp_iDaysPostResultDeclaration = m_objTradingWindowEventDTO.DaysPostResultDeclaration,
@inp_iWindowOpensAfterHours = m_objTradingWindowEventDTO.WindowOpensAfterHours,
@inp_iWindowOpensAfterMinutes = m_objTradingWindowEventDTO.WindowOpensAfterMinutes,
@inp_iTradingWindowStatusCodeId = m_objTradingWindowEventDTO.TradingWindowStatusCodeId,
@inp_iLoggedInUserId = i_nLoggedInUserID,
@out_nReturnValue = nReturnValue,
@out_nSQLErrCode = nSQLErrCode,
@out_sSQLErrMessage = sSQLErrMessage
}).SingleOrDefault <TradingWindowEventDTO>();
#region Error Values
if (Convert.ToInt32(nReturnValue.Value) != 0)
{
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;
}
//bReturn = false;
Exception ex = new Exception(db.LastSQL.ToString(), e);
throw ex;
}
else
{
scope.Complete();
//bReturn = true;
}
#endregion Error Values
}
}
}
catch (Exception exp)
{
throw exp;
}
finally
{
}
return(res);
}
public TradingWindowEventDTO GetDetailsOtherEvent(string sConnectionString, int inp_iTradingWindowEventId)
{
#region Paramters
//bool bReturn = false;
int out_nReturnValue;
int out_nSQLErrCode;
string out_sSQLErrMessage;
TradingWindowEventDTO res = null;
#endregion Paramters
try
{
#region Out Paramter
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.Value = "";
#endregion Out Paramter
using (var db = new PetaPoco.Database(sConnectionString, "System.Data.SqlClient")
{
EnableAutoSelect = false
})
{
using (var scope = db.GetTransaction())
{
res = db.Query <TradingWindowEventDTO>("exec st_rul_TradingWindowEventOtherDetails @inp_iTradingWindowEventId,@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT",
new
{
@inp_iTradingWindowEventId = inp_iTradingWindowEventId,
@out_nReturnValue = nReturnValue,
@out_nSQLErrCode = nSQLErrCode,
@out_sSQLErrMessage = sSQLErrMessage
}).FirstOrDefault <TradingWindowEventDTO>();
#region Error Values
if (Convert.ToInt32(nReturnValue.Value) != 0)
{
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;
}
//bReturn = false;
Exception ex = new Exception(db.LastSQL.ToString(), e);
throw ex;
}
else
{
scope.Complete();
//bReturn = true;
}
#endregion Error Values
}
}
}
catch (Exception exp)
{
throw exp;
}
finally
{
}
return(res);
}
