public IHttpActionResult UpdateLookUpValue(MasterSKUandPLU data)
{
if (data != null)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (DbContextTransaction transaction = entity.Database.BeginTransaction())
{
if (data.SkuMaster.Count > 1)
{
updateSKU(data.SkuMaster);
}
if (data.PluMaster.Count > 1)
{
updatePLU(data.PluMaster);
}
entity.SaveChanges();
transaction.Commit();
}
try
{
entity.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
}
return(Ok());
}
public IHttpActionResult SaveLookUpValue(MasterSKUandPLU data)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (DbContextTransaction transaction = entity.Database.BeginTransaction())
{
try
{
if (data.SkuMaster.Count > 0)
{
entity.SkuMasters.AddRange(from u in data.SkuMaster
select new SkuMaster
{
AllowDecimals = u.AllowDecimals,
AvgCost = u.AvgCost,
BestBefore = u.BestBefore,
BrandCode = u.BrandCode,
CatgCode = u.CatgCode,
ColorCode = u.ColorCode,
Consignment = u.Consignment,
CostPrice = u.CostPrice,
CreatedDate = u.CreatedDate,
CSTTaxCode = u.CSTTaxCode,
Disc1 = u.Disc1,
Disc2 = u.Disc2,
Discountable = u.Discountable,
DtPromFrom = u.DtPromFrom,
DtPromTo = u.DtPromTo,
EanCode = u.EanCode,
EanNumber = u.EanNumber,
EffectiveDate = u.EffectiveDate,
ExpiryYear = u.ExpiryYear,
ExpiryMonth = u.ExpiryMonth,
FirstCP = u.FirstCP,
FrTaxCode = u.FrTaxCode,
HSNCode = u.HSNCode,
Inactive = u.Inactive,
Indent = u.Indent,
Kit = u.Kit,
Lastcost = u.Lastcost,
LastUpdated = u.LastUpdated,
MarkDown = u.MarkDown,
Markup = u.Markup,
Matrix = u.Matrix,
MaxBQ = u.MaxBQ,
MBQ = u.MBQ,
MfgCode = u.MfgCode,
MinPrice = u.MinPrice,
MRP = u.MRP,
NewPrice = u.NewPrice,
OnOrder = u.OnOrder,
OpenRate = u.OpenRate,
PackSize = u.PackSize,
PatternCode = u.PatternCode,
Price = u.Price,
PromPrice = u.PromPrice,
Qoh = u.Qoh,
RackNo = u.RackNo,
Remarks = u.Remarks,
Rol = u.Rol,
Roq = u.Roq,
RunningPluNo = u.RunningPluNo,
ShortDesc = u.ShortDesc,
SizeCode = u.SizeCode,
SkuCode = u.SkuCode,
SkuDesc = u.SkuDesc,
SplCess = u.SplCess,
SubCatgCode = u.SubCatgCode,
SupplierCode = u.SupplierCode,
TaxCode = u.TaxCode,
ToAllLocations = u.ToAllLocations,
UOM = u.UOM,
UserId = u.UserId,
WebSKU = u.WebSKU,
WSPrice = u.WSPrice
}
);
}
if (data.PluMaster.Count > 0)
{
//entity.plumasters.AddRange(data.PluMaster);
entity.plumasters.AddRange(from u in data.PluMaster
select new plumaster
{
ACP = u.ACP,
ColorCode = u.ColorCode,
CostPrice = u.CostPrice,
DateCreated = u.DateCreated,
EanCode = u.EanCode,
ExpiryDate = u.ExpiryDate,
ExpiryMonth = u.ExpiryMonth,
ExpiryYear = u.ExpiryYear,
ExtraPrice = u.ExtraPrice,
LUpdatedDate = u.LUpdatedDate,
MRP = u.MRP,
PluMBQ = u.PluMBQ,
PluQty = u.PluQty,
PluShade = u.PluShade,
Priority = u.Priority,
RackNo = u.RackNo,
SalePrice = u.SalePrice,
SizeCode = u.SizeCode,
SkuCode = u.SkuCode,
WSPrice = u.WSPrice,
PluCode = u.PluCode
}
);
}
entity.SaveChanges();
transaction.Commit();
}
catch
{
throw;
}
finally
{
if (transaction != null)
{
transaction.Dispose();
}
}
}
}
catch
{
throw;
}
return(Ok(data));
}
