private void ClearForm()
{
moEmp = new CBEmployee();
txtNumber.Text = "";
txtName.Text = "";
txtAbbrev.Text = "";
cboTitle.Text = "";
chkIsProjMngr.Checked = false;
chkIsRelMngr.Checked = false; //**********************Added 7/13
numMinHrs.Value = 35M;
numMaxReg.Value = 45M;
numMaxAll.Value = 55M;
chkActive.Checked = true;
cmbLocation.Text = "";
chkContractor.Checked = false;
cmbType.Text = "";
cboTitle.Items.Clear();
lstDept.Items.Clear();
lstEmpDept.Items.Clear();
LoadTitleBox();
LoadDepartmentBox();
CreateRemovedDS();
}
private void LoadItemList()
{
SqlDataReader dr;
ListViewItem lvi;
this.Cursor = Cursors.WaitCursor;
if (miDeptFilter != 0)
{
dr = CBEmployee.GetListByDept(miDeptFilter);
}
else
{
dr = CBEmployee.GetList();
}
lvwItems.Items.Clear();
while (dr.Read())
{
lvi = new ListViewItem();
lvi.Text = dr["ID"].ToString();
lvi.SubItems.Add(dr["Abbrev"].ToString());
lvi.SubItems.Add(dr["Name"].ToString());
lvwItems.Items.Add(lvi);
}
dr.Close();
dr = null;
sbPanStatus.Text = lvwItems.Items.Count.ToString() + " employee(s)";
this.Cursor = Cursors.Default;
}
private void LoadFromPCN()
{
CBEmployee emp = new CBEmployee();
lblProjectNumber.Text = moProj.Number;
lblProjectTitle.Text = moProj.Description;
txtPCNTitle.Text = moPCN.PCNTitle;
emp.Load(moPCN.InitiatedByID);
txtInitiatedBy.Text = emp.Name;
dtpDateInitiated.Value = moPCN.DateInitiated;
txtRequestedBy.Text = moPCN.RequestedBy;
dtpDateRequested.Value = moPCN.DateRequested;
txtDescription.Text = moPCN.DescOfChange;
chkDesignError.Checked = moPCN.ReasonDesignError;
chkVendorError.Checked = moPCN.ReasonVendorError;
chkEstimatingError.Checked = moPCN.ReasonEstimatingError;
chkContractorError.Checked = moPCN.ReasonContractorError;
chkScheduleDelay.Checked = moPCN.ReasonSchedule;
chkScopeAdd.Checked = moPCN.ReasonScopeAdd;
chkScopeDel.Checked = moPCN.ReasonScopeDel;
chkDesignChange.Checked = moPCN.ReasonDesignChange;
chkOther.Checked = moPCN.ReasonOther;
txtOtherReason.Text = moPCN.OtherReasonDesc;
txtEstimatedHrs.Text = moPCN.EstimatedEngrHrs.ToString();
txtEstimatedDollars.Text = moPCN.EstimatedEngrDlrs.ToString("#,##0");
txtEstimTIC.Text = moPCN.EstimatedTICDlrs.ToString("#,##0");
txtEstimateAccuracy.Text = moPCN.EstimateAccuracy;
txtScheduleImpact.Text = moPCN.ScheduleImpact;
chkApproved.Checked = moPCN.IsApproved;
chkDisapproved.Checked = moPCN.IsDisapproved;
chkPrepareControlEstimate.Checked = moPCN.PrepareControlEstimate;
if (moPCN.PCNNumber != null)
{
txtPCNNumber.Text = moPCN.PCNNumber;
}
else
{
txtPCNNumber.Text = moPCN.GetNextPCNNumber(moPCN.ProjectID);
}
if (moPCN.DateApproved == RevSol.RSUtility.DefaultDate())
{
lblDateApproved.Text = "";
}
else
{
lblDateApproved.Text = moPCN.DateApproved.ToShortDateString();
}
tdbgHours.SetDataBinding(moPCN.PCNData, "PCNHours", true);
tdbgExpenses.SetDataBinding(moPCN.PCNData, "PCNExpenses", true);
TotalHoursGrid();
TotalExpenseGrid();
rtbComments.Rtf = moPCN.Comments;
}
public void SetCurrentEmployee(int empID)
{
CBEmployee emp = new CBEmployee();
emp.Load(empID);
txtEmployee.Text = emp.Name;
}
private void LoadObjectToScreen()
{
CBEmployee emp = new CBEmployee();
txtName.Text = moDept.Name;
txtDescription.Text = moDept.Description;
txtAcctCode.Text = moDept.Number.ToString();
emp.Load(moDept.EmployeeID);
cboHead.Text = emp.Name;
}
void el_OnItemSelected(int itmID)
{
CBEmployee emp = new CBEmployee();
emp.Load(itmID);
txtInitiatedBy.Text = emp.Name;
txtInitiatedBy.Tag = emp.ID;
moPci.InitiatedByID = itmID;
EnablePCISave();
}
void el_OnItemSelected(int itmID)
{
CBEmployee emp = new CBEmployee();
emp.Load(itmID);
txtInitiatedBy.Text = emp.Name;
txtInitiatedBy.Tag = emp.ID;
moPCN.InitiatedByID = itmID;
SetAllowSave(true);
}
private void LoadDrawingList()
{
ListViewItem li;
SqlDataReader dr;
int leadID;
lvwLogs.Sorting = System.Windows.Forms.SortOrder.Ascending;
dr = CBDrawingLog.GetListByDeptProj(miCurrDept, miCurrProj, cboWBS.Text, 1, true);
lvwLogs.Items.Clear();
leadID = 0;
while (dr.Read())
{
li = new ListViewItem();
li.Text = dr["ID"].ToString();
leadID = Convert.ToInt32(dr["ProjectLeadID"]);
li.SubItems.Add(dr["HGANumber"].ToString());
li.SubItems.Add(dr["CADNumber"].ToString());
li.SubItems.Add(dr["WBS"].ToString());
lvwLogs.Items.Add(li);
}
dr.Close();
CBEmployee emp = new CBEmployee();
emp.Load(leadID);
miCurrLead = leadID;
txtProjectLead.Text = emp.Name;
bttProjectLead.Enabled = false;
sbStatus1.Text = lvwLogs.Items.Count.ToString() + " Drawing(s)";
SortDrawingList sorter = new SortDrawingList();
sorter.SortColumnNumber = 1;
sorter.SortColumnAsc = true;
lvwLogs.ListViewItemSorter = sorter;
lvwLogs.Sort();
miLastSortCol = 1;
mbSortColAsc = true;
if (lvwLogs.Items.Count > 0)
{
lvwLogs.Focus();
lvwLogs.Items[0].Selected = true;
}
}
void SelectProjectLead(int itmID)
{
CBEmployee emp = new CBEmployee();
emp.Load(itmID);
miCurrLead = itmID;
txtProjectLead.Text = emp.Name;
if (lvwLogs.Items.Count > 0)
{
CBDrawingLog.UpdateProjectLead(miCurrDept, miCurrProj, itmID);
}
}
private void timer1_Tick(object sender, EventArgs e)
{
timer1.Enabled = false;
if (mbUseGroup == true)
{
CBEmployee emp = new CBEmployee();
emp.Load(miCurrLead);
txtProjectLead.Text = emp.Name;
LoadListForGrouping();
}
}
private void LoadScreenToObject()
{
CBCustomer c = new CBCustomer();
CBEmployee e = new CBEmployee();
CBRateSchedule rs = new CBRateSchedule();
moProj.Number = txtNumber.Text;
moProj.Description = txtDescription.Text;
moProj.CustomerProjNumber = txtCustomerNumber.Text;
Func <ComboBox, int?> getId = (box) => {
var selected = ((RSLib.COListItem)box.SelectedItem);
return((selected != null) ? selected.ID : (int?)null);
};
moProj.CustomerID = getId(cboCustomer) ?? moProj.CustomerID;
moProj.LocationID = getId(cboLocation) ?? moProj.LocationID;
moProj.ProjMngrID = getId(cboManager) ?? moProj.ProjMngrID;
moProj.LeadProjMngrID = getId(cboManagerLead) ?? moProj.LeadProjMngrID;
moProj.RelationshipMngrID = getId(cboRelationship) ?? moProj.RelationshipMngrID;
moProj.RateSchedID = getId(cboRateSched) ?? moProj.RateSchedID;
moProj.Multiplier = RevSol.RSMath.IsDecimalEx(txtMultiplier.Text);
moProj.Overlay = RevSol.RSMath.IsDecimalEx(txtOverlay.Text);
moProj.POAmount = txtPOAmount.Text;
moProj.DateStart = dtpStart.Value;
moProj.DateEnd = dtpEnd.Value;
moProj.IsProposal = chkActiveProposal.Checked;
moProj.IsBooked = chkIsBooked.Checked;
moProj.IsActive = chkIsActive.Checked;
moProj.IsGovernment = chkIsGovernment.Checked;
moProj.IsMaster = chkIsMaster.Checked;
if (cboMasterJobs.SelectedItem == null)
{
moProj.MasterID = 0;
}
else
{
moProj.MasterID = ((RSLib.COListItem)cboMasterJobs.SelectedItem).ID;
}
moProj.ReportingStatus = cboReportStatus.SelectedIndex;
moProj.Notes = rtbNotes.Text;
moProj.IsFixedRate = chkIsFixedRate.Checked;
}
protected override void bttDelete_Click(object sender, EventArgs e)
{
base.bttDelete_Click(sender, e);
int tmpID = Convert.ToInt32(lvwItems.SelectedItems[0].Text);
string val = lvwItems.SelectedItems[0].SubItems[2].Text;
DialogResult retVal = MessageBox.Show("Are you sure that you wish to remove \"" + val + "\"", "Remove Item", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (retVal == DialogResult.Yes)
{
CBEmployee.Delete(tmpID);
LoadItemList();
}
}
public void TestPM()
{
rprtPMReport1 r = new rprtPMReport1();
FPreviewAR pv = new FPreviewAR();
CBEmployee e = new CBEmployee();
e.Load(25);
DataSet ds = CBProjectSummary.GetPMReport(25);
r.ProjectManager = e.Name;
r.DataSource = ds;
r.DataMember = "Table";
pv.ViewReport(r);
pv.ShowDialog();
}
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;
}
}
void NewProjectLead(int itmID)
{
CBEmployee e = new CBEmployee();
e.Load(itmID);
txtProjectLead.Text = e.Name;
miCurrLead = itmID;
// save new lead to file
COAppState app = new COAppState();
app.InitAppSettings();
app.Sch_EmplyID = itmID;
app.SaveAppSettings();
LoadListForGrouping();
}
private void LoadDrawingList(int sortColumn, bool sortAsc)
{
ListViewItem li;
SqlDataReader dr;
int leadID;
dr = CBDrawingLog.GetListByDeptProj(miCurrDept, miCurrProj, cboWBS.Text, sortColumn, sortAsc);
lvwLogs.Items.Clear();
leadID = 0;
while (dr.Read())
{
li = new ListViewItem();
li.Text = dr["ID"].ToString();
leadID = Convert.ToInt32(dr["ProjectLeadID"]);
li.SubItems.Add(dr["HGANumber"].ToString());
li.SubItems.Add(dr["CADNumber"].ToString());
li.SubItems.Add(dr["WBS"].ToString());
lvwLogs.Items.Add(li);
}
dr.Close();
CBEmployee emp = new CBEmployee();
emp.Load(leadID);
miCurrLead = leadID;
txtProjectLead.Text = emp.Name;
bttProjectLead.Enabled = false;
sbStatus1.Text = lvwLogs.Items.Count.ToString() + " Drawing(s)";
if (lvwLogs.Items.Count > 0)
{
lvwLogs.Focus();
lvwLogs.Items[0].Selected = true;
LoadSelectedItem(0);
}
}
private void LoadAvailableEmployees()
{
SqlDataReader dr;
RSLib.COListItem li;
dr = CBEmployee.GetListByDept(miCurrDept);
lstAvailable.Items.Clear();
while (dr.Read())
{
li = new RSLib.COListItem();
li.ID = Convert.ToInt32(dr["ID"]);
li.Description = dr["Name"].ToString();
lstAvailable.Items.Add(li);
}
dr.Close();
}
private void LoadEmployeeBox()
{
SqlDataReader dr;
RSLib.COListItem li;
dr = CBEmployee.GetList();
cboEmployee.Items.Clear();
while (dr.Read())
{
li = new RSLib.COListItem();
li.ID = Convert.ToInt32(dr["ID"]);
li.Description = dr["Name"].ToString();
cboEmployee.Items.Add(li);
}
dr.Close();
}
private void LoadProjMngrList()
{
SqlDataReader dr;
RevSol.RSListItem li;
cboProjMngr.Items.Clear();
cboProjMngr.Text = "";
dr = CBEmployee.GetListProjectManagers();
while (dr.Read())
{
li = new RevSol.RSListItem();
li.ID = Convert.ToInt32(dr["ID"]);
li.Description = dr["Name"].ToString();
cboProjMngr.Items.Add(li);
}
dr.Close();
}
private void LoadLeads(int deptID)
{
SqlDataReader dr;
RSLib.COListItem li;
dr = CBEmployee.GetListByDept(deptID);
clstProjects.Items.Clear();
while (dr.Read())
{
li = new RSLib.COListItem();
li.ID = Convert.ToInt32(dr["ID"]);
li.Description = dr["Name"].ToString();
clstProjects.Items.Add(li);
}
clstProjects.SetItemChecked(0, true);
dr.Close();
}
public void ClearForm(bool forceClear)
{
if (moPci != null && forceClear == false)
{
return;
}
moPci = new CBPCIInfo();
txtDiscipline.Text = "";
lblPCINumber.Text = CBPCIInfo.GetNextPCINumber(miDiscipline, miProject);
txtInitiatedBy.Text = "";
lblProjectNumber.Text = "";
lblProjectTitle.Text = "";
txtPCITitle.Text = "";
dtpDateInitiated.Value = DateTime.Now;
txtRequestedBy.Text = "";
dtpDateRequested.Value = DateTime.Now;
txtDescription.Text = "";
rdoDesignError.Checked = false;
rdoVendorError.Checked = false;
rdoEstimatingError.Checked = false;
rdoContractorError.Checked = false;
rdoScheduleDelay.Checked = false;
rdoScopeAddition.Checked = false;
rdoScopeDeletion.Checked = false;
rdoDesignChange.Checked = false;
rdoOther.Checked = false;
txtOtherReason.Text = "";
txtOtherReason.Enabled = false;
chkMechPiping.Checked = false;
chkCSA.Checked = false;
chkProjAdmin.Checked = false;
chkProcess.Checked = false;
chkElectInst.Checked = false;
txtEstimatedHrs.Text = "";
txtEstimatedCost.Text = "";
txtEstimatedTIC.Text = "";
txtEstimatedAccuracy.Text = "";
txtScheduleImpact.Text = "";
chkAppvProceed.Checked = false;
chkAppvTrack.Checked = false;
chkNotAppvDNP.Checked = false;
txtProjMngr.Text = "";
lblDateApproved.Text = "";
if (miDiscipline != 0)
{
CBDepartment dept = new CBDepartment();
dept.Load(miDiscipline);
txtDiscipline.Text = dept.Name;
moPci.DepartmentID = miDiscipline;
}
if (miProject != 0)
{
CBProject proj = new CBProject();
CBEmployee emp = new CBEmployee();
proj.Load(miProject);
emp.Load(proj.ProjMngrID);
emp.Load(proj.LeadProjMngrID);
lblProjectNumber.Text = proj.Number;
lblProjectTitle.Text = proj.Description;
txtProjMngr.Text = emp.Name;
moPci.ProjectID = miProject;
moPci.ProjectManagerID = proj.ProjMngrID;
}
mbNewPCNNeeded = false;
}
private void LoadObjectToScreen()
{
CBDepartment dept = new CBDepartment();
CBEmployee emp = new CBEmployee();
CBProject proj = new CBProject();
dept.Load(moPci.DepartmentID);
emp.Load(moPci.InitiatedByID);
proj.Load(moPci.ProjectID);
projectNumber = proj.Number; //////*************************************************6/25/15
// MessageBox.Show("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%");
// MessageBox.Show(projectNumber);
txtDiscipline.Text = dept.Name;
lblPCINumber.Text = moPci.PCINumber;
txtPCITitle.Text = moPci.PCITitle;
txtInitiatedBy.Text = emp.Name;
dtpDateInitiated.Value = moPci.DateInitiated;
lblProjectNumber.Text = proj.Number;
lblProjectTitle.Text = proj.Description;
txtRequestedBy.Text = moPci.RequestedBy;
dtpDateRequested.Value = moPci.DateRequested;
txtDescription.Text = moPci.DescOfChange;
rdoDesignError.Checked = moPci.ReasonDesignError;
rdoVendorError.Checked = moPci.ReasonVendorError;
rdoEstimatingError.Checked = moPci.ReasonEstimatingError;
rdoContractorError.Checked = moPci.ReasonContractorError;
rdoScheduleDelay.Checked = moPci.ReasonSchedule;
rdoScopeAddition.Checked = moPci.ReasonScopeAdd;
rdoScopeDeletion.Checked = moPci.ReasonScopeDel;
rdoDesignChange.Checked = moPci.ReasonDesignChange;
rdoOther.Checked = moPci.ReasonOther;
txtOtherReason.Text = moPci.OtherReasonDesc;
chkMechPiping.Checked = moPci.AffectedMechPipe;
chkCSA.Checked = moPci.AffectedCSA;
chkProjAdmin.Checked = moPci.AffectedProjAdmin;
chkProcess.Checked = moPci.AffectedProcess;
chkElectInst.Checked = moPci.AffectedEandI;
txtEstimatedHrs.Text = moPci.EstimatedEngrHrs.ToString();
txtEstimatedCost.Text = moPci.EstimatedEngrDlrs.ToString("#,##0");
txtEstimatedTIC.Text = moPci.EstimatedEngrTIC.ToString("#,##0");
txtEstimatedAccuracy.Text = moPci.EstimatedAccuracy;
txtScheduleImpact.Text = moPci.ScheduleImpact;
chkAppvProceed.Checked = moPci.ApprovedProceed;
chkAppvTrack.Checked = moPci.ApprovedTrack;
chkNotAppvDNP.Checked = moPci.ApprovedNot;
emp.Load(moPci.ProjectManagerID);
txtProjMngr.Text = emp.Name;
if (moPci.DateApproved == RevSol.RSUtility.DefaultDate())
{
lblDateApproved.Text = "";
}
else
{
lblDateApproved.Text = moPci.DateApproved.ToShortDateString();
}
mbNewPCNNeeded = false;
}
private void LoadObjectToScreen()
{
CBCustomer c = new CBCustomer();
CBLocation l = new CBLocation();
CBEmployee e = new CBEmployee();
CBRateSchedule rs = new CBRateSchedule();
txtNumber.Text = moProj.Number;
txtDescription.Text = moProj.Description;
c.Load(moProj.CustomerID);
cboCustomer.Text = c.Name;
txtCustomerNumber.Text = moProj.CustomerProjNumber;
LoadLocationBox(moProj.CustomerID);
l.Load(moProj.LocationID);
cboLocation.Text = l.FullName;
e.Load(moProj.ProjMngrID);
cboManager.Text = e.Name;
e.Load(moProj.LeadProjMngrID);
cboManagerLead.Text = e.Name;
e.Load(moProj.RelationshipMngrID);
cboRelationship.Text = e.Name;
rs.Load(moProj.RateSchedID);
cboRateSched.Text = rs.Name;
if (rs.IsMultiplier == true)
{
lblMultiplier.Visible = true;
txtMultiplier.Visible = true;
txtMultiplier.Text = moProj.Multiplier.ToString("#,##0.00");
lblOverlay.Visible = true;
txtOverlay.Visible = true;
txtOverlay.Text = moProj.Overlay.ToString("#,##0.00");
}
else
{
lblMultiplier.Visible = false;
txtMultiplier.Visible = false;
txtMultiplier.Text = "0.00";
lblOverlay.Visible = false;
txtOverlay.Visible = false;
txtOverlay.Text = "0.00";
}
txtPOAmount.Text = moProj.POAmount;
dtpStart.Value = moProj.DateStart;
dtpEnd.Value = moProj.DateEnd;
chkActiveProposal.Checked = moProj.IsProposal;
chkIsBooked.Checked = moProj.IsBooked;
chkIsActive.Checked = moProj.IsActive;
chkIsGovernment.Checked = moProj.IsGovernment;
chkIsMaster.Checked = moProj.IsMaster;
chkIsFixedRate.Checked = moProj.IsFixedRate;
if (moProj.MasterID > 0)
{
cboMasterJobs.Text = CBProject.GetNumberByID(moProj.MasterID);
}
cboReportStatus.SelectedIndex = moProj.ReportingStatus;
rtbNotes.Text = moProj.Notes;
mdsBudget = CBProjectBudget.GetListDSByProjID(moProj.ID);
tdbgBudget.SetDataBinding(mdsBudget, "Table", true);
TotalBudget();
RSLib.COSecurity sec = new RSLib.COSecurity();
CBUser u = new CBUser();
sec.InitAppSettings();
u.Load(sec.UserID);
if (u.IsAdministrator == true || u.IsEngineerAdmin == true)
{
chkActiveProposal.Enabled = true;
chkIsActive.Enabled = true;
chkIsBooked.Enabled = true;
}
}