/// <summary>
/// Determines whether the US state instance is equal to the specified other US state instance.
/// </summary>
/// <param name="state">The US state instance.</param>
/// <param name="other">The other US state instance to be compared with.</param>
/// <returns>True, if both US state instances are equal; otherwise, false.</returns>
public static bool IsEqualTo(this USState? state, USState? other)
{
if(state == null)
return other == null;
return other != null && state.Value.IsEqualTo(other.Value);
}
public List <USState> GetState()
{
List <USState> state = new List <USState>();
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[@"MIS442_SMusgrave"].ConnectionString))
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = "SELECT * FROM State";
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
USState s = new USState();
s.code = reader["code"].ToString();
s.name = reader["name"].ToString();
state.Add(s);
}
}
}
}
return(state);
}
public static void AddNewClient(string firstName, string lastName, string username, string password, string email, string streetAddress, int zipCode, int state)
{
HumaneSocietyDataContext db = new HumaneSocietyDataContext();
USState uSState = new USState();
UserAddress address = new UserAddress
{
addessLine1 = streetAddress,
addressLine2 = streetAddress,
zipcode = zipCode,
USStates = uSState.ID
};
Client client = new Client()
{
firstName = firstName,
lastName = lastName,
userName = username,
pass = password,
email = email,
userAddress = address.ID
};
db.Clients.InsertOnSubmit(client);
db.SubmitChanges();
}
public List <USState> GetState()
{
List <USState> list = new List <USState>();
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MIS442_BH"].ConnectionString))
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "SELECT * FROM State";
command.CommandType = CommandType.Text;
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
USState item = new USState();
item.code = reader["code"].ToString();
item.name = reader["name"].ToString();
list.Add(item);
}
}
return(list);
}
}
}
public List <USState> GetStates()
{
List <USState> stateList = new List <USState>();
using (SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DB_MIS442"].ConnectionString))
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "SELECT * FROM State";
command.CommandType = System.Data.CommandType.Text;
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
USState state = new USState();
state.code = reader["Code"].ToString();
state.name = reader["Name"].ToString();
stateList.Add(state);
}
}
}
}
return(stateList);
}
public virtual ActionResult EditContactInfo(string username, bool editingMyRecord, ContactInfo contactInfo)
{
this.Validate(contactInfo, string.Empty);
var person = userRepository.GetUser(username).Person;
if (!string.IsNullOrEmpty(contactInfo.AddressState))
{
if (USState.FromAbbreviation(contactInfo.AddressState.ToUpper()) == null)
{
ModelState.AddModelError("State", "Must be a valid US state abbreviation.");
}
}
if (!ModelState.IsValid)
{
return(View(MVC.PersonnelRecords.Views.EditRecord, GeneratePersonnelRecordViewModel(person, editingMyRecord)));
}
Mapper.Map <ContactInfo, Person>(contactInfo, person);
if (editingMyRecord)
{
return(RedirectToAction(MVC.PersonnelRecords.EditMyRecord()));
}
else
{
return(RedirectToAction(MVC.PersonnelRecords.EditRecord(username)));
}
}
public ICollection <DroughtMonitorWeek> FindBy(USState state, DateTime?week = null, int weeksPrevious = 0)
{
week = DroughtMonitorWeek.ConvertDateToTuesday(week.Value);
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(null, conn))
{
if (week == null && weeksPrevious == 0)
{
command.CommandText = string.Format("select DroughtCategory, DroughtValue, PublishedDate, State_ID from StateDMValues where State_ID = @state order by PublishedDate, State_ID");
command.Parameters.AddWithValue("@state", state.ID);
}
else if (week == null && weeksPrevious != 0)
{
command.CommandText = string.Format("select DroughtCategory, DroughtValue, PublishedDate, State_ID from StateDMValues where State_ID = @state and PublishedDate >= @rangestart order by PublishedDate, State_ID");
command.Parameters.AddWithValue("@state", state.ID);
command.Parameters.AddWithValue("@rangestart", DateTime.Now.AddDays(7 * (0 - weeksPrevious)).ToString("yyyy/MM/dd"));
}
else if (week != null)
{
command.CommandText = string.Format("select DroughtCategory, DroughtValue, PublishedDate, State_ID from StateDMValues where State_ID = @state and PublishedDate >= @rangestart and PublishedDate <= @rangeend order by PublishedDate, State_ID");
command.Parameters.AddWithValue("@state", state.ID);
command.Parameters.AddWithValue("@rangestart", week.Value.AddDays(7 * (0 - weeksPrevious)).ToString("yyyy/MM/dd"));
command.Parameters.AddWithValue("@rangeend", week.Value.ToString("yyyy/MM/dd"));
}
return(ProcessQuery(command, DMDataType.STATE));
}
}
}
private void AddCriteriaToSessionVar()
{
//individual selection criteria
foreach (LoanInquiryCriteria criteria in this.listCriteria)
{
LoanInquiryCriteria inqCriteria = new LoanInquiryCriteria();
List <Control> ctrlvalues = inqCriteria.FindControls(new[] { "loaninquiry", "temp" }, criteria.Controls);
if (ctrlvalues.Count > 0)
{
ComboBoxData dataName = criteria.DataName;
string[] values = new string[3];
int i = 0;
//get all non-loaninquiry* objects - these have the values
foreach (Control ctrl in ctrlvalues)
{
switch (ctrl.GetType().Name)
{
case "State":
ComboBox states = (ComboBox)ctrl.Controls[0];
USState state = (USState)states.SelectedItem;
values[i++] = state.ShortName;
break;
case "Country":
ComboBox countries = (ComboBox)ctrl.Controls[0];
CountryData country = (CountryData)countries.SelectedItem;
values[i++] = country.Name;
break;
case "Gender":
case "Race":
case "Haircolor":
case "EyeColor":
ComboBox list = (ComboBox)ctrl.Controls[0];
ComboBoxData item = (ComboBoxData)list.SelectedItem;
values[i++] = item.Description;
break;
case "Zipcode":
case "Date":
values[i++] = ctrl.Controls[0].Text;
break;
case "TextBox":
case "ComboBox":
values[i++] = ctrl.Text;
break;
}
}
InquirySelectedCriteria selCriteria = new InquirySelectedCriteria(criteria.loaninquiryDataTypeCombobox.SelectedItem.ToString(),
dataName.Description, dataName.Code, criteria.SearchType,
values, false);
GlobalDataAccessor.Instance.DesktopSession.InquirySelectionCriteria.SelectedCriteria.Add(selCriteria);
}
}
}
public static USState GetStateById(int stateNumber)
{
HumaneSocietyDataContext database = new HumaneSocietyDataContext();
USState newState = new USState();
var stateObject = (from state in database.USStates where state.ID == stateNumber select state).First();
newState.ID = stateObject.ID;
newState.abbrev = stateObject.abbrev;
newState.name = stateObject.name;
return(newState);
}
/// <summary>
/// Called by the framework when the component needs to be rendered as HTML.
/// </summary>
/// <param name="model">The model being rendered by the component.</param>
/// <returns>The component rendered as HTML.</returns>
public async Task <string> RenderAsync(string model)
{
List <SelectionItem <string> > states = await USState.ReadStatesListAsync();
if (model == null)
{
model = "";
}
string state = (from s in states where string.Compare(s.Value, model.ToUpper(), true) == 0 select s.Text).FirstOrDefault();
return(HE(state));
}
public Address(
string streetLine1,
string city,
USState state,
string zip10,
string streetLine2 = null,
string streetLine3 = null)
{
Id = Guid.NewGuid();
StreetLine1 = streetLine1;
StreetLine2 = streetLine2;
StreetLine3 = streetLine3;
City = city;
State = state;
Zip = zip10;
}
object IUserType.NullSafeGet(IDataReader rs, string[] names, object owner)
{
var val = NHibernateUtil.String.NullSafeGet(rs, names);
if (val == null)
{
return(null);
}
var state = USState.FromAbbreviation(val.ToString());
if (state == null)
{
throw new InvalidCastException("Invalid US State Abbreviation");
}
return(state);
}
/// <summary>
/// Called by the framework when the component needs to be rendered as HTML.
/// </summary>
/// <param name="model">The model being rendered by the component.</param>
/// <returns>The component rendered as HTML.</returns>
public async Task <string> RenderAsync(string model)
{
List <SelectionItem <string> > states = await USState.ReadStatesListAsync();
bool useDefault = !PropData.GetAdditionalAttributeValue <bool>("NoDefault");
if (useDefault)
{
states = (from s in states select s).ToList();//copy
states.Insert(0, new SelectionItem <string> {
Text = __ResStr("default", "(select)"),
Tooltip = __ResStr("defaultTT", "Please make a selection"),
Value = "",
});
}
return(await DropDownListComponent.RenderDropDownListAsync(this, model, states, "yt_usstate"));
}
public USState GetState(long id)
{
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand("select * from States where ID = @StateID", conn))
{
command.Parameters.AddWithValue("@StateID", id);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
USState state = new USState();
state.ID = reader.GetInt64(0);
state.Name = reader.GetString(1);
return(state);
}
}
}
throw new ArgumentException(string.Format("State id {0} is not recognized", id));
}
public static void AddNewClient(string firstName, string lastName, string username, string password, string email, string streetAddress, int zipCode, int state)
{
USState State = new USState();
HumaneSocietyDataContext db = new HumaneSocietyDataContext();
UserAddress address = new UserAddress();
Client client = new Client();
client.firstName = firstName;
client.lastName = lastName;
client.userName = username;
client.pass = password;
client.email = email;
address.addessLine1 = streetAddress;
address.addressLine2 = null;
address.zipcode = zipCode;
State.ID = state;
address.USState = State;
db.Clients.InsertOnSubmit(client);
db.UserAddresses.InsertOnSubmit(address);
db.SubmitChanges();
}
private Address BuildAddress()
{
Address address = new Address
{
Name = txtName.Text,
AddressLine1 = string.IsNullOrEmpty(txtAddrLine1.Text.Trim()) ? null : txtAddrLine1.Text.Trim(),
AddressLine2 = string.IsNullOrEmpty(txtAddrLine2.Text.Trim()) ? null : txtAddrLine2.Text.Trim(),
City = string.IsNullOrEmpty(txtCity.Text.Trim()) ? null : txtCity.Text.Trim(),
County = string.IsNullOrEmpty(txtCounty.Text.Trim()) ? null : txtCounty.Text.Trim(),
PostCode = string.IsNullOrEmpty(txtPostCode.Text.Trim()) ? null : txtPostCode.Text.Trim(),
CreatedOnDate = DateTime.Now,
UpdatedOnDate = DateTime.Now
};
Country country = ShippingService.GetCountryById(Convert.ToInt32(ddlCountry.SelectedItem.Value));
address.Country = country;
address.CountryId = country.Id;
if (address.Country.ISO3166Code == "US")
{
USState usState = ShippingService.GetUSStateByCode(ddlState.SelectedValue);
address.USState = usState;
address.USStateId = usState.Id;
}
var profileId = QueryUserId;
var isAnonymous = AccountService.GetAnonymousStatusByProfileId(profileId);
if (isAnonymous == false)
{
var addressList = AccountService.GetAddressesByProfileId(profileId);
var id = addressList.Where(a => BothAddressesAreSame(a, address)).Select(a => a.Id).FirstOrDefault();
address.Id = id;
}
return(address);
}
private static void Setup_PersonnelRecordViewModel()
{
Mapper.CreateMap <Person, PersonnelRecordViewModel>()
.ForMember(x => x.Username, m => m.MapFrom(x => x.User.Username))
.ForMember(x => x.PersonalInfo, m => m.MapFrom(x => x))
.ForMember(x => x.ContactInfo, m => m.MapFrom(x => x))
.ForMember(x => x.CompanyInfo, m => m.MapFrom(x => x))
.ForMember(x => x.EditingMyRecord, m => m.Ignore())
.ForMember(x => x.HirePositions, m => m.Ignore());
Mapper.CreateMap <Person, PersonalInfo>()
.ForMember(x => x.FirstName, m => m.MapFrom(x => x.User.FirstName))
.ForMember(x => x.LastName, m => m.MapFrom(x => x.User.LastName))
.ForMember(x => x.Email, m => m.MapFrom(x => x.User.Email));
Mapper.CreateMap <Person, ContactInfo>()
.ForMember(x => x.AddressState, m => m.MapFrom(x => x.Address != null ? x.Address.State.Abbreviation : null));
Mapper.CreateMap <Person, CompanyInfo>()
.ForMember(x => x.HirePositionId, m => m.MapFrom(x => x.HirePosition != null ? x.HirePosition.Id : null));
Mapper.CreateMap <PersonalInfo, Person>()
.ForMember(x => x.Id, m => m.Ignore())
.ForMember(x => x.User, m => m.Ignore())
.ForMember(x => x.Qualifications, m => m.Ignore())
.ForMember(x => x.Address, m => m.Ignore())
.ForMember(x => x.AlternateEmail, m => m.Ignore())
.ForMember(x => x.AlternatePhoneNumber, m => m.Ignore())
.ForMember(x => x.EmergencyContactName, m => m.Ignore())
.ForMember(x => x.EmergencyContactPhoneNumber, m => m.Ignore())
.ForMember(x => x.FlightSuitSize, m => m.Ignore())
.ForMember(x => x.HirePosition, m => m.Ignore())
.ForMember(x => x.PrimaryPhoneNumber, m => m.Ignore())
.ForMember(x => x.ShirtSize, m => m.Ignore())
.ForMember(x => x.DateOfBirth, m => m.MapFrom(x => x.DateOfBirth.HasValue ? x.DateOfBirth.Value.ToUniversalTime() : (DateTime?)null))
.AfterMap((x, y) =>
{
y.User.FirstName = x.FirstName;
y.User.LastName = x.LastName;
y.User.Email = x.Email;
});
Mapper.CreateMap <ContactInfo, Person>()
.ForMember(x => x.Id, m => m.Ignore())
.ForMember(x => x.User, m => m.Ignore())
.ForMember(x => x.Qualifications, m => m.Ignore())
.ForMember(x => x.FlightSuitSize, m => m.Ignore())
.ForMember(x => x.HirePosition, m => m.Ignore())
.ForMember(x => x.ShirtSize, m => m.Ignore())
.ForMember(x => x.MiddleInitial, m => m.Ignore())
.ForMember(x => x.DateOfBirth, m => m.Ignore())
.ForMember(x => x.Gender, m => m.Ignore())
.ForMember(x => x.SocialSecurityLastFour, m => m.Ignore())
.ForMember(x => x.Address, m => m.MapFrom(x =>
{
return(new USAddress
{
StreetAddress = x.AddressStreetAddress,
City = x.AddressCity,
State = USState.FromAbbreviation(x.AddressState.ToUpper()),
ZipCode = x.AddressZipCode,
});
}))
.ForMember(x => x.PrimaryPhoneNumber, m => m.MapFrom(x => RegExLib.ParseRegEx(x.PrimaryPhoneNumber, RegExLib.USPhoneNumber)))
.ForMember(x => x.AlternatePhoneNumber, m => m.MapFrom(x => RegExLib.ParseRegEx(x.AlternatePhoneNumber, RegExLib.USPhoneNumber)))
.ForMember(x => x.EmergencyContactPhoneNumber, m => m.MapFrom(x => RegExLib.ParseRegEx(x.EmergencyContactPhoneNumber, RegExLib.USPhoneNumber)));
Mapper.CreateMap <CompanyInfo, Person>()
.ForMember(x => x.Id, m => m.Ignore())
.ForMember(x => x.User, m => m.Ignore())
.ForMember(x => x.Qualifications, m => m.Ignore())
.ForMember(x => x.Address, m => m.Ignore())
.ForMember(x => x.AlternateEmail, m => m.Ignore())
.ForMember(x => x.AlternatePhoneNumber, m => m.Ignore())
.ForMember(x => x.EmergencyContactName, m => m.Ignore())
.ForMember(x => x.EmergencyContactPhoneNumber, m => m.Ignore())
.ForMember(x => x.HirePosition, m => m.Ignore())
.ForMember(x => x.PrimaryPhoneNumber, m => m.Ignore())
.ForMember(x => x.MiddleInitial, m => m.Ignore())
.ForMember(x => x.DateOfBirth, m => m.Ignore())
.ForMember(x => x.Gender, m => m.Ignore())
.ForMember(x => x.SocialSecurityLastFour, m => m.Ignore());
Mapper.CreateMap <User, PersonnelRecordListViewModel>()
.ForMember(x => x.FileByName, m => m.MapFrom(x => x.FileByName()))
.ForMember(x => x.Status, m => m.MapFrom(x => PersonnelRecordListViewModel.GetStatus(x)));
}
private void PopulateAddress(AddressOverviewModel address, out string countryName)
{
countryName = string.Empty;
if (address.Name != string.Empty)
{
ltlName.Text = address.Name;
}
if (address.AddressLine1 != string.Empty)
{
ltlAddr1.Text = address.AddressLine1;
}
if (address.AddressLine2 != string.Empty)
{
ltlAddr2.Text = address.AddressLine2;
}
if (address.City != string.Empty)
{
ltlCity.Text = address.City;
}
if (address.County != string.Empty)
{
phCountryField.Visible = true;
ltlCounty.Text = address.County;
}
else
{
phCountryField.Visible = false;
}
if (address.PostCode != string.Empty)
{
ltlPostCode.Text = address.PostCode;
}
if (address.CountryId != 0)
{
Country country = ShippingService.GetCountryById(address.CountryId);
countryName = country.Name;
ltlCountry.Text = country.Name;
_countryCode = country.ISO3166Code;
_countryId = country.Id;
}
else
{
_countryCode = string.Empty;
}
phStateField.Visible = false;
phState.Visible = false;
_hasUSState = false;
ltlState.Text = string.Empty;
ltlStateCode.Text = "-";
if (_countryCode == US && address.USStateId != 0)
{
USState usState = ShippingService.GetUSStateById(address.USStateId);
if (usState != null)
{
phStateField.Visible = true;
phState.Visible = true;
_hasUSState = true;
ltlState.Text = usState.State;
ltlStateCode.Text = usState.Code;
}
}
}
public KendoGridDisplayState( USState state )
{
mState = state;
}
