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