private bool LoadNavigation(GeneralSessionInfo gsi, SqlConnection con)
{
SqlDataAdapter sqlDataAdapter;
DataSet dataSet = new DataSet();
List <Field> ret = new List <Field>();
SqlCommand sql = new SqlCommand("GetNavigation", con);
sql.CommandType = CommandType.StoredProcedure;
sql.Parameters.Add(new SqlParameter("NavID", Page.SideMenu.NavID));
sql.Parameters.Add(new SqlParameter("LanguageID", gsi.languageID));
sql.Parameters.Add(new SqlParameter("UserID", gsi.userID));
try
{
sqlDataAdapter = new SqlDataAdapter(sql);
sqlDataAdapter.Fill(dataSet);
if (dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)
{
Page.SideMenu.ProcessNavigation(dataSet.Tables[0]);
}
else
{
//Page.GenerateUnknownPageInfo();
Console.WriteLine("No matching records found.");
}
}
catch (Exception eee)
{
ret.Add(new LabelTextAreaField("1", "Exception in LoadNavigation(..)", eee.ToString()));
}
return(false);
}
private bool LoadPanelsInfo(GeneralSessionInfo gsi, SqlConnection con, int ProjectID, int PageID)
{
SqlDataAdapter sqlDataAdapter;
DataSet dataSet = new DataSet();
List <TempMultiSelectItem> AllMultiSelectItem = new List <TempMultiSelectItem>();
List <Field> ret = new List <Field>();
SqlCommand sql = new SqlCommand("GetPanelsInfo", con);
sql.CommandType = CommandType.StoredProcedure;
sql.Parameters.Add(new SqlParameter("RetailerID", gsi.retailerID));
sql.Parameters.Add(new SqlParameter("PageID", PageID));
sql.Parameters.Add(new SqlParameter("LanguageID", gsi.languageID));
try
{
sqlDataAdapter = new SqlDataAdapter(sql);
sqlDataAdapter.Fill(dataSet);
if (dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)
{
Page.ProcessPanelsInfo(dataSet.Tables[0]);
}
else
{
Page.GenerateUnknownPageInfo();
Console.WriteLine("No matching records found.");
}
}
catch (Exception eee)
{
ret.Add(new LabelTextAreaField("1", "Exception in LoadPanelsInfo(..)", eee.ToString()));
}
return(false);
}
public bool SavePage(GeneralSessionInfo gsi, int PageID, IFormCollection fc)
{
Project OldProject = new Project(ProjectID);
OldProject.LoadProjectFromDB(gsi, PageID);
using (SqlConnection con = new SqlConnection(DBUtil.GetSqlConnectionString()))
{
FieldValueUpdateInfo UpdateInfo = new FieldValueUpdateInfo(con, gsi.retailerID, ProjectID, null, gsi.userID);
OldProject.Page.Panels.SavePanels(fc, UpdateInfo);
}
return(false);
}
public bool LoadProjectFromDB(GeneralSessionInfo gsi, int PageID)
{
using (SqlConnection con = new SqlConnection(DBUtil.GetSqlConnectionString()))
{
con.Open();
LoadPageInfo(gsi, con, ProjectID, PageID);
//LoadNavigation(gsi, con);
LoadPanelsInfo(gsi, con, ProjectID, PageID);
LoadPanelsFields(gsi, con, ProjectID, PageID);
}
return(false);
}
private bool LoadPanelsFields(GeneralSessionInfo gsi, SqlConnection con, int ProjectID, int PageID)
{
SqlDataAdapter sqlDataAdapter;
DataSet dataSet = new DataSet();
List <TempMultiSelectItem> AllMultiSelectItem = new List <TempMultiSelectItem>();
List <Field> ret = new List <Field>();
SqlCommand sql = new SqlCommand("GetPageFields", con);
sql.CommandType = CommandType.StoredProcedure;
sql.Parameters.Add(new SqlParameter("RetailerID", gsi.retailerID));
sql.Parameters.Add(new SqlParameter("ProjectID", ProjectID));
sql.Parameters.Add(new SqlParameter("PageID", PageID));
sql.Parameters.Add(new SqlParameter("LanguageID", gsi.languageID));
try
{
// http://www.dotnetfunda.com/articles/show/1716/multiple-resultsets-in-sql-server-and-handling-them-in-csharp-part-ii
sqlDataAdapter = new SqlDataAdapter(sql);
sqlDataAdapter.Fill(dataSet);
if (dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0)
{
Page.Panels.ProcessFieldsInfo(dataSet.Tables[0]);
}
else
{
Page.GenerateUnknownPageInfo();
Console.WriteLine("No matching records found.");
}
//if (dataSet.Tables.Count > 0)
//{
// if (dataSet.Tables[0].Rows.Count > 0)
// Page.ProcessPageInfo(dataSet.Tables[0]);
// if (dataSet.Tables[1].Rows.Count > 0)
// Page.ProcessPanelsInfo(dataSet.Tables[1]);
// if (dataSet.Tables[2].Rows.Count > 0)
// Page.Panels.ProcessFieldsInfo(dataSet.Tables[2]);
//}
}
catch (Exception eee)
{
ret.Add(new LabelTextAreaField("1", "Exception in LoadPanelContent(..)", eee.ToString()));
}
return(false);
}