public int DeleteContent(int contentId)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
int result = 0;
var content = GetContentsById(contentId);
if (content != null)
{
var images = db.ContentImages.Where(x => x.Content_Id == content.Id).ToList();
if (images.Count > 0)
{
foreach (var item in images)
{
db.Entry(item).State = EntityState.Deleted;
db.ContentImages.Remove(item);
db.SaveChanges();
}
}
db.Entry(content).State = EntityState.Deleted;
db.Contents.Remove(content);
result = db.SaveChanges();
}
return(result);
}
}
//ADMİN PANELİ
public List <Category> GetCategoryList()
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Categories.ToList());
}
}
public Category GetCategoryById(int categoryId)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Categories.FirstOrDefault(x => x.Id == categoryId));
}
}
// buraya kadar olan metotlar admin paneli için çalışan metotlar
//WEB UI
public List <Category> GetCategoryContentList()
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Categories.Include(e => e.Contents).Include(e => e.Contents.Select(w => w.ContentImages)).ToList());
}
}
public List <User> GetUserList()
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Users.Include("Role").ToList());
}
}
public User GetUserById(int userId)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Users.FirstOrDefault(x => x.Id == userId));
}
}
public Role GetRoleById(int roleid)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Roles.FirstOrDefault(x => x.Id == roleid));
}
}
public int GetServiceCount()
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Services.Count());
}
}
public int GetContentCount()
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Contents.Count());
}
}
public Service GetServiceById(int serviceId)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Services.FirstOrDefault(x => x.Id == serviceId));
}
}
public ContentImage GetImageById(int imageId)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.ContentImages.FirstOrDefault(x => x.Id == imageId));
}
}
public List <Role> GetRoleList()
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Roles.ToList());
}
}
public Slider GetSliderById(int sliderId)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Sliders.FirstOrDefault(x => x.Id == sliderId));
}
}
public List <Slider> GetSliderList()
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Sliders.ToList());
}
}
public int GetCategoryCount()
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Categories.Count());
}
}
public List <Content> GetContentList()
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Contents.Include("ContentImages").Include("Category").ToList());
}
}
public Content GetContentsById(int contentId)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Contents.FirstOrDefault(x => x.Id == contentId));
}
}
public List <Service> GetServicesList()
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Services.ToList());
}
}
public Content GetContentsDetailById(int contentId)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Contents.Include("ContentImages").Include("Category").FirstOrDefault(x => x.Id == contentId));
}
}
public int UpdateContent(Content model)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
int result = 0;
var content = GetContentsById(model.Id);
if (content != null)
{
content.Title = model.Title;
content.Detail = model.Detail;
content.IsActive = model.IsActive;
content.Panel = model.Panel;
content.Price = model.Price;
content.Location = model.Location;
content.StartDate = model.StartDate;
content.FinishDate = model.FinishDate;
content.Rate = model.Rate;
content.NumberPeople = model.NumberPeople;
content.Category_Id = model.Category_Id;
db.Entry(content).State = EntityState.Modified;
result = db.SaveChanges();
}
return(result);
}
}
public int GetUsertCount()
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
return(db.Users.Count());
}
}
public int AddService(Service model)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
int result = 0;
model.CreatedDate = DateTime.Now;
db.Services.Add(model);
result = db.SaveChanges();
return(result);
}
}
public int AddUser(User model)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
int result = 0;
model.Created_Date = DateTime.Now;
db.Users.Add(model);
result = db.SaveChanges();
return(result);
}
}
public User Login(LoginViewModel loginModel)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
var user = db.Users.FirstOrDefault(x => x.Email == loginModel.Email & x.Password == loginModel.Password);
if (user != null)
{
return(user as User);
}
return(null);
}
}
public int DeleteCategory(int categoryid)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
int result = 0;
var category = GetCategoryById(categoryid);
if (category != null)
{
db.Entry(category).State = EntityState.Deleted;
db.Categories.Remove(category);
result = db.SaveChanges();
}
return(result);
}
}
public int DeleteSlider(int id)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
int result = 0;
var slider = GetSliderById(id);
if (slider != null)
{
db.Entry(slider).State = System.Data.Entity.EntityState.Deleted;
db.Sliders.Remove(slider);
result = db.SaveChanges();
}
return(result);
}
}
public int AddRole(RoleModel model)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
Role rl = new Role()
{
Role_Name = model.RolName,
Created_Date = model.CreatedDate
};
int sonuc = 0;
db.Roles.Add(rl);
sonuc = db.SaveChanges();
return(sonuc);
}
}
public int DeleteRole(int id)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
int result = 0;
var role = GetRoleById(id);
if (role != null)
{
db.Entry(role).State = System.Data.Entity.EntityState.Deleted;
db.Roles.Remove(role);
result = db.SaveChanges();
}
return(result);
}
}
public int UpdateRole(Role model)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
int result = 0;
var role = GetRoleById(model.Id);
if (role != null)
{
role.Role_Name = model.Role_Name;
db.Entry(role).State = System.Data.Entity.EntityState.Modified;
result = db.SaveChanges();
}
return(result);
}
}
public int DeleteService(int serviceId)
{
using (TurizmWebEntities db = new TurizmWebEntities())
{
int result = 0;
var service = GetServiceById(serviceId);
if (service != null)
{
db.Entry(service).State = System.Data.Entity.EntityState.Deleted;
db.Services.Remove(service);
result = db.SaveChanges();
}
return(result);
}
}