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); }