public InvoiceManager(InvoicePageModel invoiceData)
{
_invoiceData = invoiceData;
//ExcelApp.LoadExcelFile(appDocumentPath + @"\Libs\Files\CoreFiles\TemplateFiles\invoice-template.xlsx", 1);
ExcelApp.LoadExcelFile(Environment.CurrentDirectory + @"\Libs\Files\CoreFiles\TemplateFiles\invoice-template.xlsx", 1);
}
public static bool ExportAsDailyExcell(string fullPath, List <SalesAndCollectionModel> filteredSalesAndCollections)
{
FilteredSalesAndCollections = filteredSalesAndCollections;
try
{
ExcelApp.LoadExcelFile(Environment.CurrentDirectory + @"\Libs\Files\CoreFiles\TemplateFiles\daily-Sales-and-collection-report.xlsx", 1);
int x = 11;
if (FilteredSalesAndCollections != null)
{
//**Writting the Excel File: **
while (x <= FilteredSalesAndCollections.Count + 11)
{
int grandSalesAmount = 0;
int grandCollectionAmount = 0;
ExcelApp.XlWorkSheet.Cells[5, 1] = "Branch : ";
ExcelApp.XlWorkSheet.Cells[5, 7] = DateTime.Now.ToString("MMMM yyyy");
foreach (var item in FilteredSalesAndCollections)
{
ExcelApp.XlWorkSheet.Cells[x, 1] = item.Sl;
if (item.Date.HasValue)
{
ExcelApp.XlWorkSheet.Cells[x, 2] = item.Date.Value.ToString("dd-MM-yy");
}
ExcelApp.XlWorkSheet.Cells[x, 3] = item.DealerName;
ExcelApp.XlWorkSheet.Cells[x, 4] = item.IC_NO;
if (item.SyncType.ToLower().Equals("collection"))
{
ExcelApp.XlWorkSheet.Cells[x, 4] = item.MR_NO;
}
ExcelApp.XlWorkSheet.Cells[x, 5] = item.SalesAmount;
ExcelApp.XlWorkSheet.Cells[x, 6] = item.CollectionAmount;
grandSalesAmount += item.SalesAmount;
grandCollectionAmount += item.CollectionAmount;
x++;
Excel.Range line = (Excel.Range)ExcelApp.XlWorkSheet.Rows[x];
line.Insert();
}
x++;
ExcelApp.XlWorkSheet.Cells[x, 5] = grandSalesAmount;
ExcelApp.XlWorkSheet.Cells[x, 6] = grandCollectionAmount;
}
//PrintOut();
//save as PDF
ExcelApp.SaveAsPDF(FileSystemUtility.GetFileDirectory(fullPath) + FileSystemUtility.GetFileName(fullPath) + @".pdf");
//save as Xlsx
ExcelApp.SaveExcelFile(fullPath);
ExcelApp.XlWorkBook.Close();
return(true);
}
else
{
Console.WriteLine("Nothing to Print or write on Excel file");
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
if (ex.Message.Equals("Exception from HRESULT: 0x800A03EC"))
{
return(true);
}
return(false);
}
}
public static bool ExportAsPartyLedgerExcell(string fullPath, List <SalesAndCollectionModel> filteredSalesAndCollections)
{
FilteredSalesAndCollections = filteredSalesAndCollections;
try
{
ExcelApp.LoadExcelFile(Environment.CurrentDirectory + @"\Libs\Files\CoreFiles\TemplateFiles\dealer-party-ledger.xlsx", 1);
int x = 13;
if (FilteredSalesAndCollections != null)
{
//**Writting the Excel File: **
while (x <= FilteredSalesAndCollections.Count + 13)
{
int grandSalesAmount = 0;
int grandCollectionAmount = 0;
ExcelApp.XlWorkSheet.Cells[9, 1] = "Party Name : " + filteredSalesAndCollections.FirstOrDefault().DealerName;
ExcelApp.XlWorkSheet.Cells[9, 4] = "Code : " + filteredSalesAndCollections.FirstOrDefault().DealerCode;
ExcelApp.XlWorkSheet.Cells[10, 1] = "Address : " + filteredSalesAndCollections.FirstOrDefault().Address;
foreach (var item in FilteredSalesAndCollections)
{
ExcelApp.XlWorkSheet.Cells[x, 1] = item.Sl;
if (item.Date.HasValue)
{
ExcelApp.XlWorkSheet.Cells[x, 2] = item.Date.Value.ToString("dd-MMM-yy");
}
ExcelApp.XlWorkSheet.Cells[x, 3] = item.IC_NO;
ExcelApp.XlWorkSheet.Cells[x, 4] = item.MR_NO;
ExcelApp.XlWorkSheet.Cells[x, 5] = item.OpeningBalance;
ExcelApp.XlWorkSheet.Cells[x, 6] = item.SalesAmount;
ExcelApp.XlWorkSheet.Cells[x, 7] = item.CollectionAmount;
ExcelApp.XlWorkSheet.Cells[x, 8] = item.ClosingBalance;
grandSalesAmount += item.SalesAmount;
grandCollectionAmount += item.CollectionAmount;
x++;
Excel.Range line = (Excel.Range)ExcelApp.XlWorkSheet.Rows[x];
line.Insert();
}
x++;
ExcelApp.XlWorkSheet.Cells[x, 6] = grandSalesAmount;
ExcelApp.XlWorkSheet.Cells[x, 7] = grandCollectionAmount;
ExcelApp.XlWorkSheet.Cells[x, 8] = FilteredSalesAndCollections.LastOrDefault().ClosingBalance;
}
//PrintOut();
//save as PDF
ExcelApp.SaveAsPDF(FileSystemUtility.GetFileDirectory(fullPath) + FileSystemUtility.GetFileName(fullPath) + @".pdf");
//save as Xlsx
ExcelApp.SaveExcelFile(fullPath);
ExcelApp.XlWorkBook.Close();
return(true);
}
else
{
Console.WriteLine("Nothing to Print or write on Excel file");
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
if (ex.Message.Equals("Exception from HRESULT: 0x800A03EC"))
{
return(true);
}
return(false);
}
}
public ChallanManager(ChallanPageModel challanData)
{
_challanData = challanData;
//ExcelApp.LoadExcelFile(appDocumentPath + @"\Libs\Files\CoreFiles\TemplateFiles\challan-template.xlsx", 1);
ExcelApp.LoadExcelFile(Environment.CurrentDirectory + @"\Libs\Files\CoreFiles\TemplateFiles\challan-template.xlsx", 1);
}
