public Package AddTemplatePackageToLine(int lineId, Package package) { try { using (_context) { Line tmpLine = _context.LinesTable.SingleOrDefault((l) => l.LineID == lineId); if (tmpLine == null) { throw new EntityNotExistsException("This line not exists"); } Package tmpPackage = _context.PackagesTable.SingleOrDefault((p) => p.PackageID == package.PackageID && package.PackageType != PackageType.custom); if (tmpPackage == null) { throw new EntityNotExistsException("This package not exists or his type is custom package"); } tmpLine.Package = package; _context.SaveChanges(); return(package); } } catch (Exception e) { Log(e); throw new DbFaildConnncetException("Failed connect to data base"); } }
public Client AddClient(Client newClient) { try { using (_context) { Client tmp = _context.ClientsTable.SingleOrDefault((c) => c.ClientID == newClient.ClientID); if (tmp != null) { throw new EntityExistsException("Client with same client id exists!"); } _context.ClientsTable.Add(newClient); _context.SaveChanges(); SetUserNameAndPass(newClient); Client eddedClient = _context.ClientsTable.SingleOrDefault((c) => c.ClientID == newClient.ClientID); return(eddedClient); } } catch (Exception e) { Log(e); throw new DbFaildConnncetException("Failed connect to data base"); } }
public Line DeleteLine(string lineNumber) { try { using (var context = new CellularModelDB()) { Line tmp = context.LinesTable.FirstOrDefault((l) => l.LineNumber == lineNumber); if (tmp == null) { throw new EntityNotExistsException("Line number not exists"); } tmp.IsActive = false; context.SaveChanges(); return(tmp); } } catch (Exception e) { Log(e); throw new DbFaildConnncetException("Failed connect to data base"); } }
public Line AddLine(int clientId) { try { using (_context) { Client tmp = _context.ClientsTable.FirstOrDefault((c) => c.ClientID == clientId); if (tmp == null) { throw new EntityNotExistsException("Client id worng"); } string newLineNumber = GenerateLineNumber(); Line line = new Line { Client = tmp, IsActive = true, JoinDate = DateTime.Now, LineNumber = newLineNumber }; tmp.Lines.Add(line); _context.SaveChanges(); Line newLine = _context.LinesTable.SingleOrDefault((l) => l.LineNumber == newLineNumber); if (newLine == null) { throw new EntityNotExistsException("Failed to add line"); } return(newLine); } } catch (Exception e) { Log(e); throw new DbFaildConnncetException("Failed connect to data base"); } }