public static List <OrderItem> GetReport(string file)
{
string[] separater = { @""",""" };
var orderItems = new List <OrderItem>();
if (string.IsNullOrWhiteSpace(file))
{
return(orderItems);
}
using (var reader = new StreamReader(file))
{
List <string> listA = new List <string>();
List <string> listB = new List <string>();
var line = reader.ReadLine();
while (!reader.EndOfStream)
{
var newItem = true;
line = reader.ReadLine();
var values = line.Split(separater, StringSplitOptions.None);
OrderItem orderItem = null;
orderItem = new OrderItem();
orderItem.SKU = values[sku];
orderItem.OrderID = values[order_id];
orderItem.DateSold = values[date];
orderItem.SoldFor = PaymentDetail.ConvertDollarstoPennies(values[sold_for]);
orderItem.BoughtFrom = values[bought_from].Contains("EBAY") ? "Ebay" : string.Empty;
orderItem.ItemName = values[product_title];
orderItems.Add(orderItem);
}
}
return(orderItems);
}
public static List <OrderItem> GetOrderReport(string file)
{
var deliminator = ',';
var orderItems = new List <OrderItem>();
using (var reader = new StreamReader(file))
{
List <string> listA = new List <string>();
List <string> listB = new List <string>();
var line = reader.ReadLine();
line = reader.ReadLine();
line = reader.ReadLine();
while (!reader.EndOfStream)
{
var newItem = true;
var chararray = reader.ReadLine().ToCharArray();
var skip = false;
for (int i = 0; i < chararray.Length; i++)
{
if (chararray[i] == '"')
{
skip = !skip;
}
if (skip)
{
continue;
}
if (deliminator == chararray[i])
{
chararray[i] = ';';
}
}
line = new string(chararray);
var values = line.Split(';');
OrderItem orderItem = new OrderItem();
if (string.IsNullOrEmpty(values[order_number].Replace($@"""", "")) || values[order_number].Replace($@"""", "") == "record(s) downloaded")
{
continue;
}
orderItem.BoughtFrom = "Ebay";
orderItem.DateSold = ExtractDate(values);
orderItem.SoldFor = PaymentDetail.ConvertDollarstoPennies(values[sold_for].Replace($@"""", "")) + PaymentDetail.ConvertDollarstoPennies(values[shipping].Replace($@"""", "")) + PaymentDetail.ConvertDollarstoPennies(values[tax].Replace($@"""", ""));
orderItem.ItemName = values[title_name].Replace($@"""", "");
orderItem.OrderID = values[order_number].Replace($@"""", "");
orderItem.QuantitySold = int.Parse(values[qauntity].Replace($@"""", ""));
orderItem.SalesTax = PaymentDetail.ConvertDollarstoPennies(values[tax].Replace($@"""", ""));
orderItem.SKU = values[item_number].Replace($@"""", "");
orderItem.TransID = values[trans_id].Replace($@"""", "");
orderItems.Add(orderItem);
}
}
return(orderItems);
}
internal List <Transaction> GetTransactions(DateTime lastHitDate)
{
var transactions = ebayAPI.GetSellerTransactions(lastHitDate);
var profitTransactions = new List <Transaction>();
foreach (var transaction in transactions)
{
if (transaction.Item == null)
{
continue;
}
var item = new Item();
item.EbaySKU = transaction.Item?.ItemID;
item.ItemCost = PaymentDetail.ConvertDollarstoPennies(transaction.Item?.SellingStatus.CurrentPrice.value);
item.Name = transaction.Item?.Title;
var order = new OrderItem();
order.BoughtFrom = "Ebay";
order.DateSold = transaction.CreatedDate.ToString("MM/dd/yyyy");
order.ItemName = transaction.Item?.Title;
order.OrderID = transaction.ExtendedOrderID;
order.QuantitySold = transaction.QuantityPurchased;
order.SalesTax = PaymentDetail.ConvertDollarstoPennies(transaction.Taxes.TotalTaxAmount.value);
var extTransaction = PaymentDetail.ConvertDollarstoPennies(transaction.ExternalTransaction?.FeeOrCreditAmount.value);
if (extTransaction <= 0)
{
extTransaction = PaymentDetail.ConvertDollarstoPennies(transaction.MonetaryDetails?.Payments[0].FeeOrCreditAmount.value);
}
order.SellingFees = PaymentDetail.ConvertDollarstoPennies(transaction.FinalValueFee.value) + extTransaction;
order.SoldFor = PaymentDetail.ConvertDollarstoPennies(transaction.AmountPaid.value);
order.SKU = string.IsNullOrWhiteSpace(item.SKU) ? item.EbaySKU : item.SKU;
var t = new Transaction
{
Item = item,
Order = order,
};
profitTransactions.Add(t);
}
return(profitTransactions);
}
internal List <OrderItem> GetTransactions(List <OrderItem> orderItems)
{
var orderIDs = new List <string>();
foreach (var orderitem in orderItems)
{
if (string.IsNullOrEmpty(orderitem.SKU))
{
continue;
}
var orderID = $"{orderitem.SKU}-{(string.IsNullOrEmpty(orderitem.TransID)?"0":orderitem.TransID)}";
orderIDs.Add(orderID);
}
var orders = ebayAPI.GetOrders(orderIDs);
var tempOrderItems = new List <OrderItem>();
foreach (var order in orders)
{
var o = orderItems.Find(x => x.SKU == order.Item.ItemID);
o.SellingFees = -PaymentDetail.ConvertDollarstoPennies(order.FinalValueFee.value);
tempOrderItems.Add(o);
}
return(tempOrderItems);
}
public int Update(string Table, int row, string column, string value)
{
switch (column)
{
case "SKU":
column = "sku";
break;
case "Order ID":
column = "order_id";
break;
case "Selling Fees":
column = "selling_fee";
value = PaymentDetail.ConvertDollarstoPennies(value).ToString();
break;
case "Item Name":
column = "item_name";
break;
case "Quantity Bought":
column = "quantity_bought";
break;
case "Ebay SKU":
column = "ebay_sku";
break;
case "Item Cost":
column = "item_cost";
value = PaymentDetail.ConvertDollarstoPennies(value).ToString();
break;
case "SalesTax":
column = "sale_tax";
value = PaymentDetail.ConvertDollarstoPennies(value).ToString();
break;
case "Quantity Sold":
column = "quantity_sold";
break;
case "Date Sold":
column = "date_sold";
break;
case "Bought From":
column = "bought_from";
break;
case "Sold For":
column = "sold_for";
value = PaymentDetail.ConvertDollarstoPennies(value).ToString();
break;
case "Shipping Cost":
column = "shipping_cost";
value = PaymentDetail.ConvertDollarstoPennies(value).ToString();
break;
case "Assigned":
case "assigned":
value = value.ToLower() == "true" ? "1" : "0";
break;
default:
break;
}
var result = Database.Update(Table, row, new List <string> {
column.ToLower()
}, new List <object> {
value
});
if (result?.Result.ToString() != "SUCCESS")
{
return(-1);
}
else
{
try
{
var num = int.Parse(result.Message.Split(':')[1]);
return(num);
}
catch
{
return(-1);
}
}
}
