public InsiderInitialDisclosureCountDTO GetDashBoardInsiderCount(string i_sConnectionString)
{
InsiderInitialDisclosureCountDTO res = null;
try
{
//InsiderInitialDisclosureDAL objInsiderInitialDisclosureDAL = new InsiderInitialDisclosureDAL();
using (var objInsiderInitialDisclosureDAL = new InsiderInitialDisclosureDAL())
{
res = objInsiderInitialDisclosureDAL.GetDashBoardInsiderCount(i_sConnectionString);
}
}
catch (Exception exp)
{
throw exp;
}
return(res);
}
public ActionResult List(int acid)
{
InsiderInitialDisclosureCountDTO objInsiderInitialDisclosureCountDTO = null;
InsiderInitialDisclosureCountModel objInsiderInitialDisclosureCountModel = null;
LoginUserDetails objLoginUserDetails = null;
try
{
objInsiderInitialDisclosureCountModel = new InsiderInitialDisclosureCountModel();
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
using (InsiderInitialDisclosureSL objInsiderInitialDisclosureSL = new InsiderInitialDisclosureSL())
{
objInsiderInitialDisclosureCountDTO = objInsiderInitialDisclosureSL.GetDashBoardInsiderCount(objLoginUserDetails.CompanyDBConnectionString);
Common.Common.CopyObjectPropertyByName(objInsiderInitialDisclosureCountDTO, objInsiderInitialDisclosureCountModel);
}
if (objLoginUserDetails.BackURL != null && objLoginUserDetails.BackURL != "")
{
ViewBag.BackButton = true;
ViewBag.BackURL = objLoginUserDetails.BackURL;
objLoginUserDetails.BackURL = "";
Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails);
}
else
{
ViewBag.BackButton = false;
}
return(View(objInsiderInitialDisclosureCountModel));
}
catch (Exception exp)
{
string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString());
ModelState.AddModelError("Error", sErrMessage);
return(View("Index"));
}
finally
{
objLoginUserDetails = null;
}
}
public InsiderInitialDisclosureCountDTO GetDashBoardInsiderCount(string sConnectionString)
{
#region Paramters
int out_nReturnValue;
int out_nSQLErrCode;
string out_sSQLErrMessage;
InsiderInitialDisclosureCountDTO 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 = "";
sSQLErrMessage.Size = 500;
#endregion Out Paramter
using (var db = new PetaPoco.Database(sConnectionString, "System.Data.SqlClient")
{
EnableAutoSelect = false
})
{
using (var scope = db.GetTransaction())
{
res = db.Query <InsiderInitialDisclosureCountDTO>("exec st_tra_InitialDisclosureDashBoardForCO @out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT",
new
{
out_nReturnValue = nReturnValue,
out_nSQLErrCode = nSQLErrCode,
out_sSQLErrMessage = sSQLErrMessage
}).FirstOrDefault <InsiderInitialDisclosureCountDTO>();
#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;
}
Exception ex = new Exception(db.LastSQL.ToString(), e);
throw ex;
}
else
{
scope.Complete();
}
#endregion Error Values
}
}
}
catch (Exception exp)
{
throw exp;
}
finally
{
}
return(res);
}
