public AddEfficiencyReportViewModel(EfficiencyReport efficiency)
{
this.SelectedCar = this.SnapGasDb.Cars.Where(c => c.IsSelected == true).FirstOrDefault();
this.SelectedFuelingInstance = this.SnapGasDb.FuelingInstances.Where(f => f.IsSelected == true).FirstOrDefault();
this.EfficiencyReport = efficiency;
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
conn.Open();
objefficiency = new EfficiencyReport();
try
{
objefficiency.Partno = DropPartNo.SelectedValue.ToString();
objefficiency.Operation = DropOperation.SelectedValue.ToString();
objefficiency.EffDate = Convert.ToDateTime(TxtDateTime.Text.ToString());
objefficiency.Shift = DropShift.SelectedItem.Text.ToString();
//objefficiency.FromTo = TxtFromTo.Text.ToString();
objefficiency.FromTo = ddl_fromtime.Value.ToString() + " " + ddl_fromampm.Value.ToString() + " To " + ddl_totime.Value.ToString() + " " + ddl_toampm.Value.ToString();
objefficiency.OperatorName = TxtOperatorName.Text.ToString();
objefficiency.MinorStart = txt_speedstart.Value.ToString();
objefficiency.MinorEnd = txt_speedend.Value.ToString();
string mtotal = TxtMinorBreakdown.Text.ToString();
if (mtotal == "" || mtotal == null)
{
objefficiency.MinorTotal = Convert.ToDecimal(0.00);
}
else
{
mtotal = mtotal.Replace(":", ".");
objefficiency.MinorTotal = Convert.ToDecimal(mtotal);
}
objefficiency.BottleNectStart = txt_botstart.Value.ToString();
objefficiency.BottleNectEnd = txt_botend.Value.ToString();
string btotal = TxtbottleNeckTime.Text.ToString();
if (btotal == "" || btotal == null)
{
objefficiency.BottleNectTotal = Convert.ToDecimal(0.00);
}
else
{
btotal = btotal.Replace(":", ".");
objefficiency.BottleNectTotal = Convert.ToDecimal(btotal.ToString());
}
if (TXTPreventive.Text.ToString() == "")
{
objefficiency.Mainteance = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Mainteance = Convert.ToDecimal(TXTPreventive.Text.ToString());
}
if (Txtbreak.Text.ToString() == "")
{
objefficiency.LenchTea = Convert.ToDecimal(0.00);
}
else
{
objefficiency.LenchTea = Convert.ToDecimal(Txtbreak.Text.ToString());
}
if (TxtPlan.Text.ToString() == "")
{
objefficiency.NoPlan = Convert.ToDecimal(0.00);
}
else
{
objefficiency.NoPlan = Convert.ToDecimal(TxtPlan.Text.ToString());
}
if (TxtPlannedEngg.Text.ToString() == "")
{
objefficiency.Manufacturing = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Manufacturing = Convert.ToDecimal(TxtPlannedEngg.Text.ToString());
}
if (TxtMeetings.Text.ToString() == "")
{
objefficiency.Meeting = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Meeting = Convert.ToDecimal(TxtMeetings.Text.ToString());
}
if (txt_shift.Text.ToString() == "")
{
objefficiency.ShiftTime = "";
}
else
{
objefficiency.ShiftTime = txt_shift.Text.ToString();
}
if (txt_setup.Text.ToString() == "")
{
objefficiency.Setup = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Setup = Convert.ToDecimal(txt_setup.Text.ToString());
}
if (TxtProductionQty.Text.ToString() == "")
{
objefficiency.ProdQty = Convert.ToDecimal(0.00);
}
else
{
objefficiency.ProdQty = Convert.ToDecimal(TxtProductionQty.Text.ToString());
}
if (TxtRejection.Text.ToString() == "")
{
objefficiency.Rejection = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Rejection = Convert.ToDecimal(TxtRejection.Text.ToString());
}
if (TxtCMMInspection.Text.ToString() == "")
{
objefficiency.CMM = Convert.ToDecimal(0.00);
}
else
{
objefficiency.CMM = Convert.ToDecimal(TxtCMMInspection.Text.ToString());
}
objefficiency.EqupStart = txt_eqstarttime.Value.ToString();
objefficiency.EqupEnd = txt_eqendtime.Value.ToString();
string teq = TxtEquipment.Text.ToString();
if (teq == "" || teq == null)
{
objefficiency.EqupTotal = Convert.ToDecimal(0.00);
}
else
{
teq = teq.Replace(":", ".");
objefficiency.EqupTotal = Convert.ToDecimal(teq);
}
objefficiency.UnplannedStart = txt_unstart.Value.ToString();
objefficiency.UnplannedEnd = txt_unend.Value.ToString();
string tunplanned = TxtUnplanned.Text.ToString();
if (tunplanned == "" || tunplanned == null)
{
objefficiency.UnplannedTotal = Convert.ToDecimal(0.00);
}
else
{
tunplanned = tunplanned.Replace(":", ".");
objefficiency.UnplannedTotal = Convert.ToDecimal(tunplanned);
}
objefficiency.SetupStart = txt_setstart.Value.ToString();
objefficiency.SetupEnd = txt_setend.Value.ToString();
string tsetup = TxtChangeOver.Text.ToString();
if (tsetup == "" || tsetup == null)
{
objefficiency.SetupTotal = Convert.ToDecimal(0.00);
}
else
{
tsetup = tsetup.Replace(":", ".");
objefficiency.SetupTotal = Convert.ToDecimal(tsetup);
}
objefficiency.StoragStart = txt_matstart.Value.ToString();
objefficiency.StoragEnd = txt_matend.Value.ToString();
string tstorage = TxtDelay.Text.ToString();
if (tstorage == "" || tstorage == null)
{
objefficiency.StoragTotal = Convert.ToDecimal(0.00);
}
else
{
tstorage = tstorage.Replace(":", ".");
objefficiency.StoragTotal = Convert.ToDecimal(tstorage);
}
objefficiency.MaterialStart = txt_matstart.Value.ToString();
objefficiency.MaterialEnd = txt_matend.Value.ToString();
string tmaterial = TxtDelay.Text.ToString();
if (tmaterial == "" || tmaterial == null)
{
objefficiency.MaterialTotal = Convert.ToDecimal(0.00);
}
else
{
tmaterial = tmaterial.Replace(":", ".");
objefficiency.MaterialTotal = Convert.ToDecimal(tmaterial);
}
objefficiency.StoragStart = txt_opstart.Value.ToString();
objefficiency.StoragEnd = txt_opend.Value.ToString();
string tstorage1 = TxtOpStortages.Text.ToString();
if (tstorage1 == "" || tstorage1 == null)
{
objefficiency.StoragTotal = Convert.ToDecimal(0.00);
}
else
{
tstorage1 = tstorage1.Replace(":", ".");
objefficiency.StoragTotal = Convert.ToDecimal(tstorage1);
}
objefficiency.NTplannedStart = txt_ntstart.Value.ToString();
objefficiency.NTplannedEnd = txt_ntend.Value.ToString();
string ntotal = TxtNotPlanned.Text.ToString();
if (ntotal == "" || ntotal == null)
{
objefficiency.NTplannedTotal = Convert.ToDecimal(0.00);
}
else
{
ntotal = ntotal.Replace(":", ".");
objefficiency.NTplannedTotal = Convert.ToDecimal(ntotal);
}
objefficiency.QualityStart = txt_qstart.Value.ToString();
objefficiency.QualityEnd = txt_qend.Value.ToString();
string qtot = TxtQtyIssues.Text.ToString();
if (qtot == "" || qtot == null)
{
objefficiency.QualityTotal = Convert.ToDecimal(0.00);
}
else
{
qtot = qtot.Replace(":", ".");
objefficiency.QualityTotal = Convert.ToDecimal(qtot);
}
if (TxtUtilTime.Text.ToString() == "")
{
objefficiency.UtileTime = Convert.ToDecimal(0.00);
}
else
{
objefficiency.UtileTime = Convert.ToDecimal(TxtUtilTime.Text.ToString());
}
if (TextTt.Text.ToString() == "" || TextTt.Text == null)
{
objefficiency.TT = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TT = Convert.ToDecimal(TextTt.Text.ToString());
}
if (TxtPlandClosing.Text == null || TxtPlandClosing.Text.ToString() == "")
{
objefficiency.Plantclosing = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Plantclosing = Convert.ToDecimal(TxtPlandClosing.Text.ToString());
}
if (TxtOpenedTime.Text == null || TxtOpenedTime.Text.ToString() == "")
{
objefficiency.ToOpend = Convert.ToDecimal(0.00);
}
else
{
objefficiency.ToOpend = Convert.ToDecimal(TxtOpenedTime.Text.ToString());
}
if (TxtPlannedStops.Text == null || TxtPlannedStops.Text.ToString() == "")
{
objefficiency.PlannedStop = Convert.ToDecimal(0.00);
}
else
{
objefficiency.PlannedStop = Convert.ToDecimal(TxtPlannedStops.Text.ToString());
}
if (TxtReqtime.Text == null || TxtReqtime.Text.ToString() == "")
{
objefficiency.TrRequired = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TrRequired = Convert.ToDecimal(TxtReqtime.Text.ToString());
}
if (TxtDownTimeLoss.Text == null || TxtDownTimeLoss.Text.ToString() == "")
{
objefficiency.DownTimeLoss = Convert.ToDecimal(0.00);
}
else
{
objefficiency.DownTimeLoss = Convert.ToDecimal(TxtDownTimeLoss.Text.ToString());
}
if (TxtFunctionTime.Text == null || TxtFunctionTime.Text.ToString() == "")
{
objefficiency.TfFunction = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TfFunction = Convert.ToDecimal(TxtFunctionTime.Text.ToString());
}
if (TxtSpeedLoss.Text == null || TxtSpeedLoss.Text.ToString() == "")
{
objefficiency.TTtime = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TTtime = Convert.ToDecimal(TxtSpeedLoss.Text.ToString());
}
if (TxtNetOpTime.Text == null || TxtNetOpTime.Text.ToString() == "")
{
objefficiency.EntOperating = Convert.ToDecimal(0.00);
}
else
{
objefficiency.EntOperating = Convert.ToDecimal(TxtNetOpTime.Text.ToString());
}
if (TxtQualityloss.Text == null || TxtQualityloss.Text.ToString() == "")
{
objefficiency.Qloss = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Qloss = Convert.ToDecimal(TxtQualityloss.Text.ToString());
}
if (TxtUtileTime.Text == null || TxtUtileTime.Text.ToString() == "")
{
objefficiency.TuUtile = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TuUtile = Convert.ToDecimal(TxtUtileTime.Text.ToString());
}
if (TxtTRS.Text == null || TxtTRS.Text.ToString() == "")
{
objefficiency.TRS = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TRS = Convert.ToDecimal(TxtTRS.Text.ToString());
}
if (TxtTRG.Text == null || TxtTRG.Text.ToString() == "")
{
objefficiency.TRG = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TRG = Convert.ToDecimal(TxtTRG.Text.ToString());
}
if (TxtTotalStop.Text == null || TxtTotalStop.Text.ToString() == "")
{
objefficiency.TotalStop = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TotalStop = Convert.ToDecimal(TxtTotalStop.Text.ToString());
}
if (TxtTotalStophours.Text == null || TxtTotalStophours.Text.ToString() == "")
{
objefficiency.UtilTimeStop = Convert.ToDecimal(0.00);
}
else
{
objefficiency.UtilTimeStop = Convert.ToDecimal(TxtTotalStophours.Text.ToString());
}
objefficiency.MachineName = txt_machinename.Value.ToString();
objefficiency.PID = Session["PID_ID"].ToString();
objQualitySheetdclassDataContext.EfficiencyReports.InsertOnSubmit(objefficiency);
objQualitySheetdclassDataContext.SubmitChanges();
objQualitySheetdclassDataContext = null;
ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "alert('Data Saved Successfuly !');", true);
ClearAll();
}
catch (Exception ex)
{
}
finally
{
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
conn.Open();
objefficiency = new EfficiencyReport();
try
{
objefficiency.Partno = ddl_partno.SelectedIndex.ToString();
objefficiency.Operation = ddl_operation.SelectedIndex.ToString();
objefficiency.EffDate = Convert.ToDateTime(txt_date.Value.ToString());
objefficiency.Shift = ddl_shift.SelectedIndex.ToString();
//objefficiency.FromTo = TxtFromTo.Text.ToString();
objefficiency.FromTo = ddl_fromtime.Value.ToString() + " " + ddl_fromampm.Value.ToString() + " To " + ddl_totime.Value.ToString() + " " + ddl_toampm.Value.ToString();
objefficiency.OperatorName = txt_operatorname.Value.ToString();
objefficiency.MinorStart = txt_speedstart.Value.ToString();
objefficiency.MinorEnd = txt_speedend.Value.ToString();
string mtotal = txt_totspeed.Text.ToString();
if (mtotal == "" || mtotal == null)
{
objefficiency.MinorTotal = Convert.ToDecimal(0.00);
}
else
{
mtotal = mtotal.Replace(":", ".");
objefficiency.MinorTotal = Convert.ToDecimal(mtotal);
}
if (txt_maintenance.Value.ToString() == "")
{
objefficiency.Mainteance = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Mainteance = Convert.ToDecimal(txt_maintenance.Value.ToString());
}
if (txt_lunch.Value.ToString() == "")
{
objefficiency.LenchTea = Convert.ToDecimal(0.00);
}
else
{
objefficiency.LenchTea = Convert.ToDecimal(txt_lunch.Value.ToString());
}
if (txt_noplan.Value.ToString() == "")
{
objefficiency.NoPlan = Convert.ToDecimal(0.00);
}
else
{
objefficiency.NoPlan = Convert.ToDecimal(txt_noplan.Value.ToString());
}
if (txt_manuf.Value.ToString() == "")
{
objefficiency.Manufacturing = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Manufacturing = Convert.ToDecimal(txt_manuf.Value.ToString());
}
if (txt_meeting.Value.ToString() == "")
{
objefficiency.Meeting = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Meeting = Convert.ToDecimal(txt_meeting.Value.ToString());
}
if (txt_shifttime.Value.ToString() == "")
{
objefficiency.ShiftTime = "";
}
else
{
objefficiency.ShiftTime = txt_shifttime.Value.ToString();
}
if (txt_fixed.Value.ToString() == "")
{
objefficiency.Setup = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Setup = Convert.ToDecimal(txt_fixed.Value.ToString());
}
if (txt_prodqty.Text.ToString() == "")
{
objefficiency.ProdQty = Convert.ToDecimal(0.00);
}
else
{
objefficiency.ProdQty = Convert.ToDecimal(txt_prodqty.Text.ToString());
}
if (txt_rejection.Value.ToString() == "")
{
objefficiency.Rejection = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Rejection = Convert.ToDecimal(txt_rejection.Value.ToString());
}
if (txt_cmm.Text.ToString() == "")
{
objefficiency.CMM = Convert.ToDecimal(0.00);
}
else
{
objefficiency.CMM = Convert.ToDecimal(txt_cmm.Text.ToString());
}
objefficiency.EqupStart = txt_startdown.Value.ToString();
objefficiency.EqupEnd = txt_downend.Value.ToString();
string teq = txt_totdowntime.Value.ToString();
if (teq == "" || teq == null)
{
objefficiency.EqupTotal = Convert.ToDecimal(0.00);
}
else
{
teq = teq.Replace(":", ".");
objefficiency.EqupTotal = Convert.ToDecimal(teq);
}
if (Text_Util.Value.ToString() == "")
{
objefficiency.UtileTime = Convert.ToDecimal(0.00);
}
else
{
objefficiency.UtileTime = Convert.ToDecimal(Text_Util.Value.ToString());
}
if (TextTt.Text.ToString() == "" || TextTt.Text == null)
{
objefficiency.TT = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TT = Convert.ToDecimal(TextTt.Text.ToString());
}
if (TxtPlandClosing.Text == null || TxtPlandClosing.Text.ToString() == "")
{
objefficiency.Plantclosing = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Plantclosing = Convert.ToDecimal(TxtPlandClosing.Text.ToString());
}
if (TxtOpenedTime.Text == null || TxtOpenedTime.Text.ToString() == "")
{
objefficiency.ToOpend = Convert.ToDecimal(0.00);
}
else
{
objefficiency.ToOpend = Convert.ToDecimal(TxtOpenedTime.Text.ToString());
}
if (TxtPlannedStops.Text == null || TxtPlannedStops.Text.ToString() == "")
{
objefficiency.PlannedStop = Convert.ToDecimal(0.00);
}
else
{
objefficiency.PlannedStop = Convert.ToDecimal(TxtPlannedStops.Text.ToString());
}
if (TxtReqtime.Text == null || TxtReqtime.Text.ToString() == "")
{
objefficiency.TrRequired = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TrRequired = Convert.ToDecimal(TxtReqtime.Text.ToString());
}
if (TxtDownTimeLoss.Text == null || TxtDownTimeLoss.Text.ToString() == "")
{
objefficiency.DownTimeLoss = Convert.ToDecimal(0.00);
}
else
{
objefficiency.DownTimeLoss = Convert.ToDecimal(TxtDownTimeLoss.Text.ToString());
}
if (TxtFunctionTime.Text == null || TxtFunctionTime.Text.ToString() == "")
{
objefficiency.TfFunction = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TfFunction = Convert.ToDecimal(TxtFunctionTime.Text.ToString());
}
if (TxtSpeedLoss.Text == null || TxtSpeedLoss.Text.ToString() == "")
{
objefficiency.TTtime = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TTtime = Convert.ToDecimal(TxtSpeedLoss.Text.ToString());
}
if (TxtNetOpTime.Text == null || TxtNetOpTime.Text.ToString() == "")
{
objefficiency.EntOperating = Convert.ToDecimal(0.00);
}
else
{
objefficiency.EntOperating = Convert.ToDecimal(TxtNetOpTime.Text.ToString());
}
if (TxtQualityloss.Text == null || TxtQualityloss.Text.ToString() == "")
{
objefficiency.Qloss = Convert.ToDecimal(0.00);
}
else
{
objefficiency.Qloss = Convert.ToDecimal(TxtQualityloss.Text.ToString());
}
if (TxtUtileTime.Text == null || TxtUtileTime.Text.ToString() == "")
{
objefficiency.TuUtile = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TuUtile = Convert.ToDecimal(TxtUtileTime.Text.ToString());
}
if (TxtTRS.Text == null || TxtTRS.Text.ToString() == "")
{
objefficiency.TRS = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TRS = Convert.ToDecimal(TxtTRS.Text.ToString());
}
if (TxtTRG.Text == null || TxtTRG.Text.ToString() == "")
{
objefficiency.TRG = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TRG = Convert.ToDecimal(TxtTRG.Text.ToString());
}
if (TxtTotalStop.Text == null || TxtTotalStop.Text.ToString() == "")
{
objefficiency.TotalStop = Convert.ToDecimal(0.00);
}
else
{
objefficiency.TotalStop = Convert.ToDecimal(TxtTotalStop.Text.ToString());
}
if (TxtTotalStophours.Text == null || TxtTotalStophours.Text.ToString() == "")
{
objefficiency.UtilTimeStop = Convert.ToDecimal(0.00);
}
else
{
objefficiency.UtilTimeStop = Convert.ToDecimal(TxtTotalStophours.Text.ToString());
}
objefficiency.MachineName = txt_machinename.Value.ToString();
objefficiency.PID = Session["PID_ID"].ToString();
objQualitySheetdclassDataContext.EfficiencyReports.InsertOnSubmit(objefficiency);
objQualitySheetdclassDataContext.SubmitChanges();
objQualitySheetdclassDataContext = null;
ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "alert('Data Saved Successfuly !');", true);
//ClearAll();
}
catch (Exception ex)
{
}
finally
{
}
}
