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());
}
}
