public LandingPublishDO GetLandingPublish(int accountId, int accountTypeId, int version)
{
LandingPublishDO lp = null;
DataTable dtLandingPublish = _objLandingDAL.GetLandingPublish(accountId, accountTypeId);
if (dtLandingPublish.Rows.Count > 0)
{
lp = new LandingPublishDO();
lp.PublishId = Convert.ToInt32(dtLandingPublish.Rows[0]["PublishId"]);
lp.AccountId = Convert.ToInt32(dtLandingPublish.Rows[0]["AccountId"]);
lp.AccountTypeId = Convert.ToInt32(dtLandingPublish.Rows[0]["AccountTypeId"]);
lp.BannerId = Convert.ToInt32(dtLandingPublish.Rows[0]["BannerId"]);
lp.DefaultVersion = Convert.ToInt32(dtLandingPublish.Rows[0]["DefaultVersion"]);
if (version == 0)
{
version = 1; //lp.DefaultVersion;
}
DataTable dtLanding = _objLandingDAL.GetLanding(lp.PublishId, version);
LandingDO l = new LandingDO();
if (dtLanding.Rows.Count > 0)
{
l.LandingId = Convert.ToInt32(dtLanding.Rows[0]["LandingId"]);
l.PublishId = Convert.ToInt32(dtLanding.Rows[0]["PublishId"]);
l.DepartmentId = (String.IsNullOrEmpty(dtLanding.Rows[0]["DepartmentId"].ToString())) ? 0 : Convert.ToInt32(dtLanding.Rows[0]["DepartmentId"]);
l.Forms = dtLanding.Rows[0]["Forms"].ToString();
//l.CreatedOn = Convert.ToDateTime(dtLanding.Rows[0]["CreatedOn"]);
//l.ModifiedOn = Convert.ToDateTime(dtLanding.Rows[0]["ModifiedOn"]);
l.Version = Convert.ToInt32(dtLanding.Rows[0]["Version"]);
l.MainTabs = new List <MainTabDO>();
lp.Landing = l;
DataTable dtMainTabs = _objLandingDAL.GetMainTabs(l.LandingId);
MainTabDO m;
foreach (DataRow dr in dtMainTabs.Rows)
{
m = new MainTabDO();
m.MainTabId = Convert.ToInt32(dr["MainTabId"]);
m.MainTabName = dr["MainTabName"].ToString();
m.MainTabContent = dr["MainTabContent"].ToString();
m.LandingId = Convert.ToInt32(dr["LandingId"]);
m.SubTabs = new List <SubTabDO>();
DataTable dtSubTabs = _objLandingDAL.GetSubTabs(m.MainTabId);
SubTabDO s;
foreach (DataRow subdr in dtSubTabs.Rows)
{
s = new SubTabDO();
s.SubTabId = Convert.ToInt32(subdr["SubTabId"]);
s.SubTabName = subdr["SubTabName"].ToString();
s.SubTabContent = subdr["SubTabContent"].ToString();
s.MainTabId = Convert.ToInt32(subdr["MainTabId"]);
m.SubTabs.Add(s);
}
l.MainTabs.Add(m);
}
}
else
{
lp.Landing = null;
}
}
return(lp);
}
public LandingPublishDO GetLandingPublish(int accountId, int accountTypeId, int version)
{
LandingPublishDO lp = null;
DataTable dtLandingPublish = _objLandingDAL.GetLandingPublish(accountId, accountTypeId);
if (dtLandingPublish.Rows.Count > 0)
{
lp = new LandingPublishDO();
lp.PublishId = Convert.ToInt32(dtLandingPublish.Rows[0]["PublishId"]);
lp.AccountId = Convert.ToInt32(dtLandingPublish.Rows[0]["AccountId"]);
lp.AccountTypeId = Convert.ToInt32(dtLandingPublish.Rows[0]["AccountTypeId"]);
lp.BannerId = Convert.ToInt32(dtLandingPublish.Rows[0]["BannerId"]);
lp.DefaultVersion = Convert.ToInt32(dtLandingPublish.Rows[0]["DefaultVersion"]);
if (version == 0)
version = 1; //lp.DefaultVersion;
DataTable dtLanding = _objLandingDAL.GetLanding(lp.PublishId, version);
LandingDO l = new LandingDO();
if (dtLanding.Rows.Count > 0)
{
l.LandingId = Convert.ToInt32(dtLanding.Rows[0]["LandingId"]);
l.PublishId = Convert.ToInt32(dtLanding.Rows[0]["PublishId"]);
l.DepartmentId = (String.IsNullOrEmpty(dtLanding.Rows[0]["DepartmentId"].ToString())) ? 0 : Convert.ToInt32(dtLanding.Rows[0]["DepartmentId"]);
l.Forms = dtLanding.Rows[0]["Forms"].ToString();
//l.CreatedOn = Convert.ToDateTime(dtLanding.Rows[0]["CreatedOn"]);
//l.ModifiedOn = Convert.ToDateTime(dtLanding.Rows[0]["ModifiedOn"]);
l.Version = Convert.ToInt32(dtLanding.Rows[0]["Version"]);
l.MainTabs = new List<MainTabDO>();
lp.Landing = l;
DataTable dtMainTabs = _objLandingDAL.GetMainTabs(l.LandingId);
MainTabDO m;
foreach (DataRow dr in dtMainTabs.Rows)
{
m = new MainTabDO();
m.MainTabId = Convert.ToInt32(dr["MainTabId"]);
m.MainTabName = dr["MainTabName"].ToString();
m.MainTabContent = dr["MainTabContent"].ToString();
m.LandingId = Convert.ToInt32(dr["LandingId"]);
m.SubTabs = new List<SubTabDO>();
DataTable dtSubTabs = _objLandingDAL.GetSubTabs(m.MainTabId);
SubTabDO s;
foreach (DataRow subdr in dtSubTabs.Rows)
{
s = new SubTabDO();
s.SubTabId = Convert.ToInt32(subdr["SubTabId"]);
s.SubTabName = subdr["SubTabName"].ToString();
s.SubTabContent = subdr["SubTabContent"].ToString();
s.MainTabId = Convert.ToInt32(subdr["MainTabId"]);
m.SubTabs.Add(s);
}
l.MainTabs.Add(m);
}
}
else
{
lp.Landing = null;
}
}
return lp;
}