/// <summary> /// Upload Product Wise Defect Code /// </summary> /// <param name="data"></param> /// <returns></returns> public CommonResponse UploadProductWiseDefectCode(List <UploadProuctWiseDefectCodes> data) { CommonResponse obj = new CommonResponse(); try { var check = db.UnitworkccsTblproductwisedefectcodes.Where(m => m.IsDeleted == 0).ToList(); db.RemoveRange(check); db.SaveChanges(); foreach (var item in data) { UnitworkccsTblproductwisedefectcodes UnitworkccsTblproductwisedefectcodes = new UnitworkccsTblproductwisedefectcodes(); if (item.plantCode != null) { var plantId = db.UnitworkccsTblplant.Where(m => m.PlantCode == item.plantCode).Select(m => m.PlantId).FirstOrDefault(); UnitworkccsTblproductwisedefectcodes.PlantId = plantId; } UnitworkccsTblproductwisedefectcodes.PartNo = item.partNo; UnitworkccsTblproductwisedefectcodes.PartName = item.partName; UnitworkccsTblproductwisedefectcodes.Trim = item.trim; if (item.defectCode != null) { var defectIdCode = db.UnitworkccsTbldefectcodemaster.Where(m => m.DefectCodeName == item.defectCode).Select(m => m.DefectCodeId).FirstOrDefault(); UnitworkccsTblproductwisedefectcodes.DefectCodeId = defectIdCode; } UnitworkccsTblproductwisedefectcodes.IsDeleted = 0; UnitworkccsTblproductwisedefectcodes.CreatedOn = DateTime.Now; db.UnitworkccsTblproductwisedefectcodes.Add(UnitworkccsTblproductwisedefectcodes); db.SaveChanges(); obj.isStatus = true; obj.response = ResourceResponse.AddedSuccessMessage; } } catch (Exception e) { obj.isStatus = false; obj.response = ResourceResponse.FailureMessage; } return(obj); }