private void ShowReport() { ExpenseEntryBAL exBal = new ExpenseEntryBAL(); Selected_Branch_ID = Convert.ToInt32(cmb_Branch.SelectedValue); Selected_CategoryType_ID = Convert.ToInt32(cmb_CatgType.SelectedValue); Selected_FrequencyID = Convert.ToInt32(cmb_ExpsFrequency.SelectedValue); Selected_FrequencyName = (string)cmb_ExpsFrequency.Text; Selected_CategoryType_Name = (string)cmb_CatgType.Text; Selected_Branch_Name = (string)cmb_Branch.Text; Selected_FromDate = (DateTime)dt_FromDate.Value; Selected_ToDate = (DateTime)dt_ToDate.Value; string grouping = string.Empty; if (rdBtn_Daily.Checked) { grouping = Indication_ExpenseReports.Expense_Grouping_Daily; } else if (rdBtn_Monthly.Checked) { grouping = Indication_ExpenseReports.Expense_Grouping_Monthly; } else if (rdBtn_Yearly.Checked) { grouping = Indication_ExpenseReports.Expense_Grouping_Yearly; } GetReport(Selected_Branch_ID, Selected_CategoryType_ID, Selected_FrequencyID, Selected_FromDate, Selected_ToDate, grouping); //} //else if (Selected_FrequencyName == Indication_ExpenseReports.Expense_Frequency_Monthly || Selected_FrequencyName == Indication_ExpenseReports.Expense_Frequency_HalfYearly && Selected_CategoryType_Name != "All") //{ // Selected_FromDate = new DateTime(dt_FromDate.Value.Year, dt_FromDate.Value.Month, 1); // Selected_ToDate = new DateTime(dt_ToDate.Value.Year, dt_ToDate.Value.Month, DateTime.DaysInMonth(dt_ToDate.Value.Year, dt_ToDate.Value.Month)); // GetReport(Selected_Branch_ID, Selected_CategoryType_ID, Selected_FrequencyID, Selected_FromDate, Selected_ToDate, grouping); //} //else if (Selected_FrequencyName == Indication_ExpenseReports.Expense_Frequency_Yearly && Selected_CategoryType_Name != "All") //{ // Selected_FromDate = new DateTime(((DateTime)(dt_FromDate.Value)).Year, 1, 1); // Selected_ToDate = new DateTime(dt_ToDate.Value.Year, 12, 31); // GetReport(Selected_Branch_ID, Selected_CategoryType_ID, Selected_FrequencyID, Selected_FromDate, Selected_ToDate, grouping); //} //else //{ // throw new Exception("Category All Or Frequency All Are Invalid Entry"); //} }
/// <summary> /// /// </summary> /// <param name="ExpenseOrPayment"></param> /// <param name="sorting">NEW added Sorting</param> private void MonthlyexpenseReport(string ExpenseOrPayment, string sorting) { ExpenseEntryBAL bal = new ExpenseEntryBAL(); DataTable dt = new DataTable(); dt = bal.GetMonthlyExpenseReport((DateTime)dt_FromDate.Value, (DateTime)dt_ToDate.Value, ExpenseOrPayment); crExpenseMonthly cr = new crExpenseMonthly(); frmReportViewer objreportviewer = new frmReportViewer(); cr.SetDataSource(dt); GetCommonInfo(); ((TextObject)cr.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName; ((TextObject)cr.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;; ((TextObject)cr.ReportDefinition.Sections[2].ReportObjects["txtfromDate"]).Text = dt_FromDate.Value.Date.ToShortDateString(); ((TextObject)cr.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = dt_ToDate.Value.Date.ToShortDateString(); ((TextObject)cr.ReportDefinition.Sections[2].ReportObjects["Sorting"]).Text = sorting; objreportviewer.crvReportViewer.ReportSource = cr; objreportviewer.Show(); }
private void GetExpenseCategoryTypeList() { try { ExpenseEntryBAL exBal = new ExpenseEntryBAL(); DataTable data = new DataTable(); data = exBal.GetCategoryType(); DataRow dr = data.NewRow(); dr["Category_Type_ID"] = 0; dr["Category_Type"] = "All"; data.Rows.InsertAt(dr, 0); cmb_CatgType.DataSource = data; cmb_CatgType.DisplayMember = "Category_Type"; cmb_CatgType.ValueMember = "Category_Type_ID"; } catch (Exception ex) { MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void GetExpenseFrequencyList() { try { ExpenseEntryBAL exBal = new ExpenseEntryBAL(); DataTable data = new DataTable(); data = exBal.GetExpenseFrequency(); DataRow dr = data.NewRow(); dr["Frequency_ID"] = 0; dr["Frequency_Name"] = "All"; data.Rows.InsertAt(dr, 0); cmb_ExpsFrequency.DataSource = data; cmb_ExpsFrequency.DisplayMember = "Frequency_Name"; cmb_ExpsFrequency.ValueMember = "Frequency_ID"; } catch (Exception ex) { MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
//private void GetReport(int BranchID, int CatgId, int FreqId, DateTime fromDate, DateTime toDate, string Grouping) //{ // try // { // if (Grouping == Indication_ExpenseReports.Expense_Grouping_Monthly) // { // cr_MonthlyOpex objcrmonthlyopex = new cr_MonthlyOpex(); // DataTable datatable = new DataTable(); // frmReportViewer objreportviewer = new frmReportViewer(); // RecordLevelFilteringBAL recordlevelfilteringbal = new RecordLevelFilteringBAL(); // ExpenseEntryBAL exbal = new ExpenseEntryBAL(); // int tempbranchid = -2; // int resourceid = recordlevelfilteringbal.GetResourceID(ResourceName.Daily_Expenditure_Monthly_Opex); // int criteriaid = recordlevelfilteringbal.GetCriteriaID(resourceid); // if (BranchID == Indication_BrokerBranch.HeadOffice_ID) // { // tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterWorkStation_All(BranchID.ToString(), resourceid, criteriaid)); // if (BranchID != tempbranchid) // { // MessageBox.Show("you are restricted"); // return; // } // else // { // datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate); // } // } // else // { // tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterBranchID(BranchID.ToString(), resourceid, criteriaid)); // if (BranchID != tempbranchid) // { // MessageBox.Show("you are restricted"); // return; // } // else // { // datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate); // } // } // objcrmonthlyopex.SetDataSource(datatable); // GetCommonInfo(); // ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName; // ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "Branch name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; // ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtreport"]).Text = Selected_CategoryType_Name +" Report: Monthly Wise"; // ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtfrom"]).Text = fromDate.ToString("dd-mmm-yyyy"); // ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = toDate.ToString("dd-mmm-yyyy"); // ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtbranchname"]).Text = _branchName; // objreportviewer.crvReportViewer.ReportSource = objcrmonthlyopex; // objreportviewer.Text = Selected_CategoryType_Name + " Report: Monthly wise"; // objreportviewer.Show(); // } // else if (Grouping == Indication_ExpenseReports.Expense_Grouping_Daily) // { // cr_DailyOpex objctDailyOpex = new cr_DailyOpex(); // DataTable datatable = new DataTable(); // frmReportViewer objreportviewer = new frmReportViewer(); // RecordLevelFilteringBAL recordlevelfilteringbal = new RecordLevelFilteringBAL(); // ExpenseEntryBAL exbal = new ExpenseEntryBAL(); // int tempbranchid = -2; // int resourceid = recordlevelfilteringbal.GetResourceID(ResourceName.Daily_Expenditure_Monthly_Opex); // int criteriaid = recordlevelfilteringbal.GetCriteriaID(resourceid); // if (BranchID == Indication_BrokerBranch.HeadOffice_ID) // { // tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterWorkStation_All(BranchID.ToString(), resourceid, criteriaid)); // if (BranchID != tempbranchid) // { // MessageBox.Show("you are restricted"); // return; // } // else // { // datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate); // } // } // else // { // tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterBranchID(BranchID.ToString(), resourceid, criteriaid)); // if (BranchID != tempbranchid) // { // MessageBox.Show("you are restricted"); // return; // } // else // { // datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate); // } // } // objctDailyOpex.SetDataSource(datatable); // GetCommonInfo(); // ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName; // ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; // ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtreport"]).Text = Selected_CategoryType_Name+" Report: Daily Wise"; // ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtfrom"]).Text = fromDate.ToString("dd-mmm-yyyy"); // ((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = toDate.ToString("dd-mmm-yyyy"); // //((TextObject)objctDailyOpex.ReportDefinition.Sections[2].ReportObjects["txtbranchname"]).Text = _branchName; // objreportviewer.crvReportViewer.ReportSource = objctDailyOpex; // objreportviewer.Text = Selected_CategoryType_Name + " Report: Daily wise"; // objreportviewer.Show(); // } // else if (Grouping == Indication_ExpenseReports.Expense_Grouping_Yearly) // { // cr_YearlyOPex objctYearlyOpex = new cr_YearlyOPex(); // DataTable datatable = new DataTable(); // frmReportViewer objreportviewer = new frmReportViewer(); // RecordLevelFilteringBAL recordlevelfilteringbal = new RecordLevelFilteringBAL(); // ExpenseEntryBAL exbal = new ExpenseEntryBAL(); // int tempbranchid = -2; // int resourceid = recordlevelfilteringbal.GetResourceID(ResourceName.Daily_Expenditure_Monthly_Opex); // int criteriaid = recordlevelfilteringbal.GetCriteriaID(resourceid); // if (BranchID == Indication_BrokerBranch.HeadOffice_ID) // { // tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterWorkStation_All(BranchID.ToString(), resourceid, criteriaid)); // if (BranchID != tempbranchid) // { // MessageBox.Show("you are restricted"); // return; // } // else // { // datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate); // } // } // else // { // tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterBranchID(BranchID.ToString(), resourceid, criteriaid)); // if (BranchID != tempbranchid) // { // MessageBox.Show("you are restricted"); // return; // } // else // { // datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate); // } // } // objctYearlyOpex.SetDataSource(datatable); // GetCommonInfo(); // ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName; // ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "branch name:" + _branchName + "," + _branchAddress + ". phone:" + _branchContactNumber; // ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtreport"]).Text = Selected_CategoryType_Name+ " Report: Yearly wise"; // ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtfrom"]).Text = fromDate.ToString("dd-mmm-yyyy"); // ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = toDate.ToString("dd-mmm-yyyy"); // ((TextObject)objctYearlyOpex.ReportDefinition.Sections[2].ReportObjects["txtbranchname"]).Text = _branchName; // objreportviewer.crvReportViewer.ReportSource = objctYearlyOpex; // objreportviewer.Text = Selected_CategoryType_Name + " Report: Yearly wise"; // objreportviewer.Show(); // } // } // catch (Exception) // { // throw; // } //} private void GetReport(int BranchID, int CatgId, int FreqId, DateTime fromDate, DateTime toDate, string Grouping) { try { cr_ExpenseReport objcrmonthlyopex = new cr_ExpenseReport(); DataTable datatable = new DataTable(); frmReportViewer objreportviewer = new frmReportViewer(); RecordLevelFilteringBAL recordlevelfilteringbal = new RecordLevelFilteringBAL(); ExpenseEntryBAL exbal = new ExpenseEntryBAL(); bool IsExpensedate = false; int tempbranchid = -2; int resourceid = recordlevelfilteringbal.GetResourceID(ResourceName.Daily_Expenditure_Monthly_Opex); int criteriaid = recordlevelfilteringbal.GetCriteriaID(resourceid); if (rd_ExpenseDate.Checked) { IsExpensedate = rd_ExpenseDate.Checked; } if (BranchID == Indication_BrokerBranch.HeadOffice_ID) { tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterWorkStation_All(BranchID.ToString(), resourceid, criteriaid)); if (BranchID != tempbranchid) { MessageBox.Show("you are restricted"); return; } else { datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate, IsExpensedate); } } else { tempbranchid = Convert.ToInt32(recordlevelfilteringbal.FilterBranchID(BranchID.ToString(), resourceid, criteriaid)); if (BranchID != tempbranchid) { MessageBox.Show("you are restricted"); return; } else { datatable = exbal.GetReport(CatgId, FreqId, BranchID, fromDate, toDate, IsExpensedate); } } ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = (object)Grouping; objcrmonthlyopex.SetDataSource(datatable); GetCommonInfo(); ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtcompanyname"]).Text = _CommpanyName; ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtaddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;; ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtfrom"]).Text = fromDate.ToString("dd-MMM-yyyy") + " To " + toDate.ToString("dd-MMM-yyyy"); //((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtto"]).Text = toDate.ToString("dd-mmm-yyyy"); ((TextObject)objcrmonthlyopex.ReportDefinition.Sections[2].ReportObjects["txtDate"]).Text = IsExpensedate ? "Expense Date" : "Payment Date"; objcrmonthlyopex.ParameterFields["GroupingDate"].CurrentValues.Add(pdv); objreportviewer.crvReportViewer.ReportSource = objcrmonthlyopex; objreportviewer.Text = "Expense Report "; objreportviewer.Show(); } catch (Exception) { throw; } }