public bool checkBranchRole() { bool result = false; adminTableAdapters.tbl_secondary_rolesTableAdapter roles = new adminTableAdapters.tbl_secondary_rolesTableAdapter(); admin.tbl_secondary_rolesDataTable tblroles = roles.GetRoleID(MySessionManager.CurrentUser.UserID); if (tblroles.Rows.Count > 0) { for (int i = 0; i < tblroles.Count; i++) { if (tblroles[i].datRoleID == 10 || tblroles[i].datRoleID == 11 || tblroles[i].datRoleID == 12) { return(result = true); } } } return(result); }
protected void btnSaveRole_Click(object sender, EventArgs e) { try { if (Request.QueryString["id"] != null) { int id = Convert.ToInt32(MyEncryption.Decrypt(Request.QueryString["id"], "123456789")); adminTableAdapters.tbl_secondary_rolesTableAdapter role = new adminTableAdapters.tbl_secondary_rolesTableAdapter(); int?ct = null; if (ddlCreditTeam.SelectedValue != "0") { ct = Convert.ToInt32(ddlCreditTeam.SelectedValue); } role.Insert(id, Convert.ToInt32(ddlPosition.SelectedValue), ddlPosition.SelectedItem.Text, ct, Convert.ToInt32(ddlBranch.SelectedValue) ); } } catch (Exception ex) { } }
public bool RoleExist(int role) { bool result = false; //string[] mroles; try { adminTableAdapters.tbl_secondary_rolesTableAdapter roles = new adminTableAdapters.tbl_secondary_rolesTableAdapter(); admin.tbl_secondary_rolesDataTable tblroles = roles.GetRoleID(MySessionManager.CurrentUser.UserID); if (tblroles.Rows.Count > 0) { //mroles = new string[tblroles.Count]; for (int i = 0; i < tblroles.Count; i++) { if (tblroles[i].datRoleID == role) { result = true; } } } } catch (Exception ex) { } return(result); }
protected void btnSaveRole_Click(object sender, EventArgs e) { try { if (Request.QueryString["id"] != null) { int id = Convert.ToInt32(MyEncryption.Decrypt(Request.QueryString["id"], "123456789")); adminTableAdapters.tbl_secondary_rolesTableAdapter role = new adminTableAdapters.tbl_secondary_rolesTableAdapter(); int? ct = null; if(ddlCreditTeam.SelectedValue!="0") { ct = Convert.ToInt32(ddlCreditTeam.SelectedValue); } role.Insert(id, Convert.ToInt32(ddlPosition.SelectedValue), ddlPosition.SelectedItem.Text, ct, Convert.ToInt32(ddlBranch.SelectedValue) ); } } catch (Exception ex) { } }
public string getCTPartQuery(int userID) { string qry = ""; try{ adminTableAdapters.tbl_secondary_rolesTableAdapter roles = new adminTableAdapters.tbl_secondary_rolesTableAdapter(); admin.tbl_secondary_rolesDataTable tblroles = roles.GetRoleID(MySessionManager.CurrentUser.UserID); if (tblroles.Rows.Count > 0) { for (int i = 0; i < tblroles.Count; i++) { if (tblroles[i].datRoleID == 2) { qry += "AND tbl_loan_application.datCreditTeamID=" + tblroles[i].datTeamID.ToString() + ""; } } } }catch (Exception ex) { qry = ""; } if (qry == null || qry == "") { qry = " AND 0=1 "; } return(qry); }
public string getCTPartQuery(int userID) { string qry=""; try{ adminTableAdapters.tbl_secondary_rolesTableAdapter roles = new adminTableAdapters.tbl_secondary_rolesTableAdapter(); admin.tbl_secondary_rolesDataTable tblroles = roles.GetRoleID(MySessionManager.CurrentUser.UserID); if (tblroles.Rows.Count > 0) { for (int i = 0; i < tblroles.Count; i++) { if (tblroles[i].datRoleID == 2) { qry+="AND tbl_loan_application.datCreditTeamID="+ tblroles[i].datTeamID.ToString() +""; } } } }catch(Exception ex){qry="";} if (qry == null || qry == "") { qry = " AND 0=1 "; } return qry; }
public bool checkBranchRole() { bool result = false; adminTableAdapters.tbl_secondary_rolesTableAdapter roles = new adminTableAdapters.tbl_secondary_rolesTableAdapter(); admin.tbl_secondary_rolesDataTable tblroles = roles.GetRoleID(MySessionManager.CurrentUser.UserID); if (tblroles.Rows.Count > 0) { for (int i = 0; i < tblroles.Count; i++) { if (tblroles[i].datRoleID == 10 || tblroles[i].datRoleID == 11 || tblroles[i].datRoleID == 12) { return (result = true); } } } return result; }
public bool RoleExist(int role) { bool result = false; //string[] mroles; try { adminTableAdapters.tbl_secondary_rolesTableAdapter roles = new adminTableAdapters.tbl_secondary_rolesTableAdapter(); admin.tbl_secondary_rolesDataTable tblroles = roles.GetRoleID(MySessionManager.CurrentUser.UserID); if (tblroles.Rows.Count > 0) { //mroles = new string[tblroles.Count]; for (int i = 0; i < tblroles.Count; i++) { if (tblroles[i].datRoleID == role) { result = true; } } } } catch (Exception ex) { } return result; }