private void RefreshBtn_Click(object sender, EventArgs e)
{
APIAccess.Result result = APIAccess.GetDataFromXLAPI <List <MLFSReportingPeriod> >("/MLFSReportingPeriod/GetCurrent");
Periods = (List <MLFSReportingPeriod>)result.Data;
BindPeriods();
AddingNew = false;
}
private async void MLFSDirRepBtn_Click(object sender, RibbonControlEventArgs e)
{
APIAccess.Result result = APIAccess.GetDataFromXLAPI <List <MLFSReportingPeriod> >("/MLFSReportingPeriod/GetCurrentPeriods");
MLFSDirRepForm form = new MLFSDirRepForm((List <MLFSReportingPeriod>)result.Data);
form.ShowDialog();
if (form.AddingNew)
{
MessageBox.Show("Reopen form once added");
return;
}
if (!String.IsNullOrEmpty(form.PlansFile) && !String.IsNullOrEmpty(form.FeesFile) && !String.IsNullOrEmpty(form.FCIFile) && int.TryParse(form.PeriodId, out int i))
{
string response = await XLSheet.BuildMLFSDirectorsReport(i, form.FeesFile, form.PlansFile, form.FCIFile);
if (response == "Success")
{
MessageBox.Show("Data Uploaded");
}
else
{
MessageBox.Show("Upload Unsuccessful, check your data");
}
}
else
{
MessageBox.Show("Upload Unsuccessful, check your data");
}
}
private void ReportsBtn_Click(object sender, RibbonControlEventArgs e)
{
APIAccess.Result result = APIAccess.GetDataFromXLAPI <List <MLFSReportingPeriod> >("/MLFSReportingPeriod/GetCurrentPeriods");
if (result.WasSuccessful)
{
MLFSReportingPeriodForm form = new MLFSReportingPeriodForm((List <MLFSReportingPeriod>)result.Data);
form.ShowDialog();
if (form.PeriodId != null)
{
XLSheet.RunReports((int)form.PeriodId);
}
}
else
{
MessageBox.Show("Unable to reach server");
}
}
public static void RunReports(int periodId)
{
//first get the income data
APIAccess.Result result = APIAccess.GetDataFromXLAPI <System.Data.DataTable>("/MLFSReports/SalesReport?periodId=" + periodId);
if (result.WasSuccessful)
{
System.Data.DataTable table = (System.Data.DataTable)result.Data;
CreateWorkSheet(table, "Sales Report", firstNumberColumn: "new Amount", addTotalRow: false);
//CreatePivot("IncomeRawData", new int[]{ 2, 3, 4 }, new int[] { 1 }, new int[] { 6, 7 }, "AutoPivot", new string[] { "campaign", "organisation" });
}
//then the directors' report data
result = APIAccess.GetDataFromXLAPI <System.Data.DataTable>("/MLFSReports/DirectorsReport?periodId=" + periodId);
if (result.WasSuccessful)
{
System.Data.DataTable table = (System.Data.DataTable)result.Data;
CreateWorkSheet(table, "Directors Report", firstNumberColumn: "Budget", addTotalRow: false);
}
}
