public string GetCleanNumber()
{
string tmpNumber;
string number;
CBProject p = new CBProject();
CBBudgetPCN pcn = new CBBudgetPCN();
p.Load(base.ProjectID);
pcn.Load(base.PCNID);
tmpNumber = p.Number;
int test = tmpNumber.IndexOf("-");
if (tmpNumber.IndexOf("-") > 1)
{
number = tmpNumber.Substring(0, tmpNumber.IndexOf("-"));
}
else
{
number = tmpNumber;
}
if (base.Revision > 0)
{
number += "-r" + base.Revision.ToString();
}
if (pcn.ID > 0)
{
number += "-PCN" + pcn.PCNNumber;
}
return(number);
}
private void tdbgPCNLogs_AfterColEdit(object sender, C1.Win.C1TrueDBGrid.ColEventArgs e)
{
int bm = tdbgPCNLogs.Bookmark;
if (bm >= 0)
{
int pcnID = Convert.ToInt32(mdsPCNLogs.Tables[0].Rows[bm]["ID"]);
string dateSub, dateRcvd, comm;
DateTime dSub, dRcvd;
dateSub = mdsPCNLogs.Tables[0].Rows[bm]["DateSubmittedToClient"].ToString();
dateRcvd = mdsPCNLogs.Tables[0].Rows[bm]["DateReceivedFromClient"].ToString();
comm = mdsPCNLogs.Tables[0].Rows[bm]["Comments"].ToString();
if (dateSub.Length >= 6)
{
dSub = Convert.ToDateTime(dateSub);
}
else
{
dSub = RevSol.RSUtility.DefaultDate();
}
if (dateRcvd.Length >= 6)
{
dRcvd = Convert.ToDateTime(dateRcvd);
}
else
{
dRcvd = RevSol.RSUtility.DefaultDate();
}
CBBudgetPCN.SetClientDate(pcnID, dSub, dRcvd, comm);
}
}
private void LoadPCNLog(int projectID)
{
CBProject proj = new CBProject();
CBCustomer cust = new CBCustomer();
CBEmployee emp = new CBEmployee();
miProjectID = projectID;
proj.Load(projectID);
cust.Load(proj.CustomerID);
emp.Load(proj.ProjMngrID);
emp.Load(proj.LeadProjMngrID);
txtClient.Text = cust.Name;
txtProjName.Text = proj.Description;
txtHGANumber.Text = proj.Number;
txtClientNumber.Text = proj.CustomerProjNumber;
txtProjectManager.Text = emp.Name;
mdsPCNLogs = CBBudgetPCN.GetPCNLogByProjID(projectID);
tdbgPCNLogs.SetDataBinding(mdsPCNLogs, "Table", true);
int hours, mh;
decimal tic, dlr, trend;
hours = 0;
tic = 0;
mh = 0;
dlr = 0;
trend = 0;
CBBudgetPCN.GetPCILogTotalByProjID(projectID, ref hours, ref tic, ref mh, ref dlr, ref trend);
txtTotalEngHrs.Text = hours.ToString();
txtTotalEngrTIC.Text = tic.ToString("#,##0");
txtBudgetMHAdd.Text = mh.ToString();
txtBudgetDlrAdd.Text = dlr.ToString("#,##0");
txtBudgetTrend.Text = trend.ToString("#,##0");
if (mdsPCNLogs.Tables[0].Rows.Count > 0)
{
tlbbPrint.Enabled = true;
}
else
{
tlbbPrint.Enabled = false;
}
}
private GrapeCity.ActiveReports.Document.Section.PagesCollection CreatePagesPCN(string projNumber, string pcnNumber, int pcnID)
{
rprtPCNMain rprt = new rprtPCNMain();
DataSet ds;
CBBudgetPCN pcn = new CBBudgetPCN();
ds = CBBudgetPCN.GetBudgetPCNInfoForReport(pcnID);
pcn.Load(pcnID);
rprt.SetInformation(pcn);
rprt.DataSource = ds;
rprt.DataMember = "Table";
rprt.Run();
return(rprt.Document.Pages);
}
public void PreviewPCN(int pcnID)
{
FPreviewAR pv = new FPreviewAR();
rprtPCNMain rprt = new rprtPCNMain();
DataSet ds;
CBBudgetPCN pcn = new CBBudgetPCN();
ds = CBBudgetPCN.GetBudgetPCNInfoForReport(pcnID);
pcn.Load(pcnID);
rprt.SetInformation(pcn);
rprt.DataSource = ds;
rprt.DataMember = "Table";
pv.Title = pcn.PCNTitle; //************************Added 10/1/2015
//rprt.Run();
pv.ViewReport(rprt);
pv.ShowDialog();
}
public void ViewForm()
{
moPCN = new CBBudgetPCN();
txtInitiatedBy.Enabled = false;
lblProjectNumber.Enabled = false;
lblProjectTitle.Enabled = false;
txtPCNTitle.Enabled = false;
dtpDateInitiated.Enabled = false;
txtRequestedBy.Enabled = false;
dtpDateRequested.Enabled = false;
txtDescription.Enabled = false;
chkDesignError.Enabled = false;
chkVendorError.Enabled = false;
chkEstimatingError.Enabled = false;
chkContractorError.Enabled = false;
chkScheduleDelay.Enabled = false;
chkScopeAdd.Enabled = false;
chkScopeDel.Enabled = false;
chkDesignChange.Enabled = false;
chkOther.Enabled = false;
txtOtherReason.Enabled = false;
txtOtherReason.Enabled = false;
txtEstimatedHrs.Enabled = false;
txtEstimatedDollars.Enabled = false;
txtEstimTIC.Enabled = false;
txtEstimateAccuracy.Enabled = false;
txtScheduleImpact.Enabled = false;
chkApproved.Enabled = false;
chkDisapproved.Enabled = false;
chkPrepareControlEstimate.Enabled = false;
txtProjMngr.Enabled = false;
lblDateApproved.Enabled = false;
txtPCNNumber.Enabled = false;
tdbgHours.Enabled = false;
tdbgExpenses.Enabled = false;
rtbComments.Enabled = false;
//c1CommandLink1.Enabled = false;
tlbbClear.Enabled = false;
tlbbSave.Enabled = false;
}
public void ClearForm()
{
moPCN = new CBBudgetPCN();
moPCN.Clear();
txtInitiatedBy.Text = "";
lblProjectNumber.Text = "";
lblProjectTitle.Text = "";
txtPCNTitle.Text = "";
dtpDateInitiated.Value = DateTime.Now;
txtRequestedBy.Text = "";
dtpDateRequested.Value = DateTime.Now;
txtDescription.Text = "";
chkDesignError.Checked = false;
chkVendorError.Checked = false;
chkEstimatingError.Checked = false;
chkContractorError.Checked = false;
chkScheduleDelay.Checked = false;
chkScopeAdd.Checked = false;
chkScopeDel.Checked = false;
chkDesignChange.Checked = false;
chkOther.Checked = false;
txtOtherReason.Text = "";
txtOtherReason.Enabled = false;
txtEstimatedHrs.Text = "";
txtEstimatedDollars.Text = "";
txtEstimTIC.Text = "";
txtEstimateAccuracy.Text = "";
txtScheduleImpact.Text = "";
chkApproved.Checked = false;
chkDisapproved.Checked = false;
chkPrepareControlEstimate.Checked = false;
txtProjMngr.Text = "";
lblDateApproved.Text = "";
txtPCNNumber.Text = "";
tdbgHours.SetDataBinding(moPCN.PCNData, "PCNHours", true);
tdbgExpenses.SetDataBinding(moPCN.PCNData, "PCNExpenses", true);
SqlDataReader dr = CBActivityCode.GetListForBudget();
DataRow d;
mdsAccnts = new dsAccts();
mdsExpensAccts = new dsAccts();
mdsDeptGroup = new dsAccts();
while (dr.Read())
{
d = mdsAccnts.Tables["Accounts"].NewRow();
d["Code"] = dr["Code"];
d["Description"] = dr["Description"];
mdsAccnts.Tables["Accounts"].Rows.Add(d);
}
dr.Close();
tdbdActivities.SetDataBinding(mdsAccnts, "Accounts", true);
dr = CBProjectBudget.GetExpenseGroupByDiscipline(0);
while (dr.Read())
{
d = mdsExpensAccts.Tables["Accounts"].NewRow();
d["Code"] = dr["Code"];
d["Description"] = dr["Description"];
d["DefaultMU"] = dr["DefaultMU"];
mdsExpensAccts.Tables["Accounts"].Rows.Add(d);
}
dr.Close();
tdbdExpenseAccts.SetDataBinding(mdsExpensAccts, "Accounts", true);
dr = CBActivityCode.GetDeptGroup();
while (dr.Read())
{
d = mdsDeptGroup.Tables["Accounts"].NewRow();
d["Code"] = dr["Code"];
d["Description"] = dr["Description"];
//d["DefaultMU"] = dr["DefaultMU"];
mdsDeptGroup.Tables["Accounts"].Rows.Add(d);
}
dr.Close();
tdbdDeptGroup.SetDataBinding(mdsDeptGroup, "Accounts", true);
}
