public static int Create(WidgetContainer m_Container)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "INSERT INTO CMS_WidgetContainers(name) VALUES(@name)";
SqlCommand insertContainer = new SqlCommand(queryString, conn);
insertContainer.Parameters.AddWithValue("name", m_Container.Name);
insertContainer.ExecuteNonQuery();
queryString = "SELECT IDENT_CURRENT('CMS_WidgetContainers')";
SqlCommand getPageId = new SqlCommand(queryString, conn);
int m_ContainerId = (int)(decimal)getPageId.ExecuteScalar();
conn.Close();
foreach (int widget in m_Container.MyWidgets)
{
conn.Open();
int sortOrder = getSortOrder(m_ContainerId);
queryString = "INSERT INTO CMS_ContainerToWidgets(containerId, widgetId, sortOrder) VALUES(@containerId, @widgetId, @sortOrder)";
SqlCommand insertInfo = new SqlCommand(queryString, conn);
insertInfo.Parameters.AddWithValue("containerId", m_ContainerId);
insertInfo.Parameters.AddWithValue("widgetId", widget);
insertInfo.Parameters.AddWithValue("sortOrder", sortOrder);
insertInfo.ExecuteNonQuery();
conn.Close();
}
return m_ContainerId;
}
public ActionResult ContainerAdd(WidgetContainer m_Container)
{
if (ModelState.IsValid)
{
int containerId = WidgetContainerRepository.Create(m_Container);
return RedirectToAction("Index", "WidgetContainer");
}
else
{
ViewBag.Widgets = WidgetContainerRepository.getWidgets();
return View("ContainerAdd", m_Container);
}
}
public ActionResult ContainerAdd()
{
WidgetContainer m_Container = new WidgetContainer();
ViewBag.Templates = Utility.GetTemplates();
ViewBag.Widgets = WidgetContainerRepository.getWidgets();
if (ViewBag.Widgets == null)
{
ViewBag.Widgets = new List<HTMLWidget>();
}
return View("ContainerAdd", m_Container);
}
public ActionResult ContainerEdit(WidgetContainer m_Container)
{
if (ModelState.IsValid)
{
WidgetContainerRepository.Update(m_Container);
return RedirectToAction("Index", "WidgetContainer");
}
else
{
if (m_Container.MyWidgets == null)
{
m_Container.MyWidgets = new List<int>();
}
ViewBag.Widgets = WidgetContainerRepository.getWidgets();
return View("ContainerEdit", m_Container);
}
}
public ActionResult ContainerAdd(WidgetContainer m_Container)
{
var TemplateId = ModelState["TemplateId"];
TemplateId.Errors.Clear();
if (ModelState.IsValid)
{
int containerId = WidgetContainerRepository.Create(m_Container);
return RedirectToAction("Index", "WidgetContainer");
}
else
{
ViewBag.Templates = Utility.GetTemplates();
ViewBag.Widgets = WidgetContainerRepository.getWidgets();
return View("ContainerAdd", m_Container);
}
}
public void Update(WidgetContainer m_Container)
{
DBWidgetContainer.Update(m_Container);
}
public int Create(WidgetContainer m_Container)
{
int containerId = DBWidgetContainer.Create(m_Container);
return containerId;
}
public static void Update(WidgetContainer m_Container)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "UPDATE CMS_WidgetContainers SET name = @name WHERE id = @id";
SqlCommand updateContainer = new SqlCommand(queryString, conn);
updateContainer.Parameters.AddWithValue("name", m_Container.Name);
updateContainer.Parameters.AddWithValue("id", m_Container.Id);
updateContainer.ExecuteNonQuery();
queryString = "DELETE FROM CMS_ContainerToWidgets WHERE containerId = @containerId";
SqlCommand deleteBridge = new SqlCommand(queryString, conn);
deleteBridge.Parameters.AddWithValue("containerId", m_Container.Id);
deleteBridge.ExecuteNonQuery();
conn.Close();
foreach (int widget in m_Container.MyWidgets)
{
conn.Open();
int sortOrder = getSortOrder(m_Container.Id);
queryString = "INSERT INTO CMS_ContainerToWidgets(containerId, widgetId, sortOrder) VALUES(@containerId, @widgetId, @sortOrder)";
SqlCommand insertInfo = new SqlCommand(queryString, conn);
insertInfo.Parameters.AddWithValue("containerId", m_Container.Id);
insertInfo.Parameters.AddWithValue("widgetId", widget);
insertInfo.Parameters.AddWithValue("sortOrder", sortOrder);
insertInfo.ExecuteNonQuery();
conn.Close();
}
}
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<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;
}
