public static List<HTMLWidget> RetrieveAll()
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "SELECT * FROM CMS_HTMLWidget WHERE pageWorkFlowState != 4";
SqlCommand getWidgets = new SqlCommand(queryString, conn);
SqlDataReader widgetReader = getWidgets.ExecuteReader();
List<HTMLWidget> m_Widgets = new List<HTMLWidget>();
while (widgetReader.Read())
{
HTMLWidget temp = new HTMLWidget();
temp.Id = widgetReader.GetInt32(0);
temp.Name = widgetReader.GetString(1);
temp.Content = widgetReader.GetString(2);
m_Widgets.Add(temp);
}
conn.Close();
return m_Widgets;
}
public ActionResult WidgetAdd(HTMLWidget m_Widget)
{
if (ModelState.IsValid)
{
HTMLWidgetRepository.Create(m_Widget);
return RedirectToAction("Index", "HTMLWidget");
}
else
{
return View("WidgetAdd", m_Widget);
}
}
public static void Create(HTMLWidget m_Widget)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "INSERT INTO CMS_HTMLWidget(name, content, pageWorkFlowState) VALUES(@name, @content, 0)";
SqlCommand insertWidget = new SqlCommand(queryString, conn);
insertWidget.Parameters.AddWithValue("name", m_Widget.Name);
insertWidget.Parameters.AddWithValue("content", m_Widget.Content);
insertWidget.ExecuteNonQuery();
conn.Close();
}
public void Update(HTMLWidget m_Widget)
{
DBHTMLWidget.Update(m_Widget);
}
public void Create(HTMLWidget m_Widget)
{
DBHTMLWidget.Create(m_Widget);
}
public static WidgetContainer RetrieveOneByTemplateId(int id)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "SELECT * FROM CMS_WidgetContainers WHERE templateId = @id AND pageWorkFlowState != 4";
SqlCommand getContainer = new SqlCommand(queryString, conn);
getContainer.Parameters.AddWithValue("id", id);
SqlDataReader containerReader = getContainer.ExecuteReader();
WidgetContainer m_Container = new WidgetContainer();
if (containerReader.Read())
{
m_Container.Id = containerReader.GetInt32(0);
m_Container.Name = containerReader.GetString(1);
SqlConnection conn2 = DB.DbConnect();
conn2.Open();
queryString = "select w.id, w.name, w.content, ctw.sortOrder from CMS_ContainerToWidgets ctw, CMS_HTMLWidget w WHERE ctw.widgetId = w.id AND ctw.containerId = @id AND w.pageWorkFlowState != 4 ORDER BY ctw.sortOrder ASC";
SqlCommand getWidgets = new SqlCommand(queryString, conn2);
getWidgets.Parameters.AddWithValue("id", m_Container.Id);
SqlDataReader widgetReader = getWidgets.ExecuteReader();
m_Container.Widgets = new List<HTMLWidget>();
m_Container.MyWidgets = new List<int>();
while (widgetReader.Read())
{
HTMLWidget m_Widget = new HTMLWidget();
m_Widget.Id = widgetReader.GetInt32(0);
m_Widget.Name = widgetReader.GetString(1);
m_Widget.Content = widgetReader.GetString(2);
m_Widget.SortOrder = widgetReader.GetInt32(3);
m_Container.MyWidgets.Add(widgetReader.GetInt32(0));
m_Container.Widgets.Add(m_Widget);
}
conn2.Close();
}
conn.Close();
return m_Container;
}
public static List<HTMLWidget> RetrieveAll(int id)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "select w.id, w.name, w.content, ctw.sortOrder from CMS_ContainerToWidgets ctw, CMS_HTMLWidget w WHERE ctw.widgetId = w.id AND w.pageWorkFlowState != 4 AND ctw.containerID = @id ORDER BY ctw.sortOrder ASC";
SqlCommand getWidgets = new SqlCommand(queryString, conn);
getWidgets.Parameters.AddWithValue("id", id);
SqlDataReader widgetReader = getWidgets.ExecuteReader();
List<HTMLWidget> m_Widgets = new List<HTMLWidget>();
while (widgetReader.Read())
{
HTMLWidget m_Widget = new HTMLWidget();
m_Widget.Id = widgetReader.GetInt32(0);
m_Widget.Name = widgetReader.GetString(1);
m_Widget.Content = widgetReader.GetString(2);
m_Widget.SortOrder = widgetReader.GetInt32(3);
m_Widgets.Add(m_Widget);
}
conn.Close();
return m_Widgets;
}
public static List<WidgetContainer> RetrieveAll()
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "SELECT * FROM CMS_WidgetContainers WHERE pageWorkFlowState != 4";
SqlCommand getContainer = new SqlCommand(queryString, conn);
SqlDataReader containerReader = getContainer.ExecuteReader();
List<WidgetContainer> m_Containers = new List<WidgetContainer>();
while (containerReader.Read())
{
WidgetContainer m_Container = new WidgetContainer();
m_Container.Id = containerReader.GetInt32(0);
m_Container.Name = containerReader.GetString(1);
m_Containers.Add(m_Container);
SqlConnection conn2 = DB.DbConnect();
conn2.Open();
queryString = "select w.id, w.name, w.content, ctw.sortOrder from CMS_ContainerToWidgets ctw, CMS_HTMLWidget w WHERE ctw.widgetId = w.id AND ctw.containerId = 1 AND w.pageWorkFlowState != 4 ORDER BY ctw.sortOrder ASC";
SqlCommand getWidgets = new SqlCommand(queryString, conn2);
SqlDataReader widgetReader = getWidgets.ExecuteReader();
m_Container.Widgets = new List<HTMLWidget>();
m_Container.MyWidgets = new List<int>();
while (widgetReader.Read())
{
HTMLWidget m_Widget = new HTMLWidget();
m_Widget.Id = widgetReader.GetInt32(0);
m_Widget.Name = widgetReader.GetString(1);
m_Widget.Content = widgetReader.GetString(2);
m_Widget.SortOrder = widgetReader.GetInt32(3);
m_Container.MyWidgets.Add(widgetReader.GetInt32(0));
m_Container.Widgets.Add(m_Widget);
}
conn2.Close();
}
conn.Close();
return m_Containers;
}
public static HTMLWidget RetrieveOne(int id)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "SELECT * FROM CMS_HTMLWidget WHERE id = @id AND pageWorkFlowState != 4";
SqlCommand getWidget = new SqlCommand(queryString, conn);
getWidget.Parameters.AddWithValue("id", id);
SqlDataReader widgetReader = getWidget.ExecuteReader();
HTMLWidget m_Widget = new HTMLWidget();
if (widgetReader.Read())
{
m_Widget.Id = widgetReader.GetInt32(0);
m_Widget.Name = widgetReader.GetString(1);
m_Widget.Content = widgetReader.GetString(2);
}
conn.Close();
return m_Widget;
}
/*public static List<HTMLWidget> RetrieveAll(int id)
{
}*/
public static void Update(HTMLWidget m_Widget)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "UPDATE CMS_HTMLWidget SET content = @content, name = @name WHERE id = @id";
SqlCommand updateWidget = new SqlCommand(queryString, conn);
updateWidget.Parameters.AddWithValue("content", m_Widget.Content);
updateWidget.Parameters.AddWithValue("name", m_Widget.Name);
updateWidget.Parameters.AddWithValue("id", m_Widget.Id);
updateWidget.ExecuteNonQuery();
conn.Close();
}
public ActionResult WidgetAdd()
{
HTMLWidget m_Widget = new HTMLWidget();
return View("WidgetAdd", m_Widget);
}
