public IHttpActionResult PutItem_transcation_inventory(int id, Item_transcation_inventory item_transcation_inventory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != item_transcation_inventory.Seq)
{
return(BadRequest());
}
db.Entry(item_transcation_inventory).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!Item_transcation_inventoryExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostItem_transcation_inventory(Item_transcation_inventory item_transcation_inventory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Item_transcation_inventory.Add(item_transcation_inventory);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (Item_transcation_inventoryExists(item_transcation_inventory.Seq))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = item_transcation_inventory.Seq }, item_transcation_inventory));
}
public static void InsertTable(Item_transcation_inventory item)
{
SampleDBContext db = new SampleDBContext();
db.Item_transcation_inventory.Add(item);
db.SaveChanges();
}
public static void DeleteTable(Item_transcation_inventory item)
{
SampleDBContext db = new SampleDBContext();
Item_transcation_inventory i = db.Item_transcation_inventory.Find(item.SN);
db.Item_transcation_inventory.Remove(i);
db.SaveChanges();
}
public IHttpActionResult GetItem_transcation_inventory(int id)
{
Item_transcation_inventory item_transcation_inventory = db.Item_transcation_inventory.Find(id);
if (item_transcation_inventory == null)
{
return(NotFound());
}
return(Ok(item_transcation_inventory));
}
public IHttpActionResult DeleteItem_transcation_inventory(int id)
{
Item_transcation_inventory item_transcation_inventory = db.Item_transcation_inventory.Find(id);
if (item_transcation_inventory == null)
{
return(NotFound());
}
db.Item_transcation_inventory.Remove(item_transcation_inventory);
db.SaveChanges();
return(Ok(item_transcation_inventory));
}
public static Guid AddShippingFG(IExcelDataReader reader)
{
int ColIndex = 0;
Container container = new Container();
String container_no = "";
String invoice_no = "";
String total_pieces_received = "";
String received = "";
String received_by = "";
String entered_cs = "";
String entered_pt = "";
List <Item_transcation_inventory> items = new List <Item_transcation_inventory>();
Boolean isSerialNo = false;
int serialIndex = 1;
string serialLoc = "";
int zoneCode = -1;
do
{
while (reader.Read())
{
ColIndex = 0;
while (ColIndex < reader.FieldCount)
{
String title = reader.GetString(ColIndex);
if (title != null)
{
if (isSerialNo)
{
String serial_no = title;
ColIndex++;
String location = reader.GetString(ColIndex);
if (location == null)
{
location = serialLoc;
}
else if (location != null)
{
zoneCode = MapZoneCode(location);
int locLen = location.Length;
while (locLen < 3)
{
location = "0" + location;
locLen++;
}
serialLoc = location;
}
Item_transcation_inventory item = new Item_transcation_inventory();
item.Seq = serialIndex;
item.SN = serial_no;
item.ModelNo = serial_no.Substring(0, 6);
item.Location = location;
DateTime today = DateTime.Now;
item.Date = today;
items.Add(item);
serialIndex++;
}
else if (string.Equals(reader.GetString(ColIndex), Constants.CONTAINER_NO))
{
ColIndex += 1;
container_no = reader.GetString(ColIndex);
ColIndex += 1;
title = reader.GetString(ColIndex);
if (string.Equals(title, Constants.INVOICE_NO))
{
ColIndex += 1;
invoice_no = reader.GetString(ColIndex);
}
break;
}
else
if (string.Equals(reader.GetString(ColIndex), Constants.TOTAL_PICES_RECEIVED))
{
ColIndex += 1;
total_pieces_received = reader.GetString(ColIndex);
ColIndex += 1;
title = reader.GetString(ColIndex);
if (string.Equals(title, Constants.RECEIVED))
{
ColIndex += 1;
received = reader.GetString(ColIndex);
}
break;
}
else
if (string.Equals(reader.GetString(ColIndex), Constants.RECEIVED_BY))
{
ColIndex += 1;
received_by = reader.GetString(ColIndex);
ColIndex += 1;
title = reader.GetString(ColIndex);
if (string.Equals(title, Constants.ENTERED_CS))
{
ColIndex += 1;
entered_cs = reader.GetString(ColIndex);
}
break;
}
else
if (string.Equals(reader.GetString(ColIndex), Constants.ENTERED_PT))
{
ColIndex += 1;
entered_pt = reader.GetString(ColIndex);
break;
}
else
if (string.Equals(reader.GetString(ColIndex), Constants.SERIAL_NUMBERS))
{
ColIndex += 1;
title = reader.GetString(ColIndex);
if (string.Equals(title, Constants.LOCATTION))
{
isSerialNo = true;
break;
}
}
}
ColIndex++;
}
}
} while (reader.NextResult());
container.Id = new Guid();
container.ContainerNo = container_no;
container.InvoiceNo = invoice_no;
container.PiceRecevid = total_pieces_received;
container.RecevidDate = received;
container.WorkerInfo = received_by;
container.EnteredCS = entered_cs;
container.EnteredPT = entered_pt;
container.items = items;
ContainerMapping.AddOrUpdateCache(container);
return(container.Id);
}
