public bool InsertArticles(mArticle pArticles)
{
try
{
tbl_article vArticle = new tbl_article();
var query = from b in Db.tbl_article
orderby b.article_id descending
select b;
vArticle = query.FirstOrDefault();
tbl_article a = new tbl_article();
a.article_file = pArticles.article_file;
a.article_img = pArticles.article_img;
a.article_img2 = pArticles.article_img2;
a.article_img3 = pArticles.article_img3;
a.article_title = pArticles.article_title;
a.article_summery = pArticles.article_summery;
a.article_writer = pArticles.article_writer;
a.article_date = pArticles.article_date;
a.article_exp = pArticles.article_exp;
a.article_img_alt = pArticles.article_img_alt;
a.article_writer = pArticles.article_writer;
a.article_code = pArticles.article_code;
a.article_href = pArticles.article_href;
a.article_visit = 200;
a.article_id = vArticle.article_id + 1;
a.article_type = pArticles.article_type;
Db.tbl_article.Add(a);
return(Convert.ToBoolean(Db.SaveChanges()));
}
catch (Exception)
{
return(false);
}
}
public ActionResult ArticleCreate(tbl_article tbl_Article, HttpPostedFileBase Image)
{
using (BlogEntities db = new BlogEntities())
{
if (Image != null)
{
string fileName = Path.GetFileName(Image.FileName);
string extension = Path.GetExtension(Image.FileName);
if (fileName.Length > 30)
{
fileName = "thumb-" + fileName.Substring(0, 30) + extension;
}
else
{
fileName = "thumb-" + fileName + extension;
}
string filePath = Path.Combine(Server.MapPath("~/Images"), fileName);
Image.SaveAs(filePath);
tbl_Article.Image = fileName;
tbl_Article.Status = 1;
db.tbl_article.Add(tbl_Article);
db.SaveChanges();
}
else
{
TempData["Error"] = "Somthing is wrong..";
}
}
return(RedirectToAction("Article"));
}
public ActionResult ArticleUpdate(int id, tbl_article tbl_Article, HttpPostedFileBase Image, string OldImage)
{
using (BlogEntities db = new BlogEntities())
{
if (Image != null)
{
string fileName = Path.GetFileName(Image.FileName);
string extension = Path.GetExtension(Image.FileName);
if (fileName.Length > 30)
{
fileName = "thumb-" + fileName.Substring(0, 30) + extension;
}
else
{
fileName = "thumb-" + fileName + extension;
}
string filePath = Path.Combine(Server.MapPath("~/Images"), fileName);
Image.SaveAs(filePath);
tbl_Article.Image = fileName;
}
else
{
tbl_Article.Image = OldImage;
}
db.Entry(tbl_Article).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Article"));
}
public ActionResult ArticleDelete(int id, tbl_article tbl_Article)
{
using (BlogEntities db = new BlogEntities())
{
db.Entry(tbl_Article).State = EntityState.Deleted;
db.SaveChanges();
}
return(RedirectToAction("Article"));
}
public ActionResult ArticleUpdate(int id, tbl_article tbl_Article)
{
using (BlogEntities db = new BlogEntities())
{
var article = db.tbl_article.FirstOrDefault(x => x.ID == id);
article.Status = tbl_Article.Status;
db.SaveChanges();
}
return(RedirectToAction("Article"));
}
public bool fUpdateArticles(mArticle pArticles)
{
tbl_article a = new tbl_article();
a.article_id = pArticles.article_id;
a.article_exp = pArticles.article_exp;
a.article_date = pArticles.article_date;
a.article_file = pArticles.article_file;
a.article_img = pArticles.article_img;
a.article_img2 = pArticles.article_img2;
a.article_img3 = pArticles.article_img3;
a.article_img_alt = pArticles.article_img_alt;
a.article_summery = pArticles.article_summery;
a.article_title = pArticles.article_title;
a.article_writer = pArticles.article_writer;
a.article_visit = pArticles.article_visit;
a.article_img = pArticles.article_img;
a.article_type = pArticles.article_type;
a.article_code = pArticles.article_code;
a.article_href = pArticles.article_href;
Db.tbl_article.Attach(a);
Db.Entry(a).State = System.Data.Entity.EntityState.Modified;
return(Convert.ToBoolean(Db.SaveChanges()));
}
