public List <RolePropeties> GetAllRoles(Ctx ctx)
{
List <RolePropeties> lstRole = null;
string sqlQuery = "SELECT r.AD_Role_ID, r.Name FROM AD_User u INNER JOIN AD_User_Roles ur ON (u.AD_User_ID=ur.AD_User_ID AND ur.IsActive ='Y') " +
" INNER JOIN AD_Role r ON (ur.AD_Role_ID =r.AD_Role_ID AND r.IsActive ='Y') WHERE u.AD_User_ID = " + ctx.GetAD_User_ID() + " AND u.IsActive ='Y' AND EXISTS " +
" (SELECT * FROM AD_Client c WHERE u.AD_Client_ID=c.AD_Client_ID AND c.IsActive ='Y' ) " +
" AND EXISTS (SELECT * FROM AD_Client c WHERE r.AD_Client_ID=c.AD_Client_ID AND c.IsActive ='Y' )";
DataSet ds = DB.ExecuteDataset(sqlQuery);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
lstRole = new List <RolePropeties>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
RolePropeties objCardView = new RolePropeties()
{
RoleName = Convert.ToString(ds.Tables[0].Rows[i]["NAME"]),
AD_Role_ID = Convert.ToInt32(ds.Tables[0].Rows[i]["AD_Role_ID"])
};
lstRole.Add(objCardView);
}
}
return(lstRole);
}
public List <RolePropeties> GetCardViewRole(int ad_CardView_ID, Ctx ctx)
{
List <RolePropeties> lstCardViewRole = null;
RolePropeties objCardView = null;
string sqlQuery = "SELECT AD_ROLE_ID,AD_CardView_ID from AD_CARDVIEW_ROLE WHERE AD_CardView_id=" + ad_CardView_ID + " AND AD_Client_ID=" + ctx.GetAD_Client_ID();
// string sqlQuery = "SELECT * FROM AD_CardView WHERE AD_Window_id=" + ad_Window_ID + " and AD_Tab_id=" + ad_Tab_ID + " AND (AD_USER_ID=" + ctx.GetAD_User_ID() + " OR AD_USER_ID Is NULL )" ;
// sqlQuery = MRole.GetDefault(ctx).AddAccessSQL(sqlQuery, "AD_CardView", false, false);
DataSet ds = DB.ExecuteDataset(sqlQuery);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
lstCardViewRole = new List <RolePropeties>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
objCardView = new RolePropeties()
{
AD_Role_ID = VAdvantage.Utility.Util.GetValueOfInt(ds.Tables[0].Rows[i]["AD_Role_ID"]),
AD_CardView_ID = VAdvantage.Utility.Util.GetValueOfInt(ds.Tables[0].Rows[i]["AD_CardView_ID"])
};
lstCardViewRole.Add(objCardView);
}
}
return(lstCardViewRole);
}
