private void StagingTest(ModelTypeUploadModel model) { ASHAOP_DEVEntities entities = new ASHAOP_DEVEntities(); // Add ModelTypeUpload entities.M_ModelTypeUpload.Add(new M_ModelTypeUpload { CreatedBy = "SYSTEM", CreatedDate = DateTime.Now, UpdatedBy = "SYSTEM", UpdatedDate = DateTime.Now, M_ModelTypeTempSheet = model.ModelTypeTempSheetModels.Select(sheet => new M_ModelTypeTempSheet { SheetNo = sheet.SheetNo, YM = sheet.YM, Model = sheet.Model, Door = sheet.Door, Plant = sheet.Plant, Status = sheet.Status, // Add M_ModelTypeTempRow M_ModelTypeTempRow = sheet.ModelTypeTempRowModels.Select(row => new M_ModelTypeTempRow { RowNo = row.RowNo, PNo = row.PNo, VIN = row.VIN, ErrorMessage = row.ErrorMessage, // Add M_ModelTypeTempEngine M_ModelTypeTempEngine = row.ModelTypeTempEngines.Select(engine => new M_ModelTypeTempEngine { SS = engine.SS, DISP = engine.DISP, COMCARB = engine.COMCARB, Grade = engine.Grade, Mis = engine.Mis, ModelCode01 = engine.ModelCode01, ModelCode02 = engine.ModelCode02, ModelCode03 = engine.ModelCode03, ModelCode04 = engine.ModelCode04, ModelCode05 = engine.ModelCode05 }).ToList(), // Add M_ModelTypeTempEquipment M_ModelTypeTempEquipment = row.ModelTypeTempEquipmentModels.Select(equip => new M_ModelTypeTempEquipment { EquipmentName = equip.EquipmentName, EquipmentValue = equip.EquipmentValue, Sequence = equip.Sequence }).ToList(), // Add M_ModelTypeTempType M_ModelTypeTempType = row.ModelTypeTempTypeModels.Select(type => new M_ModelTypeTempType { ModelType = type.ModelType, ModelCode = type.ModelCode, Sequence = type.Sequence }).ToList() }).ToList(), }).ToList() }); entities.SaveChanges(); }
public bool AddModelTypeUpload(ModelTypeUploadModel model) { try { bool IsSucceed = false; ASHAOP_DEVEntities entities = new ASHAOP_DEVEntities(); // Add ModelTypeUpload entities.M_ModelTypeUpload.Add(new M_ModelTypeUpload { CreatedBy = model.CreatedBy, CreatedDate = DateTime.Now, UpdatedBy = model.UpdatedBy, UpdatedDate = DateTime.Now, M_ModelTypeTempSheet = model.ModelTypeTempSheetModels.Select(sheet => new M_ModelTypeTempSheet { SheetNo = sheet.SheetNo, YM = sheet.YM, Model = sheet.Model, Door = sheet.Door, Engine = sheet.Engine, Plant = sheet.Plant, Status = sheet.Status, // Add M_ModelTypeTempRow M_ModelTypeTempRow = sheet.ModelTypeTempRowModels.Select(row => new M_ModelTypeTempRow { RowNo = row.RowNo, PNo = row.PNo, VIN = row.VIN, ErrorMessage = row.ErrorMessage, // Add M_ModelTypeTempEngine M_ModelTypeTempEngine = row.ModelTypeTempEngines.Select(engine => new M_ModelTypeTempEngine { SS = engine.SS, DISP = engine.DISP, COMCARB = engine.COMCARB, Grade = engine.Grade, Mis = engine.Mis, ModelCode01 = engine.ModelCode01, ModelCode02 = engine.ModelCode02, ModelCode03 = engine.ModelCode03, ModelCode04 = engine.ModelCode04, ModelCode05 = engine.ModelCode05 }).ToList(), // Add M_ModelTypeTempEquipment M_ModelTypeTempEquipment = row.ModelTypeTempEquipmentModels.Select(equip => new M_ModelTypeTempEquipment { EquipmentName = equip.EquipmentName, EquipmentValue = equip.EquipmentValue, Sequence = equip.Sequence }).ToList(), // Add M_ModelTypeTempType M_ModelTypeTempType = row.ModelTypeTempTypeModels.Select(type => new M_ModelTypeTempType { ModelType = type.ModelType, ModelCode = type.ModelCode, Sequence = type.Sequence }).ToList() }).ToList(), }).ToList() }); entities.SaveChanges(); IsSucceed = true; return(IsSucceed); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } catch (Exception e) { throw e; } }