public static void FilterDrugs(FilterDrugsCategory category, int intParameter = 0)
{
try
{
sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
switch (category)
{
case FilterDrugsCategory.DrugQuantity:
query = "select Quantity from Warehouse where DrugID = '" + intParameter + "'";
SqlCommand command = new SqlCommand(query, sqlConnection);
string message = command.ExecuteScalar().ToString();
MessageBox.Show(message, "Количество");
break;
}
sqlConnection.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
finally
{
sqlConnection.Close();
}
}
public static void FilterDrugs(FilterDrugsCategory category, DataGridView dgv, DateTime dateStart, DateTime dateEnd)
{
try
{
dataset = new DataTable();
sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
var comm = sqlConnection.CreateCommand();
comm.CommandText = "select * from Documents where ProvisionDate between @dateStart and @dateEnd";
comm.Parameters.Add(new SqlParameter {
ParameterName = "dateStart", SqlDbType = SqlDbType.Date, Value = dateStart
});
comm.Parameters.Add(new SqlParameter {
ParameterName = "dateEnd", SqlDbType = SqlDbType.Date, Value = dateEnd
});
adapter = new SqlDataAdapter(comm);
adapter.Fill(dataset);
dgv.DataSource = dataset;
sqlConnection.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
finally
{
sqlConnection.Close();
}
}
public static void FilterDrugs(FilterDrugsCategory category, DataGridView dgv, int intParameter = 0)
{
try
{
dataset = new DataTable();
sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
switch (category)
{
case FilterDrugsCategory.ByManufacturer:
query = "select * from Drugs where Manufacturer = '" + intParameter + "'";
break;
case FilterDrugsCategory.BySum:
query = "select * from Drugs where Price > '" + intParameter + "'";
break;
}
adapter = new SqlDataAdapter(query, sqlConnection);
adapter.Fill(dataset);
dgv.DataSource = dataset;
sqlConnection.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
finally
{
sqlConnection.Close();
}
}
