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); } }