public List <CardViewPropeties> GetCardView(int ad_Window_ID, int ad_Tab_ID, Ctx ctx)
{
List <CardViewPropeties> lstCardView = null;
//string sqlQuery = "SELECT * FROM AD_CardView WHERE AD_Window_id=" + ad_Window_ID + " and AD_Tab_id=" + ad_Tab_ID + " AND (createdby=" + ctx.GetAD_User_ID() + " OR AD_USER_ID Is NULL OR AD_User_ID = " + ctx.GetAD_User_ID() + ") AND AD_Client_ID=" + ctx.GetAD_Client_ID();
string sqlQuery = " SELECT * FROM AD_CardView c WHERE c.AD_Window_id=" + ad_Window_ID + " and c.AD_Tab_id=" + ad_Tab_ID + " AND (c.createdby=" + ctx.GetAD_User_ID() +
" OR ((c.AD_USER_ID IS NULL) AND exists (select * from ad_cardview_role r where r.ad_cardview_id = c.ad_cardview_id and r.ad_role_id = " + ctx.GetAD_Role_ID() + ")) OR c.AD_User_ID = " + ctx.GetAD_User_ID() +
" ) AND c.AD_Client_ID =" + ctx.GetAD_Client_ID();
DataSet ds = DB.ExecuteDataset(sqlQuery);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
lstCardView = new List <CardViewPropeties>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CardViewPropeties objCardView = new CardViewPropeties()
{
CardViewName = Convert.ToString(ds.Tables[0].Rows[i]["NAME"]),
CardViewID = Convert.ToInt32(ds.Tables[0].Rows[i]["AD_CardView_ID"]),
UserID = VAdvantage.Utility.Util.GetValueOfInt(ds.Tables[0].Rows[i]["AD_USER_ID"]),
AD_GroupField_ID = VAdvantage.Utility.Util.GetValueOfInt(ds.Tables[0].Rows[i]["AD_FIELD_ID"])
};
lstCardView.Add(objCardView);
}
}
return(lstCardView);
}
public List <CardViewPropeties> GetCardView(int ad_Window_ID, int ad_Tab_ID, Ctx ctx)
{
List <CardViewPropeties> lstCardView = null;
//string sqlQuery = "SELECT * FROM AD_CardView WHERE AD_Window_id=" + ad_Window_ID + " and AD_Tab_id=" + ad_Tab_ID + " AND (createdby=" + ctx.GetAD_User_ID() + " OR AD_USER_ID Is NULL OR AD_User_ID = " + ctx.GetAD_User_ID() + ") AND AD_Client_ID=" + ctx.GetAD_Client_ID();
//string sqlQuery = " SELECT * FROM AD_CardView c WHERE c.AD_Window_id=" + ad_Window_ID + " and c.AD_Tab_id=" + ad_Tab_ID + " AND (c.createdby=" + ctx.GetAD_User_ID() +
// " OR ((c.AD_USER_ID IS NULL) AND exists (select * from ad_cardview_role r where r.ad_cardview_id = c.ad_cardview_id and r.ad_role_id = " + ctx.GetAD_Role_ID() + ")) OR c.AD_User_ID = " + ctx.GetAD_User_ID() +
// " ) AND c.AD_Client_ID =" + ctx.GetAD_Client_ID();
// string sqlQuery = " SELECT * FROM AD_CardView c WHERE c.AD_Window_id=" + ad_Window_ID + " and c.AD_Tab_id=" + ad_Tab_ID + " AND c.AD_Client_ID =" + ctx.GetAD_Client_ID();
string sqlQuery = @"SELECT AD_CardView.*,AD_DefaultCardView.AD_DefaultCardView_ID,AD_DefaultCardView.AD_User_ID as userID
FROM AD_CardView
LEFT OUTER JOIN AD_DefaultCardView
ON AD_CardView.AD_CardView_ID=AD_DefaultCardView.AD_CardView_ID
WHERE AD_CardView.AD_Window_id=" + ad_Window_ID + " and AD_CardView.AD_Tab_id=" + ad_Tab_ID + " AND AD_CardView.AD_Client_ID =" + ctx.GetAD_Client_ID() + @"
ORDER BY AD_CardView.Name Asc";
DataSet ds = DB.ExecuteDataset(sqlQuery);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
lstCardView = new List <CardViewPropeties>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
bool isDefault = false;
if (ds.Tables[0].Rows[i]["AD_DefaultCardView_ID"] != null && ds.Tables[0].Rows[i]["AD_DefaultCardView_ID"] != DBNull.Value &&
ds.Tables[0].Rows[i]["userID"] != null && ds.Tables[0].Rows[i]["userID"] != DBNull.Value &&
ctx.GetAD_User_ID() == Util.GetValueOfInt(ds.Tables[0].Rows[i]["userID"]))
{
isDefault = true;
}
CardViewPropeties objCardView = new CardViewPropeties()
{
CardViewName = Convert.ToString(ds.Tables[0].Rows[i]["NAME"]),
CardViewID = Convert.ToInt32(ds.Tables[0].Rows[i]["AD_CardView_ID"]),
UserID = VAdvantage.Utility.Util.GetValueOfInt(ds.Tables[0].Rows[i]["AD_USER_ID"]),
AD_GroupField_ID = VAdvantage.Utility.Util.GetValueOfInt(ds.Tables[0].Rows[i]["AD_FIELD_ID"]),
CreatedBy = Convert.ToInt32(ds.Tables[0].Rows[i]["CREATEDBY"]),
DefaultID = isDefault
};
lstCardView.Add(objCardView);
}
}
return(lstCardView);
}
public List <CardViewPropeties> GetCardViewColumns(int ad_cardview_id, Ctx ctx)
{
int uid = 0;
int fid = 0;
List <CardViewPropeties> lstCardViewColumns = new List <CardViewPropeties>();
string sqlQuery1 = "SELECT AD_User_ID,AD_Field_ID FROM AD_CardView WHERE ad_cardview_id=" + ad_cardview_id;
DataSet ds1 = DB.ExecuteDataset(sqlQuery1);
if (ds1 != null && ds1.Tables.Count > 0 && ds1.Tables[0].Rows.Count > 0)
{
uid = VAdvantage.Utility.Util.GetValueOfInt(ds1.Tables[0].Rows[0][0]);
fid = VAdvantage.Utility.Util.GetValueOfInt(ds1.Tables[0].Rows[0][1]);
}
string sqlQuery = "SELECT * FROM(SELECT crdcol.*,fl.name FROM ad_cardview_column crdcol INNER JOIN ad_field fl on crdcol.ad_field_id=fl.ad_field_id WHERE ad_cardview_id=" + ad_cardview_id + ") cardviewcols";
sqlQuery = MRole.GetDefault(ctx).AddAccessSQL(sqlQuery, "cardviewcols", false, false);
sqlQuery += " ORDER BY seqno";
DataSet ds = DB.ExecuteDataset(sqlQuery);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CardViewPropeties objCardView = new CardViewPropeties()
{
FieldName = Convert.ToString(ds.Tables[0].Rows[i]["NAME"]),
AD_Field_ID = Convert.ToInt32(ds.Tables[0].Rows[i]["AD_FIELD_ID"]),
AD_GroupField_ID = fid,
UserID = uid
};
lstCardViewColumns.Add(objCardView);
}
}
else
{
CardViewPropeties objCardView = new CardViewPropeties()
{
FieldName = "",
AD_Field_ID = 0,
AD_GroupField_ID = fid,
UserID = uid
};
lstCardViewColumns.Add(objCardView);
}
return(lstCardViewColumns);
}
