public PartialViewResult Index()
{
LoginUserDetails objLoginUserDetails = null;
IEnumerable <InsiderTradingDAL.MenuMasterDTO> lstMenu = null;
Common.Common.WriteLogToFile("Start Method", System.Reflection.MethodBase.GetCurrentMethod());
try
{
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
int out_iTotalRecords = 0;
using (GenericSLImpl <InsiderTradingDAL.MenuMasterDTO> g = new GenericSLImpl <InsiderTradingDAL.MenuMasterDTO>())
{
lstMenu = g.ListAllDataTable(objLoginUserDetails.CompanyDBConnectionString, Common.ConstEnum.GridType.MenuList, 10, 1,
null, null, objLoginUserDetails.LoggedInUserID.ToString(), null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, out out_iTotalRecords, sLookUpPrefix);
//Replace the query string parameter during building of the Menu
#region ReplaceQueryStringParameters
for (int key = 0; key < lstMenu.Count(); key++)
{
if (lstMenu.ElementAt(key).MenuURL != null && lstMenu.ElementAt(key).MenuURL.Contains("{UserInfoID}"))
{
lstMenu.ElementAt(key).MenuURL = lstMenu.ElementAt(key).MenuURL.Replace("{UserInfoID}", objLoginUserDetails.LoggedInUserID.ToString());
}
}
#endregion ReplaceQueryStringParameters
}
ViewBag.Menu = lstMenu;
ViewBag.LoginUserName = objLoginUserDetails.UserName;
ViewBag.IsChangePassword = Common.Common.GetSessionValue("IsChangePassword") == null ? false : Common.Common.GetSessionValue("IsChangePassword");
Common.Common.WriteLogToFile("End Method", System.Reflection.MethodBase.GetCurrentMethod());
TempData["MenuList"] = lstMenu;
return(PartialView("_menuLayout", lstMenu));
}
catch (Exception exp)
{
Common.Common.WriteLogToFile("exception occured", System.Reflection.MethodBase.GetCurrentMethod(), exp);
return(PartialView("_menuLayout"));
}
finally
{
objLoginUserDetails = null;
}
}
public void GetLoginUserApplicableActions(string i_sConnectionString, string i_sLoginId, out List <string> o_lstActivityActions, out List <int> o_lstActivityIds)
{
int out_iTotalRecords = 0;
string sLookUpPrefix = "usr_msg_";
IEnumerable <UserActivityDTO> lstActivityList = new List <UserActivityDTO>();
//GenericSLImpl<UserActivityDTO> objGenericSLImpl = new GenericSLImpl<UserActivityDTO>();
string sAcidURLMap = "";
try
{
o_lstActivityActions = new List <string>();
o_lstActivityIds = new List <int>();
using (var objGenericSLImpl = new GenericSLImpl <UserActivityDTO>())
{
lstActivityList = objGenericSLImpl.ListAllDataTable(i_sConnectionString, ConstEnum.GridType.ActivityList, 0, 1,
null, null, i_sLoginId, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null, null, null, out out_iTotalRecords, sLookUpPrefix);
}
foreach (UserActivityDTO objUserActivityDTO in lstActivityList)
{
o_lstActivityIds.Add(objUserActivityDTO.ActivityId);
if (objUserActivityDTO.ControllerName != null)
{
string actionName = string.Empty;
if (!string.IsNullOrEmpty(objUserActivityDTO.ActionName))
{
actionName = objUserActivityDTO.ActionName.ToLower();
}
sAcidURLMap = objUserActivityDTO.ActivityId + "_" + objUserActivityDTO.ControllerName.ToLower() + "_" + actionName + ((objUserActivityDTO.ActionButtonName != null && objUserActivityDTO.ActionButtonName != "") ? "_" + objUserActivityDTO.ActionButtonName.ToLower() : "");
o_lstActivityActions.Add(sAcidURLMap);
sAcidURLMap = "";
}
}
o_lstActivityIds = o_lstActivityIds.Distinct().ToList();
}
catch (Exception exp)
{
throw exp;
}
}
/// <summary>
/// This function will return the header data seen on the Initial Disclosure Employee report.
/// </summary>
public IEnumerable <ReportHeaderKeyValueDTO> FetchReportHeaderKeyValueDetails(string i_sConnectionString, int i_nGridType, string[] i_sParamArr)
{
//GenericSLImpl<ReportHeaderKeyValueDTO> objGenericSLImpl = new GenericSLImpl<ReportHeaderKeyValueDTO>();
IEnumerable <ReportHeaderKeyValueDTO> lstCRUserList = new List <ReportHeaderKeyValueDTO>();
int out_iTotalRecords = 0;
try
{
using (var objGenericSLImpl = new GenericSLImpl <ReportHeaderKeyValueDTO>())
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(i_sConnectionString, i_nGridType, 0, 1,
"", "ASC", out out_iTotalRecords, "rpt_grd_", i_sParamArr[0], i_sParamArr[1], i_sParamArr[2], i_sParamArr[3], i_sParamArr[4], i_sParamArr[5],
i_sParamArr[6], i_sParamArr[7], i_sParamArr[8], i_sParamArr[9], i_sParamArr[10], i_sParamArr[11], i_sParamArr[12], i_sParamArr[13], i_sParamArr[14],
i_sParamArr[15], i_sParamArr[16], i_sParamArr[17], i_sParamArr[18], i_sParamArr[19]);
}
}
catch (Exception exp)
{
}
return(lstCRUserList);
}
/// <summary>
/// This function will fetch the data with the filters applied and then add the data to the excel file.
/// </summary>
/// <param name="i_Search"></param>
public void AddTableinSheet(string i_Search)
{
IEnumerable <Object> lstCRUserList = new List <Object>();
//GenericSLImpl<Object> objGenericSLImpl = new GenericSLImpl<Object>();
int out_iTotalRecords = 0;
String sLookUpPrefix = "";
int nCellCounter = 1;
if (i_Search == null)
{
i_Search = "";
}
String[] arr = new string[21];
String[] recArr = i_Search.Split(new string[] { "|_|" }, StringSplitOptions.None);
for (int i = 0; i <= arr.Length - 1; i++)
{
if (i < recArr.Length)
{
if (recArr[i] == "" || recArr[i] == "0")
{
arr[i] = null;
}
else
{
arr[i] = recArr[i];
}
}
else
{
arr[i] = null;
}
}
try
{
//Query to Grid
using (var objGenericSLImpl = new GenericSLImpl <Object>())
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(m_objLoginUserDetails.CompanyDBConnectionString, m_nGridType, -1, 1,
"", "", out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19]);
}
foreach (dynamic objUserList in lstCRUserList)
{
m_nRowCount++;
m_objCommonOpenXMLObject.CreateNewRow(m_nRowCount);
nCellCounter = 1;
IDictionary <string, object> resultList = (IDictionary <string, object>)objUserList;
foreach (string sColumnToShow in m_lstToShowColumnHeadingsForDateColumnSequence)
{
if (resultList.ContainsKey(sColumnToShow))
{
if (nCellCounter == 1 && m_nGridType == ConstEnum.GridType.Report_Defaulter && Convert.ToString(resultList[sColumnToShow]) == "1")
{
m_objCommonOpenXMLObject.CreateTextCell(m_sExcelColumnNames[nCellCounter], "ž", m_nRowCount,
(int)InsiderTradingExcelWriter.ExcelFacade.ConstantEnum.OpenXMLStyleIndex.TEXT_PLANE_BACKGROUND_WINGDINGS_FONT_ORANGE);
}
else
{
m_objCommonOpenXMLObject.CreateTextCell(m_sExcelColumnNames[nCellCounter], Convert.ToString(resultList[sColumnToShow]), m_nRowCount,
(int)InsiderTradingExcelWriter.ExcelFacade.ConstantEnum.OpenXMLStyleIndex.ARIAL_NARROW_10_TEXT_PLAIN_BACKGROUND_NORMAL_WITH_BORDERS);
}
nCellCounter++;
}
}
m_objCommonOpenXMLObject.AddToSheetData();
}
lstCRUserList = null;
m_lstToShowColumnHeadingsForDateColumnSequence = null;
}
catch (Exception exp)
{
}
}
public ActionResult AjaxHandler(String gridtype, String inp_sParam = "", String isInsider = "", int acid = 0, String ClearSearchFilter = "")
{
if (ClearSearchFilter == "True")
{
TempData.Remove("SearchArray");
JsonResult returnJson = Json(new
{
status = false
}, JsonRequestBehavior.AllowGet);
return(returnJson);
}
int out_iTotalRecords = 0;
String sLookUpPrefix = "";
LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
IEnumerable <Object> lstCRUserList = new List <Object>();
// Change the received generic object to <key, value> pair as per required for datatable.
List <Dictionary <string, Object> > lstUserList = new List <Dictionary <string, Object> >();
Common.Common objCommon = new Common.Common();
try
{
if (!objCommon.ValidateCSRFForAJAX())
{
return(RedirectToAction("Unauthorised", "Home"));
}
//Fetch Search parameters
String sSearch = Request.Form["Search"];
String[] arr = new string[51];
arr = sSearch.Split(new string[] { "|#|" }, StringSplitOptions.None);
for (int i = 0; i <= arr.Length - 1; i++)
{
if (arr[i] == "" || arr[i] == "0")
{
arr[i] = null;
}
}
if (!IsNullOrEmpty(arr) &&
(gridtype == InsiderTrading.Common.ConstEnum.GridType.ContinuousDisclosureListForCO.ToString() ||
gridtype == InsiderTrading.Common.ConstEnum.GridType.ContinousDisclosureStatusList.ToString() ||
gridtype == InsiderTrading.Common.ConstEnum.GridType.Report_ContinuousReportEmployeeWise.ToString() ||
gridtype == InsiderTrading.Common.ConstEnum.GridType.Report_InitialDisclosureEmployeeWise.ToString() ||
gridtype == InsiderTrading.Common.ConstEnum.GridType.InitialDisclosureListForCO.ToString() ||
gridtype == InsiderTrading.Common.ConstEnum.GridType.COUserList.ToString() ||
gridtype == InsiderTrading.Common.ConstEnum.GridType.EmployeeUserList.ToString() ||
(gridtype == InsiderTrading.Common.ConstEnum.GridType.RestrictedList.ToString() && arr[8] != "History")))
{
TempData["SearchArray"] = arr;
TempData.Keep("SearchArray");
}
if (!IsNullOrEmpty(arr) && (gridtype == InsiderTrading.Common.ConstEnum.GridType.Report_ContinuousReportEmployeeIndividual.ToString() ||
gridtype == InsiderTrading.Common.ConstEnum.GridType.Report_InitialDisclosureEmployeeIndividual.ToString()))
{
TempData["ReportSearchArray"] = arr;
TempData.Keep("ReportSearchArray");
}
//Get sort column, direction, display length and page number
String sSortCol = Request.Form["mDataProp_" + Request.Form["iSortCol_0"]];
String sSortDir = Request.Form["sSortDir_0"];
int nDisplayLength = Convert.ToInt32(Request.Form["iDisplayLength"]);
int nPage = 0;
if (nDisplayLength != 0)
{
nPage = Convert.ToInt32(Request.Form["iDisplayStart"]) / nDisplayLength + 1;
}
using (GenericSLImpl <Object> objGenericSLImpl = new GenericSLImpl <Object>())
{
//PENDING TRANSACTIONS DASHBOARD : Initial Disclosures-Insider
if (isInsider == "InitialDisInsider" && inp_sParam == "154002")
{
//nDisplayLength = 10;
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
inp_sParam, arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
//PENDING TRANSACTIONS DASHBOARD : Initial Disclosures-Insider Relative
else if (isInsider == "InitialDisInsider-Relative" && inp_sParam == "154002")
{
//nDisplayLength = 10;
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
inp_sParam, arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
"1", arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
//PENDING TRANSACTIONS DASHBOARD : Initial Disclosures-CO
else if (isInsider == "ContiDisCO" && inp_sParam == "154006")
{
//nDisplayLength = 10;
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
inp_sParam, arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
//PENDING TRANSACTIONS DASHBOARD : Continuous Disclosures-CO
else if (isInsider == "ContinouseDisCO" && inp_sParam == "114049")
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
arr[6], "153019", arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], "2", arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
//PENDING TRANSACTIONS DASHBOARD : Continuous Disclosures-Insider
else if (isInsider == "ContiDisInsider" && inp_sParam == "144001")
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
arr[6], "153019", arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], "3", arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
//PENDING TRANSACTIONS DASHBOARD : Period End Disclosures-Insider
else if (isInsider == "PeriodEndDisInsider" && inp_sParam == "154002")
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
arr[6], inp_sParam, arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
//PENDING TRANSACTIONS DASHBOARD : Period End Disclosures-Insider
else if (isInsider == "PeriodEndDisCO")
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], "1",
arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
//PENDING TRANSACTIONS DASHBOARD : Trade details-Insider
else if (isInsider == "TradeDetailsInsider" && inp_sParam == "154002")
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
inp_sParam, arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], "1", arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
//PENDING TRANSACTIONS DASHBOARD : Trade details-CO
else if (isInsider == "TradeDetailsCO" && inp_sParam == "154006")
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
inp_sParam, arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], "1", arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
//PENDING TRANSACTIONS DASHBOARD : Submission to Stock Exchange-CO
else if (isInsider == "SubToStckExCO" && inp_sParam == "154002")
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], inp_sParam, arr[19],
arr[20], arr[21], arr[22], arr[23], "1", arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
//PENDING TRANSACTIONS DASHBOARD : Pre-clearances-CO
else if (isInsider == "PreClearancesCO" && inp_sParam == "144001")
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], inp_sParam, arr[3], arr[4], arr[5],
arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
else if (isInsider == "PreClearancesCO_OS" && inp_sParam == "144001")
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], inp_sParam, arr[5],
arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
else if (isInsider == "PreClearancesCO_OS" && inp_sParam == "154002")
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
inp_sParam, arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
//Defaulter DASHBOARD : Initial, Continouse, Period End, Pre-Clearance
else if (inp_sParam == "170001" || inp_sParam == "170002" || inp_sParam == "170003" || inp_sParam == "170004")
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], arr[24], inp_sParam, arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
//Defaulter DASHBOARD : Contra Trade
else if (inp_sParam == "169007")
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], inp_sParam, arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
else
{
lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage,
sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5],
arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19],
arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29],
arr[30], arr[31], arr[32],
arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47],
arr[48], arr[49]
);
}
}
foreach (dynamic objUserList in lstCRUserList)
{
var dictionary = new Dictionary <string, Object>();
foreach (KeyValuePair <string, Object> kvp in objUserList) // enumerating over it exposes the Properties and Values as a KeyValuePair
{
dictionary.Add(kvp.Key, kvp.Value);
}
lstUserList.Add(dictionary);
dictionary = null;
}
JsonResult returnJson = Json(new
{
aaData = lstUserList,
status = true,
draw = Request.Form["draw"],
iTotalRecords = out_iTotalRecords,
iTotalDisplayRecords = out_iTotalRecords
}, JsonRequestBehavior.AllowGet);
return(returnJson);
}
catch (Exception exp)
{
lstUserList = new List <Dictionary <string, Object> >();
JsonResult returnJson = Json(new
{
aaData = lstUserList,
status = false,
draw = Request.Form["draw"],
iTotalRecords = 0,
iTotalDisplayRecords = 0
}, JsonRequestBehavior.AllowGet);
return(returnJson);
}
finally
{
lstCRUserList = null;
lstUserList = null;
}
}