private void button3_Click(object sender, RibbonControlEventArgs e)
{
try
{
Excel.Application app = Globals.ThisAddIn.Application;
Excel.Workbook wkbook = app.ActiveWorkbook;
Excel.Worksheet wksheet = wkbook.ActiveSheet;
string jobnumber = wksheet.Cells[1, "A"].Value;
var wip = new adoEntities();
Kickoff ko = wip.Kickoffs.Find(jobnumber);
ActualsRep act = wip.ActualsReps.Find(jobnumber);
//RecordDataView recorddataview = db.RecordDataView.SingleOrDefault(m => m.Record_number == id);
JobMetric jo = wip.JobMetrics.FirstOrDefault(m => m.BaseID == jobnumber);
// JobMetric jo = wip.JobMetrics.Find(jobnumber);
//Quoted Hours
wksheet.Cells[16, "B"].Value = ko.DesignEst;
wksheet.Cells[17, "B"].Value = ko.PlanningEst;
wksheet.Cells[18, "B"].Value = ko.WaterjetEst;
wksheet.Cells[19, "B"].Value = ko.WeldEst;
wksheet.Cells[20, "B"].Value = ko.NCEst;
wksheet.Cells[21, "B"].Value = ko.ConventionalEst;
wksheet.Cells[22, "B"].Value = ko.AssemblyEst;
wksheet.Cells[23, "B"].Value = ko.InspectionEst;
//Adjusted Hours
wksheet.Cells[16, "E"].Value = ko.Design;
wksheet.Cells[17, "E"].Value = ko.Planning;
wksheet.Cells[18, "E"].Value = ko.Waterjet;
wksheet.Cells[19, "E"].Value = ko.Weld;
wksheet.Cells[20, "E"].Value = ko.NC;
wksheet.Cells[21, "E"].Value = ko.Convetional;
wksheet.Cells[22, "E"].Value = ko.Assy;
wksheet.Cells[23, "E"].Value = ko.Inspection;
//Actual Hours
MessageBox.Show("Time for the Actuals");
try
{
wksheet.Cells[16, "H"].Value = act.Design;
wksheet.Cells[17, "H"].Value = act.Planning;
wksheet.Cells[18, "H"].Value = act.Waterjet;
wksheet.Cells[19, "H"].Value = act.Weld;
wksheet.Cells[20, "H"].Value = act.Nc;
wksheet.Cells[21, "H"].Value = act.Machining;
wksheet.Cells[22, "H"].Value = act.Assy;
wksheet.Cells[23, "H"].Value = act.Inspection;
wksheet.Cells[16, "I"].Value = act.DesignCost;
wksheet.Cells[17, "I"].Value = act.PlanningCost;
wksheet.Cells[18, "I"].Value = act.WaterJetCost;
wksheet.Cells[19, "I"].Value = act.WeldCost;
wksheet.Cells[20, "I"].Value = act.NcCost;
wksheet.Cells[21, "I"].Value = act.MachiningCost;
wksheet.Cells[22, "I"].Value = act.AssyCost;
wksheet.Cells[23, "I"].Value = act.InspectionCost;
}
catch (Exception ef)
{
MessageBox.Show(ef.ToString());
}
//Margin
wksheet.Cells[8, "I"].Value = jo.Margin;
wksheet.Cells[9, "I"].Value = jo.Actual;
wksheet.Cells[1, "F"].Value = jo.POValue;
wksheet.Cells[2, "F"].Value = jo.ContractDate;
wksheet.Cells[1, "I"].Value = "FUCKIFIKNOW";
wksheet.Cells[2, "I"].Value = jo.ShipDate;
}
catch (Exception ef)
{
MessageBox.Show(ef.Message.ToString());
}
//Convert.ToInt32(wksheet.Cells[20, "BV"].Value);
}
private void button4_Click(object sender, RibbonControlEventArgs e)
{
Excel.Application app = Globals.ThisAddIn.Application;
Excel.Workbook wkbook = app.ActiveWorkbook;
Excel.Worksheet wksheet = wkbook.ActiveSheet;
string item = wksheet.Name.ToString();
string lot = item.Substring(item.Length - 1);
int iPlanning = 0;
int iDesign = 0;
int iWaterjet = 0;
int iWeld = 0;
int iNC = 0;
int iConventional = 0;
int iOutsource = 0;
int iAssembly = 0;
int iInspection = 0;
int iShipping = 0;
int iPlanningEst = 0;
int iDesignEst = 0;
int iWaterjetEst = 0;
int iWeldEst = 0;
int iNCEst = 0;
int iConventionalEst = 0;
int iOutsourceEst = 0;
int iAssemblyEst = 0;
int iInspectionEst = 0;
int iShippingEst = 0;
int z = 8;
string jobnumber = wksheet.Cells[5, "BV"].Value;
iPlanning += Convert.ToInt32(wksheet.Cells[7, "BV"].Value);
iPlanningEst += Convert.ToInt32(wksheet.Cells[7, "BI"].Value);
iDesign += Convert.ToInt32(wksheet.Cells[12, "BV"].Value);
iDesignEst += Convert.ToInt32(wksheet.Cells[12, "BI"].Value);
iWaterjet += Convert.ToInt32(wksheet.Cells[16, "BV"].Value);
iWaterjetEst += Convert.ToInt32(wksheet.Cells[16, "BI"].Value);
iWeld += Convert.ToInt32(wksheet.Cells[20, "BV"].Value);
iWeldEst += Convert.ToInt32(wksheet.Cells[20, "BI"].Value);
iNC += Convert.ToInt32(wksheet.Cells[28, "BV"].Value);
iNCEst += Convert.ToInt32(wksheet.Cells[28, "BI"].Value);
iConventional += Convert.ToInt32(wksheet.Cells[36, "BV"].Value);
iConventionalEst += Convert.ToInt32(wksheet.Cells[36, "BI"].Value);
iOutsource += Convert.ToInt32(wksheet.Cells[40, "BW"].Value);
iOutsourceEst += Convert.ToInt32(wksheet.Cells[40, "BJ"].Value);
iAssembly += Convert.ToInt32(wksheet.Cells[53, "BV"].Value);
iAssemblyEst += Convert.ToInt32(wksheet.Cells[53, "BI"].Value);
iInspection += Convert.ToInt32(wksheet.Cells[60, "BV"].Value);
iInspectionEst += Convert.ToInt32(wksheet.Cells[60, "BI"].Value);
iShipping += Convert.ToInt32(wksheet.Cells[67, "BV"].Value);
iShippingEst += Convert.ToInt32(wksheet.Cells[67, "BI"].Value);
var wip = new adoEntities();
Kickoff ko = new Kickoff();
ko.Assy = iAssembly;
ko.AssemblyEst = iAssemblyEst;
ko.BaseID = jobnumber;
ko.Convetional = iConventional;
ko.ConventionalEst = iConventionalEst;
ko.Shipping = iShipping;
ko.ShippingEst = iShippingEst;
ko.Planning = iPlanning;
ko.PlanningEst = iPlanningEst;
ko.Design = iDesign;
ko.DesignEst = iDesignEst;
ko.Waterjet = iWaterjet;
ko.WaterjetEst = iWaterjetEst;
ko.Weld = iWeld;
ko.WeldEst = iWeldEst;
ko.NC = iNC;
ko.NCEst = iNCEst;
ko.Outsource = iOutsource;
ko.OutsourceEst = iOutsourceEst;
ko.Inspection = iInspection;
ko.InspectionEst = iInspectionEst;
ko.Design = iDesign;
ko.DesignEst = iDesignEst;
try
{
wip.Kickoffs.Add(ko);
}
catch (Exception x)
{
MessageBox.Show(x.Message);
}
try
{
wip.SaveChanges();
}
catch (Exception xx)
{
MessageBox.Show(xx.Message);
}
finally
{
MessageBox.Show("SUCCESS!!! F**K YEA");
}
}