public async Task Insert(Cliente data)
{
try
{
String query = String.Format(@"INSERT INTO [dbo].[Clientes]
([NombreEmpresa]
,[ContactoSistemas]
,[Telefono]
,[Email]
,[Grupo]
,[Estatus])
VALUES
('{0}'
,'{1}'
,'{2}'
,'{3}'
,'{4}'
,{5})", data.nombreEmpresa, data.contactoSistemas, data.telefono, data.email, data.grupo, data.activo == true ? 1 : 0);
DataBaseSettings db = new DataBaseSettings();
await db.ExecuteQuery(query);
} catch (Exception ex)
{
throw ex;
}
}
public async Task UpdateStatus(Cliente data)
{
try
{
String query = String.Format("UPDATE Clientes SET Estatus = {0} WHERE IDCliente = {1}", data.activo == true ? 1 : 0, data.idCliente);
DataBaseSettings db = new DataBaseSettings();
await db.ExecuteQuery(query);
} catch (Exception ex)
{
throw ex;
}
}
public async Task Delete(String idUser)
{
try
{
String query = String.Format("DELETE FROM AspNetUsers WHERE Id = '{0}'", idUser);
DataBaseSettings db = new DataBaseSettings();
await db.ExecuteQuery(query);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task UpdateStatus(IDUser user)
{
try
{
String query = String.Format("UPDATE AspNetUsers SET Enabled = {0} WHERE ID = '{1}'", user.status == true ? 1 : 0, user.idUser);
DataBaseSettings db = new DataBaseSettings();
await db.ExecuteQuery(query);
}
catch (Exception ex)
{
throw ex;
}
}
private async Task InsertDetails(InsertDetailsOrdenEntrega data)
{
try
{
String query = String.Format(@" xsp_InsertProducts_DeliveryOrder
{0}, {1}, {2}", data.idProducto, data.idOrdenEntrega, data.cantidad);
DataBaseSettings db = new DataBaseSettings();
await db.ExecuteQuery(query);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task GuardarFirmas(Images data)
{
try
{
foreach (byte[] array in data.images)
{
String query = String.Format(@"INSERT INTO Firmas
(IDHistorialEntrega, Firma)
VALUES
({0}, CONVERT(VARBINARY(MAX), '{1}{2}', 1))", data.idHistorialEntrega, "0x", new StringBuilder(BitConverter.ToString(array).ToLower()).Replace("-", string.Empty));
DataBaseSettings db = new DataBaseSettings();
await db.ExecuteQuery(query);
}
}
catch (Exception ex)
{
throw ex;
}
}
