public async Task <ActionResult <esfDailyFuel> > PostesfDailyFuel(DailyFuelViewModel DailyFuel) { using (var transaction = _context.Database.BeginTransaction()) { esfDailyFuel doc = null; try { doc = new esfDailyFuel { dcNo = DailyFuel.dcNo, dcType = DailyFuel.dcType, dcDate = DailyFuel.dcDate, emID = DailyFuel.emID, Comment = DailyFuel.Comment, CreateAt = DateTime.Now, CreateBy = 0 }; _context.esfDailyFuel.Add(doc); await _context.SaveChangesAsync(); var items = DailyFuel.Items .Select(i => new esfDailyFuelItems { HIID = null, dfiID = 0, dcID = doc.dcID, Income = i.Income, Outcome = i.Outcome, Remains = i.Remains, FileName = i.FileName, eoID = i.eoID, fuID = i.fuID, CreateAt = DateTime.Now, CreateBy = 0, }).ToList(); _context.esfDailyFuelItems.AddRange(items); await _context.SaveChangesAsync(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); } return(CreatedAtAction("GetesfDailyFuel", new { id = doc.dcID }, DailyFuel)); } }
public async Task <IActionResult> PutesfDailyFuel(int dcID, DailyFuelViewModel DailyFuel) { if (dcID != DailyFuel.dcID) { return(BadRequest()); } esfDailyFuel doc = await _context.esfDailyFuel.Include(d => d.Items).FirstOrDefaultAsync(d => d.dcID == dcID); using (var transaction = _context.Database.BeginTransaction()) { try { doc.dcNo = DailyFuel.dcNo; doc.dcDate = DailyFuel.dcDate; doc.emID = DailyFuel.emID; doc.Comment = DailyFuel.Comment; doc.Items.RemoveAll(item => !DailyFuel.Items.Any(i => i.dfiID == item.dfiID)); foreach (var updItem in DailyFuel.Items) { var item = doc.Items.FirstOrDefault(i => (updItem.dfiID == i.dfiID)); if (item == null) { item = new esfDailyFuelItems { HIID = null, dfiID = 0, dcID = doc.dcID, Income = updItem.Income, Outcome = updItem.Outcome, Remains = updItem.Remains, FileName = updItem.FileName, eoID = updItem.eoID, fuID = updItem.fuID, CreateAt = DateTime.Now, CreateBy = 0, }; doc.Items.Add(item); } else { if (((updItem.eoID != item.eoID) || (updItem.FileName != item.FileName) || (updItem.fuID != item.fuID) || (updItem.Income != item.Income) || (updItem.Outcome != item.Outcome) || (updItem.Remains != item.Remains))) { item.eoID = updItem.eoID; item.fuID = updItem.fuID; item.FileName = updItem.FileName; item.Income = updItem.Income; item.Outcome = updItem.Outcome; item.Remains = updItem.Remains; item.EditAt = DateTime.Now; } } } _context.Entry(doc).State = EntityState.Modified; try { await _context.SaveChangesAsync(); transaction.Commit(); } catch (DbUpdateConcurrencyException) { if (!esfDailyFuelExists(dcID)) { return(NotFound()); } else { throw; } } } catch (Exception) { transaction.Rollback(); } } return(NoContent()); }
public static void Init(FuelDbContext context) { using (var transaction = context.Database.BeginTransaction()) { try { if (!context.esfFuelTypes.Any()) { context.AddRange( new esfFuelTypes { Code = 55, Name = "Мазут", IsHasIncome = true, IsHasOutcome = true, IsHasRemains = true, IsActive = true }, new esfFuelTypes { Code = 855, Name = "Мазут(Сторонні організації)", IsHasIncome = true, IsHasOutcome = true, IsHasRemains = true, IsActive = true }, new esfFuelTypes { Code = 65, Name = "Газ", IsHasIncome = false, IsHasOutcome = false, IsHasRemains = true, IsActive = true }, new esfFuelTypes { Code = 41, Name = "Донецький АШ", IsHasIncome = true, IsHasOutcome = true, IsHasRemains = true, IsActive = true }, new esfFuelTypes { Code = 1, Name = "Донецьке вугілля", IsHasIncome = true, IsHasOutcome = true, IsHasRemains = true, IsActive = true } ); } ; context.SaveChanges(); if (!context.mnEnergyObjects.Any()) { context.AddRange( new mnEnergyObjects { eoCode = 1, Name = "Трипільська ТЕС" }, new mnEnergyObjects { eoCode = 12, Name = "Київенерго ТЕЦ-5" }, new mnEnergyObjects { eoCode = 16, Name = "Київенерго ТЕЦ-6" }, new mnEnergyObjects { eoCode = 79, Name = "Київенерго ПКТС" }, new mnEnergyObjects { eoCode = 10, Name = "Дарницька ТЕЦ" }, new mnEnergyObjects { eoCode = 11, Name = "Черкаська ТЕЦ" }, new mnEnergyObjects { eoCode = 13, Name = "Чернігівська ТЕЦ" }, new mnEnergyObjects { eoCode = 17, Name = "Білоцерківська ТЕЦ" }, new mnEnergyObjects { eoCode = 15, Name = "Уманський ТК" } ); } ; context.SaveChanges(); if (!context.mnEnergyObjectFiles.Any()) { context.AddRange( new mnEnergyObjectFiles { eoID = context.mnEnergyObjects.Where(eo => eo.eoCode == 1).First().eoID, Path = "D:\\Test\\Palyvo", Filename = "TPTC", DateFormat = "ddmm", FileExt = "txt", IsDefault = true }, new mnEnergyObjectFiles { eoID = context.mnEnergyObjects.Where(eo => eo.eoCode == 12).First().eoID, Path = "D:\\Test\\Palyvo", Filename = "TEC5", DateFormat = "ddmm", FileExt = "txt", IsDefault = true }, new mnEnergyObjectFiles { eoID = context.mnEnergyObjects.Where(eo => eo.eoCode == 16).First().eoID, Path = "D:\\Test\\Palyvo", Filename = "TEC6", DateFormat = "ddmm", FileExt = "txt", IsDefault = true }, new mnEnergyObjectFiles { eoID = context.mnEnergyObjects.Where(eo => eo.eoCode == 79).First().eoID, Path = "D:\\Test\\Palyvo", Filename = "PKTS", DateFormat = "ddmm", FileExt = "txt", IsDefault = true }, new mnEnergyObjectFiles { eoID = context.mnEnergyObjects.Where(eo => eo.eoCode == 10).First().eoID, Path = "D:\\Test\\Palyvo", Filename = "DTEC", DateFormat = "ddmm", FileExt = "txt", IsDefault = true }, new mnEnergyObjectFiles { eoID = context.mnEnergyObjects.Where(eo => eo.eoCode == 11).First().eoID, Path = "D:\\Test\\Palyvo", Filename = "CKTC", DateFormat = "ddmm", FileExt = "txt", IsDefault = true }, new mnEnergyObjectFiles { eoID = context.mnEnergyObjects.Where(eo => eo.eoCode == 13).First().eoID, Path = "D:\\Test\\Palyvo", Filename = "CNTC", DateFormat = "ddmm", FileExt = "txt", IsDefault = true }, new mnEnergyObjectFiles { eoID = context.mnEnergyObjects.Where(eo => eo.eoCode == 17).First().eoID, Path = "D:\\Test\\Palyvo", Filename = "BCTC", DateFormat = "ddmm", FileExt = "txt", IsDefault = true }, new mnEnergyObjectFiles { eoID = context.mnEnergyObjects.Where(eo => eo.eoCode == 15).First().eoID, Path = "D:\\Test\\Palyvo", Filename = "UMTK", DateFormat = "ddmm", FileExt = "txt", IsDefault = true } ); } ; context.SaveChanges(); if (!context.mnEnergyObjectFuel.Any()) { AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 1).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 1).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 1).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 12).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 12).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 12).eoID, context.esfFuelTypes.First(ft => ft.Code == 855).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 16).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 16).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 16).eoID, context.esfFuelTypes.First(ft => ft.Code == 855).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 79).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 79).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 79).eoID, context.esfFuelTypes.First(ft => ft.Code == 855).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 10).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 10).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 10).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 11).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 11).eoID, context.esfFuelTypes.First(ft => ft.Code == 1).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 11).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 13).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 13).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 13).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 17).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 17).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID); AddFuelType(context, context.mnEnergyObjects.First(eo => eo.eoCode == 15).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID); } ; context.SaveChanges(); if (!context.esfDailyFuel.Any()) { esfDailyFuel Doc; context.Add( Doc = new esfDailyFuel { dcNo = "Паливо1", dcDate = DateTime.Parse("01.08.2019"), dcType = "Паливо", emID = 3 } ); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 1).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 590, 8000, 254830, "TPTC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 1).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 8, 2613, "TPTC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 1).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 79, 0, "TPTC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 12).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 33310, "TEC50108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 12).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 515, 0, "TEC50108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 12).eoID, context.esfFuelTypes.First(ft => ft.Code == 855).fuID, 0, 0, 170, "TEC50108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 16).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 13242, "TEC60108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 16).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 19, 0, "TEC60108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 16).eoID, context.esfFuelTypes.First(ft => ft.Code == 855).fuID, 0, 0, 0, "TEC60108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 79).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 0, 0, "PKTS0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 79).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 0, 0, "PKTS0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 79).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 0, 0, "PKTS0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 10).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 883, 54600, "DTEC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 10).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 894, "DTEC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 10).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 130, 0, "DTEC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 11).eoID, context.esfFuelTypes.First(ft => ft.Code == 1).fuID, 0, 0, 63462, "CKTC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 11).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 0, "CKTC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 11).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 215, 0, "CKTC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 13).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 791, 96755, "CNTC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 13).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 0, "CNTC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 13).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 93, 0, "CNTC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 17).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 1136, "BCTC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 17).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 482, 0, "BCTC0108.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 15).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 11, 0, "UMTK0108.txt"); context.Add( Doc = new esfDailyFuel { dcNo = "Паливо2", dcDate = DateTime.Parse("02.08.2019"), dcType = "Паливо", emID = 3, Comment = "lalala" } ); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 1).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 6056, 248774, "TPTC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 1).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 2613, "TPTC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 1).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 12, 0, "TPTC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 12).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 33310, "TEC50208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 12).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 512, 0, "TEC50208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 12).eoID, context.esfFuelTypes.First(ft => ft.Code == 855).fuID, 0, 0, 170, "TEC50208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 16).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 13242, "TEC60208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 16).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 19, 0, "TEC60208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 16).eoID, context.esfFuelTypes.First(ft => ft.Code == 855).fuID, 0, 0, 0, "TEC60208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 79).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 0, 0, "PKTS0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 79).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 0, 0, "PKTS0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 79).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 0, 0, "PKTS0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 10).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 1000, 53600, "DTEC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 10).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 894, "DTEC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 10).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 130, 0, "DTEC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 11).eoID, context.esfFuelTypes.First(ft => ft.Code == 1).fuID, 0, 0, 63462, "CKTC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 11).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 0, "CKTC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 11).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 214, 0, "CKTC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 13).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 850, 95905, "CNTC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 13).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 0, "CNTC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 13).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 92, 0, "CNTC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 17).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 1136, "BCTC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 17).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 448, 0, "BCTC0208.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 15).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 7, 0, "UMTK0208.txt"); context.Add( Doc = new esfDailyFuel { dcNo = "Паливо3", dcDate = DateTime.Parse("03.08.2019"), dcType = "Паливо", emID = 4, } ); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 1).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 747, 5550, 243971, "TPTC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 1).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 8, 2605, "TPTC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 1).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 45, 0, "TPTC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 12).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 33310, "TEC50308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 12).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 509, 0, "TEC50308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 12).eoID, context.esfFuelTypes.First(ft => ft.Code == 855).fuID, 0, 0, 170, "TEC50308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 16).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 13242, "TEC60308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 16).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 19, 0, "TEC60308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 16).eoID, context.esfFuelTypes.First(ft => ft.Code == 855).fuID, 0, 0, 0, "TEC60308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 79).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 0, 0, "PKTS0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 79).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 0, 0, "PKTS0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 79).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 0, 0, "PKTS0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 10).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 1000, 52600, "DTEC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 10).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 894, "DTEC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 10).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 140, 0, "DTEC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 11).eoID, context.esfFuelTypes.First(ft => ft.Code == 1).fuID, 0, 0, 63462, "CKTC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 11).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 0, "CKTC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 11).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 226, 0, "CKTC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 13).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 940, 94965, "CNTC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 13).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 0, "CNTC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 13).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 107, 0, "CNTC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 17).eoID, context.esfFuelTypes.First(ft => ft.Code == 55).fuID, 0, 0, 1136, "BCTC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 17).eoID, context.esfFuelTypes.First(ft => ft.Code == 65).fuID, 0, 453, 0, "BCTC0308.txt"); AddItems(context, Doc.dcID, context.mnEnergyObjects.First(eo => eo.eoCode == 15).eoID, context.esfFuelTypes.First(ft => ft.Code == 41).fuID, 0, 10, 0, "UMTK0308.txt"); } context.SaveChanges(); transaction.Commit(); } catch { transaction.Rollback(); } }; }