public List <Photo_Setting> Get_Photo_Settings(string SortOrder = "SettingID")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Photo_Settings(SortOrder);
List <Photo_Setting> list = new List <Photo_Setting>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Photo_Setting(myDR));
}
return(list);
}
public List <Photo> Get_Photos(string CategoryID, string SortOrder, string Orientation, string IsActive, int TotalNumber, string PhotoDetailURL, string DisplayID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Photos(CategoryID, SortOrder, Orientation, IsActive, TotalNumber);
List <Photo> list = new List <Photo>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Photo(myDR, true, PhotoDetailURL, DisplayID));
}
return(list);
}
public List <Photo> Get_Photos(string CategoryID, string SortOrder, string Orientation)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Photos(CategoryID, SortOrder, Orientation);
List <Photo> list = new List <Photo>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Photo(myDR, true));
}
return(list);
}
public Photo Get_Photo(string PhotoID, string DisplayID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
return(new Photo(myDP.Get_Photo(PhotoID), false, null, DisplayID));
}
public void Remove_Photo_Setting(string SettingID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
myDP.Remove_Photo_Setting(SettingID);
}
public void Edit_Photo_Setting(e2Data[] UpdateData)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
myDP.Edit_Photo_Setting(UpdateData);
}
public void Remove_Photo_Mapping(string Item_MapID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
myDP.Remove_Photo_Item_Mapping(Item_MapID);
}
public bool Chk_Photo_Setting(string DisplayID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
return(myDP.Chk_Photo_Setting(DisplayID));
}
public void Add_Photo_Item_Mapping(e2Data[] UpdateData)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
myDP.Add_Photo_Item_Mapping(UpdateData);
}
public bool Chk_Photo_Item_Mapping(string PhotoID, string CategoryID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
return(myDP.Chk_Photo_Item_Mapping(PhotoID, CategoryID));
}
public int Count_Photo_Item_Mapping(string PhotoID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
return(myDP.Count_Photo_Item_Mapping(PhotoID));
}
public bool Chk_Photo(string PhotoID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
return(myDP.Chk_Photo(PhotoID));
}
public Photo_Item_Map Get_Photo_Map(string Item_MapID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
return(new Photo_Item_Map(myDP.Get_Photo_Item_Map(Item_MapID)));
}
public Photo_Setting Get_Photo_Setting_byID(string SettingID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
return(new Photo_Setting(myDP.Get_Photo_Setting_byID(SettingID)));
}
