private void FillDataTableWithRequiredData(DataTable myDataTable)
{
try
{
DataSet ds = new DataSet();
DataSet dsDefault = new DataSet();
Banner objB = new Banner();
ds = objB.GetBannerList();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int BannerId = 0;
int BId = 0;
string BannerName = "";
string BannerPath = "";
string UsedForms = "";
string virtualmobilepath = "";
BId = Convert.ToInt32(ds.Tables[0].Rows[i]["BId"]);
BannerId = Convert.ToInt32(ds.Tables[0].Rows[i]["BannerId"]);
BannerName = Convert.ToString(ds.Tables[0].Rows[i]["BannerName"]);
BannerPath = Convert.ToString(ds.Tables[0].Rows[i]["BannerPath"]);
virtualmobilepath = Convert.ToString(ds.Tables[0].Rows[i]["virtualmobilepath"]);
//Find Set Banner
DataSet ds1 = new DataSet();
ds1 = objB.CheckUsedBannerList(BannerId);
string FormNameList = "";
if (ds1.Tables[0].Rows.Count > 0)
{
for (int k = 0; k < ds1.Tables[0].Rows.Count; k++)
{
string pgNm = "";
pgNm = Convert.ToString(ds1.Tables[0].Rows[k]["pageName"]);
FormNameList = FormNameList + ", " + pgNm;
}
FormNameList = FormNameList.Remove(0, 1);
}
//Find is Banner Set Default For any Form
DataSet ds2 = new DataSet();
ds2 = objB.CheckUsedDefaultBanner(BannerId);
if (ds2.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < ds2.Tables[0].Rows.Count; j++)
{
FormNameList = FormNameList + ", Default-" + Convert.ToString(ds2.Tables[0].Rows[j]["pageName"]);
}
}
if (FormNameList.Length == 0)
{
FormNameList = "NOT IN USE";
}
UsedForms = FormNameList;
AddDataToTable(Convert.ToString(BannerId), BannerName, BannerPath, UsedForms, myDataTable, Convert.ToString(BId), virtualmobilepath);
}
}
}
catch
{ }
}
