public string InsertDelivery(DeliveryDays delivery, string zipCode)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
// 1. create a command object identifying the stored procedure
SqlCommand cmd = new SqlCommand("AddDelivery", conn);
// 2. set the command object so it knows to execute a stored procedure
cmd.CommandType = CommandType.StoredProcedure;
// 3. add parameter to command, which will be passed to the stored procedure
cmd.Parameters.Add(new SqlParameter("@zipCode", zipCode));
cmd.Parameters.Add(new SqlParameter("@mobileText", delivery.mobileText));
cmd.Parameters.Add(new SqlParameter("@date", delivery.date));
cmd.Parameters.Add(new SqlParameter("@text", delivery.text));
cmd.Parameters.Add(new SqlParameter("@active", delivery.active));
cmd.Parameters.Add(new SqlParameter("@inMonth", delivery.inMonth));
cmd.Parameters.Add(new SqlParameter("@cheapestAmount", delivery.cheapestAmount));
// execute the command
using (SqlDataReader rdr = cmd.ExecuteReader())
{
// iterate through results, printing each to console
while (rdr.Read())
{
return(rdr["deliveryId"].ToString());
}
}
return("");
}
}
public override void Selected(UIPickerView picker, nint row, nint component)
{
if (DeliveryDays.IsNullOrEmpty() || (int)row >= DeliveryDays.Count)
{
return;
}
if (component == 0)
{
SelectedDay = DeliveryDays[(int)row];
picker.ReloadComponent(1);
var sameValueRow = SelectedDay?.Times?.FindIndex(x => x.Name.Equals(SelectedTime?.Name)) ?? -1;
var newTimeRow = (sameValueRow > 0 ? sameValueRow : 0);
picker.Select(newTimeRow, 1, true);
SelectedTime = SelectedDay.Times[newTimeRow];
}
else
{
SelectedTime = SelectedDay.Times[(int)row];
}
SelectedItem = SelectedTime;
if (SelectedChangedCommand != null && SelectedChangedCommand.CanExecute(SelectedItem))
{
SelectedChangedCommand.Execute(SelectedItem);
}
}
protected override void CollectionChangedOnCollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
{
base.CollectionChangedOnCollectionChanged(sender, e);
SelectedDay = DeliveryDays?.FirstOrDefault();
SelectedTime = SelectedDay?.Times?.FirstOrDefault();
SelectedItem = SelectedTime;
}
public override int GetHashCode()
{
return(StringComparer.InvariantCultureIgnoreCase.GetHashCode(RegionIdentifier + ServiceLocationIdentifier +
Description + AddressLine1 + AddressLine2 + City + State + PostalCode + WorldTimeZone + DeliveryDays.ToString() +
PhoneNumber + ServiceTimeTypeIdentifier + ServiceWindowTypeIdentifier + Staged + Error + Status));
}
