XtraReport createreport(DataTable dts)
{
XtraRepBankDetails report = new XtraRepBankDetails();
report.DataSource = dts;
report.DataMember = "vwRevenueCollection";
report.CreateDocument();
return(report);
}
void bttnUpdate_Click(object sender, EventArgs e)
{
DataRowView oDataRowView = cboBatch.SelectedItem as DataRowView;
if (radioGroup1.SelectedIndex == -1)
{
Common.setEmptyField("IGR Report Options...", Program.ApplicationName);
return;
}
else
{
try
{
SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);
if (oDataRowView != null)
{
if (radioGroup1.EditValue == "Bank")//Call Report for bank Reconciliation
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doIGRReport", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Bank";
_command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"];
_command.CommandTimeout = 0;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00")
{
XtraRepGen report = new XtraRepGen();
report.xrLabel18.Text = String.Format(" for the month of : [{0}]", oDataRowView.Row["BatchName"]);
report.DataSource = ds.Tables[1];
report.DataMember = "table";
report.ShowPreviewDialog();
}
else
{
return;
}
}
}
}
else if (radioGroup1.EditValue == "Agency")
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doIGRReport", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Agency";
_command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"];
_command.CommandTimeout = 0;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00")
{
XtraRepSummrayAgency repAgency = new XtraRepSummrayAgency()
{
DataSource = ds, DataMember = "table"
};
repAgency.xrLabel32.Text = string.Format(" {0} STATE GOVERNMENT ", Program.StateName.ToUpper());
repAgency.xrLabel33.Text = string.Format("Summary of Collection by Agencies for the Month of {0}", oDataRowView.Row["BatchName"]);
repAgency.DataSource = ds.Tables[1];
repAgency.DataMember = "ViewReconciliationAgencyDetails";
repAgency.ShowPreviewDialog();
}
else
{
return;
}
}
}
}
else if (radioGroup1.EditValue == "Revenue")
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doIGRReport", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Revenue";
_command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"];
_command.CommandTimeout = 0;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00")
{
XtraRepSummRevenue report = new XtraRepSummRevenue()
{
DataSource = ds.Tables[1], DataMember = "table"
};
//report.paramMonths.Value = dtpStart.Value.Month;
//report.paramYear.Value = dtpStart.Value.Year;
report.xrLabel32.Text = string.Format(" {0} STATE GOVERNMENT ", Program.StateName.ToUpper());
report.xrLabel33.Text = string.Format("Summary of Collection by Revenue Type for the Month of {0}", oDataRowView.Row["BatchName"]);
report.ShowPreviewDialog();
}
else
{
return;
}
}
}
}
else if (radioGroup1.EditValue == "Details")
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doIGRReport", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Details";
_command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"];
_command.CommandTimeout = 0;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00")
{
XtraRepAgencyDetails report = new XtraRepAgencyDetails();
report.xrLabel32.Text = string.Format(" {0} STATE GOVERNMENT ", Program.StateName.ToUpper());
report.xrLabel33.Text = string.Format("Summary of Collection by Agencies Details for the Month of {0}", oDataRowView.Row["BatchName"]);
//report.paramMonths.Value = dtpStart.Value.Month;
//report.paramYears.Value = dtpStart.Value.Year;
report.DataSource = ds.Tables[1];
report.DataMember = "ViewReconciliationAgencyDetails";
//report.DataAdapter
report.ShowPreviewDialog();
}
else
{
return;
}
}
}
}
else if (radioGroup1.EditValue == "Account")
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doIGRReport", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Account";
_command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"];
_command.CommandTimeout = 0;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00")
{
//XtraRepIGRSummary repsumary = new XtraRepIGRSummary();
XtraRepIGRAccounts repacct = new XtraRepIGRAccounts();
//repsumary.xrLabel13.Text = string.Format("{0} State Government", Program.StateName);
//repsumary.xrLabel14.Text = string.Format("Summary of {0} State Government IGR Accounts for {1}", Program.StateName, oDataRowView.Row["BatchName"]);
repacct.xrLabel27.Text = string.Format(" {0} STATE GOVERNMENT ", Program.StateName.ToUpper());
repacct.xrLabel28.Text = string.Format(" DETAILS OF TRANSFER / CHARGES FOR {0}", oDataRowView.Row["BatchName"]);
repacct.DataSource = ds.Tables[1];
repacct.DataMember = "table";
repacct.ShowPreviewDialog();
}
else
{
return;
}
}
}
}
else if (radioGroup1.EditValue == "Consolidate")
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doIGRReport", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Consolidate";
_command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"];
_command.CommandTimeout = 0;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00")
{
XtraRepSummary repsummary = new XtraRepSummary();
repsummary.xrLabel32.Text = string.Format("{0} STATE GOVERNMENT ", Program.StateName.ToUpper());
repsummary.xrLabel33.Text = string.Format("CONSOLIDATED SUMMARY ACCOUNT OF IGR FOR THE MONTH OF {0}", oDataRowView.Row["BatchName"]);
repsummary.DataSource = ds.Tables[1];
repsummary.DataMember = "ViewConsolidateDetailsTransactions";
//repsummary.paramPeriod.Value = dtpStart.Value.Month;
//repsummary.paramYear.Value = dtpStart.Value.Year;
repsummary.ShowPreviewDialog();
}
else
{
return;
}
}
}
}
else if (radioGroup1.EditValue == "Bank Details")
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doIGRReport", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Bank Details";
_command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"];
_command.CommandTimeout = 0;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00")
{
XtraRepBankDetails bankdetails = new XtraRepBankDetails();
var list = (from DataRow row in ds.Tables[1].Rows
select new Dataset.BankDetails
{
Amount = Convert.ToDecimal(row["Amount"]),
PaymentDate = Convert.ToDateTime(row["PaymentDate"]),
BankName = row["BankName"] as string,
BankCode = row["BankCode"] as string,
Description = row["Description"] as string,
PayerName = row["PayerName"] as string,
RevenueCode = row["RevenueCode"] as string,
AccountNumber = row["AccountNumber"] as string,
//Branchname = row["Branchname"] as string
}
).ToList();
bankdetails.xrLabel17.Text = string.Format("{0} State Government", Program.StateName);
bankdetails.xrLabel18.Text = string.Format("Bank Details of {0} State Government IGR Accounts for {1}", Program.StateName, oDataRowView.Row["BatchName"]);
//bankdetails.DataSource = ds.Tables[1];
//bankdetails.DataMember = "table";
var binding = (BindingSource)bankdetails.DataSource;
binding.Clear();
binding.DataSource = list;
bankdetails.ShowPreviewDialog();
}
else
{
return;
}
}
}
}
else if (radioGroup1.EditValue == "Summary")
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doIGRReport", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Summary";
_command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"];
_command.CommandTimeout = 0;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00")
{
XtraRepIGRSummary repsumary = new XtraRepIGRSummary();
repsumary.xrLabel13.Text = string.Format("{0} State Government", Program.StateName);
repsumary.xrLabel14.Text = string.Format("Summary of {0} State Government IGR Accounts for {1}", Program.StateName, oDataRowView.Row["BatchName"]);
repsumary.DataSource = ds.Tables[1];
repsumary.DataMember = "table";
repsumary.ShowPreviewDialog();
}
else
{
return;
}
}
}
}
}
else
{
}
}
catch (Exception ex)
{
Tripous.Sys.ErrorBox(ex);
}
finally
{
SplashScreenManager.CloseForm(false);
}
}
}
