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
{ }
}
private void FillDataTableWithRequiredData(DataTable myDataTable)
{
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 virtualmobilepath = "";
string UsedForms = "";
string FormNameList = "";
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"]);
//virtualmobilepath=Convert.ToString(ds.Tables[0].Rows[i]["virtualmobilepath"]);
DataSet ds2 = new DataSet();
ds2 = objB.CheckUsedDefaultBanner(BId);
if (ds2.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < ds2.Tables[0].Rows.Count; j++)
{
if (j == 4 || j == 8 || j == 12 || j == 16 || j == 20 || j == 24 || j == 28 || j == 32 || j == 36 || j == 40 || j == 44)
{
FormNameList = FormNameList + Convert.ToString(ds2.Tables[0].Rows[j]["pageName"]) + "," + "<br/>";
}
else
{
FormNameList = FormNameList + Convert.ToString(ds2.Tables[0].Rows[j]["pageName"]) + ",";
}
if (FormNameList == "ContactUs_Unregister")
{
FormNameList = "ContactUs1";
}
if (FormNameList == "Service_Unregister")
{
FormNameList = "Services1";
}
}
}
if (FormNameList.Length == 0)
{
FormNameList = "NOT IN USE";
}
else
{
FormNameList = FormNameList.Remove(FormNameList.Length - 1);
}
//if (FormNameList.Length > 50)
//{
// FormNameList = FormNameList.Substring(0, 50) + " <br />" + FormNameList.Substring(50) + "<br />" + FormNameList.Substring(100);
//}
UsedForms = FormNameList;
AddDataToTable(Convert.ToString(BannerId), BannerName, BannerPath, UsedForms, myDataTable, Convert.ToString(BId), virtualmobilepath);
}
}
}
