private string GetQuery(string cYear, int cMonth) { string strsql; DataRowView dr1 = (DataRowView)cboDirector.SelectedItem; DataRowView dr2 = (DataRowView)cboManager.SelectedItem; if (dr2 != null) { strsql = StrategyMeasures.GetQueryStrategyMeasuresProgress(cYear, cMonth, dr1["director_id"].ToString(), dr2["manager_id"].ToString()); } else { if (opt2.Checked) { strsql = StrategyMeasures.GetQueryStrategyMeasuresProgress(cYear, cMonth); } else if (opt1.Checked) { strsql = StrategyMeasures.GetQueryStrategyMeasuresProgress(cYear, cMonth, OPGlobals.CurrentUser.DirectorID); } else { strsql = StrategyMeasures.GetQueryStrategyMeasuresProgress(cYear, cMonth, OPGlobals.CurrentUser.DirectorID, OPGlobals.CurrentUser.ManagerID); } } return(strsql); }
private bool SaveStrategyMeasureMonthlyProgress() { bool mRetVal = false; DataTable tb; string msg; dgv.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 < dgv.Rows.Count; i++) { if (string.IsNullOrEmpty(dgv.Rows[i].Cells["Progress"].Value.ToString()) && string.IsNullOrEmpty(dgv.Rows[i].Cells["Comments"].Value.ToString())) { continue; } StrategyMeasures sm = new StrategyMeasures(); sm.MeasureCode = dgv.Rows[i].Cells["Code"].Value.ToString(); sm.StrategyID = dgv.Rows[i].Cells["strategy_id"].Value.ToString(); sm.Year = OPGlobals.currentYear; sm.Month = OPGlobals.GetStrategyMeasureMonth(); double mProgress; Double.TryParse(dgv.Rows[i].Cells["Progress"].Value.ToString(), out mProgress); sm.CurrentProgress = mProgress; sm.Comment = dgv.Rows[i].Cells["Comments"].Value.ToString(); if (!sm.IsExist()) { sm.InsertMonthlyStrategyMeasures(db, conn, trans); } else { sm.UpdateMonthlyStrategyMeasures(db, conn, trans); } //DbConnection conn1 = db.CreateDbConnection(Database.ConnectionType.ConnectionString, OPGlobals.connString); //string t = "SELECT count(strategy_measure_code) as noofrecs FROM strategy_measure_monthly" // + " WHERE strategy_measure_code = '" + sm.MeasureCode + "'" // + " AND strategy_id = '" + sm.StrategyID + "'" // + " AND year = '" + sm.Year + "' AND month = " + sm.Month; //DataTable tb_temp = db.GetDataTable(conn, t); //if (int.Parse(tb_temp.Rows[0]["noofrecs"].ToString()) == 0) //{ // sm.InsertMonthlyStrategyMeasures(db, conn, trans); //} else //{ // sm.UpdateMonthlyStrategyMeasures(db, conn, trans); //} } trans.Commit(); mRetVal = true; //RefreshGridAfterSaveData(); msg = "Strategy Measures 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); return(mRetVal); }