public mNews fGetNews(mNews pNews)
{
try
{
var vNews = (from n in Db.tbl_news
where n.news_id.Equals(pNews.news_id)
select new mNews
{
news_id = n.news_id,
news_summery = n.news_summery,
news_image = n.news_image,
news_title = n.news_title,
news_exp = n.news_exp,
news_date = n.news_date,
news_writer = n.news_writer,
news_index = n.news_index,
news_visit = n.news_visit,
news_category = n.news_category,
news_code = n.news_code,
news_href = n.news_href,
news_img_alt = n.news_img_alt
}).FirstOrDefault();
return(vNews);
}
catch (Exception)
{
return(null);
}
}
public bool InsertNews(mNews pNews)
{
try
{
tbl_news vNews = new tbl_news();
var query = from b in Db.tbl_news
orderby b.news_id descending
select b;
vNews = query.FirstOrDefault();
tbl_news n = new tbl_news();
n.news_summery = pNews.news_summery;
n.news_image = pNews.news_image;
n.news_title = pNews.news_title;
n.news_exp = pNews.news_exp;
n.news_date = pNews.news_date;
n.news_writer = pNews.news_writer;
n.news_index = pNews.news_index;
n.news_img_alt = pNews.news_img_alt;
n.news_href = pNews.news_href;
n.news_code = pNews.news_code;
n.news_visit = 200;
n.news_id = vNews.news_id + 1;
n.news_img_alt = pNews.news_img_alt;
Db.tbl_news.Add(n);
return(Convert.ToBoolean(Db.SaveChanges()));
}
catch (Exception)
{
return(false);
}
}
public ActionResult BlogPost(mNews pNews)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("LoginForm", "Login"));
}
if (!(ModelState.IsValid))
{
ViewBag.error = "خطا در اطلاعات ورودی !";
return(View(pNews));
}
else
{
if (pNews.img_file != null && pNews.img_file.ContentLength > 0)
{
if (pNews.img_file.ContentLength < 10485760)
{
Random rnd = new Random();
string img = rnd.Next().ToString() + ".jpg";
string Path = System.IO.Path.Combine(Server.MapPath("~/images/blog/"));
pNews.img_file.SaveAs(Path + img);
using (MemoryStream ms = new MemoryStream())
{
pNews.img_file.InputStream.CopyTo(ms);
byte[] array = ms.GetBuffer();
pNews.news_image = img;
}
}
else
{
ViewBag.error = "حد اکثر اندازه فایل را رعایت نکرده اید !";
return(View(pNews));
}
}
if (pNews.news_id > 0)
{
if (n.fUpdateNews(pNews))
{
return(RedirectToAction("index"));
}
ViewBag.error = "خطا در انجام عملیات ! ";
}
else
{
if (n.InsertNews(pNews))
{
return(RedirectToAction("index"));
}
ViewBag.error = "خطا در انجام عملیات ! ";
}
}
return(View(pNews));
}
public ActionResult News(int page)
{
mHome vHome = new mHome();
mNews vNews = new mNews();
vNews.news_id = page;
a.fUpdateNewsVisit(page);
vHome.Blog = b.fGetNews(vNews);
if (vHome == null)
{
vHome = new mHome();
}
return(View(vHome));
}
public ActionResult News()
{
mHome vHome = new mHome();
mNews vNews = new mNews();
mLink vLink = new mLink();
vLink.link_status = 2;
List <mLink> aLinks = new List <mLink>();
List <mProduct> aProducts = new List <mProduct>();
List <mNews> aNews = new List <mNews>();
if (pSkip == 0)
{
vHome.page_number = 1;
}
else
{
vHome.page_number = (pSkip / 12) + 1;
}
aNews = b.fNewsList(pGet, pSkip);
aLinks = l.fLinkList(12, 0, vLink);
if (aNews != null && aNews.Count > 0)
{
vHome.aNews = aNews;
}
else
{
vHome.aNews = new List <mNews>();
}
if (aLinks != null && aLinks.Count > 0)
{
vHome.aLink = aLinks;
}
else
{
vHome.aLink = new List <mLink>();
}
if (aProducts != null && aProducts.Count > 0)
{
vHome.aProducts = aProducts;
}
else
{
vHome.aProducts = new List <mProduct>();
}
return(View(vHome));
}
public ActionResult RemoveGallery(int pId)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("Login", "LoginForm"));
}
mNews vNews = new mNews();
if (g.fDeleteGallery(pId))
{
return(Json(pId, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(pId, JsonRequestBehavior.AllowGet));
}
}
public ActionResult BlogGet(int pId = 0)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("LoginForm", "Login"));
}
mNews vNews = new mNews();
if (pId > 0)
{
vNews.news_id = pId;
vNews = n.fGetNews(vNews);
}
else
{
vNews = new mNews();
}
return(View("_Blog", vNews));
}
public bool fUpdateNews(mNews pNews)
{
tbl_news n = new tbl_news();
n.news_id = pNews.news_id;
n.news_summery = pNews.news_summery;
n.news_image = pNews.news_image;
n.news_title = pNews.news_title;
n.news_exp = pNews.news_exp;
n.news_date = pNews.news_date;
n.news_writer = pNews.news_writer;
n.news_category = pNews.news_category;
n.news_index = pNews.news_index;
n.news_visit = pNews.news_visit;
n.news_img_alt = pNews.news_img_alt;
n.news_href = pNews.news_href;
n.news_code = pNews.news_code;
Db.tbl_news.Attach(n);
Db.Entry(n).State = System.Data.Entity.EntityState.Modified;
return(Convert.ToBoolean(Db.SaveChanges()));
}
