public List <mCenter> fCenterList(int pGet, int pSkip, mCenter pCenter, mHome pHome) { if (pCenter.center_cat > 0) { var vCenter = (from a in Db.tbl_center where a.center_cat == pCenter.center_cat select new mCenter { center_id = a.center_id, center_title = a.center_title, center_info = a.center_info, center_img = a.center_img, center_city = a.center_city, center_cat = a.center_cat }).OrderBy(b => b.center_id).Skip(pSkip).Take(pGet); return(vCenter.ToList()); } else { var vCenter = (from a in Db.tbl_center select new mCenter { center_id = a.center_id, center_title = a.center_title, center_info = a.center_info, center_img = a.center_img, center_city = a.center_city, center_cat = a.center_cat }).OrderBy(b => b.center_id).Skip(pSkip).Take(pGet); return(vCenter.ToList()); } }
public ActionResult CenterPost(mCenter pCenters) { if (fUserControl() == 0) { ViewBag.Message = "شما وارد سایت نشده اید..."; return(RedirectToAction("LoginForm", "Login")); } if (!(ModelState.IsValid)) { ViewBag.error = "خطا در اطلاعات ورودی !"; return(View(pCenters)); } else { if ((pCenters.img_file != null) && (pCenters.img_file.ContentLength > 0)) { if (pCenters.img_file.ContentLength < 10485760) { Random rnd = new Random(); string img = rnd.Next().ToString() + ".jpg"; string Path = System.IO.Path.Combine(Server.MapPath("~/images/center/")); pCenters.img_file.SaveAs(Path + img); using (MemoryStream ms = new MemoryStream()) { pCenters.img_file.InputStream.CopyTo(ms); byte[] array = ms.GetBuffer(); pCenters.center_img = img; } } else { ViewBag.error = "حد اکثر اندازه فایل را رعایت نکرده اید !"; return(View(pCenters)); } } if (pCenters.center_id > 0) { if (a.fUpdateCenter(pCenters)) { return(RedirectToAction("index", new { pId = pCenters.center_cat })); } } else { if (a.InsertCenter(pCenters)) { return(RedirectToAction("index", new { pId = pCenters.center_cat })); } } ViewBag.error = "خطا در انجام عملیات ! "; } return(View(pCenters)); }
public bool fUpdateCenter(mCenter pCenter) { tbl_center a = new tbl_center(); a.center_id = pCenter.center_id; a.center_cat = pCenter.center_cat; a.center_city = pCenter.center_city; a.center_img = pCenter.center_img; a.center_info = pCenter.center_info; a.center_title = pCenter.center_title; Db.tbl_center.Attach(a); Db.Entry(a).State = System.Data.Entity.EntityState.Modified; return(Convert.ToBoolean(Db.SaveChanges())); }
public ActionResult Index() { if (fUserControl() == 0) { ViewBag.Message = "شما وارد سایت نشده اید..."; return(RedirectToAction("LoginForm", "Login")); } mHome vHome = new mHome(); mCenter pCenter = new mCenter(); List <mCenter> aCenter = new List <mCenter>(); aCenter = a.fCenterList(pGet, pSkip, pCenter, vHome); return(View(aCenter)); }
public List <mCenter> fCenterSearchList(mCenter pCenter) { var vCenter = (from a in Db.tbl_center where a.center_city.ContaIns(pCenter.center_city) || a.center_title.ContaIns(pCenter.center_city) select new mCenter { center_id = a.center_id, center_title = a.center_title, center_info = a.center_info, center_img = a.center_img, center_city = a.center_city, center_cat = a.center_cat }).OrderBy(b => b.center_id); return(vCenter.ToList()); }
public ActionResult RemoveCenter(int pId) { if (fUserControl() == 0) { ViewBag.Message = "شما وارد سایت نشده اید..."; return(RedirectToAction("Login", "LoginForm")); } mCenter vCenter = new mCenter(); if (a.fDeleteCenter(pId)) { return(Json(pId, JsonRequestBehavior.AllowGet)); } else { return(Json(pId, JsonRequestBehavior.AllowGet)); } }
public ActionResult SearchCenter(mHome pHome) { mHome vHome = new mHome(); mCenter pCenter = new mCenter(); pCenter.center_city = pHome.pSearch; List <mCenter> aCenter = new List <mCenter>(); aCenter = ce.fCenterSearchList(pCenter); if (aCenter != null && aCenter.Count > 0) { vHome.aCenter = aCenter; } else { vHome.aCenter = new List <mCenter>(); } return(PartialView("_SearchCenter", vHome)); }
public ActionResult CenterGet(int pId = 0) { if (fUserControl() == 0) { ViewBag.Message = "شما وارد سایت نشده اید..."; return(RedirectToAction("LoginForm", "Login")); } mCenter vCenter = new mCenter(); if (pId > 0) { vCenter.center_id = pId; vCenter = a.fGetCenter(vCenter); } else { vCenter = new mCenter(); } return(View("_Center", vCenter)); }
public mCenter fGetCenter(mCenter pCenter) { try { var vCenter = (from a in Db.tbl_center where a.center_id.Equals(pCenter.center_id) select new mCenter { center_id = a.center_id, center_cat = a.center_cat, center_city = a.center_city, center_title = a.center_title, center_info = a.center_info, center_img = a.center_img }).FirstOrDefault(); return(vCenter); } catch (Exception) { return(null); } }
public ActionResult Centers(int?pId) { mHome vHome = new mHome(); mCategory vCat = new mCategory(); mCenter pCenter = new mCenter(); vCat.category_type = 2; pCenter.center_cat = pId; List <mCategory> aCat = new List <mCategory>(); List <mCenter> aCenter = new List <mCenter>(); if (pSkip == 0) { vHome.page_number = 1; } else { vHome.page_number = (pSkip / 12) + 1; } aCenter = ce.fCenterList(pGet, pSkip, pCenter, vHome); aCat = c.fCategoryList(20, 0, vCat.category_type); if (aCenter != null && aCenter.Count > 0) { vHome.aCenter = aCenter; } else { vHome.aCenter = new List <mCenter>(); } if (aCat != null && aCat.Count > 0) { vHome.aCategory = aCat; } else { vHome.aCategory = new List <mCategory>(); } return(View(vHome)); }
public bool InsertCenter(mCenter pCenter) { try { tbl_center vCenter = new tbl_center(); var query = from b in Db.tbl_center orderby b.center_id descending select b; vCenter = query.FirstOrDefault(); tbl_center a = new tbl_center(); a.center_cat = pCenter.center_cat; a.center_city = pCenter.center_city; a.center_img = pCenter.center_img; a.center_info = pCenter.center_info; a.center_title = pCenter.center_title; a.center_id = vCenter.center_id + 1; Db.tbl_center.Add(a); return(Convert.ToBoolean(Db.SaveChanges())); } catch (Exception) { return(false); } }