public void PrintJobStatList(string deptXml, string leadXml, bool isLead, bool isPreview, int sortCode) { FPreviewAR pv; rprtJobStat1 rprt = new rprtJobStat1(); DataSet ds; ds = CBDrawingLog.GetJobStatListByLeadList(deptXml, leadXml, sortCode); rprt.DataSource = ds; rprt.DataMember = "Table"; pv = new FPreviewAR(); //************** Done 6/29/15 pv.Title = "DRAWING/SPEC LOG"; //********************************12/01 pv.ViewReport(rprt); if (isPreview == true) { //pv = new FPreviewAR(); //pv.ViewReport(rprt); pv.ShowDialog(); } else { rprt.Run(); rprt.Document.Print(true, false); } }
public void PrintDrawingLog(int deptID, int projID) { //FPreview pv; ////rprtDrawingLog rprt = new rprtDrawingLog(); //rprtDrawingLog_Alt rprt = new rprtDrawingLog_Alt(); //dsDrawingLog ds; //ds = CBDrawingLog.GetDrawingLogForRprt(deptID, projID); ////rprt = new rprtDrawingLog(); //rprt = new rprtDrawingLog_Alt(); //rprt.SetDataSource(ds); //pv = new FPreview(); //pv.ShowReport(rprt); //pv.ShowDialog(); ////rprt.PrintToPrinter(1, false, 0, 0); FPreviewAR pv; rprtDrawingLog1 rprt = new rprtDrawingLog1(); dsDrawingLog ds; ds = CBDrawingLog.GetDrawingLogForRprt(deptID, projID); rprt.SetDrawingLogAsCustomerReport(); rprt.DataSource = ds; rprt.DataMember = "DrawingList"; pv = new FPreviewAR(); pv.Title = "DRAWING/SPEC LOG"; //********************************12/01 pv.ViewReport(rprt); pv.ShowDialog(); }
public void PrintJobStat(int deptID, int projID) { //FPreview pv; //rprtJobStat rprt = new rprtJobStat(); //DataSet ds; //ds = CBDrawingLog.GetJobStatForRprt(deptID, projID); //rprt = new rprtJobStat(); //rprt.SetDataSource(ds); //pv = new FPreview(); //pv.ShowReport(rprt); //pv.ShowDialog(); ////rprt.PrintToPrinter(1, false, 0, 0); FPreviewAR pv; rprtJobStat1 rprt = new rprtJobStat1(); DataSet ds; ds = CBDrawingLog.GetJobStatForRprt(deptID, projID); rprt.DataSource = ds; rprt.DataMember = "Table"; pv = new FPreviewAR(); pv.ViewReport(rprt); pv.ShowDialog(); }
public void PrintDrawingLogList(string deptXml, string leadXml, bool isLead, bool isPreview, int sortCode) { FPreviewAR pv; //rprtDrawingLog1 rprt = new rprtDrawingLog1(); rprtDrawingLogTranAlt2 rprt = new rprtDrawingLogTranAlt2(); dsDrawingLog dl; dl = CBDrawingLog.GetDrawingLogMainByLeadList(deptXml, leadXml, sortCode, 0); rprt.SetDrawingLogAsCustomerReport(); rprt.DataSource = dl; rprt.DataMember = "DrawingList"; pv = new FPreviewAR(); //************** Done 6/29/15 pv.Title = "DRAWING/SPEC LOG"; //********************************12/01 pv.ViewReport(rprt); if (isPreview == true) { //pv = new FPreviewAR(); //pv.ViewReport(rprt); pv.ShowDialog(); } else { rprt.Run(); rprt.Document.Print(true, false); } }
public void PrintJobStatList(int deptID, bool isPreview, int sortCode) { FPreviewAR pv; rprtJobStat1 rprt = new rprtJobStat1(); DataSet ds; ds = CBDrawingLog.GetJobStatListByDeptID(deptID, sortCode); rprt.DataSource = ds; rprt.DataMember = "Table"; pv = new FPreviewAR(); //************** Done 6/29/15 pv.ViewReport(rprt); if (isPreview == true) { //pv = new FPreviewAR(); //pv.ViewReport(rprt); pv.ShowDialog(); } else { rprt.Run(); rprt.Document.Print(true, false); } }
private void ClearLog() { moDrwLog = new CBDrawingLog(); txtHGANumber.Text = ""; txtClientNumber.Text = ""; txtCADNumber.Text = ""; cboActivityCodes.Text = ""; chkIsTask.Checked = false; rdoTask.Checked = false; rdoDrawing.Checked = false; rdoSpec.Checked = false; cboDrawingSizes.Text = ""; txtWBS.Text = ""; txtBudgetHrs.Text = ""; txtPercentComplete.Text = ""; txtRemainingHrs.Text = ""; txtEarnedHrs.Text = ""; txtTitle1.Text = ""; txtTitle2.Text = ""; txtTitle3.Text = ""; txtTitle4.Text = ""; txtTitle5.Text = ""; txtTitle6.Text = ""; rdoTitle1IsTitle.Checked = true; rdoTitle2IsDesc.Checked = true; txtRevision.Text = ""; cboIssuedAs.Text = ""; dtpDateRevised.Checked = false; dtpDateDue.Checked = false; dtpDateLate.Checked = false; }
private void GetThePercentComplete() { decimal budHrs; decimal remHrs; try { //budHrs = Convert.ToDecimal(txtBudgetHrs.Text); budHrs = txtBudgetHrs.Text.Trim() == "" ? 0 : Convert.ToDecimal(txtBudgetHrs.Text); remHrs = Convert.ToDecimal(txtRemainingHrs.Text); } catch { budHrs = 0; remHrs = 0; } if (budHrs == 0) { txtPercentComplete.Text = "0.00"; } else { txtPercentComplete.Text = CBDrawingLog.GetPercentComplete(budHrs, remHrs).ToString("#,##0.00"); } decimal ernHrs = budHrs - remHrs; txtEarnedHrs.Text = ernHrs.ToString("#,##0.00"); }
private void tdbgQuikUpdate_BeforeUpdate(object sender, C1.Win.C1TrueDBGrid.CancelEventArgs e) { DataRow dr = mdsUpdates.Tables[0].Rows[tdbgQuikUpdate.Bookmark]; int tmpID; int tmpBM; decimal bHrs; decimal perc; decimal eHrs; decimal rHrs; tmpBM = tdbgQuikUpdate.Bookmark; // added to allow for the sort CurrencyManager cm; System.Data.DataView dv; System.Data.DataRowView drv; System.Data.DataRow dr2; int row; row = tdbgQuikUpdate.RowBookmark(tdbgQuikUpdate.Bookmark); cm = (CurrencyManager)this.BindingContext[tdbgQuikUpdate.DataSource, tdbgQuikUpdate.DataMember]; dv = (DataView)cm.List; drv = (System.Data.DataRowView)cm.List[row]; dr2 = drv.Row; tmpID = Convert.ToInt32(dr["ID"]); bHrs = Convert.ToDecimal(dr["BudgetHrs"]); try //******************Try Catch block added 6/11/2015 { rHrs = Convert.ToDecimal(dr["RemainingHrs"]); } catch { MessageBox.Show("Field Cannot be empty, default value=0"); return; } int tmpID2 = Convert.ToInt32(dr2["ID"]); decimal bHrs2 = Convert.ToDecimal(dr2["BudgetHrs"]); decimal rHrs2 = Convert.ToDecimal(dr2["RemainingHrs"]); //perc = CBDrawingLog.GetPercentComplete(bHrs, rHrs); //eHrs = CBDrawingLog.GetEarnedHrs(bHrs, rHrs); //dr["PercentComplete"] = perc; //dr["EarnedHrs"] = eHrs; //CBDrawingLog.UpdateHours(tmpID, bHrs, perc, eHrs, rHrs); // changed to allow for the sort perc = CBDrawingLog.GetPercentComplete(bHrs2, rHrs2); eHrs = CBDrawingLog.GetEarnedHrs(bHrs2, rHrs2); dr2["PercentComplete"] = perc; dr2["EarnedHrs"] = eHrs; CBDrawingLog.UpdateHours(tmpID2, bHrs2, perc, eHrs, rHrs2); TotalHours(); }
public void PrintDrawingLogList(string deptXml, string leadXml, bool isLead, bool isPreview, int sortCode, int drwgSpec) { FPreviewAR pv; rprtDrawingLogTranAlt2 rprt = new rprtDrawingLogTranAlt2(); dsDrawingLog dl; dl = CBDrawingLog.GetDrawingLogMainByLeadList(deptXml, leadXml, sortCode, drwgSpec); string name_of_Method = "GetDrawingLogMainByLeadList"; //**************************Added 10/3/2015 rprt.DataSource = dl; rprt.DataMember = "DrawingList"; rprt.SetTitle = GetDrawingSpecTitle(drwgSpec); pv = new FPreviewAR(); //************** Done 6/29/15 pv.name_of_Method = name_of_Method; pv.leadXml = leadXml; pv.deptXml = deptXml; pv.sortCode = sortCode; pv.drwgSpec = drwgSpec; pv.Title = rprt.SetTitle; //********************************12/01 pv.ViewDrawingLogWithExcel(rprt); if (isPreview == true) { //pv = new FPreviewAR(); //pv.ViewDrawingLogWithExcel(rprt); pv.ShowDialog(); } else { rprt.Run(); rprt.Document.Print(true, false); } }
public void PrintJobStatList(int deptID, bool isPreview, int sortCode) { FPreviewAR pv; rprtJobStat1 rprt = new rprtJobStat1(); DataSet ds; ds = CBDrawingLog.GetJobStatListByDeptID(deptID, sortCode); rprt.DataSource = ds; rprt.DataMember = "Table"; pv = new FPreviewAR(); pv.ViewReport(rprt); if (isPreview == true) { //pv = new FPreviewAR(); //****Took these out of If Block, so that, ViewReport() is called, and reportType is available for Save file name //pv.ViewReport(rprt); //************** Done 6/29/15 pv.ShowDialog(); } else { rprt.Run(); rprt.Document.Print(true, false); } }
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; } }
private void tdbgUpdate_AfterUpdate(object sender, EventArgs e) { DataRow dr = mdsUpdates.Tables[0].Rows[tdbgQuikUpdate.Bookmark]; int tmpID; int tmpBM; decimal bHrs; decimal perc; decimal eHrs; decimal rHrs; tmpBM = tdbgQuikUpdate.Bookmark; // added to allow for the sort CurrencyManager cm; System.Data.DataView dv; System.Data.DataRowView drv; System.Data.DataRow dr2; int row; row = tdbgQuikUpdate.RowBookmark(tdbgQuikUpdate.Bookmark); cm = (CurrencyManager)this.BindingContext[tdbgQuikUpdate.DataSource, tdbgQuikUpdate.DataMember]; dv = (DataView)cm.List; drv = (System.Data.DataRowView)cm.List[row]; dr2 = drv.Row; tmpID = Convert.ToInt32(dr["ID"]); bHrs = Convert.ToDecimal(dr["BudgetHrs"]); rHrs = Convert.ToDecimal(dr["RemainingHrs"]); int tmpID2 = Convert.ToInt32(dr2["ID"]); decimal bHrs2 = Convert.ToDecimal(dr2["BudgetHrs"]); decimal rHrs2 = Convert.ToDecimal(dr2["RemainingHrs"]); perc = CBDrawingLog.GetPercentComplete(bHrs2, rHrs2); eHrs = CBDrawingLog.GetEarnedHrs(bHrs2, rHrs2); dr2["PercentComplete"] = perc; dr2["EarnedHrs"] = eHrs; CBDrawingLog.UpdateHours(tmpID2, bHrs2, perc, eHrs, rHrs2); //perc = CBDrawingLog.GetPercentComplete(bHrs, rHrs); //eHrs = CBDrawingLog.GetEarnedHrs(bHrs, rHrs); //dr["PercentComplete"] = perc; //dr["EarnedHrs"] = eHrs; //CBDrawingLog.UpdateHours(tmpID, bHrs, perc, eHrs, rHrs); TotalHours(); }
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); } }
public void PrintDrawingLog(int deptID, int projID) { FPreviewAR pv; rprtDrawingLogTranAlt2 rprt = new rprtDrawingLogTranAlt2(); dsDrawingLog ds; ds = CBDrawingLog.GetDrawingLogForRprt(deptID, projID); rprt.DataSource = ds; rprt.DataMember = "DrawingList"; pv = new FPreviewAR(); pv.ViewReport(rprt); pv.ShowDialog(); }
private string ActivityList() { SqlDataReader dr; string AcctList = ""; dr = CBDrawingLog.GetListAcctCodes(); while (dr.Read()) { AcctList = AcctList + dr["Code"].ToString() + ","; } dr.Close(); return(AcctList); }
public void PrintJobStat(int deptID, int projID) { FPreviewAR pv; rprtJobStat1 rprt = new rprtJobStat1(); DataSet ds; ds = CBDrawingLog.GetJobStatForRprt(deptID, projID); rprt.DataSource = ds; rprt.DataMember = "Table"; pv = new FPreviewAR(); pv.ViewReport(rprt); pv.ShowDialog(); }
private void LoadListForGrouping() { mdsUpdates = CBDrawingLog.GetListByDeptLeadForUpdate(miCurrDept, miCurrLead); //tdbgQuikUpdate.GroupByAreaVisible = true; tdbgQuikUpdate.DataView = C1.Win.C1TrueDBGrid.DataViewEnum.GroupBy; tdbgQuikUpdate.GroupedColumns.Clear(); tdbgQuikUpdate.SetDataBinding(mdsUpdates, "Table", true); tdbgQuikUpdate.GroupedColumns.Add(tdbgQuikUpdate.Columns["Project"]); tdbgQuikUpdate.Columns["Project"].GroupInfo.Interval = C1.Win.C1TrueDBGrid.GroupIntervalEnum.Custom; tdbgQuikUpdate.Columns["Project"].GroupInfo.ColumnVisible = true; TotalHours(); }
private void bttSave_Click(object sender, EventArgs e) { if (IsValid(true) == true) { EnableSaveButtons(false); LoadScreenToObject(); moDrwLog.Save(); UpdateList(); moDrwLog = new CBDrawingLog(); CheckToAddNewWBSCode(txtWBS.Text); txtCADNumber.Text = ""; EnableSaveButtons(false); } }
private void LoadDrawingList(bool sortByCAD) { mdsUpdates = CBDrawingLog.GetListbyDeptProjForUpdate(miCurrDept, miCurrProj, cboWBS.Text, true); tdbgQuikUpdate.DataView = C1.Win.C1TrueDBGrid.DataViewEnum.Normal; tdbgQuikUpdate.GroupedColumns.Clear(); tdbgQuikUpdate.SetDataBinding(mdsUpdates, "Table", true); TotalHours(); if (fgQuikUpdate.Visible) { LoadGridWithDrawings(); } }
private void removeDrawingToolStripMenuItem_Click(object sender, EventArgs e) { string currDrawing; currDrawing = lvwLogs.SelectedItems[0].SubItems[1].Text; DialogResult retVal = MessageBox.Show("Are you sure that you wish to remove " + currDrawing + " from the list", "Remove drawing", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (retVal == DialogResult.Yes) { int currID = Convert.ToInt32(lvwLogs.SelectedItems[0].Text); CBDrawingLog.Delete(currID); LoadDrawingList(); SetAccessForSecurityLevel(miCurrDept); } }
private void LoadWBSCodesForFilter() { SqlDataReader dr; dr = CBDrawingLog.GetWBSListByProject(miCurrProj); cboWBS.Items.Clear(); cboWBS.Items.Add(""); while (dr.Read()) { if (dr["WBS"].ToString().Length > 0) { cboWBS.Items.Add(dr["WBS"].ToString()); } } }
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 LoadGridWithDrawings() { Row rw; fgQuikUpdate.Redraw = false; this.Cursor = Cursors.WaitCursor; Application.DoEvents(); DataView dv; ClearCurrentGrid(); dv = new DataView(mdsUpdates.Tables[0]); dv.Sort = "AcctCode ASC"; for (int i = 0; i < dv.Count; i++) { rw = fgQuikUpdate.Rows.Add(); rw[1] = dv[i]["AcctCode"].ToString(); rw[2] = dv[i]["ID"].ToString(); rw[3] = dv[i]["Project"].ToString(); rw[4] = dv[i]["HGANumber"].ToString(); rw[5] = dv[i]["CADNumber"].ToString(); rw[6] = dv[i]["WBS"].ToString(); //rw[7] = dv[i]["IsTask"].ToString(); rw[7] = CBDrawingLog.GetTaskDrwgSpecFromInt(Convert.ToInt32(dv[i]["IsTask"])); rw[8] = dv[i]["Title"].ToString(); rw[9] = dv[i]["AcctCode"].ToString(); rw[10] = dv[i]["BudgetHrs"].ToString(); rw[11] = dv[i]["ActualHrs"].ToString(); rw[12] = dv[i]["PercentComplete"].ToString(); rw[13] = dv[i]["Earnedhrs"].ToString(); rw[14] = dv[i]["RemainingHrs"].ToString(); } this.Cursor = Cursors.Default; //fgQuikUpdate.Cols[10].Style = fgQuikUpdate.Styles["ActualValues"]; fgQuikUpdate.Redraw = true; CreateSubtotals(); }
private void SaveTimeChange(int rowIndx, int colIndx) { int tmpID; decimal bHrs; decimal perc; decimal eHrs; decimal rHrs; tmpID = Convert.ToInt32(fgQuikUpdate[rowIndx, 2]); bHrs = Convert.ToDecimal(fgQuikUpdate[rowIndx, 10]); rHrs = Convert.ToDecimal(fgQuikUpdate[rowIndx, 14]); perc = CBDrawingLog.GetPercentComplete(bHrs, rHrs); eHrs = CBDrawingLog.GetEarnedHrs(bHrs, rHrs); fgQuikUpdate[rowIndx, 12] = perc; fgQuikUpdate[rowIndx, 13] = eHrs; CBDrawingLog.UpdateHours(tmpID, bHrs, perc, eHrs, rHrs); CreateSubtotals(); }
private void LoadDrawingList() { SqlDataReader dr; ListViewItem lvi; dr = CBDrawingLog.GetListbyDeptProjForTrans(miDeptID, miProjID); lvwDocList.Items.Clear(); while (dr.Read()) { lvi = new ListViewItem(); lvi.Text = dr["ID"].ToString(); lvi.SubItems.Add(dr["HGANumber"].ToString()); lvi.SubItems.Add(dr["CADNumber"].ToString()); lvi.SubItems.Add(dr["Title"].ToString()); lvwDocList.Items.Add(lvi); } dr.Close(); }
public void ExportBudgetForPrimavera_GetDrawingLogMainByProjList(string saveLoc, string xml, int sortCode, int drwgSpec) { SqlDataReader dr; C1XLBook book = new C1XLBook(); XLSheet sheet = book.Sheets[0]; int indx; decimal tmpRate; // must be output with the following columns // code,blank,description,quantity,uom,hours,rate,cost // dr = CBBudgetLine.GetExportListByBudget(budgetID); dr = CBDrawingLog.GetExportListForDrawingLog_Proj(xml, sortCode, drwgSpec); indx = 0; tmpRate = 0; while (dr.Read()) { sheet[indx, 3].Value = dr["DrawingID"].ToString(); // code sheet[indx, 4].Value = ""; // blank sheet[indx, 5].Value = dr["Department"]; // description sheet[indx, 6].Value = dr["Project"].ToString(); // quantity sheet[indx, 7].Value = dr["ProjectNumber"]; // uom sheet[indx, 8].Value = dr["Title1"].ToString(); // hours sheet[indx, 9].Value = dr["RevisionNumber"].ToString(); sheet[indx, 10].Value = dr["IssueDate"].ToString(); // rate sheet[indx, 11].Value = dr["IssuedFor"].ToString(); // cost sheet[indx, 12].Value = dr["TransNo"].ToString(); indx++; } dr.Close(); book.Save(saveLoc); }
private int LoadScreenToObject_X(int indx, int deptID, int projID, int leadID, Excel._Worksheet WS) { moDrwLog = new CBDrawingLog(); //if (WS.Cells[indx, 1].Text == "") // moDrwLog.ID = 0; //else // moDrwLog.ID = Convert.ToInt32(WS.Cells[indx, 1].Value.ToString()); moDrwLog.ID = Convert.ToInt32(WS.Cells[indx, "A"].Value); // MessageBox.Show(moDrwLog.ID.ToString()); moDrwLog.DepartmentID = deptID; moDrwLog.ProjectID = projID; moDrwLog.ProjectLeadID = leadID; // ******* Added 11/30 moDrwLog.WBS = WS.Cells[indx, 5].Text; moDrwLog.HGANumber = WS.Cells[indx, 6].Text; moDrwLog.ClientNumber = WS.Cells[indx, 7].Text; moDrwLog.CADNumber = WS.Cells[indx, 8].Text; // moDrwLog.ActCodeID = Array.IndexOf(AccountCodeID, Convert.ToInt32(WS.Cells[indx, 9].Value)); ///****************11/20 moDrwLog.ActCodeID = CBActivityCode.GetID_ByActivityCode(Convert.ToInt32(WS.Cells[indx, 9].Value)); /// ************************** to fetch index of AccountCode ***11/23 // MessageBox.Show("From Sheet....."+WS.Cells[indx, 9].Value + ".....ID...." + moDrwLog.ActCodeID); //moDrwLog.IsTask = chkIsTask.Checked; moDrwLog.IsTaskDrwgSpec = Convert.ToInt32(WS.Cells[indx, 10].Value); // moDrwLog.DrawingSizeID = GetDrawingSizeCode(); moDrwLog.DrawingSizeID = Convert.ToInt32(WS.Cells[indx, 11].Value); try { moDrwLog.BudgetHrs = Convert.ToDecimal(WS.Cells[indx, 12].Text); } catch { moDrwLog.BudgetHrs = 0; } try { moDrwLog.PercentComplete = Convert.ToDecimal(WS.Cells[indx, 13].Text); } catch { moDrwLog.PercentComplete = 0; } try { moDrwLog.RemainingHrs = Convert.ToDecimal(WS.Cells[indx, 14].Text); } catch { moDrwLog.RemainingHrs = 0; } try { moDrwLog.EarnedHrs = Convert.ToDecimal(WS.Cells[indx, 15].Text); } catch { moDrwLog.EarnedHrs = 0; } moDrwLog.Title1 = WS.Cells[indx, 16].Text; moDrwLog.Title2 = WS.Cells[indx, 19].Text; moDrwLog.Title3 = WS.Cells[indx, 22].Text; moDrwLog.Title4 = WS.Cells[indx, 25].Text; moDrwLog.Title5 = WS.Cells[indx, 28].Text; moDrwLog.Title6 = WS.Cells[indx, 31].Text; bool IsTitle1, IsTitle2, IsTitle3, IsTitle4, IsTitle5, IsTitle6; bool IsDesc1, IsDesc2, IsDesc3, IsDesc4, IsDesc5, IsDesc6; if (WS.Cells[indx, 17].Value.ToString() == "True") { IsTitle1 = true; } else { IsTitle1 = false; } if (WS.Cells[indx, 20].Value.ToString() == "True") { IsTitle2 = true; } else { IsTitle2 = false; } if (WS.Cells[indx, 23].Value.ToString() == "True") { IsTitle3 = true; } else { IsTitle3 = false; } if (WS.Cells[indx, 26].Value.ToString() == "True") { IsTitle4 = true; } else { IsTitle4 = false; } if (WS.Cells[indx, 29].Value.ToString() == "True") { IsTitle5 = true; } else { IsTitle5 = false; } if (WS.Cells[indx, 32].Value.ToString() == "True") { IsTitle6 = true; } else { IsTitle6 = false; } if (WS.Cells[indx, 18].Value.ToString() == "True") { IsDesc1 = true; } else { IsDesc1 = false; } if (WS.Cells[indx, 21].Value.ToString() == "True") { IsDesc2 = true; } else { IsDesc2 = false; } if (WS.Cells[indx, 24].Value.ToString() == "True") { IsDesc3 = true; } else { IsDesc3 = false; } if (WS.Cells[indx, 27].Value.ToString() == "True") { IsDesc4 = true; } else { IsDesc4 = false; } if (WS.Cells[indx, 30].Value.ToString() == "True") { IsDesc5 = true; } else { IsDesc5 = false; } if (WS.Cells[indx, 33].Value.ToString() == "True") { IsDesc6 = true; } else { IsDesc6 = false; } moDrwLog.Title1IsTitle = IsTitle1; moDrwLog.Title2IsTitle = IsTitle2; moDrwLog.Title3IsTitle = IsTitle3; moDrwLog.Title4IsTitle = IsTitle4; moDrwLog.Title5IsTitle = IsTitle5; moDrwLog.Title6IsTitle = IsTitle6; moDrwLog.Title1IsDesc = IsDesc1; moDrwLog.Title2IsDesc = IsDesc2; moDrwLog.Title3IsDesc = IsDesc3; moDrwLog.Title4IsDesc = IsDesc4; moDrwLog.Title5IsDesc = IsDesc5; moDrwLog.Title6IsDesc = IsDesc6; moDrwLog.Revision = WS.Cells[indx, 34].Text; moDrwLog.ReleasedDrawingID = Convert.ToInt32(WS.Cells[indx, 35].Value); //if (dtpDateRevised.Checked == false) moDrwLog.DateRevised = RSLib.COUtility.DEFAULTDATE; //else //moDrwLog.DateRevised = dtpDateRevised.Value; // if (dtpDateDue.Checked == false) moDrwLog.DateDue = RSLib.COUtility.DEFAULTDATE; //else // moDrwLog.DateDue = dtpDateDue.Value; //if (dtpDateLate.Checked == false) moDrwLog.DateLate = RSLib.COUtility.DEFAULTDATE; // else // moDrwLog.DateLate = dtpDateLate.Value; return(moDrwLog.ID); }