public static string AskCloseBox()
{
// Table to store the query results
DataTable table = new DataTable();
// Class to store the table
BoxTable boxTable;
// Creates a SQL connection
string strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (var connection = new SqlConnection(strConnString))
{
connection.Open();
// Creates a SQL command
using (var command = new SqlCommand("SELECT * FROM View_AskBox", connection))
{
// Loads the query results into the table
table.Load(command.ExecuteReader());
}
boxTable = new BoxTable(table);
connection.Close();
}
string json = JsonConvert.SerializeObject(boxTable);
return(json);
}
public static string GetBox(string date)
{
// Table to store the query results
DataTable table = new DataTable();
DateTime dateTime = Convert.ToDateTime(date);
// Class to store the table
BoxTable boxTable;
// Creates a SQL connection
string strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (var connection = new SqlConnection(strConnString))
{
connection.Open();
// Creates a SQL command
using (var command = new SqlCommand("SELECT * FROM View_FullBox WHERE fecha_cierre_caja = @CloseBoxDate", connection))
{
// Loads the query results into the table
command.Parameters.AddWithValue("@CloseBoxDate", dateTime);
table.Load(command.ExecuteReader());
}
boxTable = new BoxTable(table);
connection.Close();
}
string json = JsonConvert.SerializeObject(boxTable);
return(json);
}
