public ActionResult Index()
{
ViewBag.Year = Year;
ViewBag.Month = Month;
var orderDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
if (Request["OrderMonth"] != null && Request["OrderYear"] != null)
{
orderDate = new DateTime(Int32.Parse(Request["OrderYear"]), Int32.Parse(Request["OrderMonth"]), 1);
}
var recordCount = 1000;
if (!string.IsNullOrWhiteSpace(Request["RecordCount"]))
{
recordCount = Int32.Parse(Request["RecordCount"]);
}
ViewBag.RecordCounts = new List <SelectListItem>
{
new SelectListItem {
Value = "25", Text = "25", Selected = recordCount == 25
},
new SelectListItem {
Value = "50", Text = "50", Selected = recordCount == 50
},
new SelectListItem {
Value = "100", Text = "100", Selected = recordCount == 100
},
new SelectListItem {
Value = "250", Text = "250", Selected = recordCount == 250
},
new SelectListItem {
Value = "500", Text = "500", Selected = recordCount == 500
},
new SelectListItem {
Value = "1000", Text = "1000", Selected = recordCount == 1000
}
};
var request = new InvoiceGetAllRequest
{
Filter = new InvoiceFilterView {
OrderDate = orderDate, SchoolNameStartsWith = Request["SchoolNameStartsWith"] ?? string.Empty
},
OrderByAsc = true,
OrderByField = "SchoolName",
PageIndex = 1,
PageSize = recordCount
};
TryUpdateModel(request.Filter);
var result = OrderService.SchoolInvoicesGetAllByFilter(request);
return(View(result.SchoolInvoices));
}
public InvoiceGetAllResponse InvoicesGetAllByFilter(InvoiceGetAllRequest request)
{
return(Execute <InvoiceGetAllRequest, InvoiceGetAllResponse>(
request,
response =>
{
int totalCount;
response.Invoices = MealMenuOrderFacade.GetInvoicesByFilter(request.Filter, request.PageSize, request.PageIndex,
request.OrderByField, request.OrderByAsc, out totalCount);
response.TotalCount = totalCount;
}));
}
public ActionResult MonthlyInvoiceExport()
{
var orderDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
if (Request["OrderMonth"] != null && Request["OrderYear"] != null)
{
orderDate = new DateTime(Int32.Parse(Request["OrderYear"]), Int32.Parse(Request["OrderMonth"]), 1);
}
var recordSchoolCount = "";
if (Request["schoolListCounts"] != null)
{
recordSchoolCount = Request["schoolListCounts"];
}
var recordCount = 1000;
if (!string.IsNullOrWhiteSpace(Request["RecordCount"]))
{
recordCount = Int32.Parse(Request["RecordCount"]);
}
var request = new InvoiceGetAllRequest
{
Filter = new InvoiceFilterView {
OrderDate = orderDate, SchoolNameStartsWith = Request["SchoolNameStartsWith"] ?? string.Empty
},
OrderByAsc = true,
OrderByField = "SchoolName",
PageIndex = 1,
PageSize = recordCount
};
TryUpdateModel(request.Filter);
var result = OrderService.SchoolInvoicesGetAllByFilter(request);
if (result.SchoolInvoices.Count != 0)
{
byte[] fileContent = new byte[4096];
var fileName = "";
var directoryPath = "";
var templateDirectory = "";
string[] files = new string[4096];
int j = 0;
List <int> numbers = new List <int>();
string[] words = recordSchoolCount.Split('-');
foreach (string word in words)
{
int Count = Convert.ToInt32(word);
numbers.Add(Count);
}
for (j = numbers[0]; j <= numbers[1]; j++)
{
var invoiceId = result.SchoolInvoices[j].InvoiceList;
List <int> countIds = new List <int>();
for (int i = 0; i <= invoiceId.Count - 1; i++)
{
int list56 = Convert.ToInt32(invoiceId[i].Id);
countIds.Add(list56);
}
int[] invoiceIds = countIds.ToArray();
var orderReports = new List <MealMenuOrderReportResponse>();
var model = new InvoiceExportViewModel();
foreach (var i in invoiceIds)
{
var orderList = OrderService.InvoicesGetAllByFilter(new InvoiceGetAllRequest {
Filter = new InvoiceFilterView()
{
OrderId = i
}
});
if (orderList != null && orderList.Invoices != null && orderList.Invoices.Count > 0)
{
var note = orderList.Invoices[0].Note;
var mealType = (MealTypes)orderList.Invoices[0].MealType.Id;
model.Notes.Add(mealType, note);
}
}
foreach (int i in invoiceIds)
{
var orderReport =
OrderService.GetOrderReport(new MealMenuOrderReportRequest
{
Filter = new OrderReportFilterView {
OrderId = i
},
OrderByAsc = true,
OrderByField = "Id",
PageIndex = 0,
// PageSize = 20
});
if (orderReport.Result == Result.Success && orderReport.Orders.Any())
{
orderReports.Add(orderReport);
}
}
if (orderReports.Count == 0)
{
ErrorMessage = "Invoice Couldn't be found.";
return(null);
}
var school = SchoolService.Get(new SchoolGetRequest {
Id = orderReports[0].Orders[0].SchoolId
});
model.School = school.School;
model.orderReports = orderReports;
templateDirectory = Settings.GetSetting <string>("TemplateDirectory");
var templateFile = Server.MapPath(string.Format(@"\{0}\invoice5.xlsx", templateDirectory));
directoryPath =
Server.MapPath(string.Format(@"~\{0}\Invoices\{1}", templateDirectory, "InvoiceReport"));
if (Directory.Exists(directoryPath))
{
Directory.CreateDirectory(directoryPath);
}
var dateString = DateTime.Now.ToString("yyyyMMdd");
files = Directory.GetFiles(directoryPath, string.Format("{0}*", dateString),
SearchOption.TopDirectoryOnly);
fileName = string.Format("{0}_" + result.SchoolInvoices[j].SchoolName + ".xlsx", dateString, files.Count() + 1);
var filePath = string.Format(@"{0}\{1}", directoryPath, fileName);
InvoiceExport invoice = new InvoiceExport(model, filePath, templateFile, OrderService, SchoolService);
invoice.GenerateInvoiceSheet();
invoice.CloseWorkSheet();
//var fs = new FileStream(filePath, FileMode.Open, FileAccess.Read);
//fileContent = new byte[fs.Length];
//fs.Read(fileContent, 0, fileContent.Length);
}
//DirectoryInfo di = fi.Directory;
//if (di.Exists)
// di.Delete(true);
//return File(fileContent, "application/vnd.ms-excel", fileName);
//return new FileStreamResult(new FileStream(fileName, FileMode.Open), "application/zip")
//{
// FileDownloadName = directoryPath
//};
var zipFile = Server.MapPath(string.Format(@"~\{0}\Invoices\{1}", templateDirectory, "InvoiceAllReport.zip"));
using (var stream = new FileStream(zipFile, FileMode.Create))
{
var zipFolder = Server.MapPath(string.Format(@"~\{0}\Invoices\{1}", templateDirectory, "InvoiceAllReport"));
ZipComponentFactory.CreateZipComponent().Zip(stream, directoryPath, true);
string[] filePaths = Directory.GetFiles(directoryPath);
FileInfo fi = new FileInfo(directoryPath);
DirectoryInfo dir = new DirectoryInfo(directoryPath);
dir.GetFiles("*", SearchOption.AllDirectories).ToList().ForEach(file => file.Delete());
}
using (Ionic.Zip.ZipFile zip = Ionic.Zip.ZipFile.Read(zipFile))
{
zip.RemoveSelectedEntries("InvoiceAllReport/*"); // Remove folder and all its contents
zip.Save();
}
return(new FileStreamResult(new FileStream(zipFile, FileMode.Open), "application/zip")
{
FileDownloadName = "InvoiceAllReport.zip"
});
}
return(null);
}
public ActionResult Index()
{
ViewBag.Year = Year;
ViewBag.Month = Month;
var orderDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
if (Request["OrderMonth"] != null && Request["OrderYear"] != null)
{
orderDate = new DateTime(Int32.Parse(Request["OrderYear"]), Int32.Parse(Request["OrderMonth"]), 1);
}
var recordCount = 1000;
if (!string.IsNullOrWhiteSpace(Request["RecordCount"]))
{
recordCount = Int32.Parse(Request["RecordCount"]);
}
ViewBag.RecordCounts = new List <SelectListItem>
{
new SelectListItem {
Value = "25", Text = "25", Selected = recordCount == 25
},
new SelectListItem {
Value = "50", Text = "50", Selected = recordCount == 50
},
new SelectListItem {
Value = "100", Text = "100", Selected = recordCount == 100
},
new SelectListItem {
Value = "250", Text = "250", Selected = recordCount == 250
},
new SelectListItem {
Value = "500", Text = "500", Selected = recordCount == 500
},
new SelectListItem {
Value = "1000", Text = "1000", Selected = recordCount == 1000
}
};
var request = new InvoiceGetAllRequest
{
Filter = new InvoiceFilterView {
OrderDate = orderDate, SchoolNameStartsWith = Request["SchoolNameStartsWith"] ?? string.Empty
},
OrderByAsc = true,
OrderByField = "SchoolName",
PageIndex = 1,
PageSize = recordCount
};
TryUpdateModel(request.Filter);
var result = OrderService.SchoolInvoicesGetAllByFilter(request);
int count = result.SchoolInvoices.Count;
int TotalSchool = result.SchoolInvoices.Count + 1;
var schoolCount = TotalSchool;
if (!string.IsNullOrWhiteSpace(Request["SchoolCount"]))
{
schoolCount = Int32.Parse(Request["SchoolCount"]);
}
int TotalSchools1 = result.SchoolInvoices.Count % 50;
int remender = (result.SchoolInvoices.Count / 50);
int TotalRemender = count - TotalSchools1;
var TotalSchools2 = TotalRemender / 5;
var startCount1 = "";
int start = 1;
int endCount = 1;
List <string> listCount = new List <string>();
List <string> listCount1 = new List <string>();
List <string> listTotalCount = new List <string>();
if (count == 0)
{
ViewBag.TotalSchools = new List <SelectListItem>
{
new SelectListItem {
Value = "No Records", Text = "No Records", Selected = TotalSchool == 0
}
};
}
else
{
var lastCount = "";
if (TotalSchools1 != 0)
{
for (int i = 1; i <= remender; i++)
{
startCount1 = start + " - " + TotalSchools2 * endCount;
start = start + TotalSchools2;
endCount++;
listCount.Add(startCount1);
}
lastCount = start + " - " + (TotalRemender + TotalSchools1);
listCount1.Add(lastCount);
listTotalCount = listCount.Union(listCount1).ToList();
}
else
{
for (int i = 1; i <= remender - 1; i++)
{
startCount1 = start + " - " + TotalSchools2 * endCount;
start = start + TotalSchools2;
endCount++;
listCount.Add(startCount1);
}
lastCount = start + " - " + (TotalRemender + TotalSchools1);
listCount1.Add(lastCount);
listTotalCount = listCount.Union(listCount1).ToList();
}
}
List <string> totalList = new List <string>();
for (int i = 0; i <= listTotalCount.Count - 1; i++)
{
var countList = listTotalCount[i];
totalList.Add(countList);
}
var SelectedCounts = count;
if (!string.IsNullOrWhiteSpace(Request["SelectedCount"]))
{
SelectedCounts = Int32.Parse(Request["SelectedCount"]);
}
List <SelectListItem> ObjList = new List <SelectListItem>();
//SelectList list = new SelectList(totalList,"schoolListCounts", "schoolListCountId");
foreach (var item in totalList)
{
ObjList.Add(new SelectListItem {
Text = item, Value = item
});
}
if (count == 0)
{
ViewBag.schoolListCount = new List <SelectListItem>
{
new SelectListItem {
Value = "No Records Found", Text = "No Records Found"
}
};
}
else
{
ViewBag.schoolListCount = ObjList;
}
return(View(result.SchoolInvoices));
}
