public bool ChangeTradeStatus(int tradeId,int newStatus) { bool result = false; using (AnanEntities db = new AnanEntities()) { Trade trade = (from t in db.Trade where t.ID == tradeId select t).FirstOrDefault<Trade>(); if (trade == null) { throw new Exception("此订单不存在"); } if (trade.Status == 7) { throw new Exception("此订单已经取消,不能修改状态"); } if (trade.Status == 1 && (newStatus == 3 || newStatus == 4 || newStatus ==5)) { throw new Exception("此订单没有付款,不能设为正在配货,已经发货,订单完成"); } trade.Status = (short)newStatus; db.SaveChanges(); result = true; } return result; }
public bool CancelTrade(int trade_id, int user_id) { bool result = false; using (AnanEntities db = new AnanEntities()) { Trade trade=(from td in db.Trade where td.ID==trade_id select td).FirstOrDefault<Trade>(); if (trade == null) { throw new Exception("此订单不存在"); } if (trade.UserID != user_id) { throw new Exception("您不能取消别人的订单"); } if (trade.Status != 0) { throw new Exception("订单状态不是初始状态,无法取消,请联系客户取消。"); } //7 means cancel trade trade.Status = 7; db.SaveChanges(); result = true; } return result; }
public void SetCorpInfo(CorpInfo info) { using (AnanEntities db = new AnanEntities()) { List<CorpInfo> infos = (from ci in db.CorpInfo orderby ci.ID descending select ci).ToList<CorpInfo>(); if (infos.Count > 0) { info.ID = infos[0].ID; UpdateProperties(infos[0], info); } else { db.CorpInfo.Add(info); } db.SaveChanges(); } }
public Category CreateCategory(int parentId,string name) { Category category = new Category(); if (string.IsNullOrEmpty(name)) { throw new Exception(""); } category.Name = name; category.ParentID = parentId; category.Created = anan.web.Util.DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); if(this.CurrentUser!=null) category.UserID = this.CurrentUser.ID; category.Enabled = true; using (AnanEntities db = new AnanEntities()) { db.Category.Add(category); db.SaveChanges(); } return category; }
public void CreateImage(Image img) { using (AnanEntities db = new AnanEntities()) { img.ProductID = 0; if(img.Path==null) { img.Path=""; } db.Image.Add(img); db.SaveChanges(); } }
public bool UpdateProduct(Product product, int[] images) { bool result = false; using (AnanEntities db = new AnanEntities()) { Product old = (from p in db.Product where p.ID == product.ID select p).FirstOrDefault<Product>(); List<Image> imgs = null; List<int> newImg = new List<int>(); if (old != null) { product.Created = old.Created; base.UpdateProperties(old, product); db.SaveChanges(); imgs=(from i in db.Image where i.ProductID==product.ID select i).ToList<Image>(); for (int i = 0; i < images.Length; i++) { bool found = false; foreach (Image im in imgs) { if (im.ID == images[i]) { found = true; break; } } if (!found) { newImg.Add(images[i]); } } int[] ids = newImg.ToArray<int>(); List<Image> igs = (from im in db.Image where ids.Contains(im.ID) select im).ToList<Image>(); foreach (Image i in igs) { i.ProductID = product.ID; } db.SaveChanges(); result = true; } } return result; }
public void UpdateImage(Image img) { using (AnanEntities db = new AnanEntities()) { Image image = (from i in db.Image where i.ID == img.ID select i).FirstOrDefault<Image>(); if (image != null) { image.ProductID = img.ProductID; image.Path = img.Path; } db.SaveChanges(); } }
public bool UpdateCategoryVisibility(int category_id) { bool result = false; using (AnanEntities db = new AnanEntities()) { Category cate = (from ca in db.Category where ca.ID == category_id select ca).FirstOrDefault<Category>(); if (cate != null) { if ((bool)cate.Enabled) { cate.Enabled = false; } else { cate.Enabled = true; } db.SaveChanges(); result = true; } } return result; }
public void DeleteImage(int imageId) { using (AnanEntities db = new AnanEntities()) { Image image = (from i in db.Image where i.ID == imageId select i).FirstOrDefault<Image>(); if (image != null) { db.Image.Remove(image); } db.SaveChanges(); } }
public bool DeleteCategory(int categoryId) { bool result = false; using (AnanEntities db = new AnanEntities()) { Category c = (from cate in db.Category where cate.ID == categoryId select cate).FirstOrDefault<Category>(); if (c != null) { db.Category.Remove(c); db.SaveChanges(); result = true; } } return result; }
public bool CreateAddress(int userId,int pid,int cid,int did,string addr,string person,string phone) { bool result = false; User_Address address = new User_Address(); address.ProvinceID = pid; address.CityID = cid; address.DistrictID = did; address.Address = addr; address.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); address.Person = person; address.Phone = phone; address.UserID = userId; using (AnanEntities db = new AnanEntities()) { db.User_Address.Add(address); db.SaveChanges(); result = true; } return result; }
/// <summary> /// /// </summary> /// <param name="user"></param> /// <returns></returns> public bool UpdateUser(User user) { bool result = false; using (AnanEntities db = new AnanEntities()) { User dbUser=(from u in db.User where u.ID==user.ID select u).FirstOrDefault<User>(); base.UpdateProperties(dbUser, user); db.SaveChanges(); result = true; } return result; }
public bool SubmitOrder(int user_id,int address_id, List<Product> products,string desc) { bool result = false; if (products != null && address_id > 0) { using (AnanEntities db = new AnanEntities()) { Trade trade = new Trade(); trade.AddressID = address_id; trade.Amount = 0; trade.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); trade.ID = 0; trade.Modified = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); trade.PaidTime = 0; trade.Status = 1; trade.UserID = user_id; if (!string.IsNullOrEmpty(desc)) { trade.Description = desc; } db.Trade.Add(trade); db.SaveChanges(); double amount = 0; foreach (Product product in products) { Trade_Order order = new Trade_Order(); order.Amount = product.Price * product.Quantity; order.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); order.Price = (double)product.Price; order.Quantity = (int)product.Quantity; order.ProductID = product.ID; order.Status = 0; order.TradeID = trade.ID; db.Trade_Order.Add(order); amount += (double)(product.Price * product.Quantity); } trade.Amount = amount; db.SaveChanges(); result = true; } } return result; }
/// <summary> /// /// </summary> /// <param name="user"></param> /// <returns></returns> public bool LocalRegisterUser(User user) { bool result = false; AnanEntities db = new AnanEntities(); try { if (string.IsNullOrEmpty(user.Email)) { throw new Exception(""); } if (string.IsNullOrEmpty(user.Password)) { throw new Exception(""); } user.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); user.Password = Encrypt.MD5(user.Password); db.User.Add(user); db.SaveChanges(); } catch { } finally { if (db != null) { db.Dispose(); } } return result; }
public bool CreateProduct(Product product,int[] images) { bool result = false; using (AnanEntities db = new AnanEntities()) { db.Product.Add(product); db.SaveChanges(); if (product.ID>0 && images != null) { List<Image> imgs = (from im in db.Image where images.Contains(im.ID) select im).ToList<Image>(); foreach (Image i in imgs) { i.ProductID = product.ID; } db.SaveChanges(); result = true; } } return result; }
public bool DeleteImage(int image_id,string serverRoot) { bool result = false; Image image = null; using (AnanEntities db = new AnanEntities()) { image = (from i in db.Image where i.ID == image_id select i).FirstOrDefault<Image>(); if (image != null) { string fullPath = serverRoot+image.Path.Replace("/",@"\"); if (System.IO.File.Exists(fullPath)) { System.IO.File.Delete(fullPath); db.Image.Remove(image); db.SaveChanges(); result = true; } } } return result; }
public bool DeleteAddress(int id,int user_id) { bool result = false; using (AnanEntities db = new AnanEntities()) { User_Address address=(from add in db.User_Address where add.ID==id && add.UserID==user_id select add).FirstOrDefault<User_Address>(); if (address == null) { } else { db.User_Address.Remove(address); db.SaveChanges(); result = true; } } return result; }