public IActionResult RemoveWorkSheet([FromBody] Munkalap data) { try { var manager = new WorksheetManager(_options); manager.RemoveWorkSheet(data); return(Ok()); } catch (Exception ex) { logger.Error(ex); return(BadRequest(ex.Message)); } }
public Munkalap GetWorkSheet(int workSheetId) { var worksheet = new Munkalap(); var result = _worksheetAccess.GetWorkSheet(workSheetId); worksheet.Id = result.Id; worksheet.Idopont = result.Idopont; worksheet.Ugyfel = new Ugyfel() { Id = result.Ugyfel.Id, Nev = result.Ugyfel.Nev }; worksheet.Lezarta = result.LezartaNavigation != null ? result.LezartaNavigation.Nev : null; worksheet.Lezarva = result.Lezarva; worksheet.Rogzitette = result.RogzitetteNavigation.Nev; worksheet.Rogzitve = result.Rogzitve; return(worksheet); }
public int SetWorkSheet(Munkalap worksheet) { using (var context = new CarMechanicContext(_options)) { var ws = new Munkalapok(); if (worksheet.Id == 0) { ws.Ugyfelid = worksheet.Ugyfel.Id; ws.Idopont = worksheet.Idopont; ws.Rogzitve = DateTime.Now; ws.Rogzitette = context.Felhasznalok.Where(x => x.Loginnev == (worksheet.Rogzitette.Contains("@") ? "ugyfel" : worksheet.Rogzitette)).FirstOrDefault().Id;; ws.MunkalapTetelek = new List <MunkalapTetelek>(); if (worksheet.Tetelek != null) { foreach (var row in worksheet.Tetelek) { ws.MunkalapTetelek.Add(new MunkalapTetelek() { Ar = row.Ar, Szolgaltatasid = row.Szolgaltatas.Id, Mennyiseg = row.Mennyiseg, Rogzitve = ws.Rogzitve, Rogzitette = ws.Rogzitette }); } } context.Munkalapok.Add(ws); } else { ws = context.Munkalapok.FirstOrDefault(x => x.Id == worksheet.Id); ws.Idopont = worksheet.Idopont; ws.Rogzitve = DateTime.Now; ws.Rogzitette = context.Felhasznalok.Where(x => x.Loginnev == (worksheet.Rogzitette.Contains("@") ? "ugyfel" : worksheet.Rogzitette)).FirstOrDefault().Id;; } context.SaveChanges(); return(ws.Id); } }
public void RemoveWorkSheet(Munkalap worksheet) { using (var context = new CarMechanicContext(_options)) { var oResult = context.MunkalapRendelesek.Where(x => x.Munkalapid == worksheet.Id); if (oResult != null) { context.MunkalapRendelesek.RemoveRange(oResult); } var wsResult = context.MunkalapTetelek.Where(x => x.Munkalapid == worksheet.Id); if (wsResult != null) { context.MunkalapTetelek.RemoveRange(wsResult); } var result = context.Munkalapok.FirstOrDefault(x => x.Id == worksheet.Id); if (result != null) { context.Munkalapok.Remove(result); } context.SaveChanges(); } }
public void RemoveWorkSheet(Munkalap worksheet) { _worksheetAccess.RemoveWorkSheet(worksheet); }
public int SetWorkSheet(Munkalap worksheet) { return(_worksheetAccess.SetWorkSheet(worksheet)); }