public IHttpActionResult GetStockDistributionSummary(int id)
{
StockDistributionSummary stockDistributionSummary = db.StockDistributionSummaries.Find(id);
if (stockDistributionSummary == null)
{
return(NotFound());
}
return(Ok(stockDistributionSummary));
}
public IHttpActionResult PutStockDistributionSummary(int id, StockDistributionSummary stock1)
{
var stockDistribution = db.StockDistributionSummaries.Where(s => s.Id == stock1.Id).FirstOrDefault();
DateTime dNow = DateTime.Now;
stockDistribution.DistributionNumber = 1;
stockDistribution.DateClose = dNow;
stockDistribution.UpdatedOn = System.DateTime.UtcNow;
stockDistribution.IsActive = false;
db.SaveChanges();
return(Ok(true));
}
public IHttpActionResult DeleteStockDistributionSummary(int id)
{
StockDistributionSummary stockDistributionSummary = db.StockDistributionSummaries.Find(id);
if (stockDistributionSummary == null)
{
return(NotFound());
}
db.StockDistributionSummaries.Remove(stockDistributionSummary);
db.SaveChanges();
return(Ok(stockDistributionSummary));
}
public IHttpActionResult PostStockDistributionSummary(StockDistributionSummary stock)
{
StockDistributionSummary stockDistributionSummary = new StockDistributionSummary();
stockDistributionSummary.Id = stock.Id;
DateTime dNow = DateTime.Now;
stockDistributionSummary.DateOpen = dNow;
stockDistributionSummary.IsActive = true;
stockDistributionSummary.LogId = 2;
stockDistributionSummary.DistributionNumber = 1;
stockDistributionSummary.CreatedOn = System.DateTime.UtcNow;
stockDistributionSummary.UpdatedOn = System.DateTime.UtcNow;
// stockDistributionSummary.DistributionNumber = stock.DistributionNumber;
db.StockDistributionSummaries.Add(stockDistributionSummary);
db.SaveChanges();
return(Ok(true));
}
public IHttpActionResult PutStockData(StockDistributionViewModel model)
{
var stockDistribution1 = new StockDistribution();
foreach (var item in model.BranchDistribution)
{
if (item.Id != 0)
{
var stockDistribution = db.StockDistributions.Where(s => s.Id == item.Id).FirstOrDefault();
stockDistribution.ProductID = item.ProductId;
stockDistribution.BranchId = item.BranchId;
stockDistribution.Quantity01 = Convert.ToInt32(item.Quantity01);
stockDistribution.Quantity02 = Convert.ToInt32(item.Quantity02);
stockDistribution.Quantity03 = Convert.ToInt32(item.Quantity03);
stockDistribution.Quantity04 = Convert.ToInt32(item.Quantity04);
stockDistribution.Quantity05 = Convert.ToInt32(item.Quantity05);
stockDistribution.Quantity06 = Convert.ToInt32(item.Quantity06);
stockDistribution.Quantity07 = Convert.ToInt32(item.Quantity07);
stockDistribution.Quantity08 = Convert.ToInt32(item.Quantity08);
stockDistribution.Quantity09 = Convert.ToInt32(item.Quantity09);
stockDistribution.Quantity10 = Convert.ToInt32(item.Quantity10);
stockDistribution.Quantity11 = Convert.ToInt32(item.Quantity11);
stockDistribution.Quantity12 = Convert.ToInt32(item.Quantity12);
stockDistribution.Quantity13 = Convert.ToInt32(item.Quantity13);
stockDistribution.Quantity14 = Convert.ToInt32(item.Quantity14);
stockDistribution.Quantity15 = Convert.ToInt32(item.Quantity15);
stockDistribution.Quantity16 = Convert.ToInt32(item.Quantity16);
stockDistribution.Quantity17 = Convert.ToInt32(item.Quantity17);
stockDistribution.Quantity18 = Convert.ToInt32(item.Quantity18);
stockDistribution.Quantity19 = Convert.ToInt32(item.Quantity19);
stockDistribution.Quantity20 = Convert.ToInt32(item.Quantity20);
stockDistribution.Quantity21 = Convert.ToInt32(item.Quantity21);
stockDistribution.Quantity22 = Convert.ToInt32(item.Quantity22);
stockDistribution.Quantity23 = Convert.ToInt32(item.Quantity23);
stockDistribution.Quantity24 = Convert.ToInt32(item.Quantity24);
stockDistribution.Quantity25 = Convert.ToInt32(item.Quantity25);
stockDistribution.Quantity26 = Convert.ToInt32(item.Quantity26);
stockDistribution.Quantity27 = Convert.ToInt32(item.Quantity27);
stockDistribution.Quantity28 = Convert.ToInt32(item.Quantity28);
stockDistribution.Quantity29 = Convert.ToInt32(item.Quantity29);
stockDistribution.Quantity30 = Convert.ToInt32(item.Quantity30);
stockDistribution.StockDistributionSummaryId = Convert.ToInt32(item.StockDistributionSummaryId);
stockDistribution.IsActive = true;
stockDistribution1.StockDistributionStatusId = 1;
db.SaveChanges();
}
else if (item.Id == 0)
{
if (item.Quantity01 != 0 || item.Quantity02 != 0 || item.Quantity03 != 0 || item.Quantity04 != 0 || item.Quantity05 != 0 || item.Quantity06 != 0 || item.Quantity07 != 0 || item.Quantity08 != 0 || item.Quantity09 != 0 || item.Quantity10 != 0 || item.Quantity11 != 0 || item.Quantity12 != 0 || item.Quantity13 != 0 || item.Quantity14 != 0 || item.Quantity15 != 0 || item.Quantity16 != 0 || item.Quantity17 != 0 || item.Quantity18 != 0 || item.Quantity19 != 0 || item.Quantity20 != 0 ||
item.Quantity21 != 0 || item.Quantity22 != 0 || item.Quantity23 != 0 || item.Quantity24 != 0 || item.Quantity25 != 0 || item.Quantity26 != 0 || item.Quantity27 != 0 || item.Quantity29 != 0 || item.Quantity29 != 0 || item.Quantity30 != 0)
{
stockDistribution1.ProductID = item.ProductId;
stockDistribution1.BranchId = item.BranchId;
// stockDistribution.Name = item.Name;
stockDistribution1.Quantity01 = Convert.ToInt32(item.Quantity01);
stockDistribution1.Quantity02 = Convert.ToInt32(item.Quantity02);
stockDistribution1.Quantity03 = Convert.ToInt32(item.Quantity03);
stockDistribution1.Quantity04 = Convert.ToInt32(item.Quantity04);
stockDistribution1.Quantity05 = Convert.ToInt32(item.Quantity05);
stockDistribution1.Quantity06 = Convert.ToInt32(item.Quantity06);
stockDistribution1.Quantity07 = Convert.ToInt32(item.Quantity07);
stockDistribution1.Quantity08 = Convert.ToInt32(item.Quantity08);
stockDistribution1.Quantity09 = Convert.ToInt32(item.Quantity09);
stockDistribution1.Quantity10 = Convert.ToInt32(item.Quantity10);
stockDistribution1.Quantity11 = Convert.ToInt32(item.Quantity11);
stockDistribution1.Quantity12 = Convert.ToInt32(item.Quantity12);
stockDistribution1.Quantity13 = Convert.ToInt32(item.Quantity13);
stockDistribution1.Quantity14 = Convert.ToInt32(item.Quantity14);
stockDistribution1.Quantity15 = Convert.ToInt32(item.Quantity15);
stockDistribution1.Quantity16 = Convert.ToInt32(item.Quantity16);
stockDistribution1.Quantity17 = Convert.ToInt32(item.Quantity17);
stockDistribution1.Quantity18 = Convert.ToInt32(item.Quantity18);
stockDistribution1.Quantity19 = Convert.ToInt32(item.Quantity19);
stockDistribution1.Quantity20 = Convert.ToInt32(item.Quantity20);
stockDistribution1.Quantity21 = Convert.ToInt32(item.Quantity21);
stockDistribution1.Quantity22 = Convert.ToInt32(item.Quantity22);
stockDistribution1.Quantity23 = Convert.ToInt32(item.Quantity23);
stockDistribution1.Quantity24 = Convert.ToInt32(item.Quantity24);
stockDistribution1.Quantity25 = Convert.ToInt32(item.Quantity25);
stockDistribution1.Quantity26 = Convert.ToInt32(item.Quantity26);
stockDistribution1.Quantity27 = Convert.ToInt32(item.Quantity27);
stockDistribution1.Quantity28 = Convert.ToInt32(item.Quantity28);
stockDistribution1.Quantity29 = Convert.ToInt32(item.Quantity29);
stockDistribution1.Quantity30 = Convert.ToInt32(item.Quantity30);
stockDistribution1.StockDistributionSummaryId = Convert.ToInt32(item.StockDistributionSummaryId);
stockDistribution1.IsActive = true;
stockDistribution1.StockDistributionStatusId = 1;
DateTime dNow1 = DateTime.Now;
stockDistribution1.DistributionDate = dNow1;
db.StockDistributions.Add(stockDistribution1);
db.SaveChanges();
}
}
}
// var StockInventory = model.ProductInventory;
//return Ok(true);
var stockInventory1 = db.StockInventories.Where(x => x.IsActive == true && x.ProductID == model.ProductInventory.ProductId).FirstOrDefault();
// stockInventory1.Id = model.ProductInventory.Id;
// stockInventory1.ProductID = (int)model.ProductInventory.ProductId;
stockInventory1.Quantity01 = model.ProductInventory.Quantity01;
stockInventory1.Quantity02 = model.ProductInventory.Quantity02;
stockInventory1.Quantity03 = model.ProductInventory.Quantity03;
stockInventory1.Quantity04 = model.ProductInventory.Quantity04;
stockInventory1.Quantity05 = model.ProductInventory.Quantity05;
stockInventory1.Quantity06 = model.ProductInventory.Quantity06;
stockInventory1.Quantity07 = model.ProductInventory.Quantity07;
stockInventory1.Quantity08 = model.ProductInventory.Quantity08;
stockInventory1.Quantity09 = model.ProductInventory.Quantity09;
stockInventory1.Quantity10 = model.ProductInventory.Quantity10;
stockInventory1.Quantity11 = model.ProductInventory.Quantity11;
stockInventory1.Quantity12 = model.ProductInventory.Quantity12;
stockInventory1.Quantity13 = model.ProductInventory.Quantity13;
stockInventory1.Quantity14 = model.ProductInventory.Quantity14;
stockInventory1.Quantity15 = model.ProductInventory.Quantity15;
stockInventory1.Quantity16 = model.ProductInventory.Quantity16;
stockInventory1.Quantity17 = model.ProductInventory.Quantity17;
stockInventory1.Quantity18 = model.ProductInventory.Quantity18;
stockInventory1.Quantity19 = model.ProductInventory.Quantity19;
stockInventory1.Quantity20 = model.ProductInventory.Quantity20;
stockInventory1.Quantity21 = model.ProductInventory.Quantity21;
stockInventory1.Quantity22 = model.ProductInventory.Quantity22;
stockInventory1.Quantity23 = model.ProductInventory.Quantity23;
stockInventory1.Quantity24 = model.ProductInventory.Quantity24;
stockInventory1.Quantity25 = model.ProductInventory.Quantity25;
stockInventory1.Quantity26 = model.ProductInventory.Quantity26;
stockInventory1.Quantity27 = model.ProductInventory.Quantity27;
stockInventory1.Quantity28 = model.ProductInventory.Quantity28;
stockInventory1.Quantity29 = model.ProductInventory.Quantity29;
stockInventory1.Quantity30 = model.ProductInventory.Quantity30;
stockInventory1.IsActive = true;
db.SaveChanges();
//db.Entry(stockInventory1).State = EntityState.Modified;
var stockDistributionSummary = new StockDistributionSummary();
stockDistributionSummary.Id = model.StockDistributionSummaryModel.Id;
DateTime dNow = DateTime.Now;
stockDistributionSummary.DateClose = dNow;
stockDistributionSummary.IsActive = true;
db.SaveChanges();
return(Ok(true));
}
