///// <summary>
///// Get WorkOrder No
///// </summary>
///// <param name="machineId"></param>
///// <returns></returns>
//public CommonResponse GetWorkOrderNo(int machineId)
//{
// CommonResponse obj = new CommonResponse();
// CommonFunction commonFunction = new CommonFunction();
// string shift = commonFunction.GetCurrentShift();
// try
// {
// var check = db.Tblmachinedetails.Where(m => m.MachineId == machineId).Select(m => m.MachineName).FirstOrDefault();
// var shiftId = db.TblshiftMstr.Where(m => m.ShiftName == shift).Select(m => m.ShiftId).FirstOrDefault();
// var dbCheck = (from wf in db.TblPlanLinkageMaster
// where wf.ResourceId == check && wf.ShiftId == shiftId
// select new
// {
// ProductionOrder = wf.ProductionOrder,
// PlanLinkageId = wf.PlanLinkageId
// }).ToList();
// if (dbCheck.Count > 0)
// {
// obj.isStatus = true;
// obj.response = dbCheck;
// }
// else
// {
// obj.isStatus = false;
// obj.response = "No Items Found";
// }
// }
// catch (Exception ex)
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.FailureMessage;
// }
// return obj;
//}
///// <summary>
///// View Multiple Part No
///// </summary>
///// <param name="ProductionOrder"></param>
///// <returns></returns>
//public CommonResponse ViewMultiplePartNo(string ProductionOrder, int PlanLinkageId)
//{
// CommonResponse obj = new CommonResponse();
// try
// {
// var check = (from wf in db.TblPlanLinkageMaster
// where wf.IsDeleted == 0 && wf.ProductionOrder == ProductionOrder && wf.PlanLinkageId == PlanLinkageId
// select new
// {
// FgPartNo = wf.FgPartNo,
// PlanLinkageId = wf.PlanLinkageId
// }).ToList();
// if (check.Count > 0)
// {
// obj.isStatus = true;
// obj.response = check;
// }
// else
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.NoItemsFound;
// }
// }
// catch (Exception e)
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.FailureMessage;
// }
// return obj;
//}
///// <summary>
///// Get Operation No
///// </summary>
///// <param name="FgPartNo"></param>
///// <returns></returns>
//public CommonResponse GetOperationNo(string FgPartNo, int PlanLinkageId)
//{
// CommonResponse obj = new CommonResponse();
// try
// {
// var check = (from wf in db.TblPlanLinkageMaster
// where wf.IsDeleted == 0 && wf.FgPartNo == FgPartNo && wf.PlanLinkageId == PlanLinkageId
// select new
// {
// OperationNo = wf.Operation,
// RoutingId = wf.RoutingId,
// PlanLinkageId = wf.PlanLinkageId
// }).ToList();
// if (check.Count > 0)
// {
// obj.isStatus = true;
// obj.response = check;
// }
// else
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.NoItemsFound;
// }
// }
// catch (Exception e)
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.FailureMessage;
// }
// return obj;
//}
///// <summary>
///// Get WorkOrder Qty
///// </summary>
///// <param name="operationNo"></param>
///// <returns></returns>
//public CommonResponse GetWorkOrderQty(int operationNo, int PlanLinkageId)
//{
// CommonResponse obj = new CommonResponse();
// try
// {
// var check = (from wf in db.TblPlanLinkageMaster
// where wf.IsDeleted == 0 && wf.Operation == operationNo && wf.PlanLinkageId == PlanLinkageId
// select new
// {
// WorkOrderQty = wf.WorkOrderQty,
// PlanLinkageId = wf.PlanLinkageId
// }).ToList();
// if (check.Count > 0)
// {
// obj.isStatus = true;
// obj.response = check;
// }
// else
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.NoItemsFound;
// }
// }
// catch (Exception e)
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.FailureMessage;
// }
// return obj;
//}
///// <summary>
///// View Multiple Part No
///// </summary>
///// <param name="opearationNo"></param>
///// <returns></returns>
//public CommonResponse ViewMultiplePartNo(int opearationNo,int machineId)
//{
// CommonResponse obj = new CommonResponse();
// try
// {
// var machineName = db.Tblmachinedetails.Where(m => m.MachineId == machineId).Select(m => m.MachineName).FirstOrDefault();
// var check = (from wf in db.Tblparts
// where wf.IsDeleted == 0 && wf.OperationNo == Convert.ToString(opearationNo) && wf.ResourceId == machineName
// select new
// {
// PartId = wf.PartId,
// PartNo = wf.Fgcode
// }).ToList();
// if (check.Count > 0)
// {
// obj.isStatus = true;
// obj.response = check;
// }
// else
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.NoItemsFound;
// }
// }
// catch (Exception e)
// {
// obj.isStatus = false;
// obj.response = ResourceResponse.FailureMessage;
// }
// return obj;
//}
/// <summary>
/// Add Update Fg Part No
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public GeneralResponse AddUpdateFgPartNo(AddUpdateFgPartNo data)
{
GeneralResponse obj = new GeneralResponse();
CommonFunction commonFunction = new CommonFunction();
try
{
string shift = commonFunction.GetCurrentShift();
string correctedDate = commonFunction.GetCorrectedDate();
var loginTrackerDetails = commonFunction.GetLoginTrackerDetailsLastRow(correctedDate, data.machineId);
var machineName = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == data.machineId && m.IsDeleted == 0).Select(m => m.MachineName).FirstOrDefault();
if (loginTrackerDetails != null)
{
#region Add and Update FGPart
var check = db.UnitworkccsTblfgpartnodet.Where(m => m.FgPartId == data.fgPartId).FirstOrDefault();
if (check == null)
{
UnitworkccsTblfgpartnodet tblFgPartNoDet = new UnitworkccsTblfgpartnodet();
tblFgPartNoDet.OperationNo = data.operationNo;
tblFgPartNoDet.NoOfPartsPerCycle = data.noOfPartsPerCycle;
tblFgPartNoDet.PartCountMethod = data.partsCountMethod;
tblFgPartNoDet.WorkOrderNo = data.workOrderNo;
tblFgPartNoDet.IsDeleted = 0;
tblFgPartNoDet.CreatedOn = DateTime.Now;
tblFgPartNoDet.MachineId = data.machineId;
tblFgPartNoDet.OperatorId = data.operatorId;
tblFgPartNoDet.MachineId = data.machineId;
tblFgPartNoDet.CorrectedDate = correctedDate;
tblFgPartNoDet.StartDate = DateTime.Now;
tblFgPartNoDet.Shift = shift;
tblFgPartNoDet.TargetQty = 0;
tblFgPartNoDet.ActaulValue = 0;
tblFgPartNoDet.PlanLinkageId = data.planLinkageId;
var planVisageData = (from wf in db.UnitworkccsTblplanlinkagemaster
where wf.PlanLinkageId == data.planLinkageId
select new
{
idealCycleTime = wf.IdealCycleTime,
fgPartNo = wf.FgPartNo,
plannedStartTime = wf.PlannedStartTime,
plannedEndTime = wf.PlannedEndTime,
unit = wf.Unit,
scheduledQty = wf.ScheduledQty,
partName = wf.PartName,
routingId = wf.RoutingId,
workOrderCompletedQty = wf.WorkOrderCompletedQty
}).FirstOrDefault();
if (planVisageData != null)
{
tblFgPartNoDet.FgPartNo = planVisageData.fgPartNo;
tblFgPartNoDet.IdealCycleTime = planVisageData.idealCycleTime;
tblFgPartNoDet.Unit = planVisageData.unit;
tblFgPartNoDet.Unit = planVisageData.unit;
tblFgPartNoDet.PlannedStartTime = planVisageData.plannedStartTime;
tblFgPartNoDet.PlannedEndTime = planVisageData.plannedEndTime;
tblFgPartNoDet.PartName = planVisageData.partName;
tblFgPartNoDet.ScheduledQty = planVisageData.scheduledQty;
tblFgPartNoDet.RoutingId = planVisageData.routingId;
tblFgPartNoDet.WorkOrderCompletedQty = planVisageData.workOrderCompletedQty;
}
db.UnitworkccsTblfgpartnodet.Add(tblFgPartNoDet);
db.SaveChanges();
obj.fgPartId = tblFgPartNoDet.FgPartId;
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
obj.partNo = db.UnitworkccsTblplanlinkagemaster.Where(m => m.PlanLinkageId == tblFgPartNoDet.PlanLinkageId).Select(m => m.FgPartNo).FirstOrDefault();
}
else
{
//var fgPartNo = db.TblPlanLinkageMaster.Where(m => m.PlanLinkageId == data.partId).Select(m => m.FgPartNo).FirstOrDefault();
//var partId = db.Tblparts.Where(m => m.Fgcode == fgPartNo && m.ResourceId == machineName).Select(m => m.PartId).FirstOrDefault();
//if (partId > 0)
//{
// check.PartId = partId;
//}
//check.PartId = data.partId;
check.OperationNo = data.operationNo;
check.NoOfPartsPerCycle = data.noOfPartsPerCycle;
check.PartCountMethod = data.partsCountMethod;
check.WorkOrderNo = data.workOrderNo;
check.IsDeleted = 0;
check.ModifiedOn = DateTime.Now;
check.OperatorId = data.operatorId;
check.MachineId = data.machineId;
check.CorrectedDate = correctedDate;
check.PlanLinkageId = data.planLinkageId;
check.Shift = shift;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
obj.fgPartId = check.FgPartId;
obj.partNo = db.UnitworkccsTblplanlinkagemaster.Where(m => m.PlanLinkageId == check.PlanLinkageId).Select(m => m.FgPartNo).FirstOrDefault();
}
#endregion
#region Update last row of logged in user details
loginTrackerDetails.CurrentFgpart = obj.fgPartId;
db.UnitworkccsLogintrackerdetails.Update(loginTrackerDetails);
db.SaveChanges();
#endregion
}
else
{
obj.isStatus = false;
obj.response = ResourceResponse.LoginAgain;
}
}
catch (Exception e)
{
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
commonFunction.LogFile(obj.response);
return(obj);
}
public async Task <IActionResult> AddUpdateFgPartNo(AddUpdateFgPartNo data)
{
GeneralResponse response = fgPartNo.AddUpdateFgPartNo(data);
return(Ok(response));
}
