public void close(AperturaDeCajaEnt aperturaDeCaja)
{
SqlConnection sqlConnection = new SqlConnection(ConexionDal.connectionString);
SqlCommand sqlCommand = sqlConnection.CreateCommand();
sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = "Update Apertura_De_Caja Set Cerrado = 1 Where Cerrado = 1 And Id = @Id";
sqlCommand.Parameters.AddWithValue("@Id", aperturaDeCaja.ID);
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
public int exist(AperturaDeCajaEnt aperturaDeCaja)
{
SqlConnection sqlConnection = new SqlConnection(ConexionDal.connectionString);
SqlCommand sqlCommand = sqlConnection.CreateCommand();
sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = "Select Count(Id) From Apertura_De_Caja Where Cerrado = 0 And Id_Caja = @Id_Caja";
sqlCommand.Parameters.AddWithValue("@Id_Caja", aperturaDeCaja.ID_CAJA);
sqlConnection.Open();
int exist = Convert.ToInt32(sqlCommand.ExecuteScalar());
sqlConnection.Close();
return exist;
}
public DataTable get(AperturaDeCajaEnt aperturaDeCaja)
{
SqlConnection sqlConnection = new SqlConnection(ConexionDal.connectionString);
SqlCommand sqlCommand = sqlConnection.CreateCommand();
sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = "Select Id, Monto From Apertura_De_Caja Where Cerrado = 0 And Id_Usuario = @Id_Usuario "
+ "And Id_Caja = @Id_Caja";
sqlCommand.Parameters.AddWithValue("@Id_Usuario", aperturaDeCaja.ID_USUARIO);
sqlCommand.Parameters.AddWithValue("@Id_Caja", aperturaDeCaja.ID_CAJA);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
DataTable dataTable = new DataTable("AperturaDeCaja");
sqlDataAdapter.SelectCommand = sqlCommand;
sqlDataAdapter.Fill(dataTable);
return dataTable;
}
public int add(AperturaDeCajaEnt aperturaDeCaja)
{
SqlConnection sqlConnection = new SqlConnection(ConexionDal.connectionString);
SqlCommand sqlCommand = sqlConnection.CreateCommand();
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "insertarAperturaDeCaja";
sqlCommand.Parameters.AddWithValue("@Id_Usuario", aperturaDeCaja.ID_USUARIO);
sqlCommand.Parameters.AddWithValue("@Id_Caja", aperturaDeCaja.ID_CAJA);
sqlCommand.Parameters.AddWithValue("@Hora", aperturaDeCaja.HORA);
sqlCommand.Parameters.AddWithValue("@Monto", aperturaDeCaja.MONTO);
sqlConnection.Open();
int id = Convert.ToInt32(sqlCommand.ExecuteScalar());
sqlConnection.Close();
return id;
}
public int getId(AperturaDeCajaEnt aperturaDeCaja)
{
return objetoAperturaDeCaja.getId(aperturaDeCaja);
}
public DataTable get(AperturaDeCajaEnt aperturaDeCaja)
{
return objetoAperturaDeCaja.get(aperturaDeCaja);
}
public int exists(AperturaDeCajaEnt aperturaDeCaja)
{
return objetoAperturaDeCaja.exists(aperturaDeCaja);
}
public void close(AperturaDeCajaEnt aperturaDeCaja)
{
objetoAperturaDeCaja.close(aperturaDeCaja);
}
public int add(AperturaDeCajaEnt aperturaDeCaja)
{
return objetoAperturaDeCaja.add(aperturaDeCaja);
}
public int getId(AperturaDeCajaEnt aperturaDeCaja)
{
SqlConnection sqlConnection = new SqlConnection(ConexionDal.connectionString);
SqlCommand sqlCommand = sqlConnection.CreateCommand();
sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = "Select Id From Apertura_De_Caja Where Cerrado = 0 And Id_Usuario = @Id_Usuario "
+ "And Id_Caja = @Id_Caja";
sqlCommand.Parameters.AddWithValue("@Id_Usuario", aperturaDeCaja.ID_USUARIO);
sqlCommand.Parameters.AddWithValue("@Id_Caja", aperturaDeCaja.ID_CAJA);
sqlConnection.Open();
int id = Convert.ToInt32(sqlCommand.ExecuteScalar());
sqlConnection.Close();
return id;
}