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