/// <summary> /// Add Rejection Details /// </summary> /// <param name="data"></param> /// <returns></returns> public CommonResponse AddRejectionDetails(AddRejection data) { CommonResponse obj = new CommonResponse(); try { CommonFunction commonFunction = new CommonFunction(); string shift = commonFunction.GetCurrentShift(); addedResopnse addresopnce = new addedResopnse(); string correctedDate = commonFunction.GetCorrectedDate(); if (data.dmcCodeStatus == "Enable") { if (data.actual > 1) { var check = db.UnitworkccsTblrejectiondetails.Where(m => m.QrCodeNo == data.qrCodeNo).FirstOrDefault(); if (check == null) { var dbCheck = db.UnitworkccsTblreworkdetails.Where(m => m.QrCodeNo == data.qrCodeNo).FirstOrDefault(); if (dbCheck == null) { UnitworkccsTblrejectiondetails UnitworkccsTblrejectiondetails = new UnitworkccsTblrejectiondetails(); UnitworkccsTblrejectiondetails.DefectCodeId = data.defectCodeId; UnitworkccsTblrejectiondetails.DefectQty = 1; UnitworkccsTblrejectiondetails.MachineId = data.machineId; UnitworkccsTblrejectiondetails.OperatorId = data.operatorId; UnitworkccsTblrejectiondetails.IsDeleted = 0; UnitworkccsTblrejectiondetails.Shift = shift; UnitworkccsTblrejectiondetails.FgPartId = data.fgPartId; UnitworkccsTblrejectiondetails.CorrectedDate = correctedDate; UnitworkccsTblrejectiondetails.CreatedOn = DateTime.Now; UnitworkccsTblrejectiondetails.QrCodeNo = data.qrCodeNo; UnitworkccsTblrejectiondetails.DmcCodeStatus = data.dmcCodeStatus; UnitworkccsTblrejectiondetails.ReasonForRejection = data.reasonForRejection; db.UnitworkccsTblrejectiondetails.Add(UnitworkccsTblrejectiondetails); db.SaveChanges(); obj.isStatus = true; // obj.response = ResourceResponse.AddedSuccessMessage; var reLast = db.UnitworkccsTblrejectiondetails.Where(m => m.IsDeleted == 0).LastOrDefault(); var fgpartdet = db.UnitworkccsTblfgpartnodet.Where(m => m.FgPartId == data.fgPartId).FirstOrDefault(); var cellid = db.UnitworkccsTblfgandcellallocation.Where(m => m.PartNo == fgpartdet.FgPartNo).FirstOrDefault(); var cellname = db.UnitworkccsTblshop.Where(m => m.ShopId == cellid.CellFinalId).Select(m => m.ShopName).FirstOrDefault(); var subcellname = db.UnitworkccsTblcell.Where(m => m.CellId == cellid.SubCellFinalId).Select(m => m.CellName).FirstOrDefault(); var defectcode = db.UnitworkccsTbldefectcodemaster.Where(m => m.DefectCodeId == data.defectCodeId).FirstOrDefault(); var empno = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == fgpartdet.OperatorId).Select(m => m.OpNo).FirstOrDefault(); int?machineid = db.UnitworkccsTblfgpartnodet.Where(m => m.FgPartId == fgpartdet.FgPartId).Select(m => m.MachineId).FirstOrDefault(); var machinedet = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == (int)machineid).FirstOrDefault(); var plantcode = db.UnitworkccsTblplant.Where(m => m.PlantId == machinedet.PlantId).Select(m => m.PlantCode).FirstOrDefault(); var operatorname = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == fgpartdet.OperatorId).Select(m => m.OperatorName).FirstOrDefault(); addresopnce.cellId = (int)cellid.CellFinalId; addresopnce.cellName = cellname; addresopnce.subCellId = (int)cellid.SubCellFinalId; addresopnce.subCellName = subcellname; // addresopnce.date = Convert.ToString(fgpartdet.StartDate); DateTime date1 = Convert.ToDateTime(fgpartdet.StartDate); addresopnce.date = date1.ToString("yyyy-MM-ddTHH:mm:ss.fffZ"); // DateTime.Now.ToString("yyyy’-‘MM’-‘dd’T’HH’:’mm’:’ss.fffffffK") addresopnce.defectCodeId = data.defectCodeId; addresopnce.defectCode = defectcode.DefectCodeName; addresopnce.defectDescription = defectcode.DefectCodeDesc; addresopnce.employeeNo = (int)empno; addresopnce.fgPartId = fgpartdet.FgPartId; addresopnce.isRejectionOrRework = "Rejection"; addresopnce.machineId = (int)machineid; string[] machinename = machinedet.MachineName.Split('_'); addresopnce.machineName = machinename[1]; addresopnce.operatorId = (int)fgpartdet.OperatorId; addresopnce.operatorName = operatorname; addresopnce.partDescription = fgpartdet.PartName; addresopnce.partId = null; addresopnce.partNumber = fgpartdet.FgPartNo; addresopnce.partQrCode = data.qrCodeNo; addresopnce.plantId = (int)machinedet.PlantId; addresopnce.plantName = plantcode; addresopnce.quantity = (int)reLast.DefectQty; addresopnce.rejectionId = reLast.RejectionId; addresopnce.reworkId = 0; addresopnce.shift = fgpartdet.Shift; addresopnce.updatedRejectionOrRework = null; addresopnce.workorderNumber = fgpartdet.WorkOrderNo; addresopnce.reasonForRejection = reLast.ReasonForRejection; obj.response = addresopnce; } else { obj.isStatus = false; obj.response = "Qr Code already Added"; } } else { obj.isStatus = false; obj.response = "Qr Code already Added"; } } else { obj.isStatus = false; obj.response = "Please enter Defect Qty less than Actal value" + data.actual; } } else { if (data.actual > 1) { UnitworkccsTblrejectiondetails UnitworkccsTblrejectiondetails = new UnitworkccsTblrejectiondetails(); UnitworkccsTblrejectiondetails.DefectCodeId = data.defectCodeId; UnitworkccsTblrejectiondetails.DefectQty = data.defectQty; UnitworkccsTblrejectiondetails.MachineId = data.machineId; UnitworkccsTblrejectiondetails.OperatorId = data.operatorId; UnitworkccsTblrejectiondetails.IsDeleted = 0; UnitworkccsTblrejectiondetails.Shift = shift; UnitworkccsTblrejectiondetails.FgPartId = data.fgPartId; UnitworkccsTblrejectiondetails.CorrectedDate = correctedDate; UnitworkccsTblrejectiondetails.CreatedOn = DateTime.Now; UnitworkccsTblrejectiondetails.DmcCodeStatus = data.dmcCodeStatus; UnitworkccsTblrejectiondetails.ReasonForRejection = data.reasonForRejection; db.UnitworkccsTblrejectiondetails.Add(UnitworkccsTblrejectiondetails); db.SaveChanges(); obj.isStatus = true; // obj.response = ResourceResponse.AddedSuccessMessage; var reLast = db.UnitworkccsTblrejectiondetails.Where(m => m.IsDeleted == 0).LastOrDefault(); var fgpartdet = db.UnitworkccsTblfgpartnodet.Where(m => m.FgPartId == data.fgPartId).FirstOrDefault(); var cellid = db.UnitworkccsTblfgandcellallocation.Where(m => m.PartNo == fgpartdet.FgPartNo).FirstOrDefault(); var cellname = db.UnitworkccsTblshop.Where(m => m.ShopId == cellid.CellFinalId).Select(m => m.ShopName).FirstOrDefault(); var subcellname = db.UnitworkccsTblcell.Where(m => m.CellId == cellid.SubCellFinalId).Select(m => m.CellName).FirstOrDefault(); var defectcode = db.UnitworkccsTbldefectcodemaster.Where(m => m.DefectCodeId == data.defectCodeId).FirstOrDefault(); var empno = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == fgpartdet.OperatorId).Select(m => m.OpNo).FirstOrDefault(); int?machineid = db.UnitworkccsTblfgpartnodet.Where(m => m.FgPartId == fgpartdet.FgPartId).Select(m => m.MachineId).FirstOrDefault(); var machinedet = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == (int)machineid).FirstOrDefault(); var plantcode = db.UnitworkccsTblplant.Where(m => m.PlantId == machinedet.PlantId).Select(m => m.PlantCode).FirstOrDefault(); var operatorname = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == fgpartdet.OperatorId).Select(m => m.OperatorName).FirstOrDefault(); addresopnce.cellId = (int)cellid.CellFinalId; addresopnce.cellName = cellname; addresopnce.subCellId = (int)cellid.SubCellFinalId; addresopnce.subCellName = subcellname; // addresopnce.date = Convert.ToString(fgpartdet.StartDate); DateTime date1 = Convert.ToDateTime(fgpartdet.StartDate); addresopnce.date = date1.ToString("yyyy-MM-ddTHH:mm:ss.fffZ"); addresopnce.defectCodeId = data.defectCodeId; addresopnce.defectCode = defectcode.DefectCodeName; addresopnce.defectDescription = defectcode.DefectCodeDesc; addresopnce.employeeNo = (int)empno; addresopnce.fgPartId = fgpartdet.FgPartId; addresopnce.isRejectionOrRework = "Rejection"; addresopnce.machineId = (int)machineid; string[] machinename = machinedet.MachineName.Split('_'); addresopnce.machineName = machinename[1]; addresopnce.operatorId = (int)fgpartdet.OperatorId; addresopnce.operatorName = operatorname; addresopnce.partDescription = fgpartdet.PartName; addresopnce.partId = null; addresopnce.partNumber = fgpartdet.FgPartNo; addresopnce.partQrCode = data.qrCodeNo; addresopnce.plantId = (int)machinedet.PlantId; addresopnce.plantName = plantcode; addresopnce.quantity = (int)reLast.DefectQty; addresopnce.rejectionId = reLast.RejectionId; addresopnce.reworkId = 0; addresopnce.shift = fgpartdet.Shift; addresopnce.updatedRejectionOrRework = null; addresopnce.workorderNumber = fgpartdet.WorkOrderNo; addresopnce.reasonForRejection = reLast.ReasonForRejection; obj.response = addresopnce; } else { obj.isStatus = false; obj.response = "Please enter Defect Qty less than Actal value" + data.actual; } } } catch (Exception ex) { obj.isStatus = false; obj.response = ResourceResponse.FailureMessage; } return(obj); }
public async Task <IActionResult> AddRejectionDetails(AddRejection data) { CommonResponse response = reworkAndRejection.AddRejectionDetails(data); return(Ok(response)); }