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