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);
}
}
