public bool Insert(Models.Banner banner)
{
using (Models.CMSContext db = new Models.CMSContext())
{
db.Banners.Add(banner);
}
return(true);
}
public bool ValidateUser(Models.User users)
{
using (Models.CMSContext db = new Models.CMSContext())
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
return(true);
}
}
public bool Delete(Models.Banner banner)
{
try
{
using (Models.CMSContext db = new Models.CMSContext())
{
var id = db.Banners.Find(banner.IdBanner);
db.Banners.Remove(id);
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
public bool Edit(Models.Banner banner)
{
try
{
using (Models.CMSContext db = new Models.CMSContext())
{
var id = db.Banners.Find(banner.IdBanner);
id.Header = banner.Header;
db.Entry(id).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
