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