public IHttpActionResult GetSizeGrid(int id)
{
SizeGrid sizeGrid = db.SizeGrids.Find(id);
if (sizeGrid == null)
{
return(NotFound());
}
return(Ok(sizeGrid));
}
public IHttpActionResult DeleteSizeGrid(int id)
{
SizeGrid sizeGrid = db.SizeGrids.Find(id);
if (sizeGrid == null)
{
return(NotFound());
}
sizeGrid.IsActive = false;
sizeGrid.UpdatedOn = System.DateTime.UtcNow;
db.SaveChanges();
return(Ok(sizeGrid));
}
public bool GetEmail(SizeGrid model)
{
if (model.Id > 0)
{
var code = db.SizeGrids.Where(x => x.Id == model.Id && x.IsActive == true).FirstOrDefault();
if (code.GridNumber.Equals(model.GridNumber))
{
return(false);
}
}
var data = db.SizeGrids.Any(x => x.GridNumber == model.GridNumber && x.IsActive == true);
return(data);
}
public IHttpActionResult PostSizeGrid(SizeGrid sizeGrid)
{
SizeGrid model = new SizeGrid();
model.GridNumber = sizeGrid.GridNumber;
model.Z01 = sizeGrid.Z01 ?? 0;
model.Z02 = sizeGrid.Z02 ?? 0;
model.Z03 = sizeGrid.Z03 ?? 0;
model.Z04 = sizeGrid.Z04 ?? 0;
model.Z05 = sizeGrid.Z05 ?? 0;
model.Z06 = sizeGrid.Z06 ?? 0;
model.Z07 = sizeGrid.Z07 ?? 0;
model.Z08 = sizeGrid.Z08 ?? 0;
model.Z09 = sizeGrid.Z09 ?? 0;
model.Z10 = sizeGrid.Z10 ?? 0;
model.Z11 = sizeGrid.Z11 ?? 0;
model.Z12 = sizeGrid.Z12 ?? 0;
model.Z13 = sizeGrid.Z13 ?? 0;
model.Z14 = sizeGrid.Z14 ?? 0;
model.Z15 = sizeGrid.Z15 ?? 0;
model.Z16 = sizeGrid.Z16 ?? 0;
model.Z17 = sizeGrid.Z17 ?? 0;
model.Z18 = sizeGrid.Z18 ?? 0;
model.Z19 = sizeGrid.Z19 ?? 0;
model.Z20 = sizeGrid.Z20 ?? 0;
model.Z21 = sizeGrid.Z21 ?? 0;
model.Z22 = sizeGrid.Z22 ?? 0;
model.Z23 = sizeGrid.Z23 ?? 0;
model.Z24 = sizeGrid.Z24 ?? 0;
model.Z25 = sizeGrid.Z25 ?? 0;
model.Z26 = sizeGrid.Z26 ?? 0;
model.Z27 = sizeGrid.Z27 ?? 0;
model.Z28 = sizeGrid.Z28 ?? 0;
model.Z29 = sizeGrid.Z29 ?? 0;
model.Z30 = sizeGrid.Z30 ?? 0;
model.IsActive = true;
model.CreatedOn = System.DateTime.UtcNow;
model.UpdatedOn = System.DateTime.UtcNow;
db.SizeGrids.Add(model);
db.SaveChanges();
model.IsActive = true;
return(Ok(true));
}
public SizeGrid GetCode(string sku)
{
SizeGrid model = new SizeGrid();
bool data = db.SizeGrids.Any(x => x.GridNumber == sku && x.IsActive == true);
if (data == true)
{
model = db.SizeGrids.Where(x => x.IsActive == true && x.GridNumber == sku).FirstOrDefault();
}
else
{
model.GridNumber = sku;
model.IsActive = true;
db.SizeGrids.Add(model);
db.SaveChanges();
var list = db.SizeGrids.Where(x => x.IsActive == true).ToList();
model = list.LastOrDefault();
}
return(model);
}
public IHttpActionResult PutSizeGrid(int id, SizeGrid sizeGrid)
{
var data = db.SizeGrids.Where(x => x.IsActive == true && x.Id == id).FirstOrDefault();
data.Z01 = sizeGrid.Z01;
data.Z02 = sizeGrid.Z02;
data.Z03 = sizeGrid.Z03;
data.Z04 = sizeGrid.Z04;
data.Z05 = sizeGrid.Z05;
data.Z06 = sizeGrid.Z06;
data.Z07 = sizeGrid.Z07;
data.Z08 = sizeGrid.Z08;
data.Z09 = sizeGrid.Z09;
data.Z10 = sizeGrid.Z10;
data.Z11 = sizeGrid.Z11;
data.Z12 = sizeGrid.Z12;
data.Z13 = sizeGrid.Z13;
data.Z14 = sizeGrid.Z14;
data.Z15 = sizeGrid.Z15;
data.Z16 = sizeGrid.Z16;
data.Z17 = sizeGrid.Z17;
data.Z18 = sizeGrid.Z18;
data.Z19 = sizeGrid.Z19;
data.Z20 = sizeGrid.Z20;
data.Z21 = sizeGrid.Z21;
data.Z22 = sizeGrid.Z22;
data.Z23 = sizeGrid.Z23;
data.Z24 = sizeGrid.Z24;
data.Z25 = sizeGrid.Z25;
data.Z26 = sizeGrid.Z26;
data.Z27 = sizeGrid.Z27;
data.Z28 = sizeGrid.Z28;
data.Z29 = sizeGrid.Z29;
data.Z30 = sizeGrid.Z30;
data.GridNumber = sizeGrid.GridNumber;
data.IsActive = true;
data.UpdatedOn = System.DateTime.UtcNow;
db.SaveChanges();
return(Ok(true));
}
