public void ListTitle()
{
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
Property p1 = new Property();
p1.Condition1 = "";
p1.Condition2 = "";
p1.Condition3 = "";
p1.onTable = "GALLERY_DROPDOWN";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
List <SelectListItem> Title = new List <SelectListItem>();
Title.Add(new SelectListItem {
Text = "-SELECT-", Value = "0"
});
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Title.Add(new SelectListItem {
Text = ds.Tables[0].Rows[i]["Title"].ToString(), Value = ds.Tables[0].Rows[i]["id"].ToString()
});
}
ViewBag.TitleList = new SelectList(Title, "Value", "Text");
}
public void ListMenu()
{
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
Property p1 = new Property();
p1.Condition1 = "";
p1.Condition2 = "";
p1.Condition3 = "";
p1.onTable = "LIST_MENU_DROPDOWN";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
List <SelectListItem> Menu = new List <SelectListItem>();
Menu.Add(new SelectListItem {
Text = "-SELECT-", Value = "0"
});
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Menu.Add(new SelectListItem {
Text = ds.Tables[0].Rows[i][1].ToString(), Value = ds.Tables[0].Rows[i][0].ToString()
});
}
ViewBag.MenuList = new SelectList(Menu, "Value", "Text");
}
public JsonResult SearchList(string title)
{
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
Property p = new Property();
p.Condition1 = title;
p.Condition2 = "";
p.Condition3 = "";
p.onTable = "MULTIPLE_LIST";
ds = dl.FETCH_CONDITIONAL_QUERY(p);
List <Property> Data = new List <Property>();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Property p1 = new Property();
p1.id = ds.Tables[0].Rows[i]["id"].ToString();
p1.Title = ds.Tables[0].Rows[i]["Gallery"].ToString();
p1.ThumbImgURL = ds.Tables[0].Rows[i]["ThumbImgURL"].ToString().Replace("~", "");
Data.Add(p1);
}
}
else
{
Property p1 = new Property();
p1.id = "";
Data.Add(p1);
}
return(Json(Data, JsonRequestBehavior.AllowGet));
}
public string Menu_Edit(string id)
{
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
Property p1 = new Property();
p1.Condition1 = id;
p1.Condition2 = "";
p1.Condition3 = "";
p1.onTable = "MAIN_MENU_EDIT";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
List <Property> Data = new List <Property>();
string custData = "";
if (ds.Tables[0].Rows.Count > 0)
{
custData = ds.Tables[0].Rows[0]["id"].ToString();
custData += "##" + ds.Tables[0].Rows[0]["Menu"].ToString();
custData += "##" + ds.Tables[0].Rows[0]["Position"].ToString();
custData += "##" + ds.Tables[0].Rows[0]["Status"].ToString();
}
else
{
custData = "0";
custData += "##" + "0";
custData += "##" + "0";
custData += "##" + "0";
}
return(custData);
}
public JsonResult SubMenuLevel(string Id)
{
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
Property p1 = new Property();
p1.Condition1 = Id;
p1.Condition2 = "";
p1.Condition3 = "";
p1.onTable = "SUB_LEVEL_DROPDOWN";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
List <SelectListItem> DropDown = new List <SelectListItem>();
DropDown.Add(new SelectListItem {
Text = "-select-", Value = "0"
});
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DropDown.Add(new SelectListItem {
Text = ds.Tables[0].Rows[i][1].ToString(), Value = ds.Tables[0].Rows[i][0].ToString()
});
}
return(Json(new SelectList(DropDown, "Value", "Text"), JsonRequestBehavior.AllowGet));
}
public void PhotoBag()
{
Property p = new Property();
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
p.Condition1 = "5";
p.Condition2 = "";
p.Condition3 = "";
p.onTable = "FETCH_HOME_CONTENT";
ds = dl.FETCH_CONDITIONAL_QUERY(p);
List <Property> Photo = new List <Property>();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Property p1 = new Property();
p1.id = ds.Tables[0].Rows[i]["id"].ToString();
p1.Title = ds.Tables[0].Rows[i]["Title"].ToString();
p1.URLTitle = ds.Tables[0].Rows[i]["URL"].ToString();
p1.Description = ds.Tables[0].Rows[i]["Description"].ToString();
Regex rstr = new Regex("<(.|\n)*?>");
if (rstr.IsMatch(p1.Description))
{
p1.Description = rstr.Replace(p1.Description, "");
}
if (p1.Description.Length >= 100)
{
p1.Description = p1.Description.Substring(0, 100) + "...";
}
else
{
p1.Description = p1.Description;
}
p1.ThumbImgURL = ds.Tables[0].Rows[i]["ThumbImgURL"].ToString().Replace("~", "");
p1.ImgURL = ds.Tables[0].Rows[i]["ImgURL"].ToString().Replace("~", "");
Photo.Add(p1);
}
}
else
{
Property p1 = new Property();
p1.id = "0";
p1.Title = "NONE";
p1.Description = "NONE";
Photo.Add(p1);
}
ViewBag.PhotoList = Photo;
}
public void Vedio()
{
Property p = new Property();
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
p.Condition1 = "";
p.Condition2 = "";
p.Condition3 = "";
p.onTable = "FETCH_VEDIO_CONTENT";
ds = dl.FETCH_CONDITIONAL_QUERY(p);
List <Property> Detail = new List <Property>();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Property p1 = new Property();
p1.id = ds.Tables[0].Rows[i]["id"].ToString();
p1.Title = ds.Tables[0].Rows[i]["Title"].ToString();
p1.URLTitle = ds.Tables[0].Rows[i]["URL"].ToString();
p1.Description = ds.Tables[0].Rows[i]["Description"].ToString();
p1.Menu = ds.Tables[0].Rows[i]["MenuID"].ToString();
Regex rstr = new Regex("<(.|\n)*?>");
if (rstr.IsMatch(p1.Description))
{
p1.Description = rstr.Replace(p1.Description, "");
}
if (p1.Description.Length >= 1000)
{
p1.Description = p1.Description.Substring(0, 1000) + "...";
}
else
{
p1.Description = p1.Description;
}
Detail.Add(p1);
}
}
else
{
Property p1 = new Property();
p1.id = "0";
p1.Title = "NONE";
p1.Description = "NONE";
Detail.Add(p1);
}
ViewBag.vediocontentlist = Detail;
}
public ActionResult List()
{
Property p1 = new Property();
DataSet ds = new DataSet();
p1.Condition1 = "";
p1.Condition2 = "";
p1.Condition3 = "";
p1.onTable = "CONTENT_LIST";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
List <Property> Detail = new List <Property>();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Property p = new Property();
p.id = ds.Tables[0].Rows[i]["id"].ToString();
p.Title = ds.Tables[0].Rows[i]["Title"].ToString();
p.Menu = ds.Tables[0].Rows[i]["Menu"].ToString();
p.Status = ds.Tables[0].Rows[i]["Status"].ToString();
Detail.Add(p);
}
}
else
{
Property p = new Property();
p.id = "0";
p.Title = "NONE";
p.Menu = "NONE";
p.Status = "NONE";
Detail.Add(p);
}
ViewBag.DetailList = Detail;
return(View());
}
public void ListMenu()
{
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
Property p1 = new Property();
p1.Condition1 = "";
p1.Condition2 = "";
p1.Condition3 = "";
p1.onTable = "LIST_MENU";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
List <Property> Menu = new List <Property>();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Property p = new Property();
p.id = ds.Tables[0].Rows[i]["id"].ToString();
p.Menu = ds.Tables[0].Rows[i]["Menu"].ToString();
p.URLTitle = ds.Tables[0].Rows[i]["URL"].ToString();
Menu.Add(p);
}
}
else
{
Property p = new Property();
p.id = "0";
p.Menu = "NONE";
p.URLTitle = "NONE";
Menu.Add(p);
}
ViewBag.MenuList = Menu;
}
public string EMAILID_CHECK(string Id)
{
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
Property p1 = new Property();
p1.Condition1 = Id;
p1.Condition2 = "";
p1.onTable = "EMAIL_CHECK";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
if (ds.Tables[0].Rows.Count > 0)
{
return("Email ID Already Exists.");
}
else
{
return("Available");
}
}
public ActionResult Menu()
{
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
Property p1 = new Property();
p1.Condition1 = "";
p1.Condition2 = "";
p1.Condition3 = "";
p1.onTable = "MAIN_MENU";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
List <Property> Menu = new List <Property>();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Property p = new Property();
p.id = ds.Tables[0].Rows[i]["id"].ToString();
p.Menu = ds.Tables[0].Rows[i]["Menu"].ToString();
p.Position = ds.Tables[0].Rows[i]["Position"].ToString();
p.Status = ds.Tables[0].Rows[i]["Status"].ToString();
Menu.Add(p);
}
}
else
{
Property p = new Property();
p.id = "0";
p.Menu = "NONE";
p.Position = "NONE";
p.Status = "NONE";
Menu.Add(p);
}
ViewBag.MenuList = Menu;
return(View());
}
public ActionResult Detail(string id)
{
ListMenu();
Property p1 = new Property();
DataSet ds = new DataSet();
Datalayer dl = new Datalayer();
try
{
p1.Condition1 = id;
}
catch
{
p1.Condition1 = "";
}
p1.Condition2 = "";
p1.Condition3 = "";
p1.onTable = "FETCH_DETAIL";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
if (ds.Tables[0].Rows.Count > 0)
{
TempData["Found"] = "1";
var info = new collegedaze.Models.Property()
{
id = ds.Tables[0].Rows[0]["id"].ToString(),
Title = ds.Tables[0].Rows[0]["Title"].ToString(),
Description = ds.Tables[0].Rows[0]["Description"].ToString(),
ImgURL = ds.Tables[0].Rows[0]["ImgURL"].ToString().Replace("~", ""),
};
return(View(info));
}
else
{
TempData["MSG"] = "Invalid ID!!!";
return(Redirect("/"));
}
}
public void HomeContent(string Id)
{
Property p = new Property();
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
p.Condition1 = Id;
p.Condition2 = "";
p.Condition3 = "";
p.onTable = "FETCH_HOME_CONTENT";
ds = dl.FETCH_CONDITIONAL_QUERY(p);
List <Property> Detail = new List <Property>();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
p.id = ds.Tables[0].Rows[i]["id"].ToString();
p.Title = ds.Tables[0].Rows[i]["Title"].ToString();
p.Menu = ds.Tables[0].Rows[i]["Menu"].ToString();
p.Description = ds.Tables[0].Rows[i]["Description"].ToString();
p.ThumbImgURL = ds.Tables[0].Rows[i]["ThumbImgURL"].ToString().Replace("~", "");
p.ImgURL = ds.Tables[0].Rows[i]["ImgURL"].ToString().Replace("~", "");
Detail.Add(p);
}
}
else
{
p.id = "0";
p.Title = "NONE";
p.Menu = "NONE";
p.Description = "NONE";
Detail.Add(p);
}
ViewBag.contentlist = Detail;
}
public ActionResult Home()
{
Property p = new Property();
p.Condition1 = "HOME";
p.Condition2 = "";
p.Condition3 = "";
p.onTable = "HOME_CONTENT";
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
ds = dl.FETCH_CONDITIONAL_QUERY(p);
var home = new collegedaze.Models.Property()
{
id = ds.Tables[0].Rows[0]["id"].ToString(),
Title = ds.Tables[0].Rows[0]["Title"].ToString(),
Description = ds.Tables[0].Rows[0]["Description"].ToString(),
};
return(View(home));
}
public void SliderBag()
{
Property p = new Property();
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
p.Condition1 = "9";
p.Condition2 = "";
p.Condition3 = "";
p.onTable = "FETCH_HOME_CONTENT";
ds = dl.FETCH_CONDITIONAL_QUERY(p);
List <Property> Photo = new List <Property>();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Property p1 = new Property();
p1.id = ds.Tables[0].Rows[i]["id"].ToString();
p1.Title = ds.Tables[0].Rows[i]["Title"].ToString();
p1.URLTitle = ds.Tables[0].Rows[i]["URL"].ToString();
p1.Description = ds.Tables[0].Rows[i]["Description"].ToString();
p1.ImgURL = ds.Tables[0].Rows[i]["ImgURL"].ToString().Replace("~", "");
Photo.Add(p1);
}
}
else
{
Property p1 = new Property();
p1.id = "0";
p1.Title = "NONE";
p1.Description = "NONE";
Photo.Add(p1);
}
ViewBag.SliderList = Photo;
}
public ActionResult Delete()
{
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
Property p1 = new Property();
string str = "";
p1.ImgURL = "";
p1.ThumbImgURL = "";
p1.id = Request.QueryString["id"].ToString();
p1.Condition1 = Request.QueryString["id"].ToString();
p1.Condition2 = "";
p1.Condition3 = "";
if (Request.QueryString["type"].ToString() == "Content")
{
p1.onTable = "CONTENT_EDIT";
str = "DELETE FROM tbl_Content WHERE id='" + p1.id + "'";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
if (ds.Tables[0].Rows.Count > 0)
{
p1.ImgURL = ds.Tables[0].Rows[0]["ImgURL"].ToString();
p1.ThumbImgURL = ds.Tables[0].Rows[0]["ThumbImgURL"].ToString();
}
string completIMG = Server.MapPath(p1.ImgURL);
string completeThumb = Server.MapPath(p1.ThumbImgURL);
try
{
if (System.IO.File.Exists(completIMG))
{
System.IO.File.Delete(completIMG);
}
if (System.IO.File.Exists(completeThumb))
{
System.IO.File.Delete(completeThumb);
}
}
catch (Exception ex)
{
TempData["MSG"] = ex.ToString();
}
}
else if (Request.QueryString["type"].ToString() == "Contact")
{
p1.onTable = "CONTENT_EDIT";
str = "DELETE FROM tbl_Contact WHERE id='" + p1.id + "'";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
}
else if (Request.QueryString["type"].ToString() == "Multiple")
{
p1.onTable = "MULTIPLE_URL";
str = "DELETE FROM tbl_Multiple WHERE id='" + p1.id + "'";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
if (ds.Tables[0].Rows.Count > 0)
{
p1.ImgURL = ds.Tables[0].Rows[0]["ImgURL"].ToString();
p1.ThumbImgURL = ds.Tables[0].Rows[0]["ThumbImgURL"].ToString();
}
string completIMG = Server.MapPath(p1.ImgURL);
string completeThumb = Server.MapPath(p1.ThumbImgURL);
try
{
if (System.IO.File.Exists(completIMG))
{
System.IO.File.Delete(completIMG);
}
if (System.IO.File.Exists(completeThumb))
{
System.IO.File.Delete(completeThumb);
}
}
catch (Exception ex)
{
TempData["MSG"] = ex.ToString();
}
}
else
{
p1.onTable = "";
str = "";
}
SqlConnection con = new SqlConnection(p1.Con);
con.Open();
try
{
SqlCommand cmd = new SqlCommand(str, con);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
TempData["MSG"] = "Data Deleted Successfully!!!";
}
else
{
TempData["MSG"] = "Record Not Deleted.";
}
}
catch (Exception ex)
{
TempData["MSG"] = ex.ToString();
}
con.Close();
if (Request.QueryString["type"].ToString() == "Content")
{
return(RedirectToAction("List", "Content"));
}
else if (Request.QueryString["type"].ToString() == "Contact")
{
return(RedirectToAction("Contact", "Content"));
}
else if (Request.QueryString["type"].ToString() == "Multiple")
{
return(RedirectToAction("Multiple", "Content"));
}
else
{
return(RedirectToAction("Index", "Admin"));
}
}
public ActionResult Delete()
{
Datalayer dl = new Datalayer();
DataSet ds = new DataSet();
Property p1 = new Property();
string str = "";
p1.ImgURL = "";
p1.ThumbImgURL = "";
p1.id = Request.QueryString["id"].ToString();
p1.Condition1 = Request.QueryString["id"].ToString();
p1.Condition2 = "";
p1.Condition3 = "";
if (Request.QueryString["type"].ToString() == "Menu")
{
p1.onTable = "";
str = "DELETE FROM tbl_Menu WHERE id='" + p1.id + "'";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
}
else if (Request.QueryString["type"].ToString() == "SubMenu")
{
p1.onTable = "";
str = "DELETE FROM tbl_SubMenu WHERE id='" + p1.id + "'";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
}
else if (Request.QueryString["type"].ToString() == "SubMenuLevel")
{
p1.onTable = "";
str = "DELETE FROM tbl_SubMenu_Level2 WHERE id='" + p1.id + "'";
ds = dl.FETCH_CONDITIONAL_QUERY(p1);
}
else
{
p1.onTable = "";
str = "";
}
SqlConnection con = new SqlConnection(p1.Con);
con.Open();
try
{
SqlCommand cmd = new SqlCommand(str, con);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
TempData["MSG"] = "Data Deleted Successfully!!!";
}
else
{
TempData["MSG"] = "Record Not Deleted.";
}
}
catch (Exception ex)
{
TempData["MSG"] = ex.ToString();
}
con.Close();
if (Request.QueryString["type"].ToString() == "Menu")
{
return(RedirectToAction("Menu", "Settings"));
}
else if (Request.QueryString["type"].ToString() == "SubMenu")
{
return(RedirectToAction("SubMenu", "Settings"));
}
else if (Request.QueryString["type"].ToString() == "SubMenuLevel")
{
return(RedirectToAction("SubMenuLevel2", "Settings"));
}
else
{
return(RedirectToAction("Index", "Admin"));
}
}
