public List<sp_BankReconciliationResult> GetBankReconciliationData(int ps_AllLocation, string ps_Location, int ps_AllDate, string ps_DateFrom, string ps_DateTo) { string UserLoginId = ""; string[] LocationsIds; try { SECURITY_User _User = (SECURITY_User)System.Web.HttpContext.Current.Session["user"]; UserLoginId = _User.User_Id; List<sp_GetUserLocationsByUserIdResult> UserLocations = new DALUserMenuRights().GetUserLocationsByUserId(UserLoginId).ToList(); if (UserLocations != null && UserLocations.Count > 0) { UserLocations = UserLocations.Where(c => c.SelectedLocation != "0").ToList(); } LocationsIds = UserLocations.Select(c => c.Loc_Id).ToArray(); SCMSDataContext dbSCMS = Connection.Create(); return dbSCMS.sp_BankReconciliation(ps_AllLocation, ps_Location, ps_AllDate, ps_DateFrom, ps_DateTo).ToList().Where(c => LocationsIds.Contains(c.Loc_Id)).ToList(); } catch { return null; } }
public string GetUserLocations(string GroupId, string UserId) { List<sp_GetUserLocationsByUserIdResult> UserLocations = new DALUserMenuRights().GetUserLocationsByUserId(UserId).ToList(); string response = ""; response += "<table id='LocationGrid' class='display' style='width: 100%; padding: 2px;'>"; response += "<thead>"; response += "<tr class='odd gradeX' style='line-height: 15px; cursor: pointer; text-align: left;"; response += "background-color: #ccc;'>"; response += "<th style='vertical-align: middle; width: 90%; padding-left: 3px;'>"; response += "Location"; response += "</th>"; response += "<th style='vertical-align: middle; width: 10%;'>"; response += "Is Allowed"; response += "</th>"; response += "</tr>"; response += "</thead>"; response += "<tbody>"; foreach (SCMSDataLayer.DB.sp_GetUserLocationsByUserIdResult location in UserLocations) { response += " <tr class='odd gradeX' style='line-height: 15px; cursor: pointer;'>"; response += "<td style='vertical-align: middle; width: 25%;'>"; response += location.Loc_Title; response += "</td>"; response += "<td style='vertical-align: middle;'>"; response += "<input type='checkbox' class='allowedloc' id='" + location.Loc_Id + "' "; response += location.SelectedLocation == "0" ? "" : "checked='checked'" + "/>"; response += "</td>"; response += "</tr>"; } response += "</tbody>"; response += "</table>"; return response; }
public string GetUserChartOfAccounts(string GroupId, string UserId) { List<sp_GetUserChartOfAccountByUserIdResult> UserChartOfAccounts = new DALUserMenuRights().GetUserChartOfAccountByUserId(UserId).ToList(); string response = ""; response += "<table id='ChartOfAccountGrid' class='display' style='width: 100%; padding: 2px;'>"; response += "<thead>"; response += "<tr class='odd gradeX' style='line-height: 15px; cursor: pointer; text-align: left;"; response += "background-color: #ccc;'>"; response += "<th style='vertical-align: middle; width: 25%; padding-left: 3px;'>"; response += " Code"; response += "</th>"; response += "<th style='vertical-align: middle; width: 25%; padding-left: 3px;'>"; response += " Chart Of Account"; response += "</th>"; response += "<th style='vertical-align: middle; width: 25%; padding-left: 3px;'>"; response += " Type"; response += "</th>"; response += "<th style='vertical-align: middle; width: 25%;'>"; response += "<input type='checkbox' id='chk_AllCOA' onclick='SelectAllCOA(this);' style='margin-bottom:5px;margin-right:1px;margin-left:4px;' /> Is Allowed"; response += "</th>"; response += "</tr>"; response += "</thead>"; response += "<tbody>"; foreach (SCMSDataLayer.DB.sp_GetUserChartOfAccountByUserIdResult coa in UserChartOfAccounts) { response += " <tr class='odd gradeX' style='line-height: 15px; cursor: pointer; " + (coa.ChrtAcc_Type == 1 ? "font-weight:bold" : "") + "'>"; response += "<td style='vertical-align: middle; width: 25%;'>"; response += coa.ChrtAcc_CodeDisplay; response += "</td>"; response += "<td style='vertical-align: middle; width: 25%;'>"; response += coa.ChrtAcc_Title; response += "</td>"; response += "<td style='vertical-align: middle; width: 25%;'>"; response += coa.ChrtAcc_Type == 1 ? "Group" : "Detail"; response += "</td>"; response += "<td style='vertical-align: middle;'>"; response += "<input type='checkbox' class='allowedCOA' id='" + coa.ChrtAcc_Id + "' value='' "; response += (coa.SelectedChartOfAccount == "0" ? "" : "checked='checked'") + "/>"; response += "</td>"; response += "</tr>"; } response += "</tbody>"; response += "</table>"; return response; }
/// <summary> /// Use GetAllData Method To Get Voucher Types With Security /// </summary> /// <returns></returns> public List<sp_GetVoucherTypesListResult> GetAllData() { try { SECURITY_User user = (SECURITY_User)System.Web.HttpContext.Current.Session["user"]; string UserLoginId = user.User_Id; string UserGroupId = user.UsrGrp_Id; List<sp_GetUserVoucherTypesByUserIdResult> UserVoucherTypes = new DALUserMenuRights().GetUserVoucherTypesByUserId(UserLoginId).ToList(); if (UserVoucherTypes != null && UserVoucherTypes.Count > 0) { UserVoucherTypes = UserVoucherTypes.Where(c => c.SelectedVoucherType != "0").ToList(); } string[] VoucherTypeIds = UserVoucherTypes.Select(c => c.VchrType_Id).ToArray(); SCMSDataContext dbSCMS = Connection.Create(); return dbSCMS.sp_GetVoucherTypesList().ToList().Where(c => VoucherTypeIds.Contains(c.VchrType_Id)).ToList(); } catch { return null; } }
/// <summary> /// This function is used to retreive data in Budget entry console /// </summary> /// <param name="ps_AllLocation"></param> /// <param name="ps_Location"></param> /// <param name="ps_AllBudgetType"></param> /// <param name="ps_BudgetType"></param> /// <param name="ps_AllDate"></param> /// <param name="ps_DateFrom"></param> /// <param name="ps_DateTo"></param> /// <param name="ps_IncludeSecurity"></param> /// <returns></returns> public List<sp_BudgetConsoleResult> GetBudgetEntryConsoleData(int pi_AllLocation, string ps_Location) { try { SECURITY_User user = (SECURITY_User)System.Web.HttpContext.Current.Session["user"]; string UserLoginId = user.User_Id; string UserGroupId = user.UsrGrp_Id; string[] LocationsIds; SCMSDataContext dbSCMS = Connection.Create(); if (pi_AllLocation == 1) { List<sp_GetUserLocationsByUserIdResult> UserLocations = new DALUserMenuRights().GetUserLocationsByUserId(UserLoginId).ToList(); if (UserLocations != null && UserLocations.Count > 0) { UserLocations = UserLocations.Where(c => c.SelectedLocation != "0").ToList(); } LocationsIds = UserLocations.Select(c => c.Loc_Id).ToArray(); } else { LocationsIds = new string[1]; LocationsIds[0] = ps_Location; } //return dbSCMS.sp_BudgetConsole(ps_AllLocation, ps_Location).ToList().Where(c => LocationsIds.Contains(c.Loc_Id) && _Status.Contains(c.BgdtMas_Status)).ToList(); return dbSCMS.sp_BudgetConsole().ToList().Where(c => LocationsIds.Contains(c.Loc_Id)).ToList(); } catch (Exception ex) { return null; } }
public string SetUserVoucherTypes(string GroupId, string UserId, bool isGroup, string UserVoucherTypes) { try { string[] UserVoucherTypeIds = UserVoucherTypes.Split(','); DALUserMenuRights objUserMenuRights = new DALUserMenuRights(); int Success = objUserMenuRights.DeleteVoucherTypesByGroupId(GroupId, UserId); if (Success >= 0) { foreach (string userVoucherTypeId in UserVoucherTypeIds) { Security_UserVoucherType userVoucherTypeRow = new Security_UserVoucherType(); userVoucherTypeRow.UserGrp_Id = GroupId.ToString(); if (UserId != null) { userVoucherTypeRow.User_Id = UserId.ToString(); } userVoucherTypeRow.VchrType_Id = userVoucherTypeId; objUserMenuRights.SetUserVoucherTypes(userVoucherTypeRow); } } return "1"; } catch { return "0"; } }
public string SetUserLocations(string GroupId, string UserId, bool isGroup, string UserLocations) { try { string[] UserLocationIds = UserLocations.Split(','); DALUserMenuRights objUserMenuRights = new DALUserMenuRights(); int Success = objUserMenuRights.DeleteLocationsByGroupId(GroupId, UserId); if (Success >= 0) { foreach (string userLocationId in UserLocationIds) { Security_UserLocation userLocationRow = new Security_UserLocation(); userLocationRow.UsrGrp_Id = GroupId.ToString(); if (UserId != null) { userLocationRow.User_Id = UserId.ToString(); } userLocationRow.Loc_Id = userLocationId; objUserMenuRights.SetUserLocations(userLocationRow); } } return "1"; } catch { return "0"; } }
public string SetUserChartOfAccount(String GroupId, String UserId, Boolean isGroup, String UserChartOfAccounts) { try { //string GroupId = ""; //string UserId = ""; //bool isGroup = false; //string UserChartOfAccounts = ""; string[] UserChartOfAccountIds = UserChartOfAccounts.Split(','); DALUserMenuRights objUserMenuRights = new DALUserMenuRights(); int Success = objUserMenuRights.DeleteChartOfAccountsByGroupId(GroupId, UserId); if (Success >= 0) { foreach (string userChartOfAccountId in UserChartOfAccountIds) { Security_UserChartOfAccount userChartOfAccountRow = new Security_UserChartOfAccount(); userChartOfAccountRow.UserGrp_Id = GroupId.ToString(); if (UserId != null) { userChartOfAccountRow.User_Id = UserId.ToString(); } userChartOfAccountRow.ChrtAcc_Id = userChartOfAccountId; objUserMenuRights.SetUserChartOfAccount(userChartOfAccountRow); } } return "1"; } catch { return "0"; } }
public string SaveUserRights(int GroupId, int? UserId, bool isGroup, string UserMenus) { try { string[] UserMenuIds = UserMenus.Split(','); DALUserMenuRights objUserMenuRights = new DALUserMenuRights(); int Success = objUserMenuRights.DeleteRecordByGroupId(GroupId, UserId, SystemParameters.ModuleId); if (Success >= 0) { foreach (string userMenuId in UserMenuIds) { Security_UserRight userRightRow = new Security_UserRight(); string Code = ""; if (DALCommon.AutoCodeGeneration("Security_UserRights") == 1) { Code = DALCommon.GetMaximumCode("Security_UserRights"); } userRightRow.UsrSec_Code = Code; userRightRow.Grp_Id = GroupId; if (UserId != null) { userRightRow.UsrSec_UserId = UserId.ToString(); } string[] cols = userMenuId.Split('~'); userRightRow.Mnu_Id = Convert.ToInt32(cols[0]); userRightRow.UsrSec_Add = Convert.ToBoolean(cols[1]); userRightRow.UsrSec_Edit = Convert.ToBoolean(cols[2]); userRightRow.UsrSec_Delete = Convert.ToBoolean(cols[3]); userRightRow.UsrSec_Print = Convert.ToBoolean(cols[4]); userRightRow.UsrSec_Import = Convert.ToBoolean(cols[5]); userRightRow.Mod_Id = SystemParameters.ModuleId; objUserMenuRights.SaveRecord(userRightRow); } } return "1"; } catch { return "0"; } }
// // GET: /UserRightsSetup/ public ActionResult Index() { List<sp_GetUserGroupListResult> userGroups = new DALUserGroup().GetAllData().ToList(); ViewData["ddl_UserGroups"] = new SelectList(userGroups, "UsrGrp_Id", "UsrGrp_Title"); List<sp_GetUserMenuRightsResult> MenuRights = new DALUserMenuRights().GetUserMenuRights("").Where(c => c.Mod_Id == SystemParameters.ModuleId && c.Mnu_Level != "0").ToList(); List<sp_GetUserLocationsByGroupIdResult> UserLocations = new DALUserMenuRights().GetUserLocationsByGroupId("").ToList(); List<sp_GetUserVoucherTypesByGroupIdResult> UserVouchers = new DALUserMenuRights().GetUserVoucherTypesByGroupId("").ToList(); List<sp_GetUserChartOfAccountByGroupIdResult> UserChartOfAccounts = new DALUserMenuRights().GetUserChartOfAccountByGroupId("").ToList(); List<sp_GetUserListResult> Users = new DALUser().GetAllData().ToList(); ViewData["UserMenuRights"] = MenuRights; ViewData["UserLocations"] = UserLocations; ViewData["UserVoucherTypes"] = UserVouchers; ViewData["UserChartOfAccount"] = UserChartOfAccounts; ViewData["AllUsers"] = Users; return View("UserRights"); }
public string GetUserMenus(string GroupId, string UserId) { List<sp_GetUserMenuRightsByUserIdResult> MenuRights = new DALUserMenuRights().GetUserMenuRightsByUserId(Convert.ToInt32(UserId).ToString()).Where(c => c.Mod_Id == SystemParameters.ModuleId && c.Mnu_Level != "0").ToList(); string response = ""; response += "<table id='MenuGrid' class='display' style='width: 100%; padding: 2px;'>"; response += "<thead>"; response += "<tr class='odd gradeX' style='line-height: 15px; cursor: pointer; text-align: left;"; response += "background-color: #ccc;'>"; response += "<th style='vertical-align: middle; width: 30%; padding-left: 3px;'>"; response += "Menu Description"; response += "</th>"; response += "<th style='vertical-align: middle; width: 10%;'>"; response += "Is Allowed"; response += "</th>"; response += "<th style='vertical-align: middle; width: 10%;'>"; response += "Can Add"; response += "</th>"; response += "<th style='vertical-align: middle; width: 10%;'>"; response += "Can Edit"; response += "</th>"; response += "<th style='vertical-align: middle; width: 10%;'>"; response += "Can Delete"; response += "</th>"; response += "<th style='vertical-align: middle; width: 10%;'>"; response += "Can Print"; response += "</th>"; response += "<th style='vertical-align: middle; width: 10%;'>"; response += "Can Import"; response += "</th>"; response += "</tr>"; response += "</thead>"; response += "<tbody>"; int count = 0; foreach (SCMSDataLayer.DB.sp_GetUserMenuRightsByUserIdResult menuRight in MenuRights) { count++; string node = menuRight.Mnu_Level.Contains(".") ? "Child" : "Parent"; response += "<tr class='odd gradeX' style='line-height: 15px; cursor: pointer;'>"; if (node == "Parent") { response += "<th style='vertical-align: middle; text-align: left; padding-left: 3px;'>"; response += menuRight.Mnu_Description; response += "</th>"; } else { response += "<td style='vertical-align: middle; padding-left: 50px;'>"; response += menuRight.Mnu_Description; response += "</td>"; } response += "<td style='vertical-align: middle;'>"; response += "<input type='checkbox' class='allowed' value='ChkDesc" + menuRight.Mnu_Level + "' id='ChkDesc" + menuRight.Mnu_Id + "'"; response += menuRight.SelectedMenu == 0 ? "" : "checked='checked'" + "/>"; response += "</td>"; if (menuRight.Mnu_Level == "3" || menuRight.Mnu_Level.Contains("3.")) { response += "<td></td>"; response += "<td></td>"; response += "<td></td>"; response += "<td></td>"; response += "<td></td>"; } else { response += "<td style='vertical-align: middle;'>"; response += "<input type='checkbox' class='add' value='ChkAdd" + menuRight.Mnu_Level + "' id='ChkAdd" + menuRight.Mnu_Id + "'"; response += menuRight.CanAdd == false ? "" : "checked='checked'" + "/>"; response += "</td>"; response += "<td style='vertical-align: middle;'>"; response += "<input type='checkbox' class='edit' value='ChkEdit" + menuRight.Mnu_Level + "' id='ChkEdit" + menuRight.Mnu_Id + "'"; response += menuRight.CanEdit == false ? "" : "checked='checked'" + "/>"; response += "</td>"; response += "<td style='vertical-align: middle;'>"; response += "<input type='checkbox' class='delete' value='ChkDelete" + menuRight.Mnu_Level + "'"; response += "id='ChkDelete" + menuRight.Mnu_Id + "'"; response += menuRight.CanDelete == false ? "" : "checked='checked'" + "/>"; response += "</td>"; response += "<td style='vertical-align: middle;'>"; response += "<input type='checkbox' class='print' value='ChkPrint" + menuRight.Mnu_Level + "' id='ChkPrint" + menuRight.Mnu_Id + "'"; response += menuRight.CanPrint == false ? "" : "checked='checked'" + "/>"; response += "</td>"; response += "<td style='vertical-align: middle;'>"; response += "<input type='checkbox' class='import' value='ChkImport" + menuRight.Mnu_Level + "'"; response += "id='ChkImport" + menuRight.Mnu_Id + "'"; response += menuRight.CanImport == false ? "" : "checked='checked'" + "/>"; response += "</td>"; } response += "</tr>"; } response += "</tbody>"; response += "</table>"; return response; }
// Use for the drop downs to implement Security public List<sp_PopulateLocationListResult> PopulateData() { try { SECURITY_User user = (SECURITY_User)System.Web.HttpContext.Current.Session["user"]; string UserLoginId = user.User_Id; string UserGroupId = user.UsrGrp_Id; List<sp_GetUserLocationsByUserIdResult> UserLocations = new DALUserMenuRights().GetUserLocationsByUserId(UserLoginId).ToList(); if (UserLocations != null && UserLocations.Count > 0) { UserLocations = UserLocations.Where(c => c.SelectedLocation != "0").ToList(); } string[] LocationsIds = UserLocations.Select(c => c.Loc_Id).ToArray(); SCMSDataContext dbSCMS = Connection.Create(); return dbSCMS.sp_PopulateLocationList().ToList().Where(c => LocationsIds.Contains(c.Loc_Id)).ToList(); } catch { return null; } }
/// <summary> /// This function is used to retreive data in voucher entry console /// </summary> /// <param name="ps_AllLocation"></param> /// <param name="ps_Location"></param> /// <param name="ps_AllVoucherType"></param> /// <param name="ps_VoucherType"></param> /// <param name="ps_AllDate"></param> /// <param name="ps_DateFrom"></param> /// <param name="ps_DateTo"></param> /// <param name="ps_IncludeSecurity"></param> /// <returns></returns> public List<sp_VoucherEntryConsoleResult> GetVoucherEntryConsoleData(int ps_AllLocation, string ps_Location, int ps_AllVoucherType, string ps_VoucherType, int ps_AllDate, string ps_DateFrom, string ps_DateTo, bool ps_IncludeSecurity) { try { SECURITY_User user = (SECURITY_User)System.Web.HttpContext.Current.Session["user"]; string UserLoginId = user.User_Id; string UserGroupId = user.UsrGrp_Id; string _Status = "Pending"; List<sp_GetUserVoucherTypesByUserIdResult> UserVoucherTypes = new DALUserMenuRights().GetUserVoucherTypesByUserId(UserLoginId).ToList(); if (UserVoucherTypes != null && UserVoucherTypes.Count > 0) { UserVoucherTypes = UserVoucherTypes.Where(c => c.SelectedVoucherType != "0").ToList(); } string[] VoucherTypeIds = UserVoucherTypes.Select(c => c.VchrType_Id).ToArray(); List<sp_GetUserLocationsByUserIdResult> UserLocations = new DALUserMenuRights().GetUserLocationsByUserId(UserLoginId).ToList(); if (UserLocations != null && UserLocations.Count > 0) { UserLocations = UserLocations.Where(c => c.SelectedLocation != "0").ToList(); } string[] LocationsIds = UserLocations.Select(c => c.Loc_Id).ToArray(); SCMSDataContext dbSCMS = Connection.Create(); if (ps_IncludeSecurity == true) { //return dbSCMS.sp_VoucherEntryConsole(ps_AllLocation, ps_Location, ps_AllVoucherType, ps_VoucherType, ps_AllDate, ps_DateFrom, ps_DateTo).ToList().Where(c => VoucherTypeIds.Contains(c.VchrType_Id) && LocationsIds.Contains(c.Loc_Id) && _Status.Contains (c.VchMas_Status) ).ToList(); return dbSCMS.sp_VoucherEntryConsole(ps_AllLocation, ps_Location, ps_AllVoucherType, ps_VoucherType, ps_AllDate, ps_DateFrom, ps_DateTo).ToList().Where(c => VoucherTypeIds.Contains(c.VchrType_Id) && LocationsIds.Contains(c.Loc_Id) ).ToList(); } else { return dbSCMS.sp_VoucherEntryConsole(ps_AllLocation, ps_Location, ps_AllVoucherType, ps_VoucherType, ps_AllDate, ps_DateFrom, ps_DateTo).ToList(); } } catch { return null; } }
public string SetParam_BalanceSheet(string ps_ReportName, string pi_AllLoc, string ps_Location, Int32 pi_Level, Int32 pi_Year) { string ls_Location = ""; ResetParameters(); Reports.ReportParameters.ReportName = ps_ReportName; Reports.ReportParameters.Level = pi_Level; Reports.ReportParameters.Year = pi_Year; if (pi_AllLoc == "1") { SECURITY_User user = (SECURITY_User)System.Web.HttpContext.Current.Session["user"]; UserLoginId = user.User_Id; List<sp_GetUserLocationsByUserIdResult> UserLocations = new DALUserMenuRights().GetUserLocationsByUserId(UserLoginId).ToList(); if (UserLocations != null && UserLocations.Count > 0) { UserLocations = UserLocations.Where(c => c.SelectedLocation != "0").ToList(); } ls_Location = ConvertStringArrayToString(UserLocations.Select(c => c.Loc_Id).ToArray()); if (ls_Location == null || ls_Location.Trim() == "") { ls_Location = "''"; } Reports.ReportParameters.Location = ls_Location; } else { Reports.ReportParameters.Location = ps_Location; } return "OK"; }
public string SetParam_VoucherDocument(string ps_ReportName, string pi_AllLoc, string ps_Location, string pi_AllVchrType, string ps_VoucherTypes, string pi_AllDoc, string ps_DocFrom, string ps_DocTo, string pi_AllVchrStatus, string ps_VchrStatus, string pi_AllDate, DateTime pdt_DateFrom, DateTime pdt_DateTo, string ps_VoucherPrint) { string ls_Location = "", ls_VoucherTypes = ""; ResetParameters(); Reports.ReportParameters.ReportName = ps_ReportName; Reports.ReportParameters.VoucherPrint = ps_VoucherPrint; if (pi_AllLoc == "1") { SECURITY_User user = (SECURITY_User)System.Web.HttpContext.Current.Session["user"]; UserLoginId = user.User_Id; List<sp_GetUserLocationsByUserIdResult> UserLocations = new DALUserMenuRights().GetUserLocationsByUserId(UserLoginId).ToList(); if (UserLocations != null && UserLocations.Count > 0) { UserLocations = UserLocations.Where(c => c.SelectedLocation != "0").ToList(); } ls_Location = ConvertStringArrayToString(UserLocations.Select(c => c.Loc_Id).ToArray()); if (ls_Location == null || ls_Location.Trim() == "") { ls_Location = "''"; } Reports.ReportParameters.Location = ls_Location; } else { Reports.ReportParameters.Location = ps_Location; } if (pi_AllVchrType == "1") { SECURITY_User user = (SECURITY_User)System.Web.HttpContext.Current.Session["user"]; UserLoginId = user.User_Id; List<sp_GetUserVoucherTypesByUserIdResult> UserVoucherTypes = new DALUserMenuRights().GetUserVoucherTypesByUserId(UserLoginId).ToList(); if (UserVoucherTypes != null && UserVoucherTypes.Count > 0) { UserVoucherTypes = UserVoucherTypes.Where(c => c.SelectedVoucherType != "0").ToList(); } ls_VoucherTypes = ConvertStringArrayToString(UserVoucherTypes.Select(c => c.VchrType_Id).ToArray()); if (ls_VoucherTypes == null || ls_VoucherTypes.Trim() == "") { ls_VoucherTypes = "''"; } Reports.ReportParameters.VoucherTypes = ls_VoucherTypes; } else { Reports.ReportParameters.VoucherTypes = ps_VoucherTypes; } if (pi_AllDoc == "1") { Reports.ReportParameters.AllDoc = 1; Reports.ReportParameters.DocFrom = ""; Reports.ReportParameters.DocTo = ""; } else { Reports.ReportParameters.AllDoc = 0; Reports.ReportParameters.DocFrom = ps_DocFrom; Reports.ReportParameters.DocTo = ps_DocTo; } if (pi_AllVchrStatus == "1") { Reports.ReportParameters.AllVchrStatus = 1; Reports.ReportParameters.VoucherStatus = ""; } else { Reports.ReportParameters.AllVchrStatus = 0; Reports.ReportParameters.VoucherStatus = ps_VchrStatus; } if (pi_AllDate == "1") { Reports.ReportParameters.AllDate = 1; Reports.ReportParameters.DateFrom = Convert.ToDateTime("01/01/1900"); Reports.ReportParameters.DateTo = Convert.ToDateTime("01/01/1900"); } else { Reports.ReportParameters.AllDate = 0; Reports.ReportParameters.DateFrom = pdt_DateFrom; Reports.ReportParameters.DateTo = pdt_DateTo; } return "OK"; }
public string SetParam_TrialBalance(String ps_ReportName, string pi_AllLoc, String ps_Location, string pi_AllAccCode, string ps_AccCodeFrom, string ps_AccCodeTo, string pi_AllDate, DateTime pdt_DateFrom, DateTime pdt_DateTo, string ps_Level, string ps_TrialActivity) { string ls_Location = ""; ResetParameters(); Reports.ReportParameters.ReportName = ps_ReportName; Reports.ReportParameters.Level = Convert.ToInt32(ps_Level); Reports.ReportParameters.TrialActivity = ps_TrialActivity; if (pi_AllLoc == "1") { SECURITY_User user = (SECURITY_User)System.Web.HttpContext.Current.Session["user"]; UserLoginId = user.User_Id; List<sp_GetUserLocationsByUserIdResult> UserLocations = new DALUserMenuRights().GetUserLocationsByUserId(UserLoginId).ToList(); if (UserLocations != null && UserLocations.Count > 0) { UserLocations = UserLocations.Where(c => c.SelectedLocation != "0").ToList(); } ls_Location = ConvertStringArrayToString(UserLocations.Select(c => c.Loc_Id).ToArray()); if (ls_Location == null || ls_Location.Trim() == "") { ls_Location = "''"; } Reports.ReportParameters.Location = ls_Location; } else { Reports.ReportParameters.Location = ps_Location; } if (pi_AllAccCode == "1") { Reports.ReportParameters.AllAccCode = 1; Reports.ReportParameters.AccCodeFrom = ""; Reports.ReportParameters.AccCodeTo = ""; } else { Reports.ReportParameters.AllAccCode = 0; Reports.ReportParameters.AccCodeFrom = ps_AccCodeFrom; Reports.ReportParameters.AccCodeTo = ps_AccCodeTo; } if (pi_AllDate == "1") { Reports.ReportParameters.AllDate = 1; Reports.ReportParameters.DateFrom = pdt_DateFrom; Reports.ReportParameters.DateTo = pdt_DateTo; } else { Reports.ReportParameters.AllDate = 0; Reports.ReportParameters.DateFrom = pdt_DateFrom; Reports.ReportParameters.DateTo = pdt_DateTo; } return "OK"; }