public static void PrintActionByStatusGraph(string strsql)
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable tb = new DataTable();
//string strsql = null;
////=========================== REPORT 4 ===================
//strsql = "Select status.id, status.status_short, status.status_color, A.action_completed, A.progress_year, A.progress_month"
// + " From status Left Join"
// + " (Select progress.progress_year, progress.progress_month, Count(progress.id) As action_completed, progress.status_id"
// + " From progress Where progress_year = '" + OPGlobals.currentYear + "' and progress_month = " + OPGlobals.currentMonth
// + " Group By progress.progress_year, progress.progress_month, progress.status_id) A On status.id = A.status_id";
tb = db.GetDataTable(conn, strsql);
frmprint.dataTable = tb;
frmprint.reportName = @"gphActionByStatus.rdlc";
frmprint.Show();
}
public static void TestSubReport(string opYear, int opMonth, string directorID, string managerID)
{
frmPrint frmprint = new frmPrint();
List <DataTable> tbList = new List <DataTable>();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
string strsql = "";
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
//strsql = ReportQueries.QMonthlyProgress(opYear, opMonth, false, directorID, managerID);
strsql = MonthlyProgress.GetQueryMonthlyProgress(opYear, opMonth, directorID, managerID);
DataTable tb = db.GetDataTable(conn, strsql);
frmprint.dataTable = tb;
tb = CapitalWork.GetTableCapitalWorksMonthlyProgress(opYear, opMonth, directorID, managerID);
tbList.Add(tb);
strsql = KeyPerformanceIndex.GetMonthlyKPIProgressQuery(opYear, opMonth, directorID, managerID);
tb = db.GetDataTable(conn, strsql);
tbList.Add(tb);
frmprint.subDataTable = tbList;
frmprint.dataTable = tb;
frmprint.reportName = @"rpt1.rdlc";
frmprint.Show();
}
public static void PrintActionByThemeGraph()
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable tb = new DataTable();
string strsql = null;
//=========================== REPORT 1 ===================
strsql = "SELECT * FROM view_dashboard_top WHERE delivery_program_year = '" + OPGlobals.currentYear + "'"
+ " AND progress_month=" + OPGlobals.currentMonth + " ORDER BY theme_id, status_id";
tb = db.GetDataTable(conn, strsql);
if (tb.Rows.Count == 0)
{
strsql = "SELECT DISTINCT theme_id, theme_short, theme_color, theme_color,action_by_theme,"
+ " null as status_id, null as status_short, null as status_color, null as completed_action, null as progress_month"
+ " FROM view_dashboard_top WHERE delivery_program_year = '" + OPGlobals.prevoiusYear + "' ORDER BY theme_id";
tb = db.GetDataTable(conn, strsql);
}
frmprint.dataTable = tb;
frmprint.reportName = @"gphActionByTheme.rdlc";
frmprint.Show();
}
public static void PrintCapitalWorksQBR(string cpw_year, int cpw_month)
{
frmPrint frmprint = new frmPrint();
frmprint.dataTable = CapitalWork.GetTableCapitalWorksMonthlyProgress(cpw_year, cpw_month);
frmprint.reportName = @"rptcpwqbr.rdlc";
frmprint.Show();
}
public static void PrintCapitalWorksServiceSummary(string cpw_year, int cpw_month)
{
frmPrint frmprint = new frmPrint();
frmprint.dataTable = CapitalWork.GetTableCapitalWorksServiceSummary(cpw_year, cpw_month);
frmprint.reportName = @"rptCPWServiceSummary.rdlc";
frmprint.Show();
}
public static void PrintCapitalWorksMonthlyProgressByServicePlan(string cpw_year, int cpw_month)
{
frmPrint frmprint = new frmPrint();
frmprint.dataTable = CapitalWork.GetTableCapitalWorksMonthlyProgress(cpw_year, cpw_month);
frmprint.reportName = @"rptcpw_progress_by_service_plan.rdlc";
frmprint.Show();
}
public static void PrintCapitalWorksCounil(string cpw_year, int cpw_month, string serviceID)
{
frmPrint frmprint = new frmPrint();
frmprint.dataTable = CapitalWork.GetTableCapitalWorksMonthlyProgress(cpw_year, cpw_month, serviceID);
frmprint.reportName = @"rptcpw_progressCouncil.rdlc";
frmprint.Show();
}
public static void PrintCapitalWorksDepartmentSummary(string cpw_year, int cpw_month, string department)
{
frmPrint frmprint = new frmPrint();
frmprint.dataTable = CapitalWork.GetTableCapitalWorksDepartmentSummary(cpw_year, cpw_month, department);
frmprint.reportName = @"gphBudgetSummaryDepartment.rdlc";
frmprint.Show();
}
public static void PrintCapitalWorksServiceDetails(string cpw_year, int cpw_month, string servicePlanID)
{
frmPrint frmprint = new frmPrint();
frmprint.dataTable = CapitalWork.GetTableCapitalWorksServiceDetails(cpw_year, cpw_month, servicePlanID);
frmprint.reportName = @"rptCPWServiceWise.rdlc";
frmprint.Show();
}
private static void PrintKPIProgressReportFull(string strsql)
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable tb = db.GetDataTable(conn, strsql);
frmprint.dataTable = tb;
frmprint.reportName = @"rptKPMProgressFull.rdlc";
frmprint.Show();
}
public static void PrintCapitalWorks(string cpwYear)
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
string strsql = "SELECT * FROM view_cpw where cpw_year='" + cpwYear + "';";
DataTable tb = db.GetDataTable(conn, strsql);
frmprint.dataTable = tb;
frmprint.reportName = @"rptcpw.rdlc";
frmprint.Show();
}
public static void PrintCouncilSourcePlan(string query)
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable tb = db.GetDataTable(conn, query);
tb.DefaultView.Sort = "action_rank" + " " + "asc";
tb = tb.DefaultView.ToTable();
frmprint.dataTable = tb;
frmprint.reportName = @"rptCouncilSourcePlan.rdlc";
frmprint.Show();
}
public static void PrintStatus()
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
string strsql = "SELECT status.* FROM status ORDER BY id;";
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable tb = db.GetDataTable(conn, strsql);
frmprint.dataTable = tb;
frmprint.reportName = @"rptStatus.rdlc";
frmprint.Show();
}
public static void PrintKPIMonthlyProgress(string query)
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable tb = db.GetDataTable(conn, query);
frmprint.dataTable = tb;
frmprint.reportName = @"Report3.rdlc";
frmprint.Show();
}
public static void PrintActionByThemeGraph(string strsql)
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable tb = new DataTable();
tb = db.GetDataTable(conn, strsql);
frmprint.dataTable = tb;
frmprint.reportName = @"gphActionByTheme.rdlc";
frmprint.Show();
}
public static void PrintStrategyDashboard(string strsql)
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable tb = new DataTable();
tb = db.GetDataTable(conn, strsql);
frmprint.dataTable = tb;
frmprint.reportName = @"rptCompletedActionsByStrategy.rdlc";
frmprint.Show();
}
public static void PrintStrategyObjective()
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
string strsql = "Select Distinct strategy_view.theme_id, strategy_view.theme_color, strategy_view.strategy_objective, strategy_view.strategy_objective_id"
+ " From strategy_view Order By strategy_view.theme_id, strategy_view.strategy_objective_rank; ";
DataTable tb = db.GetDataTable(conn, strsql);
frmprint.dataTable = tb;
frmprint.reportName = @"rptStrategyObjective.rdlc";
frmprint.Show();
}
public static void PrintAction(string query)
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable tb = db.GetDataTable(conn, query);
DataTable temp = AlterActionTable(tb);
frmprint.dataTable = temp;
frmprint.reportName = @"rptAction.rdlc";
frmprint.Show();
}
public static void PrintDeliveryProgram()
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
//string strsql = "SELECT view_delivery_program.* FROM view_delivery_program;";
//string strsql = "SELECT * FROM view_delivery_program_17_21;";
string strsql = "SELECT * FROM nsc_operation_plan_17_to_21.view_delivery_program_chart ORDER BY theme_id, strategy_objective_rank, strategy_rank, strategy_measure_code;";
DataTable tb = db.GetDataTable(conn, strsql);
frmprint.dataTable = tb;
//frmprint.reportName = @"rptStrategyMeasureMonthly.rdlc";
frmprint.reportName = @"rptStrategyMeasureMonthlyWithChart.rdlc";
frmprint.Show();
}
private void frmDashBoard2_Load(object sender, EventArgs e)
{
Color bkg = Color.FromArgb(172, 172, 172);
reportViewer1.ShowToolBar = false;
reportViewer1.BackColor = bkg;
//reportViewer2.Dock = DockStyle.Fill;
reportViewer2.ShowToolBar = false;
reportViewer2.BackColor = bkg;
reportViewer3.ShowToolBar = false;
reportViewer3.BackColor = bkg;
reportViewer4.ShowToolBar = false;
reportViewer4.BackColor = bkg;
frmPrint frmprint = new frmPrint();
DrawCharts();
RefreshCharts();
}
internal static void PrintSubReport(string servicePlanSql, string actionSql, string kpmSql, string cwpSql)
{
frmPrint frmprint = new frmPrint();
Database db = MyDLLs.MyDBFactory.GetDatabase(OPGlobals.dbProvider);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable dtServicePlan = db.GetDataTable(conn, servicePlanSql);
DataTable dtAction = db.GetDataTable(conn, actionSql);
DataTable dtKPM = db.GetDataTable(conn, kpmSql);
DataTable dtCWP = db.GetDataTable(conn, cwpSql);
frmprint.dataTable = dtServicePlan;
frmprint.dataTable2 = dtAction;
frmprint.dataTable3 = dtKPM;
frmprint.dataTable4 = dtCWP;
frmprint.reportName = @"rptCouncilReport.rdlc";
//frmprint.reportName = @"Report1.rdlc";
frmprint.Show();
}
