private void RefreshGridView()
{
for (int x = 0; x < 3; x++)
{
for (int i = 0; i < dgvList[x].RowCount; i++)
{
if (!MyGridUtils.IsColumnDataChanged(dgvList[x].Rows[i],
new List <String>()
{
"Description", "PrefixID", "Value", "UnitID", "ManagerID", "SP_ID"
},
new List <String>()
{
"BDescription", "BPrefixID", "BValue", "BUnitID", "BManagerID", "BSP_ID"
}))
{
continue;
}
dgvList[x].Rows[i].Cells["BDescription"].Value = dgvList[x].Rows[i].Cells["Description"].Value;
dgvList[x].Rows[i].Cells["BPrefixID"].Value = dgvList[x].Rows[i].Cells["PrefixID"].Value;
dgvList[x].Rows[i].Cells["BValue"].Value = dgvList[x].Rows[i].Cells["Value"].Value;
dgvList[x].Rows[i].Cells["BUnitID"].Value = dgvList[x].Rows[i].Cells["UnitID"].Value;
dgvList[x].Rows[i].Cells["BManagerID"].Value = dgvList[x].Rows[i].Cells["ManagerID"].Value;
dgvList[x].Rows[i].Cells["BSP_ID"].Value = dgvList[x].Rows[i].Cells["SP_ID"].Value;
}
}
}
private bool IsRowDataChanged(DataGridView dgv)
{
bool result = false;
if (MyGridUtils.IsColumnDataChanged(dgv, new List <string>()
{
"Status", "Progress", "Remarks"
}, new List <string>()
{
"BStatus", "BProgress", "BRemarks"
}))
{
result = true;
}
return(result);
}
private bool IsRowDataChanged(DataGridView dgv)
{
bool retVal = false;
if (MyGridUtils.IsColumnDataChanged(dgv, new List <string>()
{
"Projected", "% Comp.", "Comment"
}, new List <string>()
{
"BProjected", "B% Comp.", "BComment"
}))
{
retVal = true;
}
return(retVal);
}
private void tsbClose_Click(object sender, EventArgs e)
{
dgv01.EndEdit();
if (MyGridUtils.IsColumnDataChanged(dgv01, new List <string>()
{
"Status", "Progress", "Remarks"
}, new List <string>()
{
"BStatus", "BProgress", "BRemarks"
}))
{
if (MessageBox.Show("Data has been changed, Do you want to Save Before exit?", "OPERATION PLAN", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
SaveOPMonthlyProgress();
}
}
this.Dispose();
}
private void RefreshGridAfterSaveData()
{
for (int x = 0; x < dgv.Count; x++)
{
for (int i = 0; i < dgv[x].RowCount; i++)
{
if (!MyGridUtils.IsColumnDataChanged(dgv[x].Rows[i], new List <string>()
{
"Progress", "Remarks"
}, new List <string>()
{
"BProgress", "BRemarks"
}))
{
continue;
}
dgv[x].Rows[i].Cells["BProgress"].Value = dgv[x].Rows[i].Cells["Progress"].Value;
dgv[x].Rows[i].Cells["BRemarks"].Value = dgv[x].Rows[i].Cells["Remarks"].Value;
}
}
}
private bool SaveDataToDatabase(string kpm_id, DataGridView dgv, DbConnection con, DbTransaction trans)
{
bool retval = true;
KeyPerformanceIndex kpi;
LAST_KPI_ID = KeyPerformanceIndex.getNextKPIIndex();
int mKPIId;
bool mNewFlag = false;
try
{
for (int i = 0; i < dgv.RowCount; i++)
{
if (!MyGridUtils.IsColumnDataChanged(dgv.Rows[i],
new List <String>()
{
"Description", "PrefixID", "Value", "UnitID", "ManagerID", "SP_ID", "STATUS"
},
new List <String>()
{
"BDescription", "BPrefixID", "BValue", "BUnitID", "BManagerID", "BSP_ID", "BSTATUS"
}))
{
continue;
}
//---- Check for KPI Index in the Grid--
//--------- If Empty or Null New KPI otherwise Edit
if (String.IsNullOrEmpty(dgv.Rows[i].Cells["ID"].Value.ToString()))
{
mKPIId = LAST_KPI_ID;
LAST_KPI_ID++;
mNewFlag = true;
}
else
{
mKPIId = int.Parse(dgv.Rows[i].Cells["ID"].Value.ToString());
mNewFlag = false;
}
kpi = new KeyPerformanceIndex();
kpi.KPIID = mKPIId;
kpi.KPMID = kpm_id;
kpi.ManagerID = dgv.Rows[i].Cells["ManagerID"].Value.ToString();
kpi.Description = dgv.Rows[i].Cells["Description"].Value.ToString();
kpi.Prefix = dgv.Rows[i].Cells["PrefixID"].Value.ToString();
kpi.EstimateYear = dgv.Rows[i].Cells["Est.Year"].Value.ToString();
kpi.EstimateValue = Convert.ToDouble(dgv.Rows[i].Cells["Value"].Value);
kpi.Unit = dgv.Rows[i].Cells["UnitID"].Value.ToString();
kpi.ServicePlanID = dgv.Rows[i].Cells["SP_ID"].Value == null ? "000" : dgv.Rows[i].Cells["SP_ID"].Value.ToString();
kpi.Status = ((dgv.Rows[i].Cells["STATUS"].Value.ToString().ToUpper() == "TRUE") ? true : false);
if (mNewFlag)
{
kpi.InsertKPI(db, con, trans);
kpi.InsertKPIEstimate(db, con, trans);
}
else
{
kpi.UpdateKPI(db, con, trans);
kpi.UpdateKPIEstimate(db, con, trans);
}
}
} catch (Exception ex)
{
retval = false;
}
return(retval);
}