public IHttpActionResult PutItemTracking(string id, ItemTracking itemTracking) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != itemTracking.ItemID) { return(BadRequest()); } db.Entry(itemTracking).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ItemTrackingExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PostItemTracking(ItemTracking itemTracking) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.ItemTrackings.Add(itemTracking); try { db.SaveChanges(); } catch (DbUpdateException) { if (ItemTrackingExists(itemTracking.ItemID)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = itemTracking.ItemID }, itemTracking)); }
public IActionResult DeleteAllTrx(string trxNum) { using (var transaction = dbContext.Database.BeginTransaction()) { try { ItemTracking Itracking = dbContext.itemTrackings.Find(trxNum); if (Itracking != null) { dbContext.itemTrackings.Remove(Itracking); dbContext.SaveChanges(); transaction.Commit(); return(Json(trxNum)); } else { throw new Exception($"User Not found with a user ID of '{trxNum}'."); } } catch (Exception ex) { transaction.Rollback(); return(BadRequest(GetErrorMessage(ex))); } } }
private IList <OrderItemStatus> GetLineItemStatuses(int orderId) { var lineItems = new List <OrderItemStatus>(); using (var cmd = new SqlCommand("usp_GetLineItemStatuses", cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@OrderId", SqlDbType.Int) { Value = orderId }); var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { var lineItem = new OrderItemStatus { OrderlineItemId = reader.GetString(OrderLineItemIdOrdinal), ProductIdentifier = reader.GetString(ProductIdentifierOrdinal), QtyOrdered = reader.GetInt32(QtyOrderedOrdinal), QtyShipped = reader.GetInt32(QtyShippedOrdinal), QtyCancelled = reader.GetInt32(QtyCancelledOrdinal), QtyBackordered = reader.GetInt32(QtyBackorderedOrdinal), TrackingInformation = new List <ItemTracking>() }; var tracking = new ItemTracking(); if (!reader.IsDBNull(CarrierOrdinal)) { tracking.Carrier = reader.GetString(CarrierOrdinal); } if (!reader.IsDBNull(ShipDateOrdinal)) { tracking.ShipDate = reader.GetDateTime(ShipDateOrdinal); } if (!reader.IsDBNull(TrackingNumberOrdinal)) { tracking.TrackingNumber = reader.GetString(TrackingNumberOrdinal); } if (!reader.IsDBNull(TrackingUrlOrdinal)) { tracking.TrackingUrl = reader.GetString(TrackingUrlOrdinal); } lineItem.TrackingInformation.Add(tracking); lineItems.Add(lineItem); } } else { // TODO: Throw exception indicating no line items were returned. } } return(lineItems); }
public ShippingInfoResult GetShippingInfo(ShippingInfoRequest request) { var result = new ShippingInfoResult(); try { using (var cmd = new SqlCommand("usp_GetShippingInfoByDateRange", cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.DateTime) { Value = request.StartDate }); cmd.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime) { Value = request.EndDate }); var reader = cmd.ExecuteReader(); if (reader.HasRows) { result.Manifests = new List <ItemTracking>(); while (reader.Read()) { var itemStatus = new ItemTracking { OrderLineItemId = reader.GetString(OrderLineItemIdOrdinal), Carrier = reader.GetString(CarrierOrdinal), ShipDate = reader.GetDateTime(ShipDateOrdinal), TrackingNumber = reader.GetString(TrackingNumberOrdinal), TrackingUrl = reader.GetString(TrackingUrlOrdinal) }; result.Manifests.Add(itemStatus); } } else { // TODO: Throw an exception indicating no rows were returned. } } } catch (SqlException ex) { result.HasException = true; result.Exception = ExceptionFactory.BuildSqlException(ex); } catch (Exception ex) { result.HasException = true; result.Exception = ExceptionFactory.BuildSystemException(ex); } return(result); }
public IHttpActionResult GetItemTracking(string id, string year) { ItemTracking itemTracking = db.ItemTrackings.Find(id, year); if (itemTracking == null) { return(NotFound()); } return(Ok(itemTracking)); }
public IHttpActionResult DeleteItemTracking(string id) { ItemTracking itemTracking = db.ItemTrackings.Find(id); if (itemTracking == null) { return(NotFound()); } db.ItemTrackings.Remove(itemTracking); db.SaveChanges(); return(Ok(itemTracking)); }
public ShippingInfoResult GetShippingInfo(ShippingInfoRequest request) { var result = new ShippingInfoResult(); try { using (var cmd = new SqlCommand("usp_GetShippingInfoByDateRange", cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.DateTime) {Value = request.StartDate}); cmd.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime) {Value = request.EndDate}); var reader = cmd.ExecuteReader(); if (reader.HasRows) { result.Manifests = new List<ItemTracking>(); while (reader.Read()) { var itemStatus = new ItemTracking { OrderLineItemId = reader.GetString(OrderLineItemIdOrdinal), Carrier = reader.GetString(CarrierOrdinal), ShipDate = reader.GetDateTime(ShipDateOrdinal), TrackingNumber = reader.GetString(TrackingNumberOrdinal), TrackingUrl = reader.GetString(TrackingUrlOrdinal) }; result.Manifests.Add(itemStatus); } } else { // TODO: Throw an exception indicating no rows were returned. } } } catch (SqlException ex) { result.HasException = true; result.Exception = ExceptionFactory.BuildSqlException(ex); } catch (Exception ex) { result.HasException = true; result.Exception = ExceptionFactory.BuildSystemException(ex); } return result; }
public IActionResult UpdateLocation([FromBody] ItemTracking itemTracking) { var ItemTrack = new ItemTracking(); try { dbContext.itemTrackings.Add(itemTracking); dbContext.SaveChanges(); return(Ok(ItemTrack)); } catch (Exception ex) { return(BadRequest(GetErrorMessage(ex))); } }
public Invoice convert(InvoiceViewModel invoiceViewModel) { ContactViewModelToContactConverter contactConverter = new ContactViewModelToContactConverter(); Invoice invoice = new Invoice(); if (!(string.IsNullOrEmpty(invoiceViewModel.BrandingThemeId))) { try { invoice.BrandingThemeId = Guid.Parse(invoiceViewModel.BrandingThemeId); } catch (ArgumentNullException) { throw new BrandingThemeIsNullException("Branding theme can not be empty"); } catch (FormatException) { throw new BrandingThemeIdIsNotVallid("Branding theme id is not a vallid branding theme id"); } } invoice.Contact = contactConverter.Convert(invoiceViewModel.Contact); if(!(string.IsNullOrEmpty(invoiceViewModel.CurrencyCode))) { invoice.CurrencyCode = invoiceViewModel.CurrencyCode; } invoice.Date = invoiceViewModel.Date; invoice.DueDate = invoiceViewModel.DueDate; List<LineItem> lineItemList = new List<LineItem>(); ItemTrackingCategory itemTrackingCategory = new ItemTrackingCategory(); itemTrackingCategory.Name = invoiceViewModel.TrackingName; itemTrackingCategory.Option = invoiceViewModel.TrackingOption; ItemTracking itemTraking = new ItemTracking() { itemTrackingCategory }; string taxType = null; if (invoiceViewModel.TaxType == "15% GST on Income") { taxType = "OUTPUT2"; } if (invoiceViewModel.TaxType == "No GST") { taxType = "NONE"; } if (invoiceViewModel.TaxType == "15% GST on Expenses") { taxType = "INPUT2"; } LineItem lineItem = new LineItem(); lineItem.Description = invoiceViewModel.Description; if (invoiceViewModel.DiscountRate > 0) { lineItem.DiscountRate = invoiceViewModel.DiscountRate; } //lineItem.ItemCode = invoiceViewModel.ItemCode; lineItem.ItemCode = "GB3-White"; lineItem.Quantity = invoiceViewModel.Quantity; lineItem.TaxType = taxType; lineItem.Tracking = itemTraking; lineItem.UnitAmount = invoiceViewModel.UnitAmount; lineItem.AccountCode = invoiceViewModel.AccountCode; lineItemList.Add(lineItem); invoice.Items = lineItemList; invoice.Number = invoiceViewModel.Number; invoice.Reference = invoiceViewModel.Reference; invoice.Status = InvoiceStatus.Draft; if (invoiceViewModel.typeOfInvoice == "ACCPAY") { invoice.Type = InvoiceType.AccountsPayable; } if (invoiceViewModel.typeOfInvoice == "ACCREC") { invoice.Type = InvoiceType.AccountsReceivable; } if (invoiceViewModel.typeOfInvoice == "ACCREC") { invoice.Type = InvoiceType.AccountsReceivable; CreditNote cr = new CreditNote(); } return invoice; }
private IList<OrderItemStatus> GetLineItemStatuses(int orderId) { var lineItems = new List<OrderItemStatus>(); using (var cmd = new SqlCommand("usp_GetLineItemStatuses", cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@OrderId", SqlDbType.Int) {Value = orderId}); var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { var lineItem = new OrderItemStatus { OrderlineItemId = reader.GetString(OrderLineItemIdOrdinal), ProductIdentifier = reader.GetString(ProductIdentifierOrdinal), QtyOrdered = reader.GetInt32(QtyOrderedOrdinal), QtyShipped = reader.GetInt32(QtyShippedOrdinal), QtyCancelled = reader.GetInt32(QtyCancelledOrdinal), QtyBackordered = reader.GetInt32(QtyBackorderedOrdinal), TrackingInformation = new List<ItemTracking>() }; var tracking = new ItemTracking(); if (!reader.IsDBNull(CarrierOrdinal)) tracking.Carrier = reader.GetString(CarrierOrdinal); if (!reader.IsDBNull(ShipDateOrdinal)) tracking.ShipDate = reader.GetDateTime(ShipDateOrdinal); if (!reader.IsDBNull(TrackingNumberOrdinal)) tracking.TrackingNumber = reader.GetString(TrackingNumberOrdinal); if (!reader.IsDBNull(TrackingUrlOrdinal)) tracking.TrackingUrl = reader.GetString(TrackingUrlOrdinal); lineItem.TrackingInformation.Add(tracking); lineItems.Add(lineItem); } } else { // TODO: Throw exception indicating no line items were returned. } } return lineItems; }