public static List<Gallery> RetrieveAll()
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "SELECT * FROM CMS_Gallery WHERE pageWorkFlowState != 4 ORDER BY name";
SqlCommand getGalleries = new SqlCommand(queryString, conn);
SqlDataReader m_Galleries = getGalleries.ExecuteReader();
List<Gallery> myGalleries = new List<Gallery>();
while(m_Galleries.Read())
{
Gallery tempGallery = new Gallery();
tempGallery.Id = m_Galleries.GetInt32(0);
tempGallery.Name = m_Galleries.GetString(1);
tempGallery.ContentGroup = m_Galleries.GetInt32(2);
myGalleries.Add(tempGallery);
}
conn.Close();
return myGalleries;
}
public void Update(Gallery m_Gallery, string OldName)
{
DBGallery.Update(m_Gallery);
if (m_Gallery.Name != OldName)
{
string source = ConfigurationManager.AppSettings["Gallery"] + "\\" + OldName;
string destination = ConfigurationManager.AppSettings["Gallery"] + "\\" + m_Gallery.Name;
Directory.Move(source, destination);
}
}
public static void Create(Gallery m_Gallery)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "INSERT INTO CMS_Gallery(name, contentGroup) VALUES(@name, @contentGroup)";
SqlCommand insertGallery = new SqlCommand(queryString, conn);
insertGallery.Parameters.AddWithValue("name", m_Gallery.Name);
insertGallery.Parameters.AddWithValue("contentGroup", m_Gallery.ContentGroup);
insertGallery.ExecuteNonQuery();
conn.Close();
}
public ActionResult AddGallery(Gallery m_Gallery)
{
ViewBag.myContentGroups = Utility.ContentGroups();
if (ModelState.IsValid)
{
GalleryRepository.CreateGallery(m_Gallery);
return RedirectToAction("Index", "Gallery");
}
else
{
return View("AddGallery", m_Gallery);
}
}
public void CreateGallery(Gallery m_Gallery)
{
DBGallery.Create(m_Gallery);
Directory.CreateDirectory(ConfigurationManager.AppSettings["Gallery"] + "\\" + m_Gallery.Name);
Directory.CreateDirectory(ConfigurationManager.AppSettings["Gallery"] + "\\" + m_Gallery.Name + "\\thumbs");
}
public ActionResult AddGallery()
{
ViewBag.myContentGroups = Utility.ContentGroups();
Gallery m_Gallery = new Gallery();
return View("AddGallery", m_Gallery);
}
public ActionResult EditGallery(Gallery m_Gallery, string OldName)
{
ViewBag.myContentGroups = Utility.ContentGroups();
if (ModelState.IsValid)
{
GalleryRepository.Update(m_Gallery, OldName);
return RedirectToAction("Index", "Gallery");
}
else
{
return View("EditGallery", m_Gallery);
}
}
public static Gallery RetrieveOne(int id)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "SELECT * FROM CMS_Gallery WHERE id = @id AND pageWorkFlowState != 4";
SqlCommand getGallery = new SqlCommand(queryString, conn);
getGallery.Parameters.AddWithValue("id", id);
SqlDataReader m_Gallery = getGallery.ExecuteReader();
Gallery myGallery = new Gallery();
if(m_Gallery.Read())
{
myGallery.Id = m_Gallery.GetInt32(0);
myGallery.Name = m_Gallery.GetString(1);
myGallery.ContentGroup = m_Gallery.GetInt32(2);
}
conn.Close();
return myGallery;
}
public static void Update(Gallery m_Gallery)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "UPDATE CMS_Gallery SET name = @name, contentGroup = @contentGroup WHERE id = @id";
SqlCommand updateGallery = new SqlCommand(queryString, conn);
updateGallery.Parameters.AddWithValue("name", m_Gallery.Name);
updateGallery.Parameters.AddWithValue("contentGroup", m_Gallery.ContentGroup);
updateGallery.Parameters.AddWithValue("id", m_Gallery.Id);
updateGallery.ExecuteNonQuery();
conn.Close();
}
