/// <summary>
/// Updates a record in the sol_EntriesDetail table.
/// </summary>
public virtual void Update(Sol_EntriesDetail sol_EntriesDetail)
{
ValidationUtility.ValidateArgument("sol_EntriesDetail", sol_EntriesDetail);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@DetailID", sol_EntriesDetail.DetailID),
new SqlParameter("@EntryID", sol_EntriesDetail.EntryID),
new SqlParameter("@EntryType", sol_EntriesDetail.EntryType),
new SqlParameter("@CashID", sol_EntriesDetail.CashID),
new SqlParameter("@Count", sol_EntriesDetail.Count)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "sol_EntriesDetail_Update", parameters);
}
/// <summary>
/// Selects all records from the Usuario table by a foreign key.
/// </summary>
public List <UsuarioEntidad> SelectAllByIdCondicionFiscal(int idCondicionFiscal)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdCondicionFiscal", idCondicionFiscal)
};
using (DataTable dt = SqlClientUtility.ExecuteDataTable(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "UsuarioSelectAllByIdCondicionFiscal", parameters))
{
List <UsuarioEntidad> lista = new List <UsuarioEntidad>();
lista = Mapeador.Mapear <UsuarioEntidad>(dt);
return(lista);
}
}
public void UsuarioUpdateDatosPersonalesConDNI(UsuarioEntidad usuario)
{
ValidationUtility.ValidateArgument("usuario", usuario);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Nombre", usuario.Nombre),
new SqlParameter("@Apellido", usuario.Apellido),
new SqlParameter("@Email", usuario.Email),
new SqlParameter("@NroIdentificacion", usuario.NroIdentificacion),
new SqlParameter("@IdUsuario", usuario.IdUsuario)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "UsuarioUpdateDatosPersonalesConDNI", parameters);
}
/// <summary>
/// Updates a record in the BitacoraLog table.
/// </summary>
public void Update(BitacoraLogEntidad bitacoraLog)
{
ValidationUtility.ValidateArgument("bitacoraLog", bitacoraLog);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdBitacoraLog", bitacoraLog.IdBitacoraLog),
new SqlParameter("@CUIT", bitacoraLog.CUIT),
new SqlParameter("@NombreUsuario", bitacoraLog.NombreUsuario),
new SqlParameter("@Evento", bitacoraLog.Evento),
new SqlParameter("@FechaEvento", bitacoraLog.FechaEvento)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "BitacoraLogUpdate", parameters);
}
public List <DireccionEntidad> SelectDireccionesDeUsuarioActuales(string elCUIT, string elNombreUsuario)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@elCUIT", elCUIT),
new SqlParameter("@elNombreUsuario", elNombreUsuario)
};
using (DataSet dt = SqlClientUtility.ExecuteDataSet(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "SelectDireccionesDeUsuarioActuales", parameters))
{
List <DireccionEntidad> unasDirecciones = new List <DireccionEntidad>();
unasDirecciones = MapearMuchos(dt);
return(unasDirecciones);
}
}
/// <summary>
/// Creates a new instance of the Qds_Drop class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Qds_Drop MakeQds_Drop(SqlDataReader dataReader)
{
Qds_Drop qds_Drop = new Qds_Drop();
qds_Drop.DropID = SqlClientUtility.GetInt32(dataReader, "DropID", 0);
qds_Drop.CustomerID = SqlClientUtility.GetInt32(dataReader, "CustomerID", 0);
qds_Drop.NumberOfBags = SqlClientUtility.GetInt32(dataReader, "NumberOfBags", 0);
qds_Drop.PaymentMethodID = SqlClientUtility.GetInt32(dataReader, "PaymentMethodID", 0);
qds_Drop.DepotID = SqlClientUtility.GetString(dataReader, "DepotID", String.Empty);
qds_Drop.OrderID = SqlClientUtility.GetInt32(dataReader, "OrderID", 0);
qds_Drop.OrderType = SqlClientUtility.GetString(dataReader, "OrderType", String.Empty);
//qds_Drop.IsNew = SqlClientUtility.GetBoolean(dataReader, "IsNew", false);
return(qds_Drop);
}
/// <summary>
/// Updates a record in the sol_CashTrays table.
/// </summary>
public virtual void Update(Sol_CashTray sol_CashTray)
{
ValidationUtility.ValidateArgument("sol_CashTray", sol_CashTray);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@CashTrayID", sol_CashTray.CashTrayID),
new SqlParameter("@Description", sol_CashTray.Description),
new SqlParameter("@WorkStationID", sol_CashTray.WorkStationID),
new SqlParameter("@UserID", sol_CashTray.UserID),
new SqlParameter("@UserName", sol_CashTray.UserName)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "sol_CashTrays_Update", parameters);
}
public int Insert(RecursoEntidad recurso)
{
ValidationUtility.ValidateArgument("recurso", recurso);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@CUIT", recurso.CUIT),
new SqlParameter("@Recurso", recurso.Recurso),
new SqlParameter("@Url", recurso.Url)
};
var valor = Convert.ToInt32(SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "RecursoInsert", parameters));
return(valor);
}
/// <summary>
/// Creates a new instance of the sol_CashDenominations class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_CashDenomination MakeSol_CashDenomination(SqlDataReader dataReader)
{
Sol_CashDenomination sol_CashDenomination = new Sol_CashDenomination();
sol_CashDenomination.CashID = SqlClientUtility.GetInt32(dataReader, "CashID", 0);
sol_CashDenomination.CashType = SqlClientUtility.GetByte(dataReader, "CashType", 0x00);
sol_CashDenomination.CashValue = SqlClientUtility.GetDecimal(dataReader, "CashValue", Decimal.Zero);
sol_CashDenomination.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
sol_CashDenomination.OrderValue = SqlClientUtility.GetInt16(dataReader, "OrderValue", 0);
sol_CashDenomination.CashItemValue = SqlClientUtility.GetDecimal(dataReader, "CashItemValue", Decimal.Zero);
sol_CashDenomination.Quantity = SqlClientUtility.GetInt32(dataReader, "Quantity", 0);
sol_CashDenomination.MoneyID = SqlClientUtility.GetInt32(dataReader, "MoneyID", 0);
return(sol_CashDenomination);
}
/// <summary>
/// Saves a record to the sol_Containers table.
/// </summary>
public virtual void Insert(Sol_Container sol_Container)
{
ValidationUtility.ValidateArgument("sol_Container", sol_Container);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Description", sol_Container.Description),
new SqlParameter("@ShortDescription", sol_Container.ShortDescription),
new SqlParameter("@ContainerTypeID", sol_Container.ContainerTypeID),
new SqlParameter("@ShippingContainerID", sol_Container.ShippingContainerID),
new SqlParameter("@ShippingContainerTypeID", sol_Container.ShippingContainerTypeID)
};
sol_Container.ContainerID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "sol_Containers_Insert", parameters);
}
/// <summary>
/// Updates a record in the PedidoDetalle table.
/// </summary>
public void Update(PedidoDetalleEntidad pedidoDetalle)
{
ValidationUtility.ValidateArgument("pedidoDetalle", pedidoDetalle);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdPedidoDetalle", pedidoDetalle.IdPedidoDetalle),
new SqlParameter("@IdPedido", pedidoDetalle.IdPedido),
new SqlParameter("@Cantidad", pedidoDetalle.Cantidad),
new SqlParameter("@PrecioUnitario", pedidoDetalle.PrecioUnitario),
new SqlParameter("@IdProducto", pedidoDetalle.miProducto.IdProducto)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "PedidoDetalleUpdate", parameters);
}
public List <TarjetaEntidad> ListaTarjetasDAL(int Id)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdUsuario", Id),
};
using (DataSet ds = SqlClientUtility.ExecuteDataSet(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "SelectTarjeta", parameters))
{
List <TarjetaEntidad> ListaMisTarjetas = new List <TarjetaEntidad>();
ListaMisTarjetas = MapearMisTarjetas(ds);
return(ListaMisTarjetas);
}
}
/// <summary>
/// Updates a record in the BIEN_NHAN table.
/// </summary>
public void Update(BIENNHAN_DTO BienNhan)
{
ValidationUtility.ValidateArgument("BienNhan", BienNhan);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MA", BienNhan.Ma),
new SqlParameter("@MA_HOA_DON", BienNhan.MaHoaDon),
new SqlParameter("@NGAY_THANH_TOAN", BienNhan.NgayThanhToan),
new SqlParameter("@MA_NHAN_VIEN", BienNhan.MaNhanVien),
new SqlParameter("@SO_TIEN", BienNhan.SoTien)
};
SqlClientUtility.ExecuteNonQuery(m_ConnectionString, CommandType.StoredProcedure, "PROC_BienNhan_Update", parameters);
}
/// <summary>
/// Saves a record to the Sol_Categories table.
/// </summary>
public virtual void Insert(Sol_Category Sol_Category)
{
ValidationUtility.ValidateArgument("Sol_Category", Sol_Category);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Description", Sol_Category.Description),
new SqlParameter("@RefundAmount", Sol_Category.RefundAmount),
new SqlParameter("@SubContainerQuantity", Sol_Category.SubContainerQuantity),
new SqlParameter("@StagingMethodID", Sol_Category.StagingMethodID),
new SqlParameter("@StagingProductID", Sol_Category.StagingProductID)
};
Sol_Category.CategoryID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Sol_Categories_Insert", parameters);
}
/// <summary>
/// Selects all records from the Reserva table by a foreign key.
/// </summary>
public List <ReservaEntidad> SelectAllByIdSucursal(int idSucursal)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdSucursal", idSucursal)
};
using (DataTable dt = SqlClientUtility.ExecuteDataTable(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "ReservaSelectAllByIdSucursal", parameters))
{
List <ReservaEntidad> reservas = new List <ReservaEntidad>();
reservas = Mapeador.Mapear <ReservaEntidad>(dt);
return(reservas);
}
}
/// <summary>
/// Selects all records from the Location table.
/// </summary>
public virtual List <Location> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "LocationSelectAll"))
{
List <Location> locationList = new List <Location>();
while (dataReader.Read())
{
Location location = MakeLocation(dataReader);
locationList.Add(location);
}
dataReader.Close();
return(locationList);
}
}
/// <summary>
/// Updates a record in the Encargado table.
/// </summary>
public void Update(EncargadoEntidad encargado)
{
ValidationUtility.ValidateArgument("encargado", encargado);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@NumCedula", encargado.NumCedula),
new SqlParameter("@Nombre", encargado.Nombre),
new SqlParameter("@Apellidos", encargado.Apellidos),
new SqlParameter("@TelefonoDomicilio", encargado.TelefonoDomicilio),
new SqlParameter("@TelefonoCelular", encargado.TelefonoCelular)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "EncargadoUpdate", parameters);
}
public void Insert(ListaDeDeseoEntidad listaDeseo)
{
ValidationUtility.ValidateArgument("listaDeseo", listaDeseo);
SqlParameter[] parameters = new SqlParameter[]
{
//new SqlParameter("@IdDeseo", listaDeseo.IdDeseo),
new SqlParameter("@NumeroDocumento", listaDeseo.NumeroDocumento),
new SqlParameter("@NombreUsuario", listaDeseo.NombreUsuario),
new SqlParameter("@IdServicio", listaDeseo.IdServicio),
new SqlParameter("@IdEstado", 1)
};
SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "ListaDeseosInsert", parameters);
}
/// <summary>
/// Selects all records from the Sucursal table by a foreign key.
/// </summary>
public List <SucursalEntidad> SelectAllByCUIT(int cUIT)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@CUIT", cUIT)
};
using (DataTable dt = SqlClientUtility.ExecuteDataTable(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "SucursalSelectAllByCUIT", parameters))
{
List <SucursalEntidad> lista = new List <SucursalEntidad>();
lista = Mapeador.Mapear <SucursalEntidad>(dt);
return(lista);
}
}
/// <summary>
/// Updates a record in the Usuario table.
/// </summary>
public void Update(UsuarioEntidad usuario)
{
ValidationUtility.ValidateArgument("usuario", usuario);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdUsuario", usuario.IdUsuario),
new SqlParameter("@Rol", usuario.Rol),
new SqlParameter("@Usuario", usuario.Usuario),
new SqlParameter("@Clave", usuario.Clave),
new SqlParameter("@Nombre", usuario.Nombre)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "UsuarioUpdate", parameters);
}
/// <summary>
/// Selects all records from the Producto table by a foreign key.
/// </summary>
public List <ProductoEntidad> SelectAllByIdMarca(int idMarca)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdMarca", idMarca)
};
using (DataTable dt = SqlClientUtility.ExecuteDataTable(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "ProductoSelectAllByIdMarca", parameters))
{
List <ProductoEntidad> productoEntidadList = new List <ProductoEntidad>();
productoEntidadList = Mapeador.Mapear <ProductoEntidad>(dt);
return(productoEntidadList);
}
}
/// <summary>
/// Saves a record to the CHI_TIET_HOA_DON table.
/// </summary>
public void Insert(CHITIETHOADON_DTO ChiTietHoaDon)
{
ValidationUtility.ValidateArgument("ChiTietHoaDon", ChiTietHoaDon);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MA_HOA_DON", ChiTietHoaDon.MaHoaDon),
new SqlParameter("@MA_XE", ChiTietHoaDon.MaXe),
new SqlParameter("@MA_MAU", ChiTietHoaDon.MaMau),
new SqlParameter("@SO_LUONG", ChiTietHoaDon.SoLuong),
new SqlParameter("@THANH_TIEN", ChiTietHoaDon.ThanhTien)
};
ChiTietHoaDon.Ma = (int)SqlClientUtility.ExecuteScalar(m_ConnectionString, CommandType.StoredProcedure, "PROC_ChiTietHoaDon_Insert", parameters);
}
/// <summary>
/// Saves a record to the Telefono table.
/// </summary>
public void Insert(TelefonoEntidad telefono)
{
ValidationUtility.ValidateArgument("telefono", telefono);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@CUIT", telefono.CUIT),
new SqlParameter("@NombreUsuario", telefono.NombreUsuario),
new SqlParameter("@NroTelefono", telefono.NroTelefono),
new SqlParameter("@CodArea", telefono.CodArea),
new SqlParameter("@IdTipoTel", telefono.IdTipoTel)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "TelefonoInsert", parameters);
}
/// <summary>
/// Updates a record in the Sac_Money table.
/// </summary>
public virtual void Update(Sac_Money sac_Money)
{
ValidationUtility.ValidateArgument("sac_Money", sac_Money);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MoneyID", sac_Money.MoneyID),
new SqlParameter("@Name", sac_Money.Name),
new SqlParameter("@TypeID", sac_Money.TypeID),
new SqlParameter("@DollarValue", sac_Money.DollarValue),
new SqlParameter("@CountryCode", sac_Money.CountryCode)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sac_Money_Update", parameters);
}
/// <summary>
/// Saves a record to the Syc_UpdateLog table.
/// </summary>
public virtual void Insert(Syc_UpdateLog syc_UpdateLog)
{
ValidationUtility.ValidateArgument("syc_UpdateLog", syc_UpdateLog);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@TableName", syc_UpdateLog.TableName),
new SqlParameter("@IDName", syc_UpdateLog.IDName),
new SqlParameter("@IDValue", syc_UpdateLog.IDValue),
new SqlParameter("@ColumnName", syc_UpdateLog.ColumnName),
new SqlParameter("@ColumnData", syc_UpdateLog.ColumnData)
};
syc_UpdateLog.TempID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Syc_UpdateLog_Insert", parameters);
}
/// <summary>
/// Creates a new instance of the HOA_DON class and populates it with data from the specified SqlDataReader.
/// </summary>
private HOADON_DTO MakeHOADON_DTO(SqlDataReader dataReader)
{
HOADON_DTO HoaDon = new HOADON_DTO();
HoaDon.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
HoaDon.MaKhachHang = SqlClientUtility.GetInt32(dataReader, "MA_KHACH_HANG", 0);
HoaDon.MaNhanVien = SqlClientUtility.GetInt32(dataReader, "MA_NHAN_VIEN", 0);
HoaDon.NgayLap = SqlClientUtility.GetDateTime(dataReader, "NGAY_LAP", DateTime.Now);
HoaDon.KieuThanhToan = SqlClientUtility.GetBoolean(dataReader, "KIEU_THANH_TOAN", false);
HoaDon.TongTien = SqlClientUtility.GetDecimal(dataReader, "TONG_TIEN", Decimal.Zero);
HoaDon.TienTraMoiDot = SqlClientUtility.GetDecimal(dataReader, "TIEN_TRA_MOI_DOT", Decimal.Zero);
HoaDon.SoLanTra = SqlClientUtility.GetInt32(dataReader, "SO_LAN_TRA", 0);
return(HoaDon);
}
public List <UsuarioEntidad> EmpresasConMasPedidos(string CUIT)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@CUIT", CUIT)
};
using (DataTable dt = SqlClientUtility.ExecuteDataTable(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "rankingEmpresas", parameters))
{
List <UsuarioEntidad> lista = new List <UsuarioEntidad>();
lista = Mapeador.Mapear <UsuarioEntidad>(dt);
return(lista);
}
}
/// <summary>
/// Saves a record to the Reserva table.
/// </summary>
public void Insert(ReservaEntidad reserva)
{
ValidationUtility.ValidateArgument("reserva", reserva);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdPedido", reserva.IdPedido),
new SqlParameter("@IdPedidoDetalle", reserva.IdPedidoDetalle),
new SqlParameter("@IdSucursal", reserva.IdSucursal),
new SqlParameter("@Activo", reserva.Activo),
new SqlParameter("@Fecha", reserva.Fecha)
};
reserva.IdReserva = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "ReservaInsert", parameters);
}
/// <summary>
/// Updates a record in the Pago table.
/// </summary>
public void Update(PagoEntidad pago)
{
ValidationUtility.ValidateArgument("pago", pago);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdPedido", pago.IdPedido),
new SqlParameter("@FechaPago", pago.FechaPago),
new SqlParameter("@IdFormaPago", pago.miFormaPago.IdFormaPago),
new SqlParameter("@MontoPago", pago.MontoPago),
new SqlParameter("@CUIT", pago.CUIT)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "PagoUpdate", parameters);
}
/// <summary>
/// Updates a record in the sol_WorkStations table.
/// </summary>
public virtual void Update(Sol_WorkStation sol_WorkStation)
{
ValidationUtility.ValidateArgument("sol_WorkStation", sol_WorkStation);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@WorkStationID", sol_WorkStation.WorkStationID),
new SqlParameter("@Name", sol_WorkStation.Name),
new SqlParameter("@Description", sol_WorkStation.Description),
new SqlParameter("@Location", sol_WorkStation.Location),
new SqlParameter("@ConveyorID", sol_WorkStation.ConveyorID)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "sol_WorkStations_Update", parameters);
}