public bool UpdateNewsStatus(int newsId)
{
// News.CreatedDate = DateTime.Now;
SA_News EditNews = _context.SA_News.Where(Cat => Cat.id == newsId).FirstOrDefault();
if (EditNews.status.HasValue)
{
if (EditNews.status.Value == 1)
{
EditNews.status = 2;
}
else
{
EditNews.status = 1;
}
}
else
{
EditNews.status = 1;
}
_context.Entry(EditNews).State = EntityState.Modified;
int x = _context.SaveChanges();
return(x == 0 ? false : true);
}
public ActionResult SaveNews(SA_News UserNews)
{
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/ProductImages"), fileName);
file.SaveAs(path);
UserNews.NewsImg = fileName;
}
}
UserNews.CreatedTime = DateTime.Now;
NewsDataStore Obj = new NewsDataStore();
if (UserNews.id == 0)
{
Obj.AddNews(UserNews);
}
else
{
Obj.EditNews(UserNews);
}
return(RedirectToAction("News"));
}
public async Task <bool> UpdateNews(SA_News News)
{
_context.Entry(News).State = EntityState.Modified;
// News.ModeifiedDate = DateTime.Now;
int x = await _context.SaveChangesAsync();
return(x == 0 ? false : true);
}
public bool AddNews(SA_News News)
{
// News.CreatedDate = DateTime.Now;
_context.SA_News.Add(News);
int x = _context.SaveChanges();
return(x == 0 ? false : true);
}
public ActionResult SaveNews(SA_News UserNews)
{
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/ProductImages"), fileName);
file.SaveAs(path);
UserNews.NewsImg = fileName;
}
}
UserNews.status = 1;
UserNews.CreatedBy = Session["User"].ToString();
UserNews.CreatedTime = UserNews.CreatedTime != null? UserNews.CreatedTime: DateTime.Now;
NewsDataStore Obj = new NewsDataStore();
if (UserNews.id == 0)
{
Obj.AddNews(UserNews);
string np = Request.Form["allProduct"].ToString();
foreach (string s in np.Split(','))
{
if (s != "")
{
Obj.AddNewsProduct(new SA_NewsAndProductRelation {
SA_NewsId = UserNews.id,
SA_ProductId = Convert.ToInt16(s)
});
}
}
}
else
{
Obj.EditNews(UserNews);
string np = Request.Form["allProduct"].ToString();
Obj.DeleteNewsProduct(UserNews.id);
foreach (string s in np.Split(','))
{
if (s != "")
{
Obj.AddNewsProduct(new SA_NewsAndProductRelation
{
SA_NewsId = UserNews.id,
SA_ProductId = Convert.ToInt16(s)
});
}
}
}
return(RedirectToAction("News"));
}
public bool DeleteNews(int NewsId)
{
// News.CreatedDate = DateTime.Now;
SA_News EditNews = _context.SA_News.Where(News => News.id == NewsId).FirstOrDefault();
_context.Entry(EditNews).State = EntityState.Deleted;
int x = _context.SaveChanges();
return(x == 0 ? false : true);
}
public ActionResult EditNews(int id)
{
NewsDataStore Obj = new NewsDataStore();
SA_News obj = Obj.GetNewsByid(id);
List <SelectListItem> productList = Obj.GetProductList();
SA_NewsViewModel objSaCatV = new SA_NewsViewModel();
objSaCatV.id = obj.id;
objSaCatV.NewsName = obj.NewsName;
objSaCatV.NewsDiscription = obj.NewsDiscription;
objSaCatV.URL = obj.URL;
objSaCatV.MetaDiscription = obj.MetaDiscription;
objSaCatV.Keywords = obj.Keywords;
objSaCatV.ProductList = productList;
objSaCatV.Product = obj.Product.ToString();
return(View("add-News", objSaCatV));
}
public bool EditNews(SA_News News)
{
// News.CreatedDate = DateTime.Now;
SA_News EditNews = _context.SA_News.Where(Cat => Cat.id == News.id).FirstOrDefault();
EditNews.NewsName = News.NewsName;
EditNews.NewsDiscription = News.NewsDiscription;
EditNews.URL = News.URL;
EditNews.MetaDiscription = News.MetaDiscription;
EditNews.Keywords = News.Keywords;
EditNews.MetaTitle = News.MetaTitle;
EditNews.Product = News.Product;
EditNews.CreatedTime = News.CreatedTime;
if (News.NewsImg != null)
{
EditNews.NewsImg = News.NewsImg;
}
_context.Entry(EditNews).State = EntityState.Modified;
int x = _context.SaveChanges();
return(x == 0 ? false : true);
}
