public CustEnum.PageAccess CheckPageAccess(string RoleID, string PageID) { CustEnum.PageAccess OpResult = CustEnum.PageAccess.Error; try { Users objUsr = new Users(); DataSet dsMenu = objUsr.GetMenusForRoleID(RoleID); if (!DataUtils.IsDataSetNull(dsMenu, 0)) { List <DataRow> lst = dsMenu.Tables[0].AsEnumerable().ToList(); int count = (from r in lst where r.Field <int>("MenuID") == int.Parse(PageID) select r.Field <int>("MenuID")).SingleOrDefault <int>(); if (count == 0) { OpResult = CustEnum.PageAccess.No; } else { OpResult = CustEnum.PageAccess.Yes; } } } catch { } return(OpResult); }
protected void Page_Load(object sender, EventArgs e) { Users objUsr = new Users(); UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails(); string UserID = objUsrDet.UserID; string UserStatusID = objUsrDet.StatusID; string UserRoleID = objUsrDet.RoleID; string UserOfficeID = objUsrDet.OfficeID; if (UserID != null && UserStatusID == DbSettings.UserStatus.Active) { CustEnum.PageAccess Access = objUsr.CheckPageAccess(UserRoleID, DbSettings.Menus.CIF); if (Access == CustEnum.PageAccess.Yes) { string rr = null; string did = null; string dcn = null; try { rr = Request.QueryString["rr"]; //redirect reason did = Request.QueryString["did"]; //client id dcn = Request.QueryString["dcn"]; //client name if (rr == "s") { //gloErrHO.InnerHtml = String.Format(UiMsg.CIF.ClientAdded, "<a href='" + did + "'>" + dcn + "</a>").SuccessWrap(); gloErrHO.InnerHtml = String.Format(UiMsg.CIF.ClientAdded, "<a href='#'>" + dcn + "</a>").SuccessWrap(); } } catch { } if (!Page.IsPostBack) { { Office objOff = new Office(); DataSet dsOff = objOff.GetAllSubOfficeByTypeID(UserOfficeID, DbSettings.OfficeType.Village); StringBuilder sbrVillage = new StringBuilder(); string OffID; string OffName; sbrVillage.Append("<select id='drpVil' class='span2'>"); //sbrVillage.Append("<option id='0'>Select</option>"); foreach (DataRow dr in dsOff.Tables[0].Rows) { OffID = dr["OfficeID"].ToString(); OffName = dr["OfficeName"].ToString(); sbrVillage.Append("<option id='" + OffID + "'>" + OffName + "</option>"); } sbrVillage.Append("</select>"); uxClientVill.InnerHtml = sbrVillage.ToString(); } } } } }
protected void Page_Load(object sender, EventArgs e) { string PageID = DbSettings.Menus.LoanRepayment; Users objUsr = new Users(); UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails(); string UserID = objUsrDet.UserID; string UserStatusID = objUsrDet.StatusID; string UserRoleID = objUsrDet.RoleID; string UserOfficeID = objUsrDet.OfficeID; if (UserID != null && UserStatusID == DbSettings.UserStatus.Active) { CustEnum.PageAccess Access = objUsr.CheckPageAccess(UserRoleID, PageID); if (Access == CustEnum.PageAccess.Yes) { Office objOff = new Office(); Loans objLoan = new Loans(); DataSet dsCen = objOff.GetAllCentersForUserID(UserID); StringBuilder sbrCenter = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsCen, 0)) { sbrCenter.Append("<select class='span2' id='drpCenter'>"); sbrCenter.Append("<option value='0'>Select Center</option>"); foreach (DataRow dr in dsCen.Tables[0].Rows) { string CenterID = dr["CenterID"].ToString(); string VillageID = dr["ParentOfficeID"].ToString(); sbrCenter.Append("<option class='" + VillageID + "' value='" + CenterID + "'>Center " + CenterID + "</option>"); } sbrCenter.Append("</select>"); uxDrpCenterWrap.InnerHtml = sbrCenter.ToString(); } //center } else { uxRepayWrap.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } } else { uxRepayWrap.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } }
protected void Page_Load(object sender, EventArgs e) { string OfficeID = null; try { OfficeID = (string)Page.RouteData.Values[AppRoutes.AreaOffice.ValOfficeID]; } catch (Exception ex) { } if (OfficeID != null) { //CHECK FOR USER ACCESS string OfficeTypeID = DbSettings.OfficeType.AreaOffice; Users objUsr = new Users(); UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails(); string UserID = objUsrDet.UserID; string UserStatusID = objUsrDet.StatusID; string UserRoleID = objUsrDet.RoleID; string UserOfficeID = objUsrDet.OfficeID; string UserOfficeTypeID = objUsrDet.OfficeTypeID; if (UserID != null && UserStatusID == DbSettings.UserStatus.Active) { //check if user can access this office type DataSet ds = objUsr.GetMenusActionsForRoleID(UserRoleID); List <string> MenuActions = ds.Tables[0].AsEnumerable().Select(r => r[0].ToString()).ToList(); bool AccessView = MenuActions.Contains(DbSettings.AccessOffice.ViewAoTab); if (AccessView) { //check if user can access this office of OfficeID Office objOff = new Office(); CustEnum.PageAccess CanAccessOffice = CustEnum.PageAccess.Error; if ((UserOfficeTypeID == OfficeTypeID) && (UserOfficeID == OfficeID)) { CanAccessOffice = CustEnum.PageAccess.Yes; } else if (int.Parse(UserOfficeTypeID) < int.Parse(OfficeTypeID)) { if (objOff.CheckIfSubOfficeExistUnderOfficeID(UserOfficeID, OfficeID) == "1") { CanAccessOffice = CustEnum.PageAccess.Yes; } else if (objOff.CheckIfSubOfficeExistUnderOfficeID(UserOfficeID, OfficeID) == "0") { CanAccessOffice = CustEnum.PageAccess.No; } } if (CanAccessOffice == CustEnum.PageAccess.Yes) { //user can access this page //Check for MenuActions privileges hdnOid.Value = OfficeID; bool AccessEditAO = MenuActions.Contains(DbSettings.AccessOffice.EditAo); bool AccessViewBO = MenuActions.Contains(DbSettings.AccessOffice.ViewBoTab); #region build page data if (AccessView) { DataSet dsOff = objOff.GetOfficeDetails(OfficeID); if (!DataUtils.IsDataSetNull(dsOff, 0)) { DataRow drOff = dsOff.Tables[0].Rows[0]; string OffName = drOff["OfficeName"].ToString(); string OffAddr = drOff["Address"].ToString(); string OffPhone1 = drOff["Phone1"].ToString(); string OffPhone2 = drOff["Phone2"].ToString(); string OffFax = drOff["Fax"].ToString(); string OffEmail = drOff["EmailID"].ToString(); spnName.InnerHtml = OffName; spnAddr.InnerHtml = OffAddr; spnPh1.InnerHtml = OffPhone1; spnPh2.InnerHtml = OffPhone2; spnFax.InnerHtml = OffFax; spnMail.InnerHtml = OffEmail; //edit options. must follow only after view is completed if (!AccessEditAO) { editOff.InnerHtml = ""; } } else { viewRO.InnerHtml = UiMsg.PageRO.ViewAoFetchErr.ErrorWrap(); } } else { viewRO.InnerHtml = ""; } if (AccessViewBO) { DataSet dsSubOff = objOff.GetAllImmediateSubOffices(OfficeID, DbSettings.OfficeType.BranchOffice); if (!DataUtils.IsDataSetNull(dsSubOff, 0)) { StringBuilder sbrSubOff = new StringBuilder(); foreach (DataRow dr in dsSubOff.Tables[0].Rows) { string SubOffName = dr["OfficeName"].ToString(); string SubOffAddr = dr["Address"].ToString(); string SubOffPh = dr["Phone1"].ToString(); string SubOffURL = Page.GetRouteUrl(AppRoutes.BranchOffice.Name, new { OfficeID = dr["OfficeID"].ToString() }); sbrSubOff.Append("<tr>"); sbrSubOff.Append("<td>"); sbrSubOff.Append("<a href='" + SubOffURL + "'>" + SubOffName + "</a>"); sbrSubOff.Append("</td>"); sbrSubOff.Append("<td>" + SubOffAddr + "</td>"); sbrSubOff.Append("<td>" + SubOffPh + "</td>"); sbrSubOff.Append("</tr>"); } uxSubOfficeTblBody.InnerHtml = sbrSubOff.ToString(); } else { viewSubOff.InnerHtml = UiMsg.PageRO.ViewBoFetchErr.ErrorWrap(); } } else { viewSubOff.InnerHtml = ""; } #endregion build page data } else if (CanAccessOffice == CustEnum.PageAccess.No) { uxOffcontent.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } } //view access else { uxOffcontent.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } } else { Sessions objSession = new Sessions(); objSession.EndSession("&" + AppSettings.QueryStr.SessionExpired.Name + "=" + AppSettings.QueryStr.SessionExpired.Value); } } else { //error uxOffcontent.InnerHtml = UiMsg.Global.NoOfficeExists.ErrorWrap(); } }
protected void Page_Load(object sender, EventArgs e) { string PageID = DbSettings.Menus.Office; Users objUsr = new Users(); UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails(); string UserID = objUsrDet.UserID; string UserStatusID = objUsrDet.StatusID; string UserRoleID = objUsrDet.RoleID; string UserOfficeID = objUsrDet.OfficeID; string UserOfficeTypeID = objUsrDet.OfficeTypeID; if (UserID != null && UserStatusID == DbSettings.UserStatus.Active) { CustEnum.PageAccess Access = objUsr.CheckPageAccess(UserRoleID, PageID); if (Access == CustEnum.PageAccess.Yes) { DataSet ds = objUsr.GetMenusActionsForRoleID(UserRoleID); List <string> MenuActions = ds.Tables[0].AsEnumerable().Select(r => r[0].ToString()).ToList(); bool AccessViewHoTab = MenuActions.Contains(DbSettings.AccessOffice.ViewHoTab); bool AccessViewRoTab = MenuActions.Contains(DbSettings.AccessOffice.ViewRoTab); bool AccessAddRo = MenuActions.Contains(DbSettings.AccessOffice.AddRo); bool AccessDeleteRo = MenuActions.Contains(DbSettings.AccessOffice.DeleteRo); bool AccessViewAoTab = MenuActions.Contains(DbSettings.AccessOffice.ViewAoTab); bool AccessAddAo = MenuActions.Contains(DbSettings.AccessOffice.AddAo); bool AccessDeleteAo = MenuActions.Contains(DbSettings.AccessOffice.DeleteAo); bool AccessViewBoTab = MenuActions.Contains(DbSettings.AccessOffice.ViewBoTab); bool AccessAddBo = MenuActions.Contains(DbSettings.AccessOffice.AddBo); bool AccessDeleteBo = MenuActions.Contains(DbSettings.AccessOffice.DeleteBo); bool AccessViewVilTab = MenuActions.Contains(DbSettings.AccessOffice.ViewVilTab); bool AccessAddVil = MenuActions.Contains(DbSettings.AccessOffice.AddVil); bool AccessDeleteVil = MenuActions.Contains(DbSettings.AccessOffice.DeleteVil); Office objOff = new Office(); StringBuilder sbrTab = new StringBuilder(); StringBuilder sbrTabContent = new StringBuilder(); //tab typeID string OfficeTypeIdHO = DbSettings.OfficeType.HeadOffice; string OfficeTypeIdRO = DbSettings.OfficeType.RegionalOffice; string OfficeTypeIdAO = DbSettings.OfficeType.AreaOffice; string OfficeTypeIdBO = DbSettings.OfficeType.BranchOffice; string OfficeTypeIdVil = DbSettings.OfficeType.Village; #region HO TAB if (AccessViewHoTab) { if (OfficeTypeIdHO == UserOfficeTypeID) { //user belongs to this office level sbrTab.Append("<li class='active'><a href='#HO' data-toggle='tab'>Head Office</a></li>"); DataSet dsOff = objOff.GetOfficeDetails(DbSettings.Fixed.HOID); if (!DataUtils.IsDataSetNull(dsOff, 0)) { DataRow drOff = dsOff.Tables[0].Rows[0]; string OffURL = Page.GetRouteUrl(AppRoutes.HeadOffice.Name, new { }); string OffName = drOff["OfficeName"].ToString(); string OffAddr = drOff["Address"].ToString(); string OffPhone1 = drOff["Phone1"].ToString(); string OffPhone2 = drOff["Phone2"].ToString(); string OffFax = drOff["Fax"].ToString(); string OffEmail = drOff["EmailID"].ToString(); string OffWebsite = drOff["Website"].ToString(); sbrTabContent.Append("<div class='tab-pane active' id='HO'>"); sbrTabContent.Append("<div class='of-tbl-wrap'>"); sbrTabContent.Append("<table class='table table-bordered'>"); sbrTabContent.Append("<thead>"); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<th>Head Office</th>"); sbrTabContent.Append("<th>Address</th>"); sbrTabContent.Append("<th>Phone 1</th>"); sbrTabContent.Append("<th>Phone 2</th>"); sbrTabContent.Append("<th>Fax</th>"); sbrTabContent.Append("<th>Email</th>"); sbrTabContent.Append("<th>Website</th>"); sbrTabContent.Append("</tr>"); sbrTabContent.Append("</thead>"); sbrTabContent.Append("<tbody>"); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<td><a href='" + OffURL + "'>" + OffName + "</a></td>"); sbrTabContent.Append("<td>" + OffAddr + "</td>"); sbrTabContent.Append("<td>" + OffPhone1 + "</td>"); sbrTabContent.Append("<td>" + OffPhone2 + "</td>"); sbrTabContent.Append("<td>" + OffFax + "</td>"); sbrTabContent.Append("<td>" + OffEmail + "</td>"); sbrTabContent.Append("<td><a href='http://" + OffWebsite + "' target='_blank'>" + OffWebsite + "</a></td>"); sbrTabContent.Append("</tr>"); sbrTabContent.Append("</tbody>"); sbrTabContent.Append("</table>"); sbrTabContent.Append("</div>"); sbrTabContent.Append("</div>"); } } } //ho tab #endregion HO TAB #region RO TAB if (AccessViewRoTab) { if (UserOfficeTypeID == OfficeTypeIdRO) { //user belongs to this office level //build tab sbrTab.Append("<li class='active'><a href='#RO' data-toggle='tab'>Regional Office</a></li>"); //build tab data DataSet dsOff = objOff.GetOfficeDetails(UserOfficeID); sbrTabContent.Append("<div class='tab-pane active' id='RO'>"); if (!DataUtils.IsDataSetNull(dsOff, 0)) { sbrTabContent.Append("<div class='of-tbl-wrap'>"); sbrTabContent.Append("<table class='table table-bordered'>"); sbrTabContent.Append("<thead>"); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<th>Regional Office</th>"); sbrTabContent.Append("<th>Address</th>"); sbrTabContent.Append("<th>Phone 1</th>"); sbrTabContent.Append("<th>Phone 2</th>"); sbrTabContent.Append("<th>Fax</th>"); sbrTabContent.Append("<th>Email</th>"); sbrTabContent.Append("</tr>"); sbrTabContent.Append("</thead>"); sbrTabContent.Append("<tbody>"); DataRow dr = dsOff.Tables[0].Rows[0]; string OffURL = Page.GetRouteUrl(AppRoutes.RegionalOffice.Name, new { OfficeID = dr["OfficeID"].ToString() }); string OffID = dr["OfficeID"].ToString(); string OffName = dr["OfficeName"].ToString(); string OffAddr = dr["Address"].ToString(); string OffPhone1 = dr["Phone1"].ToString(); string OffPhone2 = dr["Phone2"].ToString(); string OffFax = dr["Fax"].ToString(); string OffEmail = dr["EmailID"].ToString(); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<td><a href='" + OffURL + "'>" + OffName + "</a></td>"); sbrTabContent.Append("<td>" + OffAddr + "</td>"); sbrTabContent.Append("<td>" + OffPhone1 + "</td>"); sbrTabContent.Append("<td>" + OffPhone2 + "</td>"); sbrTabContent.Append("<td>" + OffFax + "</td>"); sbrTabContent.Append("<td>" + OffEmail + "</td>"); sbrTabContent.Append("</tr>"); sbrTabContent.Append("</tbody>"); sbrTabContent.Append("</table>"); sbrTabContent.Append("</div>"); //div for tbl wrapper } else { sbrTabContent.Append(UiMsg.Global.NoData.ErrorWrap()); } sbrTabContent.Append("</div>"); //div for tab pane } else if (int.Parse(UserOfficeTypeID) < int.Parse(OfficeTypeIdRO)) { //this type of office coes under the user's office. //tab sbrTab.Append("<li><a href='#RO' data-toggle='tab'>Regional Office</a></li>"); //tab data sbrTabContent.Append("<div class='tab-pane' id='RO'>"); //options if (AccessAddRo) { sbrTabContent.Append("<div class='of-optn-wrap'>"); sbrTabContent.Append("<button class='btn btn-primary' id='btnAdd_" + OfficeTypeIdRO + "'><i class='icon-white icon-plus'></i> Create New Regional Office</button>"); sbrTabContent.Append("</div>"); } //reg offices DataSet dsOff = objOff.GetAllSubOfficeByTypeID(UserOfficeID, DbSettings.OfficeType.RegionalOffice); if (!DataUtils.IsDataSetNull(dsOff, 0)) { sbrTabContent.Append("<div class='of-tbl-wrap'>"); sbrTabContent.Append("<table class='table table-bordered'>"); sbrTabContent.Append("<thead>"); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<th>Regional Office</th>"); sbrTabContent.Append("<th>Address</th>"); sbrTabContent.Append("<th>Phone 1</th>"); sbrTabContent.Append("<th>Phone 2</th>"); sbrTabContent.Append("<th>Fax</th>"); sbrTabContent.Append("<th>Email</th>"); if (AccessDeleteRo) { sbrTabContent.Append("<th><i class='icon-cog'></i> Options</th>"); } sbrTabContent.Append("</tr>"); sbrTabContent.Append("</thead>"); sbrTabContent.Append("<tbody>"); foreach (DataRow dr in dsOff.Tables[0].Rows) { string OffURL = Page.GetRouteUrl(AppRoutes.RegionalOffice.Name, new { OfficeID = dr["OfficeID"].ToString() }); string OffID = dr["OfficeID"].ToString(); string OffName = dr["OfficeName"].ToString(); string OffAddr = dr["Address"].ToString(); string OffPhone1 = dr["Phone1"].ToString(); string OffPhone2 = dr["Phone2"].ToString(); string OffFax = dr["Fax"].ToString(); string OffEmail = dr["EmailID"].ToString(); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<td><a href='" + OffURL + "'>" + OffName + "</a></td>"); sbrTabContent.Append("<td>" + OffAddr + "</td>"); sbrTabContent.Append("<td>" + OffPhone1 + "</td>"); sbrTabContent.Append("<td>" + OffPhone2 + "</td>"); sbrTabContent.Append("<td>" + OffFax + "</td>"); sbrTabContent.Append("<td>" + OffEmail + "</td>"); if (AccessDeleteRo) { sbrTabContent.Append("<td>"); sbrTabContent.Append("<button class='btn btn-danger btn-mini' id='btnDel_" + OffID + "'><i class='icon-white icon-trash'></i> Remove Office</button>"); sbrTabContent.Append("</td>"); } sbrTabContent.Append("</tr>"); } sbrTabContent.Append("</tbody>"); sbrTabContent.Append("</table>"); sbrTabContent.Append("</div>"); //div for tbl wrapper } //ds not null else { //sbrTabContent.Append(UiMsg.Global.NoData.ErrorWrap()); } sbrTabContent.Append("</div>"); //div for tab pane } //otid < } //ro tab #endregion RO TAB #region AO TAB if (AccessViewAoTab) { if (UserOfficeTypeID == OfficeTypeIdAO) { //user belongs to this office level //build tab sbrTab.Append("<li class='active'><a href='#AO' data-toggle='tab'>Area Office</a></li>"); //build tab data DataSet dsOff = objOff.GetOfficeDetails(UserOfficeID); sbrTabContent.Append("<div class='tab-pane active' id='AO'>"); if (!DataUtils.IsDataSetNull(dsOff, 0)) { sbrTabContent.Append("<div class='of-tbl-wrap'>"); sbrTabContent.Append("<table class='table table-bordered'>"); sbrTabContent.Append("<thead>"); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<th>Area Office</th>"); sbrTabContent.Append("<th>Address</th>"); sbrTabContent.Append("<th>Phone 1</th>"); sbrTabContent.Append("<th>Phone 2</th>"); sbrTabContent.Append("<th>Fax</th>"); sbrTabContent.Append("<th>Email</th>"); sbrTabContent.Append("</tr>"); sbrTabContent.Append("</thead>"); sbrTabContent.Append("<tbody>"); DataRow dr = dsOff.Tables[0].Rows[0]; string OffURL = Page.GetRouteUrl(AppRoutes.AreaOffice.Name, new { OfficeID = dr["OfficeID"].ToString() }); string OffID = dr["OfficeID"].ToString(); string OffName = dr["OfficeName"].ToString(); string OffAddr = dr["Address"].ToString(); string OffPhone1 = dr["Phone1"].ToString(); string OffPhone2 = dr["Phone2"].ToString(); string OffFax = dr["Fax"].ToString(); string OffEmail = dr["EmailID"].ToString(); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<td><a href='" + OffURL + "'>" + OffName + "</a></td>"); sbrTabContent.Append("<td>" + OffAddr + "</td>"); sbrTabContent.Append("<td>" + OffPhone1 + "</td>"); sbrTabContent.Append("<td>" + OffPhone2 + "</td>"); sbrTabContent.Append("<td>" + OffFax + "</td>"); sbrTabContent.Append("<td>" + OffEmail + "</td>"); sbrTabContent.Append("</tr>"); sbrTabContent.Append("</tbody>"); sbrTabContent.Append("</table>"); sbrTabContent.Append("</div>"); //div for tbl wrapper } else { sbrTabContent.Append(UiMsg.Global.NoData.ErrorWrap()); } sbrTabContent.Append("</div>"); //div for tab pane } else if (int.Parse(UserOfficeTypeID) < int.Parse(OfficeTypeIdAO)) { //this type of office coes under the user's office. //tab sbrTab.Append("<li><a href='#AO' data-toggle='tab'>Area Office</a></li>"); //tab data sbrTabContent.Append("<div class='tab-pane' id='AO'>"); //options if (AccessAddAo) { sbrTabContent.Append("<div class='of-optn-wrap'>"); sbrTabContent.Append("<button class='btn btn-primary' id='btnAdd_" + OfficeTypeIdAO + "'><i class='icon-white icon-plus'></i> Create New Area Office</button>"); sbrTabContent.Append("</div>"); } //reg offices DataSet dsOff = objOff.GetAllSubOfficeByTypeID(UserOfficeID, DbSettings.OfficeType.AreaOffice); if (!DataUtils.IsDataSetNull(dsOff, 0)) { sbrTabContent.Append("<div class='of-tbl-wrap'>"); sbrTabContent.Append("<table class='table table-bordered'>"); sbrTabContent.Append("<thead>"); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<th>Area Office</th>"); sbrTabContent.Append("<th>Address</th>"); sbrTabContent.Append("<th>Phone 1</th>"); sbrTabContent.Append("<th>Phone 2</th>"); sbrTabContent.Append("<th>Fax</th>"); sbrTabContent.Append("<th>Email</th>"); if (AccessDeleteAo) { sbrTabContent.Append("<th><i class='icon-cog'></i> Options</th>"); } sbrTabContent.Append("</tr>"); sbrTabContent.Append("</thead>"); sbrTabContent.Append("<tbody>"); foreach (DataRow dr in dsOff.Tables[0].Rows) { string OffURL = Page.GetRouteUrl(AppRoutes.AreaOffice.Name, new { OfficeID = dr["OfficeID"].ToString() }); string OffID = dr["OfficeID"].ToString(); string OffName = dr["OfficeName"].ToString(); string OffAddr = dr["Address"].ToString(); string OffPhone1 = dr["Phone1"].ToString(); string OffPhone2 = dr["Phone2"].ToString(); string OffFax = dr["Fax"].ToString(); string OffEmail = dr["EmailID"].ToString(); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<td><a href='" + OffURL + "'>" + OffName + "</a></td>"); sbrTabContent.Append("<td>" + OffAddr + "</td>"); sbrTabContent.Append("<td>" + OffPhone1 + "</td>"); sbrTabContent.Append("<td>" + OffPhone2 + "</td>"); sbrTabContent.Append("<td>" + OffFax + "</td>"); sbrTabContent.Append("<td>" + OffEmail + "</td>"); if (AccessDeleteAo) { sbrTabContent.Append("<td>"); sbrTabContent.Append("<button class='btn btn-danger btn-mini' id='btnDel_" + OffID + "'><i class='icon-white icon-trash'></i> Remove Office</button>"); sbrTabContent.Append("</td>"); } sbrTabContent.Append("</tr>"); } sbrTabContent.Append("</tbody>"); sbrTabContent.Append("</table>"); sbrTabContent.Append("</div>"); //div for tbl wrapper } //ds not null else { //sbrTabContent.Append(UiMsg.Global.NoData.ErrorWrap()); } sbrTabContent.Append("</div>"); //div for tab pane } //otid < } //ro tab #endregion AO TAB #region BO TAB if (AccessViewBoTab) { if (UserOfficeTypeID == OfficeTypeIdBO) { //user belongs to this office level //build tab sbrTab.Append("<li class='active'><a href='#BO' data-toggle='tab'>Branch Office</a></li>"); //build tab data DataSet dsOff = objOff.GetOfficeDetails(UserOfficeID); sbrTabContent.Append("<div class='tab-pane active' id='BO'>"); if (!DataUtils.IsDataSetNull(dsOff, 0)) { sbrTabContent.Append("<div class='of-tbl-wrap'>"); sbrTabContent.Append("<table class='table table-bordered'>"); sbrTabContent.Append("<thead>"); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<th>Branch Office</th>"); sbrTabContent.Append("<th>Address</th>"); sbrTabContent.Append("<th>Phone 1</th>"); sbrTabContent.Append("<th>Phone 2</th>"); sbrTabContent.Append("<th>Fax</th>"); sbrTabContent.Append("<th>Email</th>"); sbrTabContent.Append("</tr>"); sbrTabContent.Append("</thead>"); sbrTabContent.Append("<tbody>"); DataRow dr = dsOff.Tables[0].Rows[0]; string OffURL = Page.GetRouteUrl(AppRoutes.BranchOffice.Name, new { OfficeID = dr["OfficeID"].ToString() }); string OffID = dr["OfficeID"].ToString(); string OffName = dr["OfficeName"].ToString(); string OffAddr = dr["Address"].ToString(); string OffPhone1 = dr["Phone1"].ToString(); string OffPhone2 = dr["Phone2"].ToString(); string OffFax = dr["Fax"].ToString(); string OffEmail = dr["EmailID"].ToString(); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<td><a href='" + OffURL + "'>" + OffName + "</a></td>"); sbrTabContent.Append("<td>" + OffAddr + "</td>"); sbrTabContent.Append("<td>" + OffPhone1 + "</td>"); sbrTabContent.Append("<td>" + OffPhone2 + "</td>"); sbrTabContent.Append("<td>" + OffFax + "</td>"); sbrTabContent.Append("<td>" + OffEmail + "</td>"); sbrTabContent.Append("</tr>"); sbrTabContent.Append("</tbody>"); sbrTabContent.Append("</table>"); sbrTabContent.Append("</div>"); //div for tbl wrapper } else { //sbrTabContent.Append(UiMsg.Global.NoData.ErrorWrap()); } sbrTabContent.Append("</div>"); //div for tab pane } else if (int.Parse(UserOfficeTypeID) < int.Parse(OfficeTypeIdBO)) { //this type of office coes under the user's office. //tab sbrTab.Append("<li><a href='#BO' data-toggle='tab'>Branch Office</a></li>"); //tab data sbrTabContent.Append("<div class='tab-pane' id='BO'>"); //options if (AccessAddBo) { sbrTabContent.Append("<div class='of-optn-wrap'>"); sbrTabContent.Append("<button class='btn btn-primary' id='btnAdd_" + OfficeTypeIdBO + "'><i class='icon-white icon-plus'></i> Create New Branch Office</button>"); sbrTabContent.Append("</div>"); } //reg offices DataSet dsOff = objOff.GetAllSubOfficeByTypeID(UserOfficeID, DbSettings.OfficeType.BranchOffice); if (!DataUtils.IsDataSetNull(dsOff, 0)) { sbrTabContent.Append("<div class='of-tbl-wrap'>"); sbrTabContent.Append("<table class='table table-bordered'>"); sbrTabContent.Append("<thead>"); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<th>Branch Office</th>"); sbrTabContent.Append("<th>Address</th>"); sbrTabContent.Append("<th>Phone 1</th>"); sbrTabContent.Append("<th>Phone 2</th>"); sbrTabContent.Append("<th>Fax</th>"); sbrTabContent.Append("<th>Email</th>"); if (AccessDeleteBo) { sbrTabContent.Append("<th><i class='icon-cog'></i> Options</th>"); } sbrTabContent.Append("</tr>"); sbrTabContent.Append("</thead>"); sbrTabContent.Append("<tbody>"); foreach (DataRow dr in dsOff.Tables[0].Rows) { string OffURL = Page.GetRouteUrl(AppRoutes.BranchOffice.Name, new { OfficeID = dr["OfficeID"].ToString() }); string OffID = dr["OfficeID"].ToString(); string OffName = dr["OfficeName"].ToString(); string OffAddr = dr["Address"].ToString(); string OffPhone1 = dr["Phone1"].ToString(); string OffPhone2 = dr["Phone2"].ToString(); string OffFax = dr["Fax"].ToString(); string OffEmail = dr["EmailID"].ToString(); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<td><a href='" + OffURL + "'>" + OffName + "</a></td>"); sbrTabContent.Append("<td>" + OffAddr + "</td>"); sbrTabContent.Append("<td>" + OffPhone1 + "</td>"); sbrTabContent.Append("<td>" + OffPhone2 + "</td>"); sbrTabContent.Append("<td>" + OffFax + "</td>"); sbrTabContent.Append("<td>" + OffEmail + "</td>"); if (AccessDeleteBo) { sbrTabContent.Append("<td>"); sbrTabContent.Append("<button class='btn btn-danger btn-mini' id='btnDel_" + OffID + "'><i class='icon-white icon-trash'></i> Remove Office</button>"); sbrTabContent.Append("</td>"); } sbrTabContent.Append("</tr>"); } sbrTabContent.Append("</tbody>"); sbrTabContent.Append("</table>"); sbrTabContent.Append("</div>"); //div for tbl wrapper } //ds not null else { //sbrTabContent.Append(UiMsg.Global.NoData.ErrorWrap()); } sbrTabContent.Append("</div>"); //div for tab pane } //otid < } //ro tab #endregion BO TAB #region VIL TAB if (AccessViewVilTab) { #region office = vil //the following scenario won't occur as per business rules //if (UserOfficeTypeID == OfficeTypeIdVil) //{ // //user belongs to this office level // //build tab // sbrTab.Append("<li class='active'><a href='#VIL' data-toggle='tab'>Village</a></li>"); // //build tab data // DataSet dsOff = objOff.GetOfficeDetails(UserOfficeID); // sbrTabContent.Append("<div class='tab-pane active' id='VIL'>"); // if (!DataUtils.IsDataSetNull(dsOff, 0)) // { // sbrTabContent.Append("<div class='of-tbl-wrap'>"); // sbrTabContent.Append("<table class='table table-bordered'>"); // sbrTabContent.Append("<thead>"); // sbrTabContent.Append("<tr>"); // sbrTabContent.Append("<th>Village</th>"); // sbrTabContent.Append("<th>Parent Branch</th>"); // //sbrTabContent.Append("<th>Address</th>"); // //sbrTabContent.Append("<th>Phone 1</th>"); // //sbrTabContent.Append("<th>Phone 2</th>"); // //sbrTabContent.Append("<th>Fax</th>"); // //sbrTabContent.Append("<th>Email</th>"); // sbrTabContent.Append("</tr>"); // sbrTabContent.Append("</thead>"); // sbrTabContent.Append("<tbody>"); // DataRow dr = dsOff.Tables[0].Rows[0]; // string OffURL = Page.GetRouteUrl(AppRoutes.Village.Name, new { OfficeID = dr["OfficeID"].ToString() }); // string OffID = dr["OfficeID"].ToString(); // string OffName = dr["OfficeName"].ToString(); // string ParentOffice = dr["ParentOfficeName"].ToString(); // string OffAddr = dr["Address"].ToString(); // string OffPhone1 = dr["Phone1"].ToString(); // string OffPhone2 = dr["Phone2"].ToString(); // string OffFax = dr["Fax"].ToString(); // string OffEmail = dr["EmailID"].ToString(); // sbrTabContent.Append("<tr>"); // sbrTabContent.Append("<td><a href='" + OffURL + "'>" + OffName + "</a></td>"); // sbrTabContent.Append("<td>" + ParentOffice + "</td>"); // //sbrTabContent.Append("<td>" + OffAddr + "</td>"); // //sbrTabContent.Append("<td>" + OffPhone1 + "</td>"); // //sbrTabContent.Append("<td>" + OffPhone2 + "</td>"); // //sbrTabContent.Append("<td>" + OffFax + "</td>"); // //sbrTabContent.Append("<td>" + OffEmail + "</td>"); // sbrTabContent.Append("</tr>"); // sbrTabContent.Append("</tbody>"); // sbrTabContent.Append("</table>"); // sbrTabContent.Append("</div>"); //div for tbl wrapper // } // else // { // sbrTabContent.Append(UiMsg.Global.NoData.ErrorWrap()); // } // sbrTabContent.Append("</div>"); //div for tab pane //} #endregion office = vil if (int.Parse(UserOfficeTypeID) < int.Parse(OfficeTypeIdVil)) { //this type of office coes under the user's office. //tab sbrTab.Append("<li><a href='#VIL' data-toggle='tab'>Village</a></li>"); //tab data sbrTabContent.Append("<div class='tab-pane' id='VIL'>"); //options if (AccessAddVil) { sbrTabContent.Append("<div class='of-optn-wrap'>"); sbrTabContent.Append("<button class='btn btn-primary' id='btnAdd_" + OfficeTypeIdVil + "'><i class='icon-white icon-plus'></i> Create New Village</button>"); sbrTabContent.Append("</div>"); } //reg offices DataSet dsOff = objOff.GetAllSubOfficeByTypeID(UserOfficeID, DbSettings.OfficeType.Village); if (!DataUtils.IsDataSetNull(dsOff, 0)) { sbrTabContent.Append("<div class='of-tbl-wrap'>"); sbrTabContent.Append("<table class='table table-bordered' id='tblVillage'>"); sbrTabContent.Append("<thead>"); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<th>Village</th>"); sbrTabContent.Append("<th>Parent Branch</th>"); //sbrTabContent.Append("<th>Address</th>"); //sbrTabContent.Append("<th>Phone 1</th>"); //sbrTabContent.Append("<th>Phone 2</th>"); //sbrTabContent.Append("<th>Fax</th>"); //sbrTabContent.Append("<th>Email</th>"); if (AccessDeleteVil) { sbrTabContent.Append("<th><i class='icon-cog'></i> Options</th>"); } sbrTabContent.Append("</tr>"); sbrTabContent.Append("</thead>"); sbrTabContent.Append("<tbody>"); foreach (DataRow dr in dsOff.Tables[0].Rows) { string OffURL = Page.GetRouteUrl(AppRoutes.Village.Name, new { OfficeID = dr["OfficeID"].ToString() }); string OffID = dr["OfficeID"].ToString(); string OffName = dr["OfficeName"].ToString(); string ParentOffice = dr["ParentOfficeName"].ToString(); string OffAddr = dr["Address"].ToString(); string OffPhone1 = dr["Phone1"].ToString(); string OffPhone2 = dr["Phone2"].ToString(); string OffFax = dr["Fax"].ToString(); string OffEmail = dr["EmailID"].ToString(); sbrTabContent.Append("<tr>"); sbrTabContent.Append("<td><a href='" + OffURL + "'>" + OffName + "</a></td>"); sbrTabContent.Append("<td>" + ParentOffice + "</td>"); //sbrTabContent.Append("<td>" + OffAddr + "</td>"); //sbrTabContent.Append("<td>" + OffPhone1 + "</td>"); //sbrTabContent.Append("<td>" + OffPhone2 + "</td>"); //sbrTabContent.Append("<td>" + OffFax + "</td>"); //sbrTabContent.Append("<td>" + OffEmail + "</td>"); if (AccessDeleteVil) { sbrTabContent.Append("<td>"); sbrTabContent.Append("<button class='btn btn-danger btn-mini' id='btnDel_" + OffID + "'><i class='icon-white icon-trash'></i> Remove Village</button>"); sbrTabContent.Append("</td>"); } sbrTabContent.Append("</tr>"); } sbrTabContent.Append("</tbody>"); sbrTabContent.Append("</table>"); sbrTabContent.Append("</div>"); //div for tbl wrapper } //ds not null else { //sbrTabContent.Append(UiMsg.Global.NoData.ErrorWrap()); } sbrTabContent.Append("</div>"); //div for tab pane } //otid < } //ro tab #endregion VIL TAB tab.InnerHtml = sbrTab.ToString(); tabContent.InnerHtml = "<div id='locNotHO' class='gen-not-1'></div>" + sbrTabContent.ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { string ReportID = null; try { ReportID = (string)Page.RouteData.Values["ReportID"]; } catch (Exception ex) { } if (ReportID != null) { hdnRID.Value = ReportID; Users objUsr = new Users(); UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails(); string UserID = objUsrDet.UserID; string UserStatusID = objUsrDet.StatusID; string UserRoleID = objUsrDet.RoleID; string UserOfficeID = objUsrDet.OfficeID; string UserOfficeTypeID = objUsrDet.OfficeTypeID; if (UserID != null && UserStatusID == DbSettings.UserStatus.Active) { CustEnum.PageAccess Access = objUsr.CheckPageAccess(UserRoleID, ReportID); if (Access == CustEnum.PageAccess.Yes) { string ReportTitle = "Report"; //default name #region set page title switch (ReportID) { case DbSettings.ReportType.CenterCollectionSheet: ReportTitle = "Center Collection Sheet"; break; case DbSettings.ReportType.DuevsCollectionBranch: ReportTitle = "Due vs Collection - Branch"; break; case DbSettings.ReportType.DuevsCollectionCenter: ReportTitle = "Due vs Collection - Center"; break; case DbSettings.ReportType.DuevsCollectionFE: ReportTitle = "Due vs Collection - FE"; break; case DbSettings.ReportType.FEDetailed: ReportTitle = "FE Detailed"; break; case DbSettings.ReportType.HOReport: ReportTitle = "HO Report"; break; case DbSettings.ReportType.LoanDisbursementReport: ReportTitle = "Loan Disbursement Report"; break; case DbSettings.ReportType.MonthlyBranchStatus: ReportTitle = "Monthly Branch Status"; break; case DbSettings.ReportType.OutstandingReportBranch: ReportTitle = "Outstanding Report - Branch"; break; case DbSettings.ReportType.OutstandingReportProduct: ReportTitle = "Outstanding Report - Product"; break; case DbSettings.ReportType.OutstandingReportVillage: ReportTitle = "Outstanding Report - Village"; break; case DbSettings.ReportType.OverdueReportBranch: ReportTitle = "Overdue Report - Branch"; break; case DbSettings.ReportType.OverdueReportCenter: ReportTitle = "Overdue Report - Center"; break; case DbSettings.ReportType.OverdueReportFE: ReportTitle = "Overdue Report - FE"; break; case DbSettings.ReportType.OverdueReportProduct: ReportTitle = "Overdue Report - Product"; break; case DbSettings.ReportType.OverdueReportVillage: ReportTitle = "Overdue Report - Village"; break; case DbSettings.ReportType.PurposeWiseLoanPortfolio: ReportTitle = "Purpose Wise Loan Portfolio"; break; case DbSettings.ReportType.SubLedgerBalances: ReportTitle = "Sub-Ledger Balances"; break; default: break; } var page = (Page)HttpContext.Current.Handler; page.Title = ReportTitle; #endregion uxReportTitle.InnerHtml = ReportTitle; #region generate filters bool ShowBranch = true; //set to true by default bool ShowVillage = false; bool ShowCenter = false; bool ShowAsOn = false; bool ShowFrom = false; bool ShowTo = false; bool ShowMonth = false; bool ShowFE = false; bool ShowLP = false; //bool BranchGenerated = false; //decide the filters that has to be shown if (ReportID == DbSettings.ReportType.OverdueReportBranch) { //ShowLP = true; } if (ReportID == DbSettings.ReportType.OverdueReportFE || ReportID == DbSettings.ReportType.DuevsCollectionFE || ReportID == DbSettings.ReportType.FEDetailed) { ShowFE = true; } if (ReportID == DbSettings.ReportType.OverdueReportBranch) { //ShowVillage = true; } if (ReportID == DbSettings.ReportType.DuevsCollectionCenter) { ShowCenter = true; } if (ReportID == DbSettings.ReportType.OutstandingReportBranch || ReportID == DbSettings.ReportType.OutstandingReportProduct || ReportID == DbSettings.ReportType.OutstandingReportVillage || ReportID == DbSettings.ReportType.SubLedgerBalances || ReportID == DbSettings.ReportType.OverdueReportBranch || ReportID == DbSettings.ReportType.OverdueReportFE || ReportID == DbSettings.ReportType.OverdueReportCenter || ReportID == DbSettings.ReportType.OverdueReportProduct || ReportID == DbSettings.ReportType.OverdueReportVillage || ReportID == DbSettings.ReportType.PurposeWiseLoanPortfolio ) { ShowAsOn = true; } if (ReportID == DbSettings.ReportType.LoanDisbursementReport || ReportID == DbSettings.ReportType.DuevsCollectionBranch || ReportID == DbSettings.ReportType.DuevsCollectionCenter || ReportID == DbSettings.ReportType.DuevsCollectionFE || ReportID == DbSettings.ReportType.FEDetailed ) { ShowFrom = true; } if (ReportID == DbSettings.ReportType.LoanDisbursementReport || ReportID == DbSettings.ReportType.DuevsCollectionBranch || ReportID == DbSettings.ReportType.DuevsCollectionCenter || ReportID == DbSettings.ReportType.DuevsCollectionFE || ReportID == DbSettings.ReportType.FEDetailed) { ShowTo = true; } if (ReportID == DbSettings.ReportType.MonthlyBranchStatus) { ShowMonth = true; } //show required filters if (ShowBranch) { uxLblBranch.Style.Add("display", "block"); uxBranchWrap.Style.Add("display", "block"); } if (ShowFE) { uxLblFe.Style.Add("display", "block"); uxFEWrap.Style.Add("display", "block"); } if (ShowFrom) { uxLblFrom.Style.Add("display", "block"); uxFromWrap.Style.Add("display", "block"); } if (ShowLP) { uxLblLP.Style.Add("display", "block"); uxLPWrap.Style.Add("display", "block"); } if (ShowMonth) { uxLblMonth.Style.Add("display", "block"); uxMonthPickerWrap.Style.Add("display", "block"); } if (ShowTo) { uxLblTo.Style.Add("display", "block"); uxToWrap.Style.Add("display", "block"); } if (ShowVillage) { uxLblVillage.Style.Add("display", "block"); uxVillageWrap.Style.Add("display", "block"); } if (ShowCenter) { uxLblCenter.Style.Add("display", "block"); uxCenterWrap.Style.Add("display", "block"); } if (ShowAsOn) { uxLblAsOn.Style.Add("display", "block"); uxAsOnWrap.Style.Add("display", "block"); } Office objOff = new Office(); if (ShowBranch) { //branch StringBuilder sbrBranch = new StringBuilder(); if (int.Parse(UserOfficeTypeID) < int.Parse(DbSettings.OfficeType.BranchOffice)) { //user belongs to a higher office type, so the sp will fetch branches DataSet dsBranch = objOff.GetAllSubOfficeByTypeID(UserOfficeID, DbSettings.OfficeType.BranchOffice); sbrBranch.Append("<select class='span2' id='uxBranch'>"); sbrBranch.Append("<option value='0'>All Branches</option>"); foreach (DataRow drBranch in dsBranch.Tables[0].Rows) { string BranchID = drBranch["OfficeID"].ToString(); string BranchName = drBranch["OfficeName"].ToString(); sbrBranch.Append("<option value='" + BranchID + "'>" + BranchName + "</option>"); } sbrBranch.Append("</select>"); uxBranchWrap.InnerHtml = sbrBranch.ToString(); //BranchGenerated = true; } else if (UserOfficeTypeID == DbSettings.OfficeType.BranchOffice) { //user belongs to a branch DataSet dsBranchDetails = objOff.GetOfficeDetails(UserOfficeID); if (!DataUtils.IsDataSetNull(dsBranchDetails, 0)) { sbrBranch.Append("<select disabled='disabled' class='span2' id='uxBranch'>"); string BranchID = dsBranchDetails.Tables[0].Rows[0]["OfficeID"].ToString(); string BranchName = dsBranchDetails.Tables[0].Rows[0]["OfficeName"].ToString(); sbrBranch.Append("<option value='" + BranchID + "'>" + BranchName + "</option>"); sbrBranch.Append("</select>"); uxBranchWrap.InnerHtml = sbrBranch.ToString(); //BranchGenerated = true; } } } //end branch if (ShowVillage) { //villages DataSet dsVillage = objOff.GetAllSubOfficeByTypeID(UserOfficeID, DbSettings.OfficeType.Village); StringBuilder sbrVillage = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsVillage, 0)) { sbrVillage.Append("<select class='span2' id='uxVillage'>"); sbrVillage.Append("<option class='0' value='0'>All Villages</option>"); foreach (DataRow drVill in dsVillage.Tables[0].Rows) { string VillaID = drVill["OfficeID"].ToString(); string VillName = drVill["OfficeName"].ToString(); string BranchID = drVill["ParentOfficeID"].ToString(); sbrVillage.Append("<option class='" + BranchID + "' value='" + VillaID + "'>" + VillName + "</option>"); } sbrVillage.Append("</select>"); uxVillageWrap.InnerHtml = sbrVillage.ToString(); } } //show village if (ShowCenter) { //centers DataSet dsCen = objOff.GetAllCentersForUserID(UserID); StringBuilder sbrCenter = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsCen, 0)) { sbrCenter.Append("<select class='span2' id='uxCenter'>"); sbrCenter.Append("<option class='0' value='0'>All Centers</option>"); foreach (DataRow dr in dsCen.Tables[0].Rows) { string CenterID = dr["CenterID"].ToString(); string VillageID = dr["ParentOfficeID"].ToString(); sbrCenter.Append("<option class='" + VillageID + "' value='" + CenterID + "'>Center " + CenterID + "</option>"); } sbrCenter.Append("</select>"); uxCenterWrap.InnerHtml = sbrCenter.ToString(); } } //center if (ShowFE) { DataSet dsFE = objOff.GetAllFE(); StringBuilder sbrFE = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsFE, 0)) { sbrFE.Append("<select class='span2' id='uxFE'>"); sbrFE.Append("<option class='0' value='0'>All FE</option>"); foreach (DataRow drFE in dsFE.Tables[0].Rows) { string FeUserID = drFE["UserID"].ToString(); string FeName = drFE["Name"].ToString(); string BranchID = drFE["OfficeID"].ToString(); sbrFE.Append("<option class='" + BranchID + "' value='" + FeUserID + "'>" + FeName + "</option>"); } sbrFE.Append("</select>"); uxFEWrap.InnerHtml = sbrFE.ToString(); } } if (ShowLP) { Loans onjLoan = new Loans(); DataSet dsLP = onjLoan.GetLoanProducts(null); StringBuilder sbrLP = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsLP, 0)) { sbrLP.Append("<select class='span2' id='uxLP'>"); sbrLP.Append("<option class='0' value='0'>All Products</option>"); foreach (DataRow drFE in dsLP.Tables[0].Rows) { string LPID = drFE["LoanProductID"].ToString(); string LPName = drFE["ProductName"].ToString(); sbrLP.Append("<option value='" + LPID + "'>" + LPName + "</option>"); } sbrLP.Append("</select>"); uxLPWrap.InnerHtml = sbrLP.ToString(); } } } #endregion } } }
protected void Page_Load(object sender, EventArgs e) { string OfficeID = null; try { OfficeID = (string)Page.RouteData.Values[AppRoutes.Village.ValOfficeID]; } catch (Exception ex) { } if (OfficeID != null) { //CHECK FOR USER ACCESS string OfficeTypeID = DbSettings.OfficeType.Village; Users objUsr = new Users(); UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails(); string UserID = objUsrDet.UserID; string UserStatusID = objUsrDet.StatusID; string UserRoleID = objUsrDet.RoleID; string UserOfficeID = objUsrDet.OfficeID; string UserOfficeTypeID = objUsrDet.OfficeTypeID; if (UserID != null && UserStatusID == DbSettings.UserStatus.Active) { //check if user can access this office type DataSet ds = objUsr.GetMenusActionsForRoleID(UserRoleID); List <string> MenuActions = ds.Tables[0].AsEnumerable().Select(r => r[0].ToString()).ToList(); bool AccessView = MenuActions.Contains(DbSettings.AccessOffice.ViewVilTab); if (AccessView) { //check if user can access this office of OfficeID Office objOff = new Office(); CustEnum.PageAccess CanAccessOffice = CustEnum.PageAccess.Error; if ((UserOfficeTypeID == OfficeTypeID) && (UserOfficeID == OfficeID)) { CanAccessOffice = CustEnum.PageAccess.Yes; } else if (int.Parse(UserOfficeTypeID) < int.Parse(OfficeTypeID)) { if (objOff.CheckIfSubOfficeExistUnderOfficeID(UserOfficeID, OfficeID) == "1") { CanAccessOffice = CustEnum.PageAccess.Yes; } else if (objOff.CheckIfSubOfficeExistUnderOfficeID(UserOfficeID, OfficeID) == "0") { CanAccessOffice = CustEnum.PageAccess.No; } } if (CanAccessOffice == CustEnum.PageAccess.Yes) { //user can access this page //Check for MenuActions privileges hdnOid.Value = OfficeID; bool AccessEditVil = MenuActions.Contains(DbSettings.AccessOffice.EditVil); bool AccessViewCen = MenuActions.Contains(DbSettings.AccessCenters.ViewCenterList); bool AccessAddCen = MenuActions.Contains(DbSettings.AccessCenters.AddCenter); bool AccessDelCen = MenuActions.Contains(DbSettings.AccessCenters.DelCenter); #region build page data StringBuilder sbrSubOff = new StringBuilder(); if (AccessView) { DataSet dsOff = objOff.GetOfficeDetails(OfficeID); if (!DataUtils.IsDataSetNull(dsOff, 0)) { DataRow drOff = dsOff.Tables[0].Rows[0]; string OffName = drOff["OfficeName"].ToString(); spnName.InnerHtml = OffName; //edit options. must follow only after view is completed if (!AccessEditVil) { editOff.InnerHtml = ""; } } else { viewRO.InnerHtml = UiMsg.PageRO.ViewVilFetchErr.ErrorWrap(); } } else { viewRO.InnerHtml = ""; } StringBuilder sbrAddCen = new StringBuilder(); if (AccessAddCen) { sbrAddCen.Append("<div>"); sbrAddCen.Append("<a class='btn btn-primary' id='btnAddCenter'><i class='icon-white icon-plus'></i> Create New Center</a>"); sbrAddCen.Append("</div><br/>"); DataSet dsFE = objOff.GetFeByVillageID(OfficeID); if (!DataUtils.IsDataSetNull(dsFE, 0)) { DataTable dtFe = dsFE.Tables[0]; StringBuilder sbrFE = new StringBuilder(); sbrFE.Append("<select id='drpFE'>"); sbrFE.Append("<option value='0'>Select FE</option>"); foreach (DataRow drFE in dtFe.Rows) { sbrFE.Append("<option value='" + drFE["UserID"].ToString() + "'>" + drFE["Name"].ToString() + "</option>"); } sbrFE.Append("</select>"); FE.InnerHtml = sbrFE.ToString(); } } if (AccessViewCen) { DataSet dsSubOff = objOff.GetCentersForVillageID(OfficeID); sbrSubOff.Append("<div id='tblCenWrap' class='vil-cent-tbl-wrap'>"); if (!DataUtils.IsDataSetNull(dsSubOff, 0)) { sbrSubOff.Append("<table class='table table-bordered vil-cen-tbl display' id='tblCenters'>"); sbrSubOff.Append("<thead>"); sbrSubOff.Append("<tr>"); sbrSubOff.Append("<th class='off'>Center</th>"); sbrSubOff.Append("<th class='off'>Field Executive</th>"); sbrSubOff.Append("<th class='off'>Meeting Location</th>"); sbrSubOff.Append("<th class='off'>Meeting Time</th>"); sbrSubOff.Append("<th class='off'>Created On</th>"); if (AccessDelCen) { sbrSubOff.Append("<th><i class='icon-cog'></i> Options</th>"); hdnAcD.Value = "1"; } sbrSubOff.Append("</tr>"); sbrSubOff.Append("</thead>"); sbrSubOff.Append("<tbody>"); foreach (DataRow dr in dsSubOff.Tables[0].Rows) { string CenterID = dr["CenterID"].ToString(); string CenterName = "Center " + CenterID; string MeetingLocation = dr["MeetingLocation"].ToString(); string MeetingTime = dr["MeetingTime"].ToString(); string FeName = dr["StaffName"].ToString(); string FeID = dr["StaffID"].ToString(); DateTime CreatedUTC = new DateTime(); string CreatedLocalDate = string.Empty; CreatedUTC = DateTime.SpecifyKind(DateTime.Parse(dr["CreatedDateTime"].ToString()), DateTimeKind.Utc); CreatedLocalDate = TimeZoneInfo.ConvertTimeFromUtc(CreatedUTC, AppSettings.TimeZoneIst).ToDateShortMonth(false, '-'); string SubOffURL = Page.GetRouteUrl(AppRoutes.Center.Name, new { OfficeID = dr["CenterID"].ToString() }); sbrSubOff.Append("<tr id='trCen_" + CenterID + "'>"); sbrSubOff.Append("<td>"); if (int.Parse(CenterID) < 10) { sbrSubOff.Append("<a href='" + SubOffURL + "'>Center 0" + CenterID + "</a>"); } else { sbrSubOff.Append("<a href='" + SubOffURL + "'>Center " + CenterID + "</a>"); } sbrSubOff.Append("</td>"); sbrSubOff.Append("<td><a href='#'>" + FeName + "</a></td>"); sbrSubOff.Append("<td>" + MeetingLocation + "</td>"); sbrSubOff.Append("<td>" + MeetingTime + "</td>"); sbrSubOff.Append("<td>" + CreatedLocalDate + "</td>"); if (AccessDelCen) { sbrSubOff.Append("<td><a class='btn btn-danger btn-mini' id='btnDel_" + CenterID + "'><i class='icon-white icon-trash'></i> Remove Center</a></td>"); } sbrSubOff.Append("</tr>"); } sbrSubOff.Append("</tbody>"); sbrSubOff.Append("</table>"); //uxCenterList.InnerHtml = sbrSubOff.ToString(); } else { //uxCenterList.InnerHtml = UiMsg.PageVillage.NoCenters.ErrorWrap(); sbrSubOff.Append(UiMsg.PageVillage.NoCenters.ErrorWrap()); } sbrSubOff.Append("</div>"); uxCenterList.InnerHtml = sbrAddCen.ToString() + sbrSubOff.ToString(); } else { viewSubOff.InnerHtml = ""; } #endregion build page data } else if (CanAccessOffice == CustEnum.PageAccess.No) { uxOffcontent.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } } //view access else { uxOffcontent.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } } else { Sessions objSession = new Sessions(); objSession.EndSession("&" + AppSettings.QueryStr.SessionExpired.Name + "=" + AppSettings.QueryStr.SessionExpired.Value); } } else { //error uxOffcontent.InnerHtml = UiMsg.Global.NoOfficeExists.ErrorWrap(); } }
protected void Page_Load(object sender, EventArgs e) { string CenterID = null; try { CenterID = (string)Page.RouteData.Values[AppRoutes.Center.ValOfficeID]; } catch (Exception ex) { } if (CenterID != null) { Users objUsr = new Users(); UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails(); string UserID = objUsrDet.UserID; string UserStatusID = objUsrDet.StatusID; string UserRoleID = objUsrDet.RoleID; string UserOfficeID = objUsrDet.OfficeID; string UserOfficeTypeID = objUsrDet.OfficeTypeID; if (UserID != null && UserStatusID == DbSettings.UserStatus.Active) { //see if user has access to this page and if the page is valid CustEnum.PageAccess Access = objUsr.CheckPageAccess(UserRoleID, DbSettings.Menus.Center); if (Access == CustEnum.PageAccess.Yes) { //check for view and edit access DataSet ds = objUsr.GetMenusActionsForRoleID(UserRoleID); List <string> MenuActions = ds.Tables[0].AsEnumerable().Select(r => r[0].ToString()).ToList(); bool AccessView = MenuActions.Contains(DbSettings.AccessCenters.ViewCenterDetails); bool AccessEdit = MenuActions.Contains(DbSettings.AccessCenters.EditCenter); if (AccessView) { Office objOff = new Office(); hdnOid.Value = CenterID; DataSet dsCen = objOff.GetCenterDetails(CenterID); if (!DataUtils.IsDataSetNull(dsCen, 0)) { DataRow drCEn = dsCen.Tables[0].Rows[0]; string CenterName = "Center " + drCEn["CenterID"].ToString(); string MeetingLoc = drCEn["MeetingLocation"].ToString(); string MeetingTime = drCEn["MeetingTime"].ToString(); string FeID = drCEn["StaffID"].ToString(); string CreatedOnLocalDate = string.Empty; DateTime CreatedOnUTC = new DateTime(); CreatedOnUTC = DateTime.SpecifyKind(DateTime.Parse(drCEn["CreatedDateTime"].ToString()), DateTimeKind.Utc); CreatedOnLocalDate = TimeZoneInfo.ConvertTimeFromUtc(CreatedOnUTC, AppSettings.TimeZoneIst).ToDateShortMonth(true, '-'); uxCenterName.InnerHtml = CenterName; uxCreatedOn.InnerHtml = CreatedOnLocalDate; uxMeetingLoc.Value = MeetingLoc; uxMeetingTime.Value = MeetingTime; DataSet dsFE = objOff.GetFeByCenterID(CenterID); if (!DataUtils.IsDataSetNull(dsFE, 0)) { StringBuilder sbrFE = new StringBuilder(); sbrFE.Append("<select id='drpFE' class='cmEditable' disabled='disabled'>"); foreach (DataRow drFE in dsFE.Tables[0].Rows) { if (drFE["UserID"].ToString() == FeID) { sbrFE.Append("<option selected='selected' value='" + drFE["UserID"].ToString() + "'>" + drFE["Name"].ToString() + "</option>"); } else { sbrFE.Append("<option value='" + drFE["UserID"].ToString() + "'>" + drFE["Name"].ToString() + "</option>"); } } sbrFE.Append("</select>"); uxFE.InnerHtml = sbrFE.ToString(); } //get groups DataSet dsGroup = objOff.GetGroupsForCenterID(CenterID); if (!DataUtils.IsDataSetNull(dsGroup, 0)) { StringBuilder sbrGrp = new StringBuilder(); foreach (DataRow drGrp in dsGroup.Tables[0].Rows) { string GroupID = drGrp["GroupID"].ToString(); string GrpFeName = drGrp["StaffName"].ToString(); string GrpFeID = drGrp["StaffID"].ToString(); string GroupStatus = drGrp["GroupStatus"].ToString(); string GroupStatusClass = drGrp["CssClass"].ToString(); string GroupTitleDef = drGrp["TitleString"].ToString(); string GrpCreatedOnLocalDate = string.Empty; DateTime GrpCreatedOnUTC = DateTime.SpecifyKind(DateTime.Parse(drGrp["CreatedDateTime"].ToString()), DateTimeKind.Utc); GrpCreatedOnLocalDate = TimeZoneInfo.ConvertTimeFromUtc(GrpCreatedOnUTC, AppSettings.TimeZoneIst).ToDateShortMonth(false, '-'); string GroupURL = Page.GetRouteUrl(AppRoutes.Groups.Name, new { }) + "?" + AppSettings.QueryStr.Group.Name + "=" + GroupID; sbrGrp.Append("<tr>"); sbrGrp.Append("<td><a href='" + GroupURL + "'>Group " + GroupID + "</a></td>"); sbrGrp.Append("<td><span class='cmGrpStat " + GroupStatusClass + "' title='" + GroupTitleDef + "' >" + GroupStatus + "</span></td>"); sbrGrp.Append("<td><a href='#'>" + GrpFeName + "</a></td>"); sbrGrp.Append("<td>" + GrpCreatedOnLocalDate + "</td>"); sbrGrp.Append("</tr>"); } uxGroupBody.InnerHtml = sbrGrp.ToString(); } else { uxGroups.InnerHtml = UiMsg.Center.NoGroups.ErrorWrap(); } //allow edit only when view is enabled if (!AccessEdit) { uxEditCenter.InnerHtml = ""; } } else { uxCenterWrap.InnerHtml = UiMsg.Center.NoCenterData.ErrorWrap(); } } else { uxCenterWrap.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } } else { uxCenterWrap.InnerHtml = UiMsg.Global.InvalidPage.ErrorWrap(); } } else { uxCenterWrap.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } } }
protected void Page_Load(object sender, EventArgs e) { string PageID = DbSettings.Menus.LoansPending; Users objUsr = new Users(); UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails(); string UserID = objUsrDet.UserID; string UserStatusID = objUsrDet.StatusID; string UserRoleID = objUsrDet.RoleID; string UserOfficeID = objUsrDet.OfficeID; if (UserID != null && UserStatusID == DbSettings.UserStatus.Active) { CustEnum.PageAccess Access = objUsr.CheckPageAccess(UserRoleID, PageID); if (Access == CustEnum.PageAccess.Yes) { DataSet dsLoans = objUsr.GetNewGroupsForUserID(UserID); if (!DataUtils.IsDataSetNull(dsLoans, 0)) { //display the loan count LoanCount.InnerHtml = dsLoans.Tables[0].Rows.Count.ToString(); StringBuilder sbrLoans = new StringBuilder(); sbrLoans.Append("<table class='table table-bordered display' id='tblLoans'>"); sbrLoans.Append("<thead>"); sbrLoans.Append("<tr>"); sbrLoans.Append("<th>Loan</th>"); sbrLoans.Append("<th>Group</th>"); sbrLoans.Append("<th>Applied On</th>"); sbrLoans.Append("<th>Applied By</th>"); sbrLoans.Append("<th>Center</th>"); sbrLoans.Append("<th>Village</th>"); sbrLoans.Append("<th>Branch</th>"); sbrLoans.Append("</tr>"); sbrLoans.Append("</thead>"); sbrLoans.Append("<tbody>"); foreach (DataRow dr in dsLoans.Tables[0].Rows) { string GroupID = dr["GroupID"].ToString(); int DaysAgo; int.TryParse(dr["DaysAgo"].ToString(), out DaysAgo); string DaysPlurality = "Days"; string AppliedBy = dr["GroupStaff"].ToString(); string LoanURL = Page.GetRouteUrl(AppRoutes.DisburseLoans.Name, new { OfficeID = dr["GroupID"].ToString() }); string CenterID = dr["CenterID"].ToString(); string CenterURL = Page.GetRouteUrl(AppRoutes.Center.Name, new { OfficeID = CenterID }); string Village = dr["Village"].ToString(); string VillageURL = Page.GetRouteUrl(AppRoutes.Village.Name, new { OfficeID = dr["VillageID"].ToString() }); string Branch = dr["Branch"].ToString(); string BranchURL = Page.GetRouteUrl(AppRoutes.BranchOffice.Name, new { OfficeID = dr["BranchID"].ToString() }); DateTime AppliedOnUTC = new DateTime(); string AppliedOnLocalDate = string.Empty; AppliedOnUTC = DateTime.SpecifyKind(DateTime.Parse(dr["CreatedDateTime"].ToString()), DateTimeKind.Utc); AppliedOnLocalDate = TimeZoneInfo.ConvertTimeFromUtc(AppliedOnUTC, AppSettings.TimeZoneIst).ToDateShortMonth(false, '-'); sbrLoans.Append("<tr>"); sbrLoans.Append("<td><a class='btn btn-success' href='" + LoanURL + "' >View Loan Form</a></td>"); //the following is for the sake of table sorting where Center 8 > center 10! string GroupURL = Page.GetRouteUrl(AppRoutes.Groups.Name, new { }) + "?" + AppSettings.QueryStr.Group.Name + "=" + GroupID; if (int.Parse(GroupID) < 10) { sbrLoans.Append("<td><a href='" + GroupURL + "'>Group 0" + GroupID + "</a></td>"); } else { sbrLoans.Append("<td><a href='" + GroupURL + "'>Group " + GroupID + "</a></td>"); } if (DaysAgo <= 1) { DaysPlurality = "Day"; } sbrLoans.Append("<td>" + AppliedOnLocalDate + " (" + DaysAgo.ToString() + " " + DaysPlurality + " ago)</td>"); sbrLoans.Append("<td>" + AppliedBy + "</td>"); //the following is for the sake of table sorting where Center 8 > center 10! if (int.Parse(CenterID) < 10) { sbrLoans.Append("<td><a href='" + CenterURL + "'>Center 0" + CenterID + "</a></td>"); } else { sbrLoans.Append("<td><a href='" + CenterURL + "'>Center " + CenterID + "</a></td>"); } sbrLoans.Append("<td><a href='" + VillageURL + "'>" + Village + "</a></td>"); sbrLoans.Append("<td><a href='" + BranchURL + "'>" + Branch + "</a></td>"); sbrLoans.Append("</tr>"); } sbrLoans.Append("</tbody>"); sbrLoans.Append("</table>"); PendingLoans.InnerHtml = sbrLoans.ToString(); } else { PendingLoans.InnerHtml = UiMsg.LoansPending.NoNewLoans.InfoWrap(); } } else { PendingLoans.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } } else { PendingLoans.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } }
protected void Page_Load(object sender, EventArgs e) { string PageID = DbSettings.Menus.LoanProduct; Users objUsr = new Users(); UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails(); string UserID = objUsrDet.UserID; string UserStatusID = objUsrDet.StatusID; string UserRoleID = objUsrDet.RoleID; string UserOfficeID = objUsrDet.OfficeID; string UserOfficeTypeID = objUsrDet.OfficeTypeID; if (UserID != null && UserStatusID == DbSettings.UserStatus.Active) { CustEnum.PageAccess Access = objUsr.CheckPageAccess(UserRoleID, PageID); if (Access == CustEnum.PageAccess.Yes) { //check for privileges DataSet dsAction = objUsr.GetMenusActionsForRoleID(UserRoleID); List <string> MenuActions = dsAction.Tables[0].AsEnumerable().Select(r => r[0].ToString()).ToList(); bool AddLP = MenuActions.Contains(DbSettings.AccessLoanProduct.Add); //bool EditLP = MenuActions.Contains(DbSettings.AccessLoanProduct.Edit); bool DeleteLP = MenuActions.Contains(DbSettings.AccessLoanProduct.Delete); if (!AddLP) { uxAddProduct.InnerHtml = ""; } Loans objLoan = new Loans(); DataSet dsLP = objLoan.GetLoanProducts(null); if (!DataUtils.IsDataSetNull(dsLP, 0)) { StringBuilder sbrLP = new StringBuilder(); foreach (DataRow drGrp in dsLP.Tables[0].Rows) { string ProductID = drGrp["LoanProductID"].ToString(); string ProductName = drGrp["ProductName"].ToString(); string MaxDisbAmnt = drGrp["DefualtAmount"].ToString(); string Interest = drGrp["Interest"].ToString(); string Tenure = drGrp["Tenure"].ToString(); string FundSourceName = drGrp["FundSourceName"].ToString(); string CollectionTypeID = drGrp["CollectionTypeID"].ToString(); string CollectionFrequency = drGrp["CollectionFrequency"].ToString(); string CreatedOnLocalDate = string.Empty; DateTime CreatedOnUTC = DateTime.SpecifyKind(DateTime.Parse(drGrp["CreatedDateTime"].ToString()), DateTimeKind.Utc); CreatedOnLocalDate = TimeZoneInfo.ConvertTimeFromUtc(CreatedOnUTC, AppSettings.TimeZoneIst).ToDateShortMonth(false, '-'); sbrLP.Append("<tr id='LP_" + ProductID + "'>"); sbrLP.Append("<td>" + ProductName + "</td>"); sbrLP.Append("<td>" + MaxDisbAmnt + "</td>"); sbrLP.Append("<td>" + Interest + "</td>"); sbrLP.Append("<td>" + Tenure + "</td>"); sbrLP.Append("<td>" + FundSourceName + "</td>"); if (CollectionTypeID == DbSettings.CollectionType.Monthly) { sbrLP.Append("<td>Monthly</td>"); } else if (CollectionTypeID == DbSettings.CollectionType.Days) { sbrLP.Append("<td>" + CollectionFrequency + " Days </td>"); } sbrLP.Append("<td>" + CreatedOnLocalDate + "</td>"); if (DeleteLP) { sbrLP.Append("<td><a class='btn btn-danger btn-mini' id='btnDel_" + ProductID + "'><i class='icon-white icon-trash'></i> Delete Product</a></td>"); } else { sbrLP.Append("<td>-</td>"); } } uxLpBody.InnerHtml = sbrLP.ToString(); //generate fund source Common objFS = new Common(); DataSet dsFS = objFS.GetFundSource(null); if (!DataUtils.IsDataSetNull(dsFS, 0)) { StringBuilder sbrFS = new StringBuilder(); sbrFS.Append("<select id='drpFS' class='span3'>"); sbrFS.Append("<option value='0'>Select Fund Source</option>"); foreach (DataRow drFS in dsFS.Tables[0].Rows) { string FsID = drFS["FundSourceID"].ToString(); string FundSourceName = drFS["FundSourceName"].ToString(); sbrFS.Append("<option value='" + FsID + "'>" + FundSourceName + "</option>"); } sbrFS.Append("</select>"); uxFundSource.InnerHtml = sbrFS.ToString(); } } else { uxLpContent.InnerHtml = UiMsg.LoanProduct.NoLpData.ErrorWrap(); } } else { uxLpContent.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } } }
protected void Page_Load(object sender, EventArgs e) { string PageID = DbSettings.Menus.LoansPending; Users objUsr = new Users(); UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails(); string UserID = objUsrDet.UserID; string UserStatusID = objUsrDet.StatusID; string UserRoleID = objUsrDet.RoleID; string UserOfficeID = objUsrDet.OfficeID; if (UserID != null && UserStatusID == DbSettings.UserStatus.Active) { CustEnum.PageAccess Access = objUsr.CheckPageAccess(UserRoleID, PageID); if (Access == CustEnum.PageAccess.Yes) { //first, check if the group id is valid. string GroupID = null; try { GroupID = (string)Page.RouteData.Values[AppRoutes.DisburseLoans.ValOfficeID]; } catch (Exception ex) {} if (GroupID != null) { //check the group status to prevent erroneous operations Loans objLoan = new Loans(); DataSet dsLoan = objLoan.GetLafDetails(GroupID); if (!DataUtils.IsDataSetNull(dsLoan, 0)) { DataRow drBasicDetails = dsLoan.Tables[0].Rows[0]; string GroupStatusID = drBasicDetails["GroupStatusID"].ToString(); if (GroupStatusID == DbSettings.GroupStatus.New) { //can proceed hdnGID.Value = GroupID; DateTime AppliedOnUTC = new DateTime(); string AppliedOnLocalDate = string.Empty; AppliedOnUTC = DateTime.SpecifyKind(DateTime.Parse(drBasicDetails["CreatedDateTime"].ToString()), DateTimeKind.Utc); AppliedOnLocalDate = TimeZoneInfo.ConvertTimeFromUtc(AppliedOnUTC, AppSettings.TimeZoneIst).ToDateShortMonth(true, '-'); int DaysAgo; int.TryParse(drBasicDetails["DaysAgo"].ToString(), out DaysAgo); string DaysPlurality = "Days"; if (DaysAgo <= 1) { DaysPlurality = "Day"; } string FE = drBasicDetails["FE"].ToString(); string CenterID = drBasicDetails["CenterID"].ToString(); string CenterURL = Page.GetRouteUrl(AppRoutes.Center.Name, new { OfficeID = CenterID }); string Village = drBasicDetails["VillageName"].ToString(); string VillageURL = Page.GetRouteUrl(AppRoutes.Village.Name, new { OfficeID = drBasicDetails["VillageID"].ToString() }); string Branch = drBasicDetails["BranchName"].ToString(); string BranchURL = Page.GetRouteUrl(AppRoutes.BranchOffice.Name, new { OfficeID = drBasicDetails["BranchID"].ToString() }); string LoanProdID = drBasicDetails["LoanProductID"].ToString(); string LoanProdName = drBasicDetails["LoanProduct"].ToString(); string LoanProdInt = drBasicDetails["Interest"].ToString(); string LoanProdAmnt = drBasicDetails["DefualtAmount"].ToString(); string LoanProdTenure = drBasicDetails["Tenure"].ToString(); string CollectionTypeID = drBasicDetails["CollectionTypeID"].ToString(); string CollectionFrequency = drBasicDetails["CollectionFrequency"].ToString(); //pass vales to ui string GroupURL = Page.GetRouteUrl(AppRoutes.Groups.Name, new { }) + "?" + AppSettings.QueryStr.Group.Name + "=" + GroupID; uxGroupID.InnerHtml = "<a href='" + GroupURL + "'>Group " + GroupID + "</a>"; uxAppliedOn.InnerHtml = AppliedOnLocalDate + " (" + DaysAgo.ToString() + " " + DaysPlurality + " ago)"; uxFE.InnerHtml = FE; uxHierarchy.InnerHtml = "<a href='" + CenterURL + "'>Center " + CenterID + "</a> <i class='icon icon-arrow-right gen-nav-op-1'></i> " + "<a href='" + VillageURL + "'>" + Village + "</a> <i class='icon icon-arrow-right gen-nav-op-1'></i> " + "<a href='" + BranchURL + "'>" + Branch + "</a>"; uxLP.InnerHtml = "<a href='#'>" + LoanProdName + "</a>"; uxLpamnt.InnerHtml = LoanProdAmnt; uxLpInt.InnerHtml = LoanProdInt; uxLpTenure.InnerHtml = LoanProdTenure; hdnCFTID.Value = CollectionTypeID; hdnCFV.Value = CollectionFrequency; //generate client list StringBuilder sbrClients = new StringBuilder(); sbrClients.Append("<tr class='template'>"); sbrClients.Append("<td colspan='3' class='template-info'>Values entered in this row will be copied to all clients <i class='icon-hand-right'></i></td>"); sbrClients.Append("<td><input type='text' class='ldisb-amnt gloAmnt' /></td>"); sbrClients.Append("<td><input readonly='readonly' type='text' class='ldisb-date gloDate cmDisbDate' /></td>"); sbrClients.Append("<td><input readonly='readonly' type='text' class='lfr-date gloFrDate cmFRDate' /></td>"); sbrClients.Append("<td><input type='text' class='span1 gloEMI' /></td>"); sbrClients.Append("<td></td>"); sbrClients.Append("</tr>"); foreach (DataRow dr in dsLoan.Tables[0].Rows) { string ClientName = dr["Name"].ToString(); string ClientID = dr["ClientID"].ToString(); string GroupLeader = dr["IsGroupLeader"].ToString(); string LoanID = dr["LoanID"].ToString(); string PurposeName = dr["PurposeName"].ToString(); string AmntApplied = dr["AmountApplied"].ToString(); sbrClients.Append("<tr class='cmClientRow' id='LN_" + LoanID + "'>"); if (GroupLeader == "1") { sbrClients.Append("<td><a href='#' title='Group Leader' class='label label-info GroupLeader'>" + ClientName + "</a></td>"); } else { sbrClients.Append("<td><a href='#'>" + ClientName + "</a></td>"); } sbrClients.Append("<td>" + PurposeName + "</td>"); sbrClients.Append("<td>" + AmntApplied + "</td>"); sbrClients.Append("<td><input type='text' class='ldisb-amnt cmDisbAmnt' value='" + AmntApplied + "' /></td>"); sbrClients.Append("<td><input readonly='readonly' type='text' class='ldisb-date cmDisbDate' /></td>"); sbrClients.Append("<td><input readonly='readonly' type='text' class='lfr-date cmFRDate' /></td>"); sbrClients.Append("<td><input type='text' class='span1 cmEMI' /></td>"); sbrClients.Append("<td><a id='RPS_" + LoanID + "' class='ldisb-rps-a'>View Schedule</a></td>"); sbrClients.Append("</tr>"); } uxClientList.InnerHtml = sbrClients.ToString(); } else { DisburseLoan.InnerHtml = UiMsg.LoansDisbursement.InvalidStatus.ErrorWrap(); } } else { DisburseLoan.InnerHtml = UiMsg.LoansDisbursement.NoData.ErrorWrap(); } } else { DisburseLoan.InnerHtml = UiMsg.Global.InvalidPage.ErrorWrap(); } } else { DisburseLoan.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } } else { DisburseLoan.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } }
protected void Page_Load(object sender, EventArgs e) { string PageID = DbSettings.Menus.Groups; Users objUsr = new Users(); UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails(); string UserID = objUsrDet.UserID; string UserStatusID = objUsrDet.StatusID; string UserRoleID = objUsrDet.RoleID; string UserOfficeID = objUsrDet.OfficeID; string UserOfficeTypeID = objUsrDet.OfficeTypeID; if (UserID != null && UserStatusID == DbSettings.UserStatus.Active) { CustEnum.PageAccess Access = objUsr.CheckPageAccess(UserRoleID, PageID); if (Access == CustEnum.PageAccess.Yes) { //check for privileges DataSet dsAction = objUsr.GetMenusActionsForRoleID(UserRoleID); List <string> MenuActions = dsAction.Tables[0].AsEnumerable().Select(r => r[0].ToString()).ToList(); bool DeleteGroup = MenuActions.Contains(DbSettings.MenusAction.DeleteGroup); #region generate filters Office objOff = new Office(); bool BranchGenerated = false; //branch StringBuilder sbrBranch = new StringBuilder(); if (int.Parse(UserOfficeTypeID) < int.Parse(DbSettings.OfficeType.BranchOffice)) { //user belongs to a higher office type, so the sp will fetch branches DataSet dsBranch = objOff.GetAllSubOfficeByTypeID(UserOfficeID, DbSettings.OfficeType.BranchOffice); sbrBranch.Append("<select class='span2' id='drpBranch'>"); sbrBranch.Append("<option value='0'>All Branches</option>"); foreach (DataRow drBranch in dsBranch.Tables[0].Rows) { string BranchID = drBranch["OfficeID"].ToString(); string BranchName = drBranch["OfficeName"].ToString(); sbrBranch.Append("<option value='" + BranchID + "'>" + BranchName + "</option>"); } sbrBranch.Append("</select>"); uxDrpBranchWrap.InnerHtml = sbrBranch.ToString(); BranchGenerated = true; } else if (UserOfficeTypeID == DbSettings.OfficeType.BranchOffice) { //user belongs to a branch DataSet dsBranchDetails = objOff.GetOfficeDetails(UserOfficeID); if (!DataUtils.IsDataSetNull(dsBranchDetails, 0)) { sbrBranch.Append("<select disabled='disabled' class='span2' id='drpBranch'>"); string BranchID = dsBranchDetails.Tables[0].Rows[0]["OfficeID"].ToString(); string BranchName = dsBranchDetails.Tables[0].Rows[0]["OfficeName"].ToString(); sbrBranch.Append("<option value='" + BranchID + "'>" + BranchName + "</option>"); sbrBranch.Append("</select>"); uxDrpBranchWrap.InnerHtml = sbrBranch.ToString(); BranchGenerated = true; } } if (BranchGenerated) { //villages DataSet dsVillage = objOff.GetAllSubOfficeByTypeID(UserOfficeID, DbSettings.OfficeType.Village); StringBuilder sbrVillage = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsVillage, 0)) { sbrVillage.Append("<select class='span2' id='drpVillage'>"); sbrVillage.Append("<option class='0' value='0'>All Villages</option>"); foreach (DataRow drVill in dsVillage.Tables[0].Rows) { string VillaID = drVill["OfficeID"].ToString(); string VillName = drVill["OfficeName"].ToString(); string BranchID = drVill["ParentOfficeID"].ToString(); sbrVillage.Append("<option class='" + BranchID + "' value='" + VillaID + "'>" + VillName + "</option>"); } sbrVillage.Append("</select>"); uxDrpVillageWrap.InnerHtml = sbrVillage.ToString(); //centers DataSet dsCen = objOff.GetAllCentersForUserID(UserID); StringBuilder sbrCenter = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsCen, 0)) { sbrCenter.Append("<select class='span2' id='drpCenter'>"); sbrCenter.Append("<option class='0' value='0'>All Centers</option>"); foreach (DataRow dr in dsCen.Tables[0].Rows) { string CenterID = dr["CenterID"].ToString(); string VillageID = dr["ParentOfficeID"].ToString(); sbrCenter.Append("<option class='" + VillageID + "' value='" + CenterID + "'>Center " + CenterID + "</option>"); } sbrCenter.Append("</select>"); uxDrpCenterWrap.InnerHtml = sbrCenter.ToString(); } //center } //village } #endregion DataSet dsGroup = objOff.GetAllGroupsForUserID(UserID); if (!DataUtils.IsDataSetNull(dsGroup, 0)) { #region group list StringBuilder sbrGrp = new StringBuilder(); foreach (DataRow drGrp in dsGroup.Tables[0].Rows) { string GroupID = drGrp["GroupID"].ToString(); string ClassCenter = "cmCenter" + drGrp["CenterID"].ToString(); string ClassVillage = "cmVillage" + drGrp["VillageID"].ToString(); string ClassBranch = "cmBranch" + drGrp["BranchID"].ToString(); string CenterID = drGrp["CenterID"].ToString(); string CenterURL = Page.GetRouteUrl(AppRoutes.Center.Name, new { OfficeID = CenterID }); string Village = drGrp["VillageName"].ToString(); string VillageURL = Page.GetRouteUrl(AppRoutes.Village.Name, new { OfficeID = drGrp["VillageID"].ToString() }); string Branch = drGrp["BranchName"].ToString(); string BranchURL = Page.GetRouteUrl(AppRoutes.BranchOffice.Name, new { OfficeID = drGrp["BranchID"].ToString() }); string GroupLeader = drGrp["GroupLeader"].ToString(); string GroupLeaderID = drGrp["GroupLeaderID"].ToString(); string GrpFeName = drGrp["StaffName"].ToString(); string GrpFeID = drGrp["StaffID"].ToString(); string GroupStatus = drGrp["GroupStatus"].ToString(); string GroupStatusClass = drGrp["CssClass"].ToString(); string GroupTitleDef = drGrp["TitleString"].ToString(); string GrpCreatedOnLocalDate = string.Empty; DateTime GrpCreatedOnUTC = DateTime.SpecifyKind(DateTime.Parse(drGrp["CreatedDateTime"].ToString()), DateTimeKind.Utc); GrpCreatedOnLocalDate = TimeZoneInfo.ConvertTimeFromUtc(GrpCreatedOnUTC, AppSettings.TimeZoneIst).ToDateShortMonth(false, '-'); sbrGrp.Append("<tr id='trGrp_" + GroupID + "' class='" + ClassBranch + " " + ClassVillage + " " + ClassCenter + "'>"); if (int.Parse(GroupID) < 10) { sbrGrp.Append("<td><a href='javascript:void(0)' id='ancGrp_" + GroupID + "'>Group 0" + GroupID + "</a></td>"); } else { sbrGrp.Append("<td><a href='javascript:void(0)' id='ancGrp_" + GroupID + "'>Group " + GroupID + "</a></td>"); } sbrGrp.Append("<td><span class='cmGrpStat " + GroupStatusClass + "' title='" + GroupTitleDef + "' >" + GroupStatus + "</span></td>"); sbrGrp.Append("<td><a href='#'>" + GroupLeader + "</a></td>"); sbrGrp.Append("<td><a href='#'>" + GrpFeName + "</a></td>"); sbrGrp.Append("<td>" + GrpCreatedOnLocalDate + "</td>"); if (int.Parse(CenterID) < 10) { sbrGrp.Append("<td><a href='" + CenterURL + "'>Center 0" + CenterID + "</a></td>"); } else { sbrGrp.Append("<td><a href='" + CenterURL + "'>Center " + CenterID + "</a></td>"); } sbrGrp.Append("<td><a href='" + VillageURL + "'>" + Village + "</a></td>"); sbrGrp.Append("<td><a href='" + BranchURL + "'>" + Branch + "</a></td>"); if (DeleteGroup) { sbrGrp.Append("<td><buutton class='btn btn-danger btn-mini' id='btnDel_" + GroupID + "'><i class='icon-white icon-trash'></i> Delete Group</buutton></td>"); } else { sbrGrp.Append("<td> - </td>"); } sbrGrp.Append("</tr>"); } uxGroupBody.InnerHtml = sbrGrp.ToString(); #endregion group list #region group details DataSet dsGrpCli = objUsr.GetAllGroupDetailsForUserID(UserID); if (!DataUtils.IsDataSetNull(dsGrpCli, 0)) { StringBuilder sbrGrpCli = new StringBuilder(); foreach (DataRow drGrpCli in dsGrpCli.Tables[0].Rows) { string GcGrpID = drGrpCli["GroupID"].ToString(); string GcCliID = drGrpCli["ClientID"].ToString(); string GcCliName = drGrpCli["Name"].ToString(); string GcLoanID = drGrpCli["LoanID"].ToString(); string GcLoanStatus = drGrpCli["LoanStatus"].ToString(); //string GcLPID = drGrpCli["LoanProductID"].ToString(); //string GcLP = drGrpCli["ProductName"].ToString(); sbrGrpCli.Append("<tr class='trGC_" + GcGrpID + "'>"); sbrGrpCli.Append("<td><a href='#'>" + GcCliName + "</a></td>"); sbrGrpCli.Append("<td><a href='#'>Loan " + GcLoanID + "</a></td>"); sbrGrpCli.Append("<td>" + GcLoanStatus + "</td>"); sbrGrpCli.Append("</tr>"); } uxGCBody.InnerHtml = sbrGrpCli.ToString(); } #endregion group details } else { uxGroups.InnerHtml = UiMsg.Center.NoGroups.ErrorWrap(); } } else { uxCentContent.InnerHtml = UiMsg.Global.NoPageAccess.ErrorWrap(); } } }
protected void Page_Load(object sender, EventArgs e) { string PageID = DbSettings.Menus.LAF; Users objUsr = new Users(); UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails(); string UserID = objUsrDet.UserID; string UserStatusID = objUsrDet.StatusID; string UserRoleID = objUsrDet.RoleID; string UserOfficeID = objUsrDet.OfficeID; if (UserID != null && UserStatusID == DbSettings.UserStatus.Active) { CustEnum.PageAccess Access = objUsr.CheckPageAccess(UserRoleID, PageID); if (Access == CustEnum.PageAccess.Yes) { Office objOff = new Office(); Loans objLoan = new Loans(); DataSet dsOff = objOff.GetAllSubOfficeByTypeID(UserOfficeID, DbSettings.OfficeType.Village); StringBuilder sbrVillage = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsOff, 0)) { sbrVillage.Append("<select class='span2' id='drpVillage'>"); sbrVillage.Append("<option value='0'>Select Village</option>"); foreach (DataRow dr in dsOff.Tables[0].Rows) { string OffID = dr["OfficeID"].ToString(); string OffName = dr["OfficeName"].ToString(); string ParentID = dr["ParentOfficeID"].ToString(); sbrVillage.Append("<option class='" + ParentID + "' value='" + OffID + "'>" + OffName + "</option>"); } sbrVillage.Append("</select>"); drpVillageWrap.InnerHtml = sbrVillage.ToString(); DataSet dsCen = objOff.GetAllCentersForUserID(UserID); StringBuilder sbrCenter = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsCen, 0)) { sbrCenter.Append("<select class='span2' id='drpCenter'>"); sbrCenter.Append("<option value='0'>Select Center</option>"); foreach (DataRow dr in dsCen.Tables[0].Rows) { string CenterID = dr["CenterID"].ToString(); string VillageID = dr["ParentOfficeID"].ToString(); sbrCenter.Append("<option class='" + VillageID + "' value='" + CenterID + "'>Center " + CenterID + "</option>"); } sbrCenter.Append("</select>"); drpCenterWrap.InnerHtml = sbrCenter.ToString(); } //center } //village DataSet dsLP = objLoan.GetLoanProducts(null); StringBuilder sbrLP = new StringBuilder(); StringBuilder sbrLpDet = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsLP, 0)) { sbrLP.Append("<select class='span2' id='drpLP'>"); sbrLP.Append("<option value='0'>Select</option>"); foreach (DataRow dr in dsLP.Tables[0].Rows) { string LPID = dr["LoanProductID"].ToString(); string ProductName = dr["ProductName"].ToString(); string DefualtAmount = dr["DefualtAmount"].ToString(); string Interest = dr["Interest"].ToString(); string Tenure = dr["Tenure"].ToString(); sbrLP.Append("<option value='" + LPID + "'>" + ProductName + "</option>"); sbrLpDet.Append("<tr id='" + LPID + "' style='display:none'>"); sbrLpDet.Append("<td>" + ProductName + "</td>"); sbrLpDet.Append("<td>" + DefualtAmount + "</td>"); sbrLpDet.Append("<td>" + Interest + "</td>"); sbrLpDet.Append("<td>" + Tenure + "</td>"); sbrLpDet.Append("</tr>"); } sbrLP.Append("</select>"); drpLpWrap.InnerHtml = sbrLP.ToString(); lpDetailsBody.InnerHtml = sbrLpDet.ToString(); DataSet dsLoanCycle = objLoan.GetLoanCycles(null); StringBuilder sbrCycle = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsLoanCycle, 0)) { foreach (DataRow dr in dsLoanCycle.Tables[0].Rows) { string LoanProductID = dr["LoanProductID"].ToString(); string Cycle = dr["Cycle"].ToString(); string MinValue = dr["MinValue"].ToString(); string MaxValue = dr["MaxValue"].ToString(); sbrCycle.Append("<tr class='LC_" + LoanProductID + " hide'>"); sbrCycle.Append("<td>" + Cycle + "</td>"); sbrCycle.Append("<td>" + MinValue + "</td>"); sbrCycle.Append("<td>" + MaxValue + "</td>"); sbrCycle.Append("</tr>"); } lcBody.InnerHtml = sbrCycle.ToString(); } } //lp DataSet dsFE = objUsr.GetAllFeForUserID(UserID); StringBuilder sbrFE = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsFE, 0)) { sbrFE.Append("<select class='span2' id='drpFE'>"); sbrFE.Append("<option value='0'>Select</option>"); foreach (DataRow dr in dsFE.Tables[0].Rows) { string FEID = dr["UserID"].ToString(); string FeName = dr["Name"].ToString(); string OfficeID = dr["OfficeID"].ToString(); sbrFE.Append("<option class='" + OfficeID + "' value='" + FEID + "'>" + FeName + "</option>"); } sbrFE.Append("</select>"); drpFeWrap.InnerHtml = sbrFE.ToString(); } //fe DataSet dsPurp = objLoan.GetLoanPurpose(); StringBuilder sbrPurp = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsPurp, 0)) { sbrPurp.Append("<select class='lp' id='drpLoanPurpose'>"); //sbrPurp.Append("<option value='0'>Select</option>"); foreach (DataRow dr in dsPurp.Tables[0].Rows) { string PurpID = dr["LoanPurposeID"].ToString(); string PurpName = dr["PurposeName"].ToString(); sbrPurp.Append("<option value='" + PurpID + "'>" + PurpName + "</option>"); } sbrPurp.Append("</select>"); drpLoanPurposeWrap.InnerHtml = sbrPurp.ToString(); } //purpose DataSet dsCli = objUsr.GetLoanEligClientsForUserID(UserID); StringBuilder sbrCli = new StringBuilder(); if (!DataUtils.IsDataSetNull(dsCli, 0)) { sbrCli.Append("<select class='name' id='drpClients'>"); sbrCli.Append("<option value='0'>Select</option>"); foreach (DataRow dr in dsCli.Tables[0].Rows) { string ClientID = dr["ClientID"].ToString(); string Name = dr["Name"].ToString(); string VillageID = dr["VillageID"].ToString(); sbrCli.Append("<option class='" + VillageID + "' value='" + ClientID + "'>" + Name + "</option>"); } sbrCli.Append("</select>"); drpCliWrap.InnerHtml = sbrCli.ToString(); } //purpose } } }