public IGernalResult AddItem(ItemDto s) { IGernalResult result = new GernalResult(); try { TblItem item = new TblItem { Name = s.Name, CategoryId = s.CatogeryId, Discription = s.Discription, ImageUrl = s.Image, Price = s.Price, Quantity = s.Quantity, SellerId = Convert.ToInt32(s.SellerId), CreatedDate = DateTime.UtcNow, IsAvailable = true, IsDelete = false }; _dbContext.Add(item); int save = _dbContext.SaveChanges(); result.Succsefully = save > 0 ? true : false; result.Message = save > 0 ? "Selling Item add Succsefully" : "Selling Item not register"; } catch (Exception ex) { result.Succsefully = false; result.Message = "Server error"; } return(result); }
public IGernalResult EditFromCart(int cartId, int Countity) { IGernalResult result = new GernalResult(); TblCart cart = _dbContext.TblCart.Where(w => w.Id == cartId).FirstOrDefault(); try { int totalplaceOrderquantiy = 0; TblItem Item = _dbContext.TblItem.Where(w => w.Id == cart.ItemId).FirstOrDefault(); List <TblOrder> order = _dbContext.TblOrder.Where(w => w.ItemId == cart.ItemId && w.IsCanceled == false).ToList(); if (order != null) { foreach (var item in order) { int v = item.Quantity + totalplaceOrderquantiy; totalplaceOrderquantiy = v; } } int avilableNow = Convert.ToInt32(Item.Quantity) - totalplaceOrderquantiy; if (totalplaceOrderquantiy == Convert.ToInt32(Item.Quantity)) { result.Succsefully = false; result.Message = "Item not availablenow plz try some time later."; } else if (avilableNow < Countity) { result.Succsefully = false; result.Message = "Now we have avilable only" + avilableNow; } else { int total = Convert.ToInt32(cart.PricePerItem) * Countity; cart.TotalPrice = Convert.ToString(total); cart.Quantity = Countity; int save = _dbContext.SaveChanges(); result.Succsefully = save > 0 ? true : false; } } catch { result.Succsefully = false; result.Message = "server error."; } return(result); }
public bool IsAvilableItem(int cartId, int Countity, int itemid) { bool avilable = false; TblCart cart = new TblCart(); if (cartId > 0) { cart = _dbContext.TblCart.Where(w => w.Id == cartId).FirstOrDefault(); } else { cart = _dbContext.TblCart.Where(w => w.ItemId == itemid).FirstOrDefault(); } try { int totalplaceOrderquantiy = 0; TblItem Item = _dbContext.TblItem.Where(w => w.Id == cart.ItemId).FirstOrDefault(); List <TblOrder> order = _dbContext.TblOrder.Where(w => w.ItemId == cart.ItemId && w.IsCanceled == false).ToList(); if (order != null) { foreach (var item in order) { int v = item.Quantity + totalplaceOrderquantiy; totalplaceOrderquantiy = v; } } int avilableNow = Convert.ToInt32(Item.Quantity) - totalplaceOrderquantiy; if (totalplaceOrderquantiy == Convert.ToInt32(Item.Quantity)) { avilable = false; } else if (avilableNow < Countity) { avilable = true; } return(avilable); } catch { throw; } }
public static int Main(string[] args) { string csvDir = "."; if (args.Length > 0) { csvDir = args[0]; } TblCopy tblCopy = new TblCopy(); TblEffect tblEffect = new TblEffect(); TblItem tblItem = new TblItem(); TblNpc tblNpc = new TblNpc(); TblSkillLevel tblSkillLevel = new TblSkillLevel(); string errorInfo; if (tblCopy.Parse(GetTableFileContent( Path.Combine(csvDir, "copy.csv")), out errorInfo) == false) { Console.Error.WriteLine(string.Format( "parse {0} failed: {1}", "copy.csv", errorInfo)); return(1); } if (tblEffect.Parse(GetTableFileContent( Path.Combine(csvDir, "effect.csv")), out errorInfo) == false) { Console.Error.WriteLine(string.Format( "parse {0} failed: {1}", "effect.csv", errorInfo)); return(1); } if (tblItem.Parse(GetTableFileContent( Path.Combine(csvDir, "item.csv")), out errorInfo) == false) { Console.Error.WriteLine(string.Format( "parse {0} failed: {1}", "item.csv", errorInfo)); return(1); } if (tblNpc.Parse(GetTableFileContent( Path.Combine(csvDir, "npc.csv")), out errorInfo) == false) { Console.Error.WriteLine(string.Format( "parse {0} failed: {1}", "npc.csv", errorInfo)); return(1); } if (tblSkillLevel.Parse(GetTableFileContent( Path.Combine(csvDir, "skill_level.csv")), out errorInfo) == false) { Console.Error.WriteLine(string.Format( "parse {0} failed: {1}", "skill_level.csv", errorInfo)); return(1); } { TblEffect.Row row = tblEffect.GetRow(3); if (row != null) { Console.WriteLine(string.Format( "tbl_effect:3:resource_path: {0}", row.resource_path)); } } { List <TblSkillLevel.Row> rowSet = tblSkillLevel.GetRowSet(100503); if (rowSet != null) { Console.WriteLine(string.Format( "tbl_skill_level:100503:range_param:p1: {0}", rowSet[0].range_param.p1)); } } return(0); }