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