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); } }