private static void CreateBuyerSummeryLists(ISourceReader reader, string base_out_put_folder)
{
var buyers = reader.GetBuyers();
var reservations = reader.GetReservations();
var output_folder = base_out_put_folder + "\\BuyerSummeryLists";
if (!Directory.Exists(output_folder))
{
Directory.CreateDirectory(output_folder);
}
foreach (var buyer in buyers)
{
var new_file_path = output_folder + "\\" + buyer.Id + "-" + buyer.Name + ".xlsx";
File.Copy("Templates\\ReceiverSummeryTemplate01.xlsx", new_file_path, true);
var workbook = new XLWorkbook(new_file_path);
var work_sheet = workbook.Worksheets.First();
BuyerSummeryFileCreator.Create(work_sheet, buyer,
reservations.Where(x => x.Buyer.Id == buyer.Id));
workbook.Save();
}
}
public static IList <string> MakeFileForLugbulkDatabase(ISourceReader reader)
{
var lines = new List <string>();
// Elements
// [tblElements]: [ElementId], [BlId], [Description], [BLColor], [TlgColor], [TlgColorId]
// ,[Price], [SumQuantity], [Remainder]
lines.Add("-- Elements --");
var elements = reader.GetElements();
foreach (var element in elements)
{
lines.Add(string.Format("INSERT INTO tblElements (ElementId, BlId, Description, BLColor) VALUES ({0}, '{1}', '{2}', '{3}')",
element.ElementID, element.BricklinkId, element.BricklinkDescription, element.BricklinkColor));
}
lines.Add("");
// Buyers
// [tblBuyers]: [Username], [MoneySum], [BrickAmount]
lines.Add("-- Buyers --");
var buyers = reader.GetBuyers();
foreach (var buyer in buyers)
{
// [tblBuyers]: [Username], [MoneySum], [BrickAmount]
lines.Add(string.Format("INSERT INTO tblBuyers (Username) VALUES ('{0}')", buyer.Name));
}
lines.Add("");
// Amounts
// [tblBuyersAmounts]: [Username], [ElementId], [Amount], [Difference]
lines.Add("-- Amounts --");
var amounts = reader.GetReservations();
foreach (var amount in amounts)
{
// [tblBuyers]: [Username], [MoneySum], [BrickAmount]
lines.Add(string.Format("INSERT INTO tblBuyersAmounts (Username, ElementId, Amount) VALUES ('{0}', {1}, {2})",
amount.Buyer.Name, amount.Element.ElementID, amount.Amount));
}
lines.Add("");
//File.WriteAllLines("lugbulk_data.sql", lines);
return(lines);
}
private static void CreateMasterlist(ISourceReader reader, string base_out_put_folder)
{
var output_file = base_out_put_folder + "\\MasterList.xlsx";
var reservations = reader.GetReservations();
var workbook = new XLWorkbook();
var work_sheet = workbook.AddWorksheet("Master List");
work_sheet.Cell(1, "A").Value = "Buyer.Id"; work_sheet.Cell(1, "A").Style.Font.Bold = true;
work_sheet.Cell(1, "B").Value = "Buyer.Name"; work_sheet.Cell(1, "B").Style.Font.Bold = true;
work_sheet.Cell(1, "C").Value = "Element.ElementID"; work_sheet.Cell(1, "C").Style.Font.Bold = true;
work_sheet.Cell(1, "D").Value = "Element.BricklinkId"; work_sheet.Cell(1, "D").Style.Font.Bold = true;
work_sheet.Cell(1, "E").Value = "Element.BricklinkDescription"; work_sheet.Cell(1, "E").Style.Font.Bold = true;
work_sheet.Cell(1, "F").Value = "Element.BricklinkColor"; work_sheet.Cell(1, "F").Style.Font.Bold = true;
work_sheet.Cell(1, "G").Value = "Element.MaterialColor"; work_sheet.Cell(1, "G").Style.Font.Bold = true;
work_sheet.Cell(1, "H").Value = "Amount"; work_sheet.Cell(1, "H").Style.Font.Bold = true;
int line_count = 2;
foreach (var reservation in reservations)
{
work_sheet.Cell(line_count, "A").Value = reservation.Buyer.Id;
work_sheet.Cell(line_count, "B").Value = reservation.Buyer.Name;
work_sheet.Cell(line_count, "C").Value = reservation.Element.ElementID;
work_sheet.Cell(line_count, "D").Value = reservation.Element.BricklinkId;
work_sheet.Cell(line_count, "E").Value = reservation.Element.BricklinkDescription;
work_sheet.Cell(line_count, "F").Value = reservation.Element.BricklinkColor;
work_sheet.Cell(line_count, "G").Value = reservation.Element.MaterialColor;
work_sheet.Cell(line_count, "H").Value = reservation.Amount;
line_count++;
}
if (File.Exists(output_file))
{
File.Delete(output_file);
}
workbook.SaveAs(output_file);
}
private static void CreatePicklists(ISourceReader reader, string base_out_put_folder)
{
var picklists = LugBulkPicklistCreator.CreateLists(reader.GetReservations(), reader.GetElements());
var output_folder = base_out_put_folder + "\\Picklists\\";
if (!Directory.Exists(output_folder))
{
Directory.CreateDirectory(output_folder);
}
foreach (var picklist in picklists)
{
File.Copy("Templates\\PicklistTemplate01.xlsx", output_folder + picklist.ElementID + ".xlsx", true);
var workbook = new XLWorkbook(output_folder + picklist.ElementID + ".xlsx");
var work_sheet = workbook.Worksheets.First();
PicklistXlsxFileCreator.Create(work_sheet, picklist);
workbook.Save();
}
}
