public void AddLocale(CoordinateLocali Cl)
{
bool toAdd = true;
var DBExists = _connection.GetTableInfo("CoordinateLocali");
if (DBExists.Count == 0)
{
_connection.CreateTable <CoordinateLocali>();
}
_connection.CreateTable <CoordinateLocali>();
//IEnumerable<CoordinateLocali> Coord = _connection.ExecuteScalar<List<CoordinateLocali>>("SELECT * FROM DatiCliente");
IEnumerable <CoordinateLocali> Coord = _connection.Table <CoordinateLocali>();
foreach (CoordinateLocali C in Coord)
{
if (C.Restaurant == Cl.Restaurant)
{
_connection.Query <CoordinateLocali>("Update CoordinateLocali set Exipiry = " + Cl.Exipiry + " where id = " + C.id);
_connection.Query <CoordinateLocali>("Update CoordinateLocali set Sala = '" + Cl.Sala + "' where id = " + C.id);
_connection.Query <CoordinateLocali>("Update CoordinateLocali set Seat = '" + Cl.Seat + "' where id = " + C.id);
toAdd = false;
}
}
if (toAdd)
{
_connection.Insert(Cl);
}
}
public void AggiungiLocale()
{
DataService C = new DataService("DatiCliente.db");
CoordinateLocali CL = new CoordinateLocali();
CL.Db = Db;
if (daysToStore != null && daysToStore >= 1)
{
CL.Exipiry = DataService.DateTimeToUnixTimestamp(DateTime.Today.AddDays(daysToStore));
}
else
{
CL.Exipiry = DataService.DateTimeToUnixTimestamp(DateTime.Now.AddHours(8));
}
CL.LongName = NomeLocaleLong;
CL.Restaurant = Restaurant;
CL.Utenza = Utenza;
CL.Sala = sala;
CL.Seat = seat;
C.AddLocale(CL);
}
