public HttpResponseMessage UpsertInventory(HttpRequestMessage request, tbInventory tbInventory)
{
Context ctx = new Context();
InventoryRepository inventoryRepo = new InventoryRepository(ctx);
StockRepository stockRepo = new StockRepository(ctx);
tbInventory UpdatedEntity = null;
//if (tbInventory.ID > 0)
//{
// UpdatedEntity = inventoryRepo.update(tbInventory);
//}
if (tbInventory.TransactionType == "2") //Transaction Type : Justifity
{
tbStock tbStock = stockRepo.GetDataSet().Where(a => a.IsDeleted != true && a.ItemGUID == tbInventory.ItemGUID).FirstOrDefault();
if (tbStock.StockQty >= tbInventory.Qty)// Check the given quantity is enough or not in the stock table.
{
tbInventory.FlowType = "Justify";
tbInventory.Accesstime = DateTime.UtcNow.ToLocalTime();
tbInventory.IsDeleted = false;
tbInventory.UniqueID = Guid.NewGuid();
tbInventory.TotalItemPrice = Convert.ToDecimal(tbInventory.ItemPrice * tbInventory.Qty);
UpdatedEntity = inventoryRepo.Add(tbInventory);
tbStock tbStock1 = stockRepo.GetDataSet().Where(a => a.IsDeleted != true && a.ItemGUID == tbInventory.ItemGUID).FirstOrDefault();
tbStock1.StockQty -= tbInventory.Qty;
stockRepo.update(tbStock1);
}
else
{
return(request.CreateResponse <tbInventory>(HttpStatusCode.OK, UpdatedEntity));;
}
}
else
{
tbInventory.FlowType = "StockIn";
tbInventory.Accesstime = DateTime.UtcNow.ToLocalTime();
tbInventory.IsDeleted = false;
tbInventory.UniqueID = Guid.NewGuid();
tbInventory.TotalItemPrice = Convert.ToDecimal(tbInventory.ItemPrice * tbInventory.Qty);
UpdatedEntity = inventoryRepo.Add(tbInventory);
tbStock tbStock = stockRepo.GetDataSet().Where(a => a.IsDeleted != true && a.ItemGUID == tbInventory.ItemGUID).FirstOrDefault();
tbStock.StockQty += tbInventory.Qty;
stockRepo.update(tbStock);
}
return(request.CreateResponse <tbInventory>(HttpStatusCode.OK, UpdatedEntity));
}
public IHttpActionResult PostInventory(InventoryViewModel inventory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
_inventoryRepository.Add(inventory.ToModel());
}
catch (DbUpdateException)
{
if (InventoryExist(inventory.Id))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = inventory.Id }, inventory));
}
public ActionResult Create([Bind(Include = "ID,Name,Code,TotalAmount")] Inventory inventory)
{
if (ModelState.IsValid)
{
db.Add(inventory);
return(RedirectToAction("Index"));
}
return(View(inventory));
}
public async void Add_AppendsDataSet_WhenGivenObject()
{
var expected = new Beer
{
Id = 100,
Barrelage = 100,
Name = "Duff Foo Boo",
Style = "Ghost Porter"
};
await _testObject.Add(_clientId, expected);
Assert.True(_data.TryGetValue(CreateKey(expected.Id), out var actual), "Item not found");
Assert.Equal(expected, actual);
}
protected override void OnLoad(EventArgs e)
{
AddAction("افزودن", btn =>
{
var result = viewEngine.ViewInForm <view.Inventory.Editor>(null, true);
if (result.DialogResult == DialogResult.OK)
{
IInventory inventory = new InventoryRepository();
if (inventory.Add(result.Entity))
{
MessageBox.Show("انبار با موفقیت ثبت شد", "پیام سیستم");
grid.AddItem(result.Entity);
grid.ResetBindings();
}
else
{
MessageBox.Show("مشکل در ثبت انبار به وجود آمد", "پیام سیستم");
}
}
});
AddAction("ویرایش", btn =>
{
var result = viewEngine.ViewInForm <view.Inventory.Editor>(editor =>
{
editor.Entity = grid.CurrentItem;
}, true);
if (result.DialogResult == DialogResult.OK)
{
IInventory inventory = new InventoryRepository();
if (inventory.Update(result.Entity))
{
MessageBox.Show("انبار با موفقیت ویرایش شد", "پیام سیستم");
grid.ResetBindings();
}
else
{
MessageBox.Show("مشکل در ویرایش انبار به وجود آمد", "پیام سیستم");
}
}
});
AddAction("حذف", btn =>
{
if (grid.CurrentItem == null)
{
return;
}
if (MessageBox.Show("آیا میخواهید حذف کنید ؟", "پیام سیستم", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
IInventory inventory = new InventoryRepository();
int dn = inventory.CanDelete(grid.CurrentItem.InventoryId);
if (dn != 0)
{
MessageBox.Show("این مورد به علت وابستگی به" + dn + "مواردامکان پاک شدن ندارد", "پیام سیستم");
}
else
{
if (inventory.Delete(grid.CurrentItem.InventoryId))
{
MessageBox.Show("انبار با موفقیت حذف شد", "پیام سیستم");
grid.RemoveCurrent();
grid.ResetBindings();
}
else
{
MessageBox.Show("مشکل در حذف انبار به وجود آمد", "پیام سیستم");
}
}
}
});
grid = new Framwork.GirdControl <Entities.Inventory>(this);
grid.AddTextBoxColumn(p => p.CorporationId, "شناسه");
grid.AddTextBoxColumn(p => p.Title, "نام انبار");
grid.AddTextBoxColumn(p => p.CorporationId, "کد شرکت");
grid.AddTextBoxColumn(p => p.Telephone, "شماره تماس");
grid.AddTextBoxColumn(p => p.Address, "نشانی");
grid.AddTextBoxColumn(p => p.Description, "توضیحات");
grid.SetDataSource(Invs.GetAll());
base.OnLoad(e);
}
public void Add(Inventory entity)
{
_inventoryRepository.Add(entity);
}
public HttpResponseMessage UpsertOrderDetail(HttpRequestMessage request, string items)
{
#region Instances
Context ctx = new Context();
ItemRepository itemRepo = new ItemRepository(ctx);
StockRepository stockRepo = new StockRepository(ctx);
OrderRepository orderRepo = new OrderRepository(ctx);
OrderDetailRepository orderDetailRepo = new OrderDetailRepository(ctx);
InventoryRepository inventoryRepo = new InventoryRepository(ctx);
tbItem tbItem = new tbItem();
tbStock tbStock = new tbStock();
tbInventory tbInventory = new tbInventory();
tbOrder tbOrder = new tbOrder();
tbOrderDetail tbOrderDetail = new tbOrderDetail();
tbOrder UpdatedOrder = null;
tbOrderDetail UpdatedEntity = null;
decimal totalPrice = 0;
string voucherCode = Guid.NewGuid().ToString();
#endregion
#region insert order table
tbOrder.StaffGUID = "Default";
tbOrder.StaffName = "Default";
tbOrder.CinemaId = 1;
tbOrder.CinemaName = "";
tbOrder.VoucherCode = voucherCode;
tbOrder.Accesstime = DateTime.UtcNow.ToLocalTime();
tbOrder.IsDeleted = false;
tbOrder.TotalPrice = totalPrice;
tbOrder.CreatedAt = DateTime.UtcNow.ToLocalTime();
tbOrder.Status = "Default";
tbOrder.ServiceFees = 0;
tbOrder.SubTotalPrice = tbOrder.TotalPrice;
tbOrder.TotalTax = 0;
tbOrder.TaxIncluded = false;
tbOrder.Currency = "";
tbOrder.TotalDiscounts = 0;
tbOrder.TotalItemPrice = tbOrder.TotalPrice;
tbOrder.DiscountCode = "";
tbOrder.Remark = "";
UpdatedOrder = orderRepo.Add(tbOrder);
#endregion
List <string> itemList = items.Split(',').ToList();
foreach (string item in itemList)
{
string[] idVal = item.Split('|').ToArray();
string itemGUID = idVal[0];
int qty = Convert.ToInt32(idVal[1]);
tbItem = itemRepo.GetDataSet().Where(a => a.IsDeleted != true && a.UniqueID.ToString() == itemGUID).FirstOrDefault();
//if(tbStock.StockQty>=qty)
//{ }
#region Add order detail.
tbOrderDetail.ItemID = tbItem.ID;
tbOrderDetail.ItemName = tbItem.Item;
tbOrderDetail.ItemPrice = tbItem.SellingPrice;
tbOrderDetail.ItemQty = qty;
tbOrderDetail.TotalPrice = tbOrderDetail.ItemPrice * qty;
totalPrice += Convert.ToDecimal(tbOrderDetail.TotalPrice);
tbOrderDetail.VoucherCode = voucherCode;
tbOrderDetail.OrderID = UpdatedOrder.ID;
tbOrderDetail.CinemaID = tbOrder.CinemaId;
tbOrderDetail.CinemaName = tbOrder.CinemaName;
tbOrderDetail.IsDeleted = false;
UpdatedEntity = orderDetailRepo.Add(tbOrderDetail);
#endregion
#region update stock table.
tbStock = stockRepo.GetDataSet().Where(s => s.IsDeleted != true && s.ItemGUID.ToString() == itemGUID && s.CinemaID == tbOrder.CinemaId).FirstOrDefault();
tbStock.StockQty = tbStock.StockQty - qty;
tbStock.Accesstime = DateTime.UtcNow.ToLocalTime();
stockRepo.update(tbStock);
#endregion
#region update inventory table.
tbInventory.FlowType = "StockOut";
tbInventory.ItemPrice = tbItem.SellingPrice;
tbInventory.TotalItemPrice = totalPrice;
tbInventory.IsDeleted = false;
tbInventory.Accesstime = DateTime.UtcNow.ToLocalTime();
tbInventory.UniqueID = Guid.NewGuid();
tbInventory.ItemGUID = tbItem.UniqueID;
tbInventory.ItemName = tbItem.Item;
tbInventory.TransactionType = "3"; //TransactionType:3 (StockOut)
tbInventory.CinemaID = tbOrder.CinemaId;
tbInventory.Qty = qty;
inventoryRepo.Add(tbInventory);
#endregion
}
#region update total price to order table
tbOrder = orderRepo.GetDataSet().Where(x => x.IsDeleted != true && x.VoucherCode == voucherCode).FirstOrDefault();
tbOrder.TotalPrice = totalPrice;
tbOrder.TotalItemPrice = totalPrice;
orderRepo.update(tbOrder);
#endregion
return(request.CreateResponse <tbOrderDetail>(HttpStatusCode.OK, UpdatedEntity));
}