public IHttpActionResult PutClientsTable(int id, ClientsTable clientsTable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != clientsTable.ID)
{
return(BadRequest());
}
db.Entry(clientsTable).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ClientsTableExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public static string GetClientsOfOrders(string date)
{
DataTable table = new DataTable();
DateTime dateTime = Convert.ToDateTime(date);
// To store values from DB
ClientsTable clientsTable;
// Creates a SQL connection
string strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (var connection = new SqlConnection(strConnString))
{
connection.Open();
// Creates a SQL command
using (var command = new SqlCommand("SELECT id_cliente, nombre_cliente, apellido_cliente, colonia_cliente, nombre_ruta, postal_cliente, telefono_cliente, movil_cliente, plano_cliente FROM View_ClientesConPedido WHERE fechaEntrega_orden = @DeliverDate", connection))
{
// Loads the query results into the table
command.Parameters.AddWithValue("@DeliverDate", dateTime);
table.Load(command.ExecuteReader());
}
clientsTable = new ClientsTable(table);
connection.Close();
}
// Filter values form DB (Remove repeated clients)
List <Client> distinctItems = clientsTable.ClientsStoredTable.GroupBy(x => x.Id).Select(y => y.First()).ToList();
string json = JsonConvert.SerializeObject(distinctItems);
return(json);
}
public ActionResult DeleteConfirmed(int id)
{
ClientsTable clientsTable = db.ClientsTables.Find(id);
db.ClientsTables.Remove(clientsTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,LastName,FirstName,Age,Gender")] ClientsTable clientsTable)
{
if (ModelState.IsValid)
{
db.Entry(clientsTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(clientsTable));
}
public ActionResult Create([Bind(Include = "ID,LastName,FirstName,Age,Gender")] ClientsTable clientsTable)
{
if (ModelState.IsValid)
{
db.ClientsTables.Add(clientsTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(clientsTable));
}
public IHttpActionResult GetClientsTable(int id)
{
ClientsTable clientsTable = db.ClientsTables.Find(id);
if (clientsTable == null)
{
return(NotFound());
}
return(Ok(clientsTable));
}
public IHttpActionResult PostClientsTable(ClientsTable clientsTable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.ClientsTables.Add(clientsTable);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = clientsTable.ID }, clientsTable));
}
private void Join(byte[] data, EndPoint sender)
{
if (OneShotJoin == true)
{
byte[] StartedAlready = new byte[1];
StartedAlready[0] = 161;
transport.Send(StartedAlready, sender);
}
else if (idCounter < 8)
{
idCounter++;
if (!ClientsTable.ContainsKey(sender))
{
ClientsTable.Add(sender, idCounter);
ClientPosition.Add(idCounter, playersInfo);
ClientAlive.Add(idCounter, 1);
}
byte[] ResponsePacketPosition = new byte[17];
ResponsePacketPosition[0] = 2;
byte[] id;
byte[] joinPositionX;
byte[] joinPositionY;
byte[] joinPositionZ;
id = BitConverter.GetBytes(idCounter);
if (idCounter % 2 == 0)
{
joinPositionX = BitConverter.GetBytes(1f);
joinPositionY = BitConverter.GetBytes(3.77f);
joinPositionZ = BitConverter.GetBytes(-2f - spawnPositionCounter);
spawnPositionCounter += 2f;
}
else
{
joinPositionX = BitConverter.GetBytes(-1.5f);
joinPositionY = BitConverter.GetBytes(3.77f);
joinPositionZ = BitConverter.GetBytes(-2f - spawnPositionCounter);
}
Buffer.BlockCopy(id, 0, ResponsePacketPosition, 1, 4);
Buffer.BlockCopy(joinPositionX, 0, ResponsePacketPosition, 5, 4);
Buffer.BlockCopy(joinPositionY, 0, ResponsePacketPosition, 9, 4);
Buffer.BlockCopy(joinPositionZ, 0, ResponsePacketPosition, 13, 4);
transport.Send(ResponsePacketPosition, sender);
}
else
{
byte[] tooManyPlayers = new byte[1];
tooManyPlayers[0] = 162;
transport.Send(tooManyPlayers, sender);
}
}
public void KeepAlive()
{
keepAliveTimer += 0.005f;
if (keepAliveTimer >= 3)
{
foreach (var item in ClientAlive)
{
if (item.Value == 0)
{
foreach (var item2 in ClientsTable)
{
if (item.Key != item2.Value)
{
byte[] DestroyThisPlayer = new byte[5];
DestroyThisPlayer[0] = 88;
byte[] id = BitConverter.GetBytes(item.Key);
Buffer.BlockCopy(id, 0, DestroyThisPlayer, 1, 4);
transport.Send(DestroyThisPlayer, item2.Key);
}
else
{
PlayerToDestroyEndPoint = item2.Key;
}
}
PlayerToDestroyID = item.Key;
DictionaryRemover = true;
}
}
if (DictionaryRemover)
{
ClientAlive.Remove(PlayerToDestroyID);
ClientsTable.Remove(PlayerToDestroyEndPoint);
ClientPosition.Remove(PlayerToDestroyID);
//idCounter--;
if (OneShotReady)
{
ReadyCounter--;
}
DictionaryRemover = false;
}
foreach (var item in ClientsTable)
{
ClientAlive[item.Value] = 0;
byte[] keepAlive = new byte[1];
keepAlive[0] = 18;
transport.Send(keepAlive, item.Key);
}
keepAliveTimer = 0;
}
}
// GET: ClientsA/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ClientsTable clientsTable = db.ClientsTables.Find(id);
if (clientsTable == null)
{
return(HttpNotFound());
}
return(View(clientsTable));
}
public IHttpActionResult DeleteClientsTable(int id)
{
ClientsTable clientsTable = db.ClientsTables.Find(id);
if (clientsTable == null)
{
return(NotFound());
}
db.ClientsTables.Remove(clientsTable);
db.SaveChanges();
return(Ok(clientsTable));
}
public static string GetCloseClients(IDictionary <string, object> client, bool colony, bool rute, bool cp, string date)
{
DataTable table = new DataTable();
DateTime dateTime = Convert.ToDateTime(date);
Client clientObj = new Client(client);
// To store values from DB
ClientsTable clientsTable;
// Creates a SQL connection
string strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (var connection = new SqlConnection(strConnString))
{
connection.Open();
// Creates a SQL command, default is colony search
string sqlQuery = "SELECT id_cliente, nombre_cliente, apellido_cliente, colonia_cliente, nombre_ruta, id_ruta, postal_cliente, telefono_cliente, movil_cliente, plano_cliente, ultima_entrega" +
" FROM View_ClienteRutas WHERE colonia_cliente LIKE @Place AND id_cliente != @ThisClientID AND id_cliente not in (SELECT id_cliente FROM View_ClientesConPedido WHERE fechaEntrega_orden = @Date OR fechaEntrega_orden = CAST(GETDATE() AS DATE))";
if (colony)
{
sqlQuery = "SELECT id_cliente, nombre_cliente, apellido_cliente, colonia_cliente, nombre_ruta, id_ruta, postal_cliente, telefono_cliente, movil_cliente, plano_cliente, ultima_entrega" +
" FROM View_ClienteRutas WHERE colonia_cliente LIKE @Place AND id_cliente != @ThisClientID AND id_cliente not in (SELECT id_cliente FROM View_ClientesConPedido WHERE fechaEntrega_orden = @Date OR fechaEntrega_orden = CAST(GETDATE() AS DATE))";
}
else if (rute)
{
sqlQuery = "SELECT id_cliente, nombre_cliente, apellido_cliente, colonia_cliente, nombre_ruta, id_ruta, postal_cliente, telefono_cliente, movil_cliente, plano_cliente, ultima_entrega" +
" FROM View_ClienteRutas WHERE nombre_ruta = @Place AND id_cliente != @ThisClientID AND id_cliente not in (SELECT id_cliente FROM View_ClientesConPedido WHERE fechaEntrega_orden = @Date OR fechaEntrega_orden = CAST(GETDATE() AS DATE))";
}
else if (cp)
{
sqlQuery = "SELECT id_cliente, nombre_cliente, apellido_cliente, colonia_cliente, nombre_ruta, id_ruta, postal_cliente, telefono_cliente, movil_cliente, plano_cliente, ultima_entrega" +
" FROM View_ClienteRutas WHERE postal_cliente = @Place AND postal_cliente != '' AND id_cliente != @ThisClientID AND id_cliente not in (SELECT id_cliente FROM View_ClientesConPedido WHERE fechaEntrega_orden = @Date OR fechaEntrega_orden = CAST(GETDATE() AS DATE))";
}
using (var command = new SqlCommand(sqlQuery, connection))
{
// Loads the query results into the table
// Default colony parameter
if (colony)
{
command.Parameters.AddWithValue("@Place", clientObj.Colonia);
}
else if (rute)
{
command.Parameters.AddWithValue("@Place", clientObj.Ruta);
}
else if (cp)
{
command.Parameters.AddWithValue("@Place", clientObj.Postal);
}
command.Parameters.AddWithValue("@ThisClientID", Convert.ToInt32(clientObj.Id));
command.Parameters.AddWithValue("@Date", dateTime);
table.Load(command.ExecuteReader());
}
clientsTable = new ClientsTable(table);
connection.Close();
}
// Filter values form DB (Remove repeated clients)
List <Client> distinctItems = clientsTable.ClientsStoredTable.GroupBy(x => x.Id).Select(y => y.First()).ToList();
distinctItems.Add(clientObj);
string json = JsonConvert.SerializeObject(distinctItems);
return(json);
}
