public IHttpActionResult UpdateLookUpValue(MasterStock data)
{
if (data != null)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var record = entity.Stocks.Where(x => x.StockDate == data.StockDate && x.LocCode == data.LocCode &&
x.SkuCode == data.SkuCode && x.PluCode == data.PluCode).First();
record.SkuCode = data.SkuCode;
record.ApprIn = data.ApprIn;
record.ApprOut = data.ApprOut;
record.CB = data.CB;
record.CostValue = data.CostValue;
record.DiscCount = data.DiscCount;
record.Discount = data.Discount;
record.FreeQty = data.FreeQty;
record.FreeSales = data.FreeSales;
record.Gst = data.Gst;
//record.LocCode = data.LocCode;
record.OB = data.OB;
record.OldQty = data.OldQty;
//record.PluCode = data.PluCode;
record.Purchase = data.Purchase;
record.PurchaseReturn = data.Purchase;
record.QOH = data.QOH;
record.Refund = data.Refund;
record.Sales = data.Sales;
record.SalesValue = data.SalesValue;
// record.StockDate = data.StockDate;
record.StockTake = data.StockTake;
record.StockWriteOff = data.StockWriteOff;
record.SurchargeAmt = data.SurchargeAmt;
record.TransferIn = data.TransferIn;
record.TransferOut = data.TransferOut;
record.Variance = data.Variance;
try
{
entity.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
}
return(Ok(data));
}
public IHttpActionResult DeleteLookUpValue(MasterStock data)
{
var record = entity.Stocks.Where(x => x.StockDate == data.StockDate && x.LocCode == data.LocCode &&
x.SkuCode == data.SkuCode && x.PluCode == data.PluCode).First();
if (record == null)
{
return(NotFound());
}
entity.Stocks.Remove(record);
entity.SaveChanges();
return(Ok(record));
}
public IHttpActionResult SaveLookUpValue(MasterStock data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
entity.Stocks.Add(new Stock
{
SkuCode = data.SkuCode,
ApprIn = data.ApprIn,
ApprOut = data.ApprOut,
CB = data.CB,
CostValue = data.CostValue,
DiscCount = data.DiscCount,
Discount = data.Discount,
FreeQty = data.FreeQty,
FreeSales = data.FreeSales,
Gst = data.Gst,
LocCode = data.LocCode,
OB = data.OB,
OldQty = data.OldQty,
PluCode = data.PluCode,
Purchase = data.Purchase,
PurchaseReturn = data.Purchase,
QOH = data.QOH,
Refund = data.Refund,
Sales = data.Sales,
SalesValue = data.SalesValue,
StockDate = data.StockDate,
StockTake = data.StockTake,
StockWriteOff = data.StockWriteOff,
SurchargeAmt = data.SurchargeAmt,
TransferIn = data.TransferIn,
TransferOut = data.TransferOut,
Variance = data.Variance
});
entity.SaveChanges();
return(Ok(data));
}
