private void reportViewer_Drillthrough(object sender, DrillthroughEventArgs e)
{
int CompanyId = int.Parse(Parameters.Find(p => p.Name == "CompanyId").Value);
int AccountId = 0;
DateTime FromDate = DateTime.Parse(Parameters.Find(p => p.Name == "FromDate").Value);
DateTime ToDate = DateTime.Parse(Parameters.Find(p => p.Name == "ToDate").Value);
ReportParameter[] reportParam = new ReportParameter[2];
EGeneralLedgerDetailsReportDS jDataSource = new EGeneralLedgerDetailsReportDS();
GeneralLedgerDetailsTableAdapter JournalAdapter = new GeneralLedgerDetailsTableAdapter();
ECompanyDS companyDataSource = new ECompanyDS();
tblCompaniesTableAdapter companyAdapter = new tblCompaniesTableAdapter();
if ((e.Report as LocalReport).GetParameters()["ReportType"].Values[0] == "Per Date")
{
FromDate = IDateHandler.Parse((e.Report as LocalReport).GetParameters()["FromDate"].Values[0]);
ToDate = IDateHandler.Parse((e.Report as LocalReport).GetParameters()["ToDate"].Values[0]);
}
AccountId = int.Parse((e.Report as LocalReport).GetParameters()["AccountId"].Values[0]);
JournalAdapter.Fill(jDataSource.GeneralLedgerDetails, CompanyId, FromDate, ToDate, AccountId);
companyAdapter.Fill(companyDataSource.tblCompanies, CompanyId);
reportParam[0] = new ReportParameter("FromDate", FromDate.ToString("MM'/'dd'/'yyyy"), false);
reportParam[1] = new ReportParameter("ToDate", ToDate.ToString("MM'/'dd'/'yyyy"), false);
(e.Report as LocalReport).SetParameters(reportParam);
(e.Report as LocalReport).DataSources.Add(new ReportDataSource("GeneralLedgerDetails", jDataSource.Tables["GeneralLedgerDetails"]));
(e.Report as LocalReport).DataSources.Add(new ReportDataSource("Company", companyDataSource.Tables["tblCompanies"]));
}
private static void ResolveDependencies()
{
_leagueInfo = Container.Resolve <IGetLeagueInfo>();
_connection = Container.Resolve <IConnection>();
_summoner = Container.Resolve <IGetSummoner>();
_masters = Container.Resolve <IGetMasters>();
_leagueOfSummoner = Container.Resolve <IGetLeagueOfSummonerInformation>();
_serverService = Container.Resolve <IServerService>();
_summonerGame = Container.Resolve <IGetSummonerGame>();
_spectator = Container.Resolve <ISpectator>();
_lastGames = Container.Resolve <IGetLastGames>();
_printMethods = Container.Resolve <IPrintMethods>();
_dateHandler = Container.Resolve <IDateHandler>();
}
private void btnDateRangeSelection_Click(object sender, EventArgs e)
{
if (Parameters.Find(p => p.Name == "FromDate") != null && Parameters.Find(p => p.Name == "ToDate") != null)
{
Control control = sender as Control;
DateTimePicker FromDate = (Controls.Find("ControlFromDate", true).First() as DateTimePicker);
DateTimePicker ToDate = (Controls.Find("ControlToDate", true).First() as DateTimePicker);
ContextMenu menu = new ContextMenu();
//init
MenuItem AllDates = new MenuItem();
MenuItem PreviousYear = new MenuItem();
MenuItem CurrentYear = new MenuItem();
MenuItem NextYear = new MenuItem();
MenuItem PreviousMonth = new MenuItem();
MenuItem CurrentMonth = new MenuItem();
MenuItem NextMonth = new MenuItem();
MenuItem Yesterday = new MenuItem();
MenuItem Today = new MenuItem();
MenuItem Tomorrow = new MenuItem();
//text
AllDates.Text = "All Dates";
PreviousYear.Text = "Previous Year";
CurrentYear.Text = "Current Year";
NextYear.Text = "Next Year";
PreviousMonth.Text = "Previous Month";
CurrentMonth.Text = "Current Month";
NextMonth.Text = "Next Month";
Yesterday.Text = "Yesterday";
Today.Text = "Today";
Tomorrow.Text = "Tomorrow";
//events
AllDates.Click += delegate(object s, EventArgs ea)
{
FromDate.Value = IDateHandler.AllDates(true);
ToDate.Value = IDateHandler.AllDates(false);
GenerateReport();
};
PreviousYear.Click += delegate(object s, EventArgs ea)
{
FromDate.Value = IDateHandler.PreviousYear(true);
ToDate.Value = IDateHandler.PreviousYear(false);
GenerateReport();
};
CurrentYear.Click += delegate(object s, EventArgs ea)
{
FromDate.Value = IDateHandler.CurrentYear(true);
ToDate.Value = IDateHandler.CurrentYear(false);
GenerateReport();
};
NextYear.Click += delegate(object s, EventArgs ea)
{
FromDate.Value = IDateHandler.NextYear(true);
ToDate.Value = IDateHandler.NextYear(false);
GenerateReport();
};
PreviousMonth.Click += delegate(object s, EventArgs ea)
{
FromDate.Value = IDateHandler.PreviousMonth(true);
ToDate.Value = IDateHandler.PreviousMonth(false);
GenerateReport();
};
CurrentMonth.Click += delegate(object s, EventArgs ea)
{
FromDate.Value = IDateHandler.CurrentMonth(true);
ToDate.Value = IDateHandler.CurrentMonth(false);
GenerateReport();
};
NextMonth.Click += delegate(object s, EventArgs ea)
{
FromDate.Value = IDateHandler.NextMonth(true);
ToDate.Value = IDateHandler.NextMonth(false);
GenerateReport();
};
Yesterday.Click += delegate(object s, EventArgs ea)
{
FromDate.Value = DateTime.Now.AddDays(-1);
ToDate.Value = DateTime.Now.AddDays(-1);
GenerateReport();
};
Today.Click += delegate(object s, EventArgs ea)
{
FromDate.Value = DateTime.Now;
ToDate.Value = DateTime.Now;
GenerateReport();
};
Tomorrow.Click += delegate(object s, EventArgs ea)
{
FromDate.Value = DateTime.Now.AddDays(1);
ToDate.Value = DateTime.Now.AddDays(1);
GenerateReport();
};
//add
menu.MenuItems.Add(AllDates);
menu.MenuItems.Add("-");
menu.MenuItems.Add(PreviousYear);
menu.MenuItems.Add(CurrentYear);
menu.MenuItems.Add(NextYear);
menu.MenuItems.Add("-");
menu.MenuItems.Add(PreviousMonth);
menu.MenuItems.Add(CurrentMonth);
menu.MenuItems.Add(NextMonth);
menu.MenuItems.Add("-");
menu.MenuItems.Add(Yesterday);
menu.MenuItems.Add(Today);
menu.MenuItems.Add(Tomorrow);
menu.Show(this, new Point(control.Location.X + control.Size.Width, control.Location.Y));
}
}
private void CreateReportParameters()
{
if (toolStripReportParam.Items.Count == 0)
{
if (Parameters.Find(p => p.Name == "FromDate") != null && Parameters.Find(p => p.Name == "ToDate") != null)
{
ToolStripLabel labelFrom = new ToolStripLabel();
ToolStripLabel labelTo = new ToolStripLabel();
DateTimePicker dateTimePickerFrom = new DateTimePicker();
DateTimePicker dateTimePickerTo = new DateTimePicker();
Button btnDateRangeSelection = new Button();
String FromDateDefault = Parameters.Find(p => p.Name == "FromDate").Value;
String ToDateDefault = Parameters.Find(p => p.Name == "ToDate").Value;
if (!String.IsNullOrWhiteSpace(FromDateDefault))
{
dateTimePickerFrom.Value = IDateHandler.Parse(IAppHandler.ConvertMaskValue(FromDateDefault).ToString());
}
if (!String.IsNullOrWhiteSpace(ToDateDefault))
{
dateTimePickerTo.Value = IDateHandler.Parse(IAppHandler.ConvertMaskValue(ToDateDefault).ToString());
}
labelFrom.Name = "ControlLabelFromDate";
labelFrom.Text = "From:";
dateTimePickerFrom.Name = "ControlFromDate";
dateTimePickerFrom.Format = DateTimePickerFormat.Custom;
dateTimePickerFrom.CustomFormat = "MM/dd/yyyy";
dateTimePickerFrom.Width = 100;
labelTo.Name = "ControlLabelToDate";
labelTo.Text = "To:";
dateTimePickerTo.Name = "ControlToDate";
dateTimePickerTo.Format = DateTimePickerFormat.Custom;
dateTimePickerTo.CustomFormat = "MM/dd/yyyy";
dateTimePickerTo.Width = 100;
btnDateRangeSelection.Name = "ControlDateRangeSelection";
btnDateRangeSelection.Text = "...";
btnDateRangeSelection.Width = 30;
btnDateRangeSelection.BackColor = Color.Gainsboro;
btnDateRangeSelection.Click += btnDateRangeSelection_Click;
toolStripReportParam.Items.Add(labelFrom);
toolStripReportParam.Items.Add(new ToolStripControlHost(dateTimePickerFrom));
toolStripReportParam.Items.Add(labelTo);
toolStripReportParam.Items.Add(new ToolStripControlHost(dateTimePickerTo));
toolStripReportParam.Items.Add(new ToolStripControlHost(btnDateRangeSelection));
}
foreach (JkFormParameter param in this.Parameters)
{
if (param.Visible)
{
if (toolStripReportParam.Items.Count > 0)
{
ToolStripSeparator separator = new ToolStripSeparator();
separator.Name = "Separator" + param.Name;
toolStripReportParam.Items.Add(separator);
}
//not lookup
if (String.IsNullOrWhiteSpace(param.ControlName))
{
if (param.Name != "FromDate" && param.Name != "ToDate")
{
if (param.Type == SqlDbType.DateTime)
{
ToolStripLabel label = new ToolStripLabel();
DateTimePicker dateTimePicker = new DateTimePicker();
label.Name = "ControlLabel" + param.Name;
label.Text = param.Caption + ":";
dateTimePicker.Name = "Control" + param.Name;
dateTimePicker.Format = DateTimePickerFormat.Custom;
dateTimePicker.CustomFormat = "MM/dd/yyyy";
dateTimePicker.Width = 100;
toolStripReportParam.Items.Add(label);
toolStripReportParam.Items.Add(new ToolStripControlHost(dateTimePicker));
}
else if (param.Type == SqlDbType.Bit)
{
ToolStripLabel label = new ToolStripLabel();
CheckBox checkBox = new CheckBox();
label.Name = "ControlLabel" + param.Name;
label.Text = param.Caption + ":";
checkBox.Name = "Control" + param.Name;
checkBox.Checked = Boolean.Parse(param.Value);
toolStripReportParam.Items.Add(label);
toolStripReportParam.Items.Add(new ToolStripControlHost(checkBox));
}
}
}
else
{
JkLookUpComboBox lookUp = (Controls.Find(param.ControlName, true).First() as JkLookUpComboBox);
ToolStripLabel label = new ToolStripLabel();
ComboBox comboBox = new ComboBox();
if (lookUp.Items.Count == 0)
{
lookUp.LoadData();
}
label.Name = "ControlLabel" + param.Name;
label.Text = param.Caption + ":";
comboBox.Name = "Control" + param.Name;
comboBox.DataSource = lookUp.Items;
comboBox.DisplayMember = lookUp.DisplayText;
comboBox.ValueMember = lookUp.Key;
comboBox.Width = param.Width;
toolStripReportParam.Items.Add(label);
toolStripReportParam.Items.Add(new ToolStripControlHost(comboBox));
}
}
}
if (toolStripReportParam.Items.Count > 0)
{
ToolStripButton button = new ToolStripButton();
ToolStripSeparator btnSeparator = new ToolStripSeparator();
btnSeparator.Name = "SeparatorButtonGo";
button.Name = "ControlButtonGo";
button.DisplayStyle = ToolStripItemDisplayStyle.Text;
button.Text = " GO ";
button.BackColor = Color.SteelBlue;
button.Click += delegate(object s, EventArgs ea)
{
GenerateReport();
};
toolStripReportParam.Items.Add(btnSeparator);
toolStripReportParam.Items.Add(button);
}
}
}
