public List <SmartDelivery> GetSmartDeliveriesByDate(DateTime date)
{
const string storedProcedureName = Constants.GetSmartDeliveriesByDate;
using (SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString))
{
SqlCommand command = new SqlCommand(storedProcedureName, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(Constants.DeliveryDate, SqlDbType.Date);
command.Parameters[Constants.DeliveryDate].Value = date;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
SmartDelivery delivery = null;
List <SmartDelivery> deliveriesList = new List <SmartDelivery>();
while (reader.Read())
{
delivery = new SmartDelivery
{
DeliveryID = Convert.ToInt32(reader.GetValue(0)),
DeliveryDate = Convert.ToDateTime(reader.GetValue(1)),
PlaceAddress = reader.GetValue(2).ToString(),
EmployeeFullName = reader.GetValue(3).ToString()
};
deliveriesList.Add(delivery);
}
connection.Close();
return(deliveriesList);
}
}
public SmartDelivery GetSmartDeliveryByIDs(int detaineeID, int detentionID)
{
const string storedProcedureName = Constants.GetSmartDeliveriesByIDs;
using (SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString))
{
SqlCommand command = new SqlCommand(storedProcedureName, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(Constants.DetaineeID, SqlDbType.Int);
command.Parameters[Constants.DetaineeID].Value = detaineeID;
command.Parameters.Add(Constants.DetentionID, SqlDbType.Int);
command.Parameters[Constants.DetentionID].Value = detentionID;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
SmartDelivery delivery = null;
while (reader.Read())
{
delivery = new SmartDelivery
{
DeliveryID = Convert.ToInt32(reader.GetValue(0)),
DeliveryDate = Convert.ToDateTime(reader.GetValue(1)),
PlaceAddress = reader.GetValue(2).ToString(),
EmployeeFullName = reader.GetValue(3).ToString()
};
}
connection.Close();
return(delivery);
}
}
