- setup.zip
- Setup
- Setup.msi
- database.zip
- Database
- MS Access
- AccountPlus.mdb
- MySQL
- SQL Server
- Backup
- AccountPlus.bak
- Script
- accountplussource.zip
- AccountPlusSource
- AccountPlus.BusinessLogic
- AccountPlus.Configurations
- AccountPlus.DataAccess
- AccountPlus.Formatting
- AccountPlus.Messaging
- AccountPlus.Setup
- AccountPlus.sln
- AccountPlus.UserInterface
- Assemblies
- log4net.dll
- accountplus.zip
- AccountPlus
- AccountPlus
- Source_Code.zip
|
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using AccountPlus.BusinessLogic;
using AccountPlus.Messaging;
using AccountPlus.Format;
using AccountPlus.Formatting;
namespace AccountPlus.UI
{
public partial class CustomReport : AccountPlusBase
{
private MonthlyReport monthlyReport = new MonthlyReport();
public CustomReport()
{
InitializeComponent();
}
private void btnGenerate_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
message1.Clear();
string month = cmbMonth.Text.Trim();
string year = cmbYear.Text.Trim();
DataSet dsReportData = new DataSet();
int columnIndex = 0;
string reportStatistics = string.Empty;
string message = string.Empty;
if (month.Equals("[SELECT]"))
{
message = MessageManager.GetMessage("44");
errorProvider1.SetError(cmbMonth, message);
message1.MessageText = message;
grpExpenseStatistics.Visible = false;
grpReport.Visible = false ;
return;
}
if (year.Equals("[SELECT]"))
{
message = MessageManager.GetMessage("44");
errorProvider1.SetError(cmbYear, message);
message1.MessageText = message ;
grpExpenseStatistics.Visible = false;
grpReport.Visible = false;
return;
}
if (rbnIndividual.Checked)
dsReportData = monthlyReport.MonthlyReportData(month, year, MonthlyReport.ReportType.Individual);
else
dsReportData = monthlyReport.MonthlyReportData(month, year, MonthlyReport.ReportType.ItemWise);
if (dsReportData.Tables[0].Rows.Count > 0)
{
lblMessage.Text = monthlyReport.GeneralDetails(month, year);
lblFinalizeDetails.Text = GetReportFinalizationDetails(month, year);
grpExpenseStatistics.Visible = true;
grpReport.Visible = true;
dgrReport.DataSource = dsReportData.Tables[0];
if(rbnIndividual.Checked)
dgrReport.Columns[0].Visible = false;
columnIndex = rbnIndividual.Checked == true ? 2 : 1;
dgrReport.Columns[columnIndex].Width = 150;
SetGridStyle();
}
else
{
grpExpenseStatistics.Visible = false;
grpReport.Visible = false;
MessageManager.DisplayMessage("45", month, year);
}
}
private void SetGridStyle()
{
foreach (DataGridViewColumn col in dgrReport.Columns)
{
col.ReadOnly = true;
col.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
private string GetReportFinalizationDetails(string month, string year)
{
string[] finalizationDetails = monthlyReport.ReportFinalizeDetails(month, year);
string details = string.Empty;
int serialNo =0;
if(finalizationDetails != null && finalizationDetails.Length > 0)
{
details = details + "Finalization Dates" + Environment.NewLine;
for(int i=0;i<finalizationDetails.Length ;i++)
{
serialNo = i+1;
if(!finalizationDetails[i].Equals("N\\A"))
details = details + serialNo.ToString() + ". " + DataFormat.GetDateFromDBDate(finalizationDetails[i]) + Environment.NewLine ;
else
details = details + finalizationDetails[i] + Environment.NewLine;
}
}
return details;
}
private void btnClose_Click(object sender, EventArgs e)
{
this.Close();
this.Dispose();
}
private void CustomReport_Load(object sender, EventArgs e)
{
base.SetBGColor(this);
cmbMonth.SelectedIndex = 0;
cmbYear.SelectedIndex = 0;
}
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
• 8 years of experience in IT Industry as a Developer.
• Experience of End-To-End Software Development and Implementation (Entire SDLC i.e Software Development Life Cycle)
• Real time Exposure to Banking, Finance and Energy industry.
• Expertise in distributed application architecture as well as web based applications using Microsoft.NET platform.
• Expertise in database design, SQL programming and SQL performance tuning.
• Expertise in Web Services and WCF Services.
• Experience of Rich Internet Application using Adobe Flex.
• Experience in migration of legacy application to latest technology, migration of VB application to .NET.
• Knowledge of OOPS and Design Concepts.
• Expertise in Agile/ Scrum software development processes.
Specialties
• Languages\ Technologies-
.NET Framework 1.1/2.0/3.0/3.5, C#.NET, VB.NET, ASP.NET, VB6, AJAX, ASP.NET, Adobe Flex 3.0, Web Services, Windows Communication Foundation (WCF), LINQ, SQL Server, Oracle, MySql, MS Access, HTML, XML, JavaScript, C# Script, CSS and XSLT.
• Methodology/ Concepts-
OOPS, Data Structures, Design Concepts and Agile/ Scrum Software Development