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 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 bool UpdateMonthlyProgress(Database db) //{ // bool result = false; // Dictionary<string, dynamic> strdct = new Dictionary<string, dynamic>(); // strdct.Add("progress_year", this._opYear); // strdct.Add("progress_description", this._description); // strdct.Add("status_id", this._actionStatus.ToString()); // strdct.Add("action_id", this._actionID); // strdct.Add("progress_month", this._opMonth); // strdct.Add("progress_pecentage", this._percentageCompleted); // string strsql = "SELECT COUNT(*) as noofrecs FROM progress" // + " WHERE action_id = '" + this._actionID + "' AND progress_year = '" // + this._opYear + "' AND progress_month = " + this._opMonth + ";"; // DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString); // DataTable tb = db.GetDataTable(conn, strsql); // bool newflag = (int.Parse(tb.Rows[0][0].ToString()) > 0 ? false : true); // try // { // if (conn.State == ConnectionState.Closed) { conn.Open(); } // using (DbTransaction trans = conn.BeginTransaction()) // { // try // { // if (newflag) // { // strsql = @"INSERT INTO progress (progress_year, progress_month, progress_pecentage, progress_description, status_id, action_id)" // + " VALUES (@progress_year, @progress_month, @progress_pecentage, @progress_description, @status_id, @action_id)"; // } // else // { // strsql = @"UPDATE progress SET progress_description = @progress_description, progress_pecentage = @progress_pecentage," // + " status_id = @status_id" // + " WHERE action_id = @action_id AND progress_year=@progress_year AND progress_month=@progress_month;"; // } // db.InsertUpdateDeleteRecord(conn, trans, strsql, strdct); // trans.Commit(); // } // catch (Exception ex) // { // trans.Rollback(); // throw ex; // } // } // result = true; // } catch (Exception ex) // { // throw ex; // } // if (conn.State == ConnectionState.Open) { conn.Close(); } // return result; //} public bool Equals(MonthlyProgress other) { if (this._actionID != other.ActionID) { return(false); } if (this._opYear != other.OPYear) { return(false); } if (this._opMonth != other.OPMonth) { return(false); } if (this._description != other.Description) { return(false); } if (this._actionStatus != other.ActionStatus) { return(false); } if (this._percentageCompleted != other.PercentageCompleted) { return(false); } return(true); }
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 SaveOPMonthlyProgress() { DataTable tb; Double percentageComplete; MonthlyProgress progress; String mActionID, msg; int mActionStatus; dgv01.EndEdit(); DbConnection conn = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString); if (conn.State == ConnectionState.Closed) { conn.Open(); } using (DbTransaction trans = conn.BeginTransaction()) { try { for (int i = 0; i <= dgv01.Rows.Count - 1; i++) { if (!IsRowDataChanged(dgv01.Rows[i])) { continue; } mActionID = dgv01.Rows[i].Cells["Action_id"].Value.ToString(); progress = new MonthlyProgress(mActionID, OPGlobals.currentYear, OPGlobals.currentMonth); try { mActionStatus = int.Parse(dgv01.Rows[i].Cells["Status"].Value.ToString()); } catch (Exception eex) { mActionStatus = 0; } try { percentageComplete = Double.Parse(dgv01.Rows[i].Cells["Progress"].Value.ToString(), NumberStyles.Currency); } catch (Exception eex) { percentageComplete = 0; } if (percentageComplete > 100) { percentageComplete = 100; } if (percentageComplete < 0) { percentageComplete = 0; } progress.PercentageCompleted = percentageComplete; progress.Description = dgv01.Rows[i].Cells["Remarks"].Value.ToString(); progress.ActionStatus = mActionStatus; progress.InsertUpdateMonthlyProgress(db, conn, trans); } trans.Commit(); UpdateDataGrid(); msg = "Monthly Progress has been saved/updated successfully"; } catch (Exception ex) { trans.Rollback(); msg = "Data NOT Saved ..." + Environment.NewLine + ex.Message; } } conn.Close(); MessageBox.Show(msg, "OPERATION PLAN", MessageBoxButtons.OK, MessageBoxIcon.Information); }
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()); } }