public USDA.ARS.GRIN.Admin.Models.Cooperator FindCooperator(string emailAddress)
{
USDA.ARS.GRIN.Admin.Models.Cooperator cooperator = new Models.Cooperator();
return(cooperator);
}
public WebOrderRequest Get(int id)
{
const string COMMAND_TEXT = "usp_WebOrderRequest_Select";
string emailAddressList = String.Empty;
WebOrderRequest webOrderRequest = new WebOrderRequest();
try
{
using (SqlConnection cn = DataContext.GetConnection(this.GetConnectionStringKey(_context)))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = COMMAND_TEXT;
cmd.Parameters.AddWithValue("@web_order_request_id", id);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
webOrderRequest = new WebOrderRequest();
webOrderRequest.ID = GetInt(reader["web_order_request_id"].ToString());
Models.Cooperator webCooperator = new Models.Cooperator();
webCooperator.ID = GetInt(reader["web_cooperator_id"].ToString());
webCooperator.Type = 2;
webCooperator.Title = reader["web_cooperator_title"].ToString();
webCooperator.LastName = reader["web_cooperator_last_name"].ToString();
webCooperator.FirstName = reader["web_cooperator_first_name"].ToString();
webCooperator.FullName = reader["web_cooperator_full_name"].ToString();
webCooperator.Organization = reader["web_cooperator_organization"].ToString();
webCooperator.Job = reader["web_cooperator_job"].ToString();
webCooperator.PrimaryPhoneNumber = reader["web_cooperator_primary_phone"].ToString();
webCooperator.EmailAddress = reader["web_cooperator_email"].ToString();
webCooperator.CreatedDate = GetDate(reader["web_cooperator_created_date"].ToString());
webCooperator.ModifiedDate = GetDate(reader["web_cooperator_modified_date"].ToString());
webCooperator.Address.AddressLine1 = reader["web_cooperator_address_line_1"].ToString();
webCooperator.Address.AddressLine2 = reader["web_cooperator_address_line_2"].ToString();
webCooperator.Address.AddressLine3 = reader["web_cooperator_address_line_3"].ToString();
webCooperator.Address.City = reader["web_cooperator_address_city"].ToString();
webCooperator.Address.ZIP = reader["web_cooperator_address_postal_index"].ToString();
webCooperator.Address.State = reader["web_cooperator_address_state"].ToString();
webCooperator.Totals = GetTotals(webCooperator.ID);
//REFACTOR
webOrderRequest.Cooperators.Add(webCooperator);
webOrderRequest.WebCooperator = webCooperator;
webOrderRequest.OrderDate = GetDate(reader["ordered_date"].ToString());
webOrderRequest.StatusCode = reader["status_code"].ToString();
webOrderRequest.IntendedUseCode = reader["intended_use_code"].ToString();
webOrderRequest.IntendedUseNote = reader["intended_use_note"].ToString();
webOrderRequest.Note = reader["note"].ToString();
webOrderRequest.SpecialInstruction = reader["special_instruction"].ToString();
webOrderRequest.Addresses = GetAddresses(webOrderRequest.ID);
webOrderRequest.WebOrderRequestItems = SearchItems(webOrderRequest.ID, ref emailAddressList);
webOrderRequest.WebOrderRequestActions = SearchActions(webOrderRequest.ID);
webOrderRequest.EmailAddressList = emailAddressList;
webOrderRequest.IsLocked = ParseBool(reader["is_locked"].ToString());
webOrderRequest.OwnedByCooperatorID = GetInt(reader["owned_by"].ToString());
webOrderRequest.OwnedByCooperatorName = reader["owned_by_name"].ToString();
webOrderRequest.OwnedDate = GetDate(reader["owned_date"].ToString());
}
}
}
}
}
catch (SqlException ex)
{
throw ex;
}
return(webOrderRequest);
}
