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;
}
