public string UpdateProduct(int id, Product product) { try { Sell_BuyEntities db = new Sell_BuyEntities(); Product p = db.Products.Find(id); p.name = product.name; p.delivery_date = product.delivery_date; p.price = product.price; p.quantity = product.quantity; p.id_brand = product.id_brand; p.currency = product.currency; p.C_description = product.C_description; p.producer = product.producer; p.C_image = product.C_image; p.rating = product.rating; p.id_magazine = product.id_magazine; p.C_status = product.C_status; db.SaveChanges(); return(p.name + "was succefully updated"); } catch (Exception e) { return("Error:" + e.Message); } }
public string UpdateUser(int id, User user) { try { Sell_BuyEntities db = new Sell_BuyEntities(); User u = db.Users.Find(id); u.name_first = user.name_first; u.name_last = user.name_last; u.name_middle = user.name_middle; u.phone = user.phone; u.mail = user.mail; u.id_country = user.id_country; u.id_region = user.id_region; u.id_sity = user.id_sity; //u.C_status = user.C_status; //u.active = user.active; u.id_language = user.id_language; u.C_image = user.C_image; //u.date_register = user.date_register; u.C_login = user.C_login; u.C_password = user.C_password; db.SaveChanges(); return("Информация изменена"); } catch (Exception e) { return("Error:" + e.Message); } }
public string UpdateLoginProfile(int _iduser, string newlogin) { string strResult = ""; try { Sell_BuyEntities db = new Sell_BuyEntities(); var result = db.Users.SingleOrDefault(u => u.id == _iduser); if (result != null) { var user = db.Users.FirstOrDefault(x => x.C_login == newlogin); if (user != null) { strResult = "Пользователь стаким логином уже существует \n"; } else { result.C_login = newlogin; db.SaveChanges(); strResult = "Логин успешно изменен на " + newlogin; } } } catch (Exception e) { strResult = "Error !"; nLog.WriteLog("DB_Entity_DAL -> DB_Operation -> DB_User -> UpdateLoginProfile :\r\n Message: " + e.Message + "\r\n " + e.StackTrace + "", 0); } return(strResult); }
public List <Region> GetRegionByIdCountry(int id) { Sell_BuyEntities db = new Sell_BuyEntities(); var regionToCountry = (from r in db.Regions where r.id_country == id select r).ToList(); return(regionToCountry); }
public List <City> GetCityByIdRegion(int id) { Sell_BuyEntities db = new Sell_BuyEntities(); var regionToCountry = (from r in db.Cities where r.id_region == id select r).ToList(); return(regionToCountry); }
public List <string> GetDirection(int id) { Sell_BuyEntities db = new Sell_BuyEntities(); List <string> userDirection = new List <string>(); var us = (from u in db.Users where u.id == id select u).ToList(); userDirection.Add(us[0].Country.name_country); userDirection.Add(us[0].Region.name_region); userDirection.Add(us[0].City.name_sity); return(userDirection); }
public string InsertRegion(Region region) { try { Sell_BuyEntities db = new Sell_BuyEntities(); db.Regions.Add(region); db.SaveChanges(); return(region.name_region + " was succefully inserted"); } catch (Exception e) { return("Error:" + e.Message); } }
public string InsertLanguage(Language language) { try { Sell_BuyEntities db = new Sell_BuyEntities(); db.Languages.Add(language); db.SaveChanges(); return(language.translate + "was succefully inserted"); } catch (Exception e) { return("Error:" + e.Message); } }
public string InsertLastView(LastView lastview) { try { Sell_BuyEntities db = new Sell_BuyEntities(); db.LastViews.Add(lastview); db.SaveChanges(); return("was succefully inserted"); } catch (Exception e) { return("Error:" + e.Message); } }
public int InsertMagazine(Magazine magazine) { try { Sell_BuyEntities db = new Sell_BuyEntities(); db.Magazines.Add(magazine); db.SaveChanges(); return(magazine.id); } catch (Exception e) { return(0); } }
public string InsertCountry(Country country) { try { Sell_BuyEntities db = new Sell_BuyEntities(); db.Countries.Add(country); db.SaveChanges(); return(country.name_country + "was succefully inserted"); } catch (Exception e) { return("Error:" + e.Message); } }
public string InsertBrand(Brand brand) { try { Sell_BuyEntities db = new Sell_BuyEntities(); db.Brands.Add(brand); db.SaveChanges(); return(brand.name_brand + "was succefully inserted"); } catch (Exception e) { return("Error:" + e.Message); } }
public string InsertBasket(Basket basket) { try { Sell_BuyEntities db = new Sell_BuyEntities(); db.Baskets.Add(basket); db.SaveChanges(); return(basket.Product.name + "was succefully inserted"); } catch (Exception e) { return("Error:" + e.Message); } }
public string InsertRegion(City sity) { try { Sell_BuyEntities db = new Sell_BuyEntities(); db.Cities.Add(sity); db.SaveChanges(); return(sity.name_sity + " was succefully inserted"); } catch (Exception e) { return("Error:" + e.Message); } }
public string InsertComments(Comment comment) { try { Sell_BuyEntities db = new Sell_BuyEntities(); db.Comments.Add(comment); db.SaveChanges(); return(comment.comment1 + "was succefully inserted"); } catch (Exception e) { return("Error:" + e.Message); } }
public string UpdateBasket(int id, Brand brand) { try { Sell_BuyEntities db = new Sell_BuyEntities(); Brand b = db.Brands.Find(id); b.name_brand = brand.name_brand; db.SaveChanges(); return(b.name_brand + "was succefully updated"); } catch (Exception e) { return("Error:" + e.Message); } }
public Basket GetBasket(int id) { try { using (Sell_BuyEntities db = new Sell_BuyEntities()) { Basket basket = db.Baskets.Find(id); return(basket); } } catch (Exception) { return(null); } }
public List <string> GetCountiesName() { try { using (Sell_BuyEntities db = new Sell_BuyEntities()) { List <string> country = db.Countries.Select(d => d.name_country).ToList(); return(country); } } catch (Exception) { return(null); } }
public Region GetRegion(int id) { try { using (Sell_BuyEntities db = new Sell_BuyEntities()) { Region region = db.Regions.Find(id); return(region); } } catch (Exception) { return(null); } }
public string UpdateCountry(int id, Country country) { try { Sell_BuyEntities db = new Sell_BuyEntities(); Country c = db.Countries.Find(id); c.name_country = country.name_country; db.SaveChanges(); return(c.name_country + "was succefully updated"); } catch (Exception e) { return("Error:" + e.Message); } }
public Country GetCountry(int id) { try { using (Sell_BuyEntities db = new Sell_BuyEntities()) { Country country = db.Countries.Find(id); return(country); } } catch (Exception) { return(null); } }
public bool InsertUserShop(Shop us_m) { try { Sell_BuyEntities db = new Sell_BuyEntities(); db.Shops.Add(us_m); db.SaveChanges(); return(true); } catch (Exception e) { nLog.WriteLog("DB_Entity_DAL -> DB_Operation -> DB_Shop -> InsertUserShop :\r\n Message: " + e.Message + "\r\n " + e.StackTrace + "", 0); return(false); } }
public Product GetProduct(int id) { try { using (Sell_BuyEntities db = new Sell_BuyEntities()) { Product product = db.Products.Find(id); return(product); } } catch (Exception) { return(null); } }
public string UpdateBasket(int id, Basket basket) { try { Sell_BuyEntities db = new Sell_BuyEntities(); Basket b = db.Baskets.Find(id); b.id_user = basket.id_user; b.id_product = basket.id_product; db.SaveChanges(); return(b.id_product.Value + "was succefully updated"); } catch (Exception e) { return("Error:" + e.Message); } }
public List <Product> GetallProducts() { try { using (Sell_BuyEntities db = new Sell_BuyEntities()) { List <Product> products = (from x in db.Products select x).ToList(); return(products); } } catch (Exception) { return(null); } }
public List <Language> GetallLanguages() { try { using (Sell_BuyEntities db = new Sell_BuyEntities()) { List <Language> language = (from x in db.Languages select x).ToList(); return(language); } } catch (Exception) { return(null); } }
public List <Comment> GetallComments() { try { using (Sell_BuyEntities db = new Sell_BuyEntities()) { List <Comment> comment = (from x in db.Comments select x).ToList(); return(comment); } } catch (Exception) { return(null); } }
public List <City> GetallCity() { try { using (Sell_BuyEntities db = new Sell_BuyEntities()) { List <City> sity = (from x in db.Cities select x).ToList(); return(sity); } } catch (Exception) { return(null); } }
public string UpdateLanguage(int id, Language language) { try { Sell_BuyEntities db = new Sell_BuyEntities(); Language l = db.Languages.Find(id); l.translate = language.translate; l.C_status = language.C_status; db.SaveChanges(); return(l.translate + "was succefully updated"); } catch (Exception e) { return("Error:" + e.Message); } }
public List <Magazine> GetallMagazine() { try { using (Sell_BuyEntities db = new Sell_BuyEntities()) { List <Magazine> magazine = (from x in db.Magazines select x).ToList(); return(magazine); } } catch (Exception) { return(null); } }