public object ToDisplayCarousel(int UserId) { using (UserDataBase userDataBase = new UserDataBase()) { return(userDataBase.carouselSliders.Where(model => model.ID == UserId).FirstOrDefault()); } }
public List <ProductCategory> ViewProductCategory() { using (UserDataBase userDataBase = new UserDataBase()) { return(userDataBase.productCategory.ToList()); } }
public Inventory ToDisplayProduct(int ProductId) { using (UserDataBase userDataBase = new UserDataBase()) { return(userDataBase.inventory.Where(model => model.ProductId == ProductId).FirstOrDefault()); } }
public List <City> CityList() { using (UserDataBase userDataBase = new UserDataBase()) { return(userDataBase.city.ToList()); } }
public List <Inventory> ViewProduct() { using (UserDataBase userDataBase = new UserDataBase()) { return(userDataBase.inventory.ToList()); } }
public List <State> StateList() { using (UserDataBase userDataBase = new UserDataBase()) { return(userDataBase.state.ToList()); } }
public object ToDisplayProductCategory(int CategoryId) { using (UserDataBase userDataBase = new UserDataBase()) { return(userDataBase.productCategory.Where(model => model.CategoryId == CategoryId).FirstOrDefault()); } }
public object ToDisplay(int UserId) { using (UserDataBase userDataBase = new UserDataBase()) { return(userDataBase.user.Where(model => model.UserId == UserId).FirstOrDefault()); } }
public List <User> CustomerView() { using (UserDataBase userDataBase = new UserDataBase()) { return(userDataBase.user.ToList()); } }
public object ToDisplayCustomer(string UserId) { using (UserDataBase userDataBase = new UserDataBase()) { return(userDataBase.user.Where(model => model.UserName == UserId).FirstOrDefault()); } }
public bool ToUpdateCarousel(CarouselSlider carouselSlider) { using (UserDataBase userDataBase = new UserDataBase()) { userDataBase.Entry(carouselSlider).State = EntityState.Modified; userDataBase.SaveChanges(); return(true); } }
public bool ToRegister(User user) { using (UserDataBase userDataBase = new UserDataBase()) { userDataBase.user.Add(user); userDataBase.SaveChanges(); return(true); } }
public bool ToUpdateProductCategory(ProductCategory inventory) { using (UserDataBase userDataBase = new UserDataBase()) { userDataBase.Entry(inventory).State = EntityState.Modified; userDataBase.SaveChanges(); return(true); } }
public bool ToRegisterProductCategory(ProductCategory inventory) { using (UserDataBase userDataBase = new UserDataBase()) { userDataBase.productCategory.Add(inventory); userDataBase.SaveChanges(); return(true); } }
public bool ToDeleteProductCategory(int CategoryId, ProductCategory inventory) { using (UserDataBase userDataBase = new UserDataBase()) { inventory = userDataBase.productCategory.Where(model => model.CategoryId == CategoryId).FirstOrDefault(); userDataBase.productCategory.Remove(inventory); userDataBase.SaveChanges(); return(true); } }
public bool ToDelete(int UserId, User user) { using (UserDataBase userDataBase = new UserDataBase()) { user = userDataBase.user.Where(model => model.UserId == UserId).FirstOrDefault(); userDataBase.user.Remove(user); userDataBase.SaveChanges(); return(true); } }
public bool ToDeleteCarousel(int UserId, CarouselSlider carouselSlider) { using (UserDataBase userDataBase = new UserDataBase()) { SqlParameter id = new SqlParameter("@ID", UserId); var data = userDataBase.Database.ExecuteSqlCommand("CarouselSlider_Delete @ID", id); //carouselSlider = userDataBase.carouselSliders.Where(model => model.ID == UserId).FirstOrDefault(); //userDataBase.carouselSliders.Remove(carouselSlider); //userDataBase.SaveChanges(); return(true); } }
public bool ToAdd(CarouselSlider carouselSlider) { using (UserDataBase userDataBase = new UserDataBase()) { SqlParameter filename = new SqlParameter("@FileName", carouselSlider.FileName); SqlParameter filesize = new SqlParameter("@FileSize", carouselSlider.FileSize); SqlParameter filepath = new SqlParameter("@FilePath", carouselSlider.FilePath); var data = userDataBase.Database.ExecuteSqlCommand(" CarouselSlider_Insert @FileName,@FileSize,@FilePath", filename, filesize, filepath); //userDataBase.carouselSliders.Add(carouselSlider); //userDataBase.SaveChanges(); return(true); } }
public string CheckLogin(string username, string password) { using (UserDataBase userContext = new UserDataBase()) { var obj = userContext.user.Where(a => a.UserName.Equals(username) && a.Password.Equals(password)).FirstOrDefault(); if (obj != null) { return(obj.UserName); } else { return(null); } } }