/// <summary>
/// Update the money for each referrer.
/// </summary>
public static void UpdateTotalsReferrers()
{
using (CastleClubEntities entites = new CastleClubEntities())
{
decimal revenue = 0;
decimal refund = 0;
foreach (var referrer in entites.Referrers)
{
revenue = entites.Invoices.Any(x => x.Customer.ReferrerId == referrer.Id && x.StatusId == "BILLED") ? entites.Invoices.Where(x => x.Customer.ReferrerId == referrer.Id && x.StatusId == "BILLED").Sum(x => x.Amount) : 0;
refund = entites.Invoices.Any(x => x.Customer.ReferrerId == referrer.Id && x.StatusId == "REFUNDED") ? entites.Invoices.Where(x => x.Customer.ReferrerId == referrer.Id && x.StatusId == "REFUNDED").Sum(x => x.Amount) : 0;
referrer.RevenueAmount = revenue;
referrer.RefundAmount = refund;
}
entites.SaveChanges();
}
}
static void Main(string[] args)
{
string command = string.Empty;
var reports = ReadFile(args[0], true, TransactionTypes.REFUND);
int index = 0;
while (command.ToLower() != "exit")
{
if (!string.IsNullOrEmpty(command))
{
int count = 0;
if (int.TryParse(command, out count))
{
int existsTransactions = 0;
for (int i = 0; i < count; i++)
{
try
{
Dictionary <int, int> map = new Dictionary <int, int>();
bool finish = false;
while ((!finish) && (index < reports.Count))
{
using (CastleClubEntities entities = new CastleClubEntities())
{
bool cancellCustomer = false;
int invoiceID = map.ContainsKey(reports[index].InvoiceID) ? map[reports[index].InvoiceID] : reports[index].InvoiceID;
if (reports[index].SubmitDate >= DateTime.MinValue)
{
var aux = reports[index].CustomerID;
var customer = entities.Customers.FirstOrDefault(x => x.Id == aux);
if (customer != null)
{
System.Console.WriteLine("Synchronizate with customer: " + customer.Id + ", transactionID: " + reports[index].TranscactionID + ", and at datetime: " + reports[index].SubmitDate + ".\n");
#region
aux = reports[index].CustomerID;
var invoice = entities.Invoices.FirstOrDefault(x => x.Id == invoiceID && x.CustomerId == aux);
var auxlong = reports[index].TranscactionID;
var transaction = entities.Transactions.FirstOrDefault(x => x.AuthorizeTransactionId == auxlong);
if (transaction == null)
{
#region There are not any transaction with this authorize id
if (customer.Invoices.Count == 0)
{
invoice = new Invoice()
{
Amount = reports[index].Amount,
BilledDate = reports[index].SubmitDate,
CreatedAt = reports[index].SubmitDate,
Customer = customer,
CustomerId = reports[index].CustomerID,
FailCount = 0,
Transactions = new List <Transaction>(),
Id = invoiceID
};
customer.Invoices.Add(invoice);
entities.Invoices.Add(invoice);
}
else
{
if (reports[index].RefererTransactionID > 0 && customer.Invoices.Any(x => x.Transactions.Any(y => y.StatusId == "SUCCESFULL" && y.AuthorizeTransactionId == reports[index].RefererTransactionID)))
{
invoice = customer.Invoices.Where(x => x.Transactions.Any(y => y.StatusId == "SUCCESFULL" && y.AuthorizeTransactionId == reports[index].RefererTransactionID)).OrderByDescending(x => x.CreatedAt).FirstOrDefault();
}
else
{
invoice = new Invoice()
{
Amount = reports[index].Amount,
BilledDate = reports[index].SubmitDate,
CreatedAt = reports[index].SubmitDate,
Customer = customer,
CustomerId = reports[index].CustomerID,
FailCount = 0,
Transactions = new List <Transaction>(),
Id = invoiceID
};
customer.Invoices.Add(invoice);
entities.Invoices.Add(invoice);
}
}
transaction = new Transaction()
{
AuthorizeTransactionId = reports[index].TranscactionID,
CreditCard = customer.CreditCards.FirstOrDefault(),
Invoice = invoice,
Message = string.Empty,
StatusId = reports[index].Status,
SubmitDate = reports[index].SubmitDate,
TypeId = reports[index].TransactionType
};
invoice.Transactions.Add(transaction);
entities.Transactions.Add(transaction);
if (reports[index].TransactionType == "SALE")
{
if (reports[index].Status == "SUCCESFULL")
{
invoice.StatusId = "BILLED";
}
else if (reports[index].Status == "FAILED")
{
invoice.StatusId = "BILLEDFAIL";
}
}
else if (reports[index].TransactionType == "REFUND")
{
if (reports[index].Status == "SUCCESFULL")
{
invoice.StatusId = "REFUNDED";
invoice.RefundedDate = reports[index].SubmitDate;
}
else if (reports[index].Status == "FAILED")
{
invoice.StatusId = "REFUNDEDFAIL";
}
cancellCustomer = true;
var transactionRefund = invoice.Transactions.FirstOrDefault(x => x.AuthorizeTransactionId == reports[index].RefererTransactionID);
if (transactionRefund != null)
{
transaction.RefundedTransactionId = transactionRefund.Id;
}
}
if (cancellCustomer)
{
customer.CancelledDate = reports[index].SubmitDate;
customer.StatusId = "CANCELLED";
}
try
{
entities.SaveChanges();
}
catch (Exception)
{
System.Console.WriteLine("Error with customer: " + reports[index].CustomerID + " and refund transaction: " + reports[index].TranscactionID + " with date: " + reports[index].SubmitDate.ToString());
}
finish = true;
if (!map.ContainsKey(reports[index].InvoiceID))
{
map.Add(reports[index].InvoiceID, invoice.Id);
}
#endregion
}
else
{
//Exists any transaction in the system with this authorize id.
existsTransactions++;
}
#endregion
}
else
{
System.Console.WriteLine("\tCustomer with id: " + aux + " do not exists in the system.");
}
}
index = index + 1;
}
}
}
catch (Exception ex)
{
System.Console.WriteLine("\tAn error ocurred in the process. This is the error: " + ex.ToString());
System.Console.WriteLine();
}
}
if (existsTransactions > 0)
{
System.Console.WriteLine("\tThere are " + existsTransactions + " that exists.");
}
}
}
Console.WriteLine("How many refund do you want to sycnhronize? (number) (" + index + "/" + reports.Count + ") (there are " + reports.Count + " refund transaction/s), or write \"exit\" for exit.");
command = Console.ReadLine();
}
System.Console.WriteLine("\nUpdate totals in refrerrers.");
UpdateTotalsReferrers();
System.Console.WriteLine("Finish, press any key for exit.");
System.Console.ReadLine();
}
