//Inserting Cutting Time Analysis Data
private void InsertCTA(int MachineID, string CorrectedDate, CTAModel ctadet)
{
var CTADet = db.tbl_CycleTimeAnalysis.Where(m => m.CorrectedDate == CorrectedDate && m.MachineID == MachineID && m.IsDeleted == 0).FirstOrDefault();
string Unit = "MINUTES";
if (CTADet == null)
{
tbl_CycleTimeAnalysis ctarow = new tbl_CycleTimeAnalysis();
ctarow.MachineID = MachineID;
ctarow.CorrectedDate = CorrectedDate;
ctarow.Std_CycleTime = ctadet.Std_CycleTime;
ctarow.Std_CycleTimeUnit = Unit;
ctarow.PartsCount = ctadet.PartsCount;
ctarow.Std_LoadTime = ctadet.Std_LoadTime;
ctarow.Std_LoadTimeUnit = Unit;
ctarow.TotalLoadTime = ctadet.TotalLoadTime;
ctarow.TotalLoadTimeUnit = Unit;
ctarow.LossTime = ctadet.LossTime;
ctarow.LossTimeUnit = Unit;
ctarow.IsDeleted = 0;
ctarow.CreatedOn = DateTime.Now;
ctarow.PartNum = ctadet.PartNum;
ctarow.OperatingTime = ctadet.OperatingTime;
ctarow.OperatingTimeUnit = Unit;
ctarow.AvgOperatingTime = ctadet.AvgOperatingTime;
ctarow.AvgOperatingTimeUnit = Unit;
ctarow.AvgLoadTimeinMinutes = ctadet.AvgLoadTimeinMinutes;
db.tbl_CycleTimeAnalysis.Add(ctarow);
db.SaveChanges();
}
}
public virtual ActionResult CallToAction(string uri, string imageUri)
{
CTAModel ctaModel;
if (!String.IsNullOrEmpty(uri) && !String.IsNullOrEmpty(imageUri))
{
ctaModel = new CTAModel(uri, imageUri);
}
else
{
ctaModel = new CTAModel("http://www.google.com", "https://www.google.ca/logos/doodles/2015/googles-new-logo-5078286822539264.2-hp.gif");
}
return(PartialView("CallToAction", ctaModel));
}
public void GETCYCLETIMEAnalysis(int machineID, string correctdate)
{
DateTime correctedDate = Convert.ToDateTime(correctdate);
decimal IdealCycleTimeVal = 0;
decimal LoadingTime = 0;
decimal Losses = 0;
decimal SCT = 0;
CTAModel objCTA = new CTAModel();
//Get Prerequisites of OEE Like OPT,IDLETIME,POWEROFF, POWERON
OEECalModel OEECal = OEEDetails(machineID, correctedDate);
decimal OperatingTime = OEECal.OperatingTime;
decimal LossTime = OEECal.LossTime;
decimal MinorLossTime = OEECal.MinorLossTime;
decimal MntTime = OEECal.MntTime;
decimal SetupTime = OEECal.SetupTime;
//decimal SetupMinorTime = 0;
decimal PowerOffTime = OEECal.PowerOffTime;
decimal PowerONTime = OEECal.PowerONTime;
int CuttingTime = 0;
int YeildQty = 0;
#region Commented
//var machinedet = db.tblmachinedetails.Where(m => m.IsDeleted == 0 && m.IsNormalWC == 0 && m.MachineID == machineID).FirstOrDefault();
//var GetModeDurations = db.tblmodes.Where(m => m.MachineID == machineID && m.CorrectedDate == correctedDate.Date && m.IsCompleted == 1 && m.ModeTypeEnd == 1).ToList();
//foreach (var ModeRow in GetModeDurations)
//{
// //GetCorrectedDate = ModeRow.CorrectedDate;
// if (ModeRow.ModeType == "PROD")
// {
// OperatingTime += (decimal)(ModeRow.DurationInSec / 60.00);
// }
// else if (ModeRow.ModeType == "IDLE" && ModeRow.DurationInSec > 600)
// {
// LossTime += (decimal)(ModeRow.DurationInSec / 60.00);
// decimal LossDuration = (decimal)(ModeRow.DurationInSec / 60.00);
// //if (ModeRow.LossCodeID != null)
// // insertProdlosses(ProdRow.HMIID, (int)ModeRow.LossCodeID, LossDuration, CorrectedDate, MachineID);
// }
// else if (ModeRow.ModeType == "IDLE" && ModeRow.DurationInSec < 600)
// {
// MinorLossTime += (decimal)(ModeRow.DurationInSec / 60.00);
// }
// else if (ModeRow.ModeType == "MNT")
// {
// MntTime += (decimal)(ModeRow.DurationInSec / 60.00);
// }
// else if (ModeRow.ModeType == "POWEROFF")
// {
// PowerOffTime += (decimal)(ModeRow.DurationInSec / 60.00);
// }
// else if (ModeRow.ModeType == "SETUP")
// {
// try
// {
// SetupTime += (decimal)Convert.ToDateTime(ModeRow.LossCodeEnteredTime).Subtract(Convert.ToDateTime(ModeRow.StartTime)).TotalMinutes;
// //SetupMinorTime += (decimal)(db.tblSetupMaints.Where(m => m.ModeId == ModeRow.ModeId).Select(m => m.MinorLossTime).First() / 60.00);
// }
// catch { }
// }
// else if (ModeRow.ModeType == "POWERON")
// {
// PowerONTime += (decimal)(ModeRow.DurationInSec / 60.00);
// }
//}
#endregion
int TotlaQty = GetQuantiy(machineID, out YeildQty, correctedDate.ToString("yyyy-MM-dd"), out CuttingTime);
var partsdet = db.tblparts.Where(m => m.MachineID == machineID).FirstOrDefault();
if (partsdet != null)
{
objCTA.PartNum = partsdet.FGCode;
IdealCycleTimeVal = Math.Round((partsdet.IdealCycleTime / 60), 2);
int qty = Convert.ToInt32(partsdet.PartsPerCycle);
TotlaQty = TotlaQty * qty;
decimal loadtime = Math.Round((decimal)(partsdet.Std_Load_UnloadTime / 60), 2);
objCTA.Std_LoadTime = loadtime;
LoadingTime = loadtime * TotlaQty;
objCTA.CuttingTime = CuttingTime;
}
OperatingTime = Math.Round(OperatingTime, 2);
objCTA.OperatingTime = OperatingTime;
objCTA.MachineID = machineID;
objCTA.PartsCount = TotlaQty;
objCTA.Std_CycleTime = IdealCycleTimeVal;
objCTA.TotalLoadTime = LoadingTime;
if (TotlaQty == 0)
{
TotlaQty = 1;
}
objCTA.AvgOperatingTime = (OperatingTime / TotlaQty);
objCTA.AvgLoadTimeinMinutes = (LoadingTime / TotlaQty);
objCTA.AvgCuttingTime = (CuttingTime / TotlaQty);
decimal IdleTime = LossTime + MinorLossTime;
Losses = IdleTime - LoadingTime;
objCTA.LossTime = Math.Round(Losses, 2);
InsertCTA(machineID, correctdate, objCTA);
}
