/// <summary>
/// Deletes a record from the ComprobanteDetalle table by a foreign key.
/// </summary>
public void DeleteAllByIdProducto(int idProducto)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdProducto", idProducto)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "ComprobanteDetalleDeleteAllByIdProducto", parameters);
}
/// <summary>
/// Deletes a record from the TipoComprobante table by its primary key.
/// </summary>
public void Delete(int idTipoComprobante)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdTipoComprobante", idTipoComprobante)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "TipoComprobanteDelete", parameters);
}
/// <summary>
/// Deletes a record from the KHACH_HANG table by its primary key.
/// </summary>
public void Delete(int Ma)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MA", Ma)
};
SqlClientUtility.ExecuteNonQuery(m_ConnectionString, CommandType.StoredProcedure, "PROC_KhachHang_Delete", parameters);
}
/// <summary>
/// Deletes a record from the sol_WorkStations table by a foreign key.
/// </summary>
public virtual void _DeleteAllByConveyorID(int conveyorID)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ConveyorID", conveyorID)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "sol_WorkStations_DeleteAllByConveyorID", parameters);
}
/// <summary>
/// Deletes a record from the MonedaEmpresa table by a foreign key.
/// </summary>
public void DeleteAllByIdMoneda(int idMoneda)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdMoneda", idMoneda)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "MonedaEmpresaDeleteAllByIdMoneda", parameters);
}
/// <summary>
/// Deletes a record from the EstadoPago table by its primary key.
/// </summary>
public void Delete(int idEstadoPago)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdEstadoPago", idEstadoPago)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "EstadoPagoDelete", parameters);
}
/// <summary>
/// Deletes a record from the CT_DON_DAT_HANG table by a foreign key.
/// </summary>
public void DeleteAllByMaMau(string MaMau)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MA_MAU", MaMau)
};
SqlClientUtility.ExecuteNonQuery(m_ConnectionString, CommandType.StoredProcedure, "PROC_CtDonDatHangDeleteAllByMaMau", parameters);
}
/// <summary>
/// Deletes a record from the StockSucursal table by a foreign key.
/// </summary>
public void DeleteAllByIdSucursal(int idSucursal)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdSucursal", idSucursal)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "StockSucursalDeleteAllByIdSucursal", parameters);
}
public void EliminarIdItemOrdenDeTrabajo(int IdItem)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdItemOrdenDeTrabajo", IdItem)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "ItemDelete", parameters);
}
/// <summary>
/// Deletes a record from the UsuarioPatente table by a foreign key.
/// </summary>
public void DeleteAllByIdPatente(int idPatente)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdPatente", idPatente)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "UsuarioPatenteDeleteAllByIdPatente", parameters);
}
/// <summary>
/// Deletes a record from the Sol_WS_ShippingContainerTypes table by its primary key.
/// </summary>
public virtual void Delete(int shippingContainerTypeID)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ShippingContainerTypeID", shippingContainerTypeID)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sol_WS_ShippingContainerTypes_Delete", parameters);
}
/// <summary>
/// Deletes a record from the Direccion table by a foreign key.
/// </summary>
public void DeleteAllByIdTipoDireccion(int idTipoDireccion)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdTipoDireccion", idTipoDireccion)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "DireccionDeleteAllByIdTipoDireccion", parameters);
}
/// <summary>
/// Deletes a record from the Qds_Settings table by its primary key.
/// </summary>
public virtual void Delete(string name)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Name", name)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Qds_Settings_Delete", parameters);
}
/// <summary>
/// Deletes a record from the Pago table by a foreign key.
/// </summary>
public void DeleteAllByIdPedido(int idPedido)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdPedido", idPedido)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "PagoDeleteAllByIdPedido", parameters);
}
/// <summary>
/// Deletes a record from the Sol_EmployeesLog table by a foreign key.
/// </summary>
public virtual void _DeleteAllByUserId(Guid userId)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@UserId", userId)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sol_EmployeesLog_DeleteAllByUserId", parameters);
}
/// <summary>
/// Deletes a record from the Vir_ConveyorLink table by its primary key.
/// </summary>
public virtual void Delete(int conveyorLinkID)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ConveyorLinkID", conveyorLinkID)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Vir_ConveyorLink_Delete", parameters);
}
/// <summary>
/// Deletes a record from the Qds_PaymentMethodAvailableByDepot table by a foreign key.
/// </summary>
public virtual void _DeleteAllByPaymentMethodID(int paymentMethodID)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@PaymentMethodID", paymentMethodID)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Qds_PaymentMethodAvailableByDepot_DeleteAllByPaymentMethodID", parameters);
}
/// <summary>
/// Deletes a record from the Vir_ConveyorLink table by a foreign key.
/// </summary>
public virtual void _DeleteAllByBagPositionID(int bagPositionID)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@BagPositionID", bagPositionID)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Vir_ConveyorLink_DeleteAllByBagPositionID", parameters);
}
/// <summary>
/// Deletes a record from the CT_DON_DAT_HANG table by a foreign key.
/// </summary>
public void DeleteAllByMaDonDatHang(int MaDonDatHang)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MA_DON_DAT_HANG", MaDonDatHang)
};
SqlClientUtility.ExecuteNonQuery(m_ConnectionString, CommandType.StoredProcedure, "PROC_CtDonDatHangDeleteAllByMaDonDatHang", parameters);
}
/// <summary>
/// Deletes a record from the sol_StandardDozen table by its primary key.
/// </summary>
public virtual void Delete(int standardDozenID)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@StandardDozenID", standardDozenID)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "sol_StandardDozen_Delete", parameters);
}
/// <summary>
/// Deletes a record from the sol_WorkStations table by its primary key.
/// </summary>
public virtual void Delete(int workStationID)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@WorkStationID", workStationID)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "sol_WorkStations_Delete", parameters);
}
public void Delete(int idProvincia)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdProvincia", idProvincia)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "ProvinciaDelete", parameters);
}
/// <summary>
/// Deletes a record from the MonedaEmpresa table by a foreign key.
/// </summary>
public void DeleteAllByCUIT(string CUIT)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@CUIT", CUIT)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "MonedaEmpresaDeleteAllByCUIT", parameters);
}
/// <summary>
/// Deletes a record from the Sol_EmployeesLog table by its primary key.
/// </summary>
public virtual void Delete(long logId)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@LogId", logId)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sol_EmployeesLog_Delete", parameters);
}
/// <summary>
/// Deletes a record from the sol_Payments table by a foreign key.
/// </summary>
public virtual void _DeleteAllByCustomerID(int customerID)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@CustomerID", customerID)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "sol_Payments_DeleteAllByCustomerID", parameters);
}
/// <summary>
/// Deletes a record from the LenguajeControl table by its primary key.
/// </summary>
public void Delete(string texto, int idLenguaje)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Texto", texto),
new SqlParameter("@IdLenguaje", idLenguaje)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "LenguajeControlDelete", parameters);
}
/// <summary>
/// Updates a record in the sol_Stage table.
/// </summary>
public virtual void UpdateStatusByShipmentId(int shipmentId, string status)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ShipmentID", shipmentId),
new SqlParameter("@Status", status)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "sol_Stage_UpdateStatusByShipmentId", parameters);
}
/// <summary>
/// Deletes a record from the Telefono table by a foreign key.
/// </summary>
public void DeleteAllByCUIT_NombreUsuario(string cuit, string nombreUsuario)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@cuit", cuit),
new SqlParameter("@NombreUsuario", nombreUsuario)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "TelefonoDeleteAllByCUIT_NombreUsuario", parameters);
}
/// <summary>
/// Deletes a record from the sol_Stage table by a foreign key.
/// </summary>
public virtual void _DeleteAllByShipmentIdTagNumber(int shipmentID, string tagNumber)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ShipmentID", shipmentID),
new SqlParameter("@TagNumber", tagNumber)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "sol_Stage_DeleteAllByShipmentIdTagNumber", parameters);
}
public void PedidoActualizarNroTracking(int elIdPedido, string elNroTracking)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@elIdPedido", elIdPedido),
new SqlParameter("@elNroTracking", elNroTracking)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "PedidoActualizarNroTracking", parameters);
}