/// <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);
}
