private void tsbPrint_Click(object sender, EventArgs e)
{
//string strsql = ReportQueries.QMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth, true);
string strsql = MonthlyProgress.GetQueryMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth);
clsReports.PrintMonthlyProgress(strsql);
}
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();
}
private void FillActionGrid()
{
DataRowView dr = (DataRowView)cboManagerFrom.SelectedItem;
if (string.IsNullOrEmpty(dr["director_id"].ToString()) || string.IsNullOrEmpty(dr["manager_id"].ToString()))
{
return;
}
string strsql = MonthlyProgress.GetQueryMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth, dr["director_id"].ToString(), dr["manager_id"].ToString());
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable tb = db.GetDataTable(conn, strsql);
dgv01.Rows.Clear();
try
{
foreach (DataRow row in tb.Rows)
{
dgv01.Rows.Add(row["action_id"].ToString(),
row["action_description"].ToString(),
false
);
}
dgv01.CurrentCell = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void tsbPrint_Click(object sender, EventArgs e)
{
string strsql = "";
Months m = (Months)Enum.Parse(typeof(Months), cboOPMonth.SelectedValue.ToString());
//switch (rptType)
switch (cboReportType.SelectedValue.ToString())
{
//case "MonthlyProgress":
case "1":
if (cboDirector.SelectedValue.ToString() == "-0-" && cboManager.SelectedValue.ToString() == "-0-")
{
//strsql = ReportQueries.QMonthlyProgress(cboOPYear.Text, (int)m, true, cboDirector.SelectedValue.ToString(), cboManager.SelectedValue.ToString());
strsql = MonthlyProgress.GetQueryMonthlyProgress(cboOPYear.Text, (int)m);
}
else
{
//strsql = ReportQueries.QMonthlyProgress(cboOPYear.Text, (int)m, false, cboDirector.SelectedValue.ToString(), cboManager.SelectedValue.ToString());
strsql = MonthlyProgress.GetQueryMonthlyProgress(cboOPYear.Text, (int)m, cboDirector.SelectedValue.ToString(), cboManager.SelectedValue.ToString());
}
clsReports.PrintMonthlyProgress(strsql);
break;
//case "ActionCompletedByTheme":
case "2":
strsql = ReportQueries.QActionCompletedByTheme(cboOPYear.Text, (int)m);
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable tb = db.GetDataTable(conn, strsql);
if (tb.Rows.Count == 0)
{
strsql = ReportQueries.QActionCompletedByTheme(cboOPYear.Text);
}
clsReports.PrintActionByThemeGraph(strsql);
break;
//case "ActionCompletedByStatus":
case "3":
strsql = ReportQueries.QActionCompletedByStatus(cboOPYear.Text, (int)m);
clsReports.PrintActionByStatusGraph(strsql);
break;
//case "PrintStrategyDashboard":
case "4":
strsql = ReportQueries.QPrintStrategyDashboard(cboOPYear.Text, (int)m);
clsReports.PrintStrategyDashboard(strsql);
break;
}
}
private void PrintSubReportyMonth()
{
Months m = (Months)Enum.Parse(typeof(Months), cboOPMonth.SelectedValue.ToString());
//string month = OPGlobals.currentMonth.ToString();
string year = cboOPYear.Text;
string servicePlanSql = GetServicePlanForSubReporting(year, (int)m, cboServicePlan.SelectedValue.ToString());
//"Select A.id As service_plan_id, A.service_plan, B.actions As action, C.kpm As kpm, D.cwp As cwp From service_plan A"
//+ " Left Join(Select action.service_plan_id, COUNT(*) As actions From action Group By action.service_plan_id) B"
//+ " On B.service_plan_id = A.id Left Join (Select kpi.service_plan_id, COUNT(*) As kpm From kpi Group By kpi.service_plan_id) C"
//+ " On C.service_plan_id = A.id Left Join (Select capital_works.capital_works_service_plann_id As service_plan_id, COUNT(*) As cwp From capital_works Group By capital_works.capital_works_service_plann_id) D"
//+ " On D.service_plan_id = A.id where service_plan != '-NONE-';";
string actionSql = "", kpmSql = "", cwpSql = "";
actionSql = MonthlyProgress.GetQueryMonthlyProgress(cboServicePlan.SelectedValue.ToString(), cboOPYear.Text, (int)m);
cwpSql = CapitalWork.GetSQLCapitalWorksMonthlyProgress(cboServicePlan.SelectedValue.ToString(), cboOPYear.Text, (int)m);
kpmSql = KeyPerformanceIndex.GetMonthlyKPIProgressQuery(cboServicePlan.SelectedValue.ToString(), cboOPYear.Text, (int)m);
clsReports.PrintSubReport(servicePlanSql, actionSql, kpmSql, cwpSql);
}
private void PrintActionsByMonth()
{
string strsql = "";
Months m = (Months)Enum.Parse(typeof(Months), cboOPMonth.SelectedValue.ToString());
if (tabControl1.SelectedIndex == 0)
{
if (cboDirector.SelectedValue.ToString() != "-0-") // && cboManager.SelectedValue.ToString() != "-0-")
{
strsql = MonthlyProgress.GetQueryMonthlyProgress(cboOPYear.Text, (int)m, cboDirector.SelectedValue.ToString(), cboManager.SelectedValue.ToString());
}
else
{
strsql = MonthlyProgress.GetQueryMonthlyProgress(cboOPYear.Text, (int)m);
}
}
else
{
strsql = MonthlyProgress.GetQueryMonthlyProgress(cboServicePlan.SelectedValue.ToString(), cboOPYear.Text, (int)m);
}
clsReports.PrintMonthlyProgressForCouncil(strsql);
}
private void FillGrid()
{
string strsql;
DataRowView dr1 = (DataRowView)cboDirector.SelectedItem;
DataRowView dr2 = (DataRowView)cboManager.SelectedItem;
if (dr2 != null)
{
strsql = MonthlyProgress.GetQueryMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth, dr1["director_id"].ToString(), dr2["manager_id"].ToString());
}
else
{
if (opt2.Checked)
{
strsql = MonthlyProgress.GetQueryMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth);
}
else if (opt1.Checked)
{
strsql = MonthlyProgress.GetQueryMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth, OPGlobals.CurrentUser.DirectorID);
}
else
{
strsql = MonthlyProgress.GetQueryMonthlyProgress(OPGlobals.currentYear, OPGlobals.currentMonth, OPGlobals.CurrentUser.DirectorID, OPGlobals.CurrentUser.ManagerID);
}
}
DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString);
DataTable tb = db.GetDataTable(conn, strsql);
dgv01.Rows.Clear();
try
{
foreach (DataRow row in tb.Rows)
{
dgv01.Rows.Add(new String[] { (dgv01.RowCount + 1).ToString(),
" ",
row["action_id"].ToString(),
row["action_id"].ToString() + " " + row["action_description"].ToString(),
String.Format("{0:dd-MMM-yyyy}", row["delivery_program_targetdate"]),
row["manager_id"].ToString(),
row["manager_description"].ToString(),
row["status_id"].ToString(),
"",
row["progress_pecentage"].ToString(),
row["progress_description"].ToString(),
row["theme_color"].ToString(),
row["status_color"].ToString(),
String.IsNullOrEmpty(row["status_id"].ToString()) ? "1" : "0",
row["status_id"].ToString(),
row["progress_pecentage"].ToString(),
row["progress_description"].ToString() });
//dgv01.Rows[8].Cells[8].Style.BackColor = Color.Beige;
}
MyDLLs.MyGridUtils.ColorDataGrid(dgv01, 0, 11);
MyDLLs.MyGridUtils.ColorDataGrid(dgv01, 8, 12);
dgv01.CurrentCell = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
