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