public async Task <int> DeletePacking(int id) { try { Packing pack = await getPackingById(id); if (pack != null) { sde.Products.RemoveRange(pack.Products); await sde.SaveChangesAsync(); sde.Packings.Remove(pack); sde.SaveChanges(); return(1); } else { return(0); } } catch (Exception ex) { throw ex; } }
public async Task <Packing> getPackingById(int id) { try { Packing pack = await(from p in sde.Packings where p.packingId == id select p).FirstOrDefaultAsync(); return(pack); } catch (Exception ex) { throw ex; } }
public async Task AddPacking(Packing pack) { try { sde.Packings.Add(pack); await sde.SaveChangesAsync(); } catch (Exception ex) { throw ex; } }
public async Task UpdatePacking(int id, Packing pack) { try { Packing old_pack = await getPackingById(id); old_pack.packingName = pack.packingName; old_pack.modifiedAt = pack.modifiedAt; old_pack.modifiedBy = pack.modifiedBy; sde.SaveChanges(); } catch (Exception ex) { throw ex; } }