public override int GetHashCode()
{
int hashCode = -1623438759;
if (AddressLine1 != null)
{
hashCode += AddressLine1.GetHashCode();
}
if (AddressLine2 != null)
{
hashCode += AddressLine2.GetHashCode();
}
if (AddressLine3 != null)
{
hashCode += AddressLine3.GetHashCode();
}
if (Locality != null)
{
hashCode += Locality.GetHashCode();
}
if (Sublocality != null)
{
hashCode += Sublocality.GetHashCode();
}
if (Sublocality2 != null)
{
hashCode += Sublocality2.GetHashCode();
}
if (Sublocality3 != null)
{
hashCode += Sublocality3.GetHashCode();
}
if (AdministrativeDistrictLevel1 != null)
{
hashCode += AdministrativeDistrictLevel1.GetHashCode();
}
if (AdministrativeDistrictLevel2 != null)
{
hashCode += AdministrativeDistrictLevel2.GetHashCode();
}
if (AdministrativeDistrictLevel3 != null)
{
hashCode += AdministrativeDistrictLevel3.GetHashCode();
}
if (PostalCode != null)
{
hashCode += PostalCode.GetHashCode();
}
if (Country != null)
{
hashCode += Country.GetHashCode();
}
if (FirstName != null)
{
hashCode += FirstName.GetHashCode();
}
if (LastName != null)
{
hashCode += LastName.GetHashCode();
}
if (Organization != null)
{
hashCode += Organization.GetHashCode();
}
return(hashCode);
}
/// <summary>
/// Get the GEDCOM 5.5 lines for the data in this object.
/// Lines start at the given level
/// </summary>
/// <param name="sw">
/// A <see cref="TextWriter"/>
/// </param>
/// <param name="level">
/// A <see cref="int"/>
/// </param>
public void Output(TextWriter sw, int level)
{
sw.Write(Environment.NewLine);
sw.Write(Util.IntToString(level));
sw.Write(" ADDR");
if (!string.IsNullOrEmpty(AddressLine))
{
sw.Write(" ");
Util.SplitLineText(sw, AddressLine, level, 60, 3, true);
}
string levelStr = null;
string levelPlusOne = null;
if (!string.IsNullOrEmpty(AddressLine1))
{
if (levelPlusOne == null)
{
levelPlusOne = Util.IntToString(level + 1);
}
string line = AddressLine1.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelPlusOne);
sw.Write(" ADR1 ");
if (line.Length <= 60)
{
sw.Write(AddressLine1);
}
else
{
sw.Write(line.Substring(0, 60));
System.Diagnostics.Debug.WriteLine("Truncating AddressLine1");
}
}
if (!string.IsNullOrEmpty(AddressLine2))
{
if (levelPlusOne == null)
{
levelPlusOne = Util.IntToString(level + 1);
}
string line = AddressLine2.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelPlusOne);
sw.Write(" ADR2 ");
if (line.Length <= 60)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 60));
System.Diagnostics.Debug.WriteLine("Truncating AddressLine2");
}
}
if (!string.IsNullOrEmpty(AddressLine3))
{
if (levelPlusOne == null)
{
levelPlusOne = Util.IntToString(level + 1);
}
string line = AddressLine3.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelPlusOne);
sw.Write(" ADR3 ");
if (line.Length <= 60)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 60));
System.Diagnostics.Debug.WriteLine("Truncating AddressLine3");
}
}
if (!string.IsNullOrEmpty(City))
{
if (levelPlusOne == null)
{
levelPlusOne = Util.IntToString(level + 1);
}
string line = City.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelPlusOne);
sw.Write(" CITY ");
if (line.Length <= 60)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 60));
System.Diagnostics.Debug.WriteLine("Truncating City");
}
}
if (!string.IsNullOrEmpty(State))
{
if (levelPlusOne == null)
{
levelPlusOne = Util.IntToString(level + 1);
}
string line = State.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelPlusOne);
sw.Write(" STAE ");
if (line.Length <= 60)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 60));
System.Diagnostics.Debug.WriteLine("Truncating State");
}
}
if (!string.IsNullOrEmpty(PostCode))
{
if (levelPlusOne == null)
{
levelPlusOne = Util.IntToString(level + 1);
}
string line = PostCode.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelPlusOne);
sw.Write(" POST ");
if (line.Length <= 10)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 10));
System.Diagnostics.Debug.WriteLine("Truncating PostCode");
}
}
if (!string.IsNullOrEmpty(Country))
{
if (levelPlusOne == null)
{
levelPlusOne = Util.IntToString(level + 1);
}
string line = Country.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelPlusOne);
sw.Write(" CTRY ");
if (line.Length <= 60)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 60));
System.Diagnostics.Debug.WriteLine("Truncating Country");
}
}
if (!string.IsNullOrEmpty(Phone1))
{
if (levelStr == null)
{
levelStr = Util.IntToString(level);
}
string line = Phone1.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelStr);
sw.Write(" PHON ");
if (line.Length <= 25)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 25));
System.Diagnostics.Debug.WriteLine("Truncating Phone1");
}
}
if (!string.IsNullOrEmpty(Phone2))
{
if (levelStr == null)
{
levelStr = Util.IntToString(level);
}
string line = Phone2.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelStr);
sw.Write(" PHON ");
if (line.Length <= 25)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 25));
System.Diagnostics.Debug.WriteLine("Truncating Phone2");
}
}
if (!string.IsNullOrEmpty(Phone3))
{
if (levelStr == null)
{
levelStr = Util.IntToString(level);
}
string line = Phone3.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelStr);
sw.Write(" PHON ");
if (line.Length <= 25)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 25));
System.Diagnostics.Debug.WriteLine("Truncating Phone3");
}
}
if (!string.IsNullOrEmpty(Fax1))
{
if (levelStr == null)
{
levelStr = Util.IntToString(level);
}
string line = Fax1.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelStr);
sw.Write(" FAX ");
if (line.Length <= 60)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 60));
System.Diagnostics.Debug.WriteLine("Truncating Fax1");
}
}
if (!string.IsNullOrEmpty(Fax2))
{
if (levelStr == null)
{
levelStr = Util.IntToString(level);
}
string line = Fax2.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelStr);
sw.Write(" FAX ");
if (line.Length <= 60)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 60));
System.Diagnostics.Debug.WriteLine("Truncating Fax2");
}
}
if (!string.IsNullOrEmpty(Fax3))
{
if (levelStr == null)
{
levelStr = Util.IntToString(level);
}
string line = Fax3.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelStr);
sw.Write(" FAX ");
if (line.Length <= 60)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 60));
System.Diagnostics.Debug.WriteLine("Truncating Fax3");
}
}
if (!string.IsNullOrEmpty(Email1))
{
if (levelStr == null)
{
levelStr = Util.IntToString(level);
}
string line = Email1.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelStr);
sw.Write(" EMAIL ");
if (line.Length <= 120)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 120));
System.Diagnostics.Debug.WriteLine("Truncating Email1");
}
}
if (!string.IsNullOrEmpty(Email2))
{
if (levelStr == null)
{
levelStr = Util.IntToString(level);
}
string line = Email2.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelStr);
sw.Write(" EMAIL ");
if (line.Length <= 120)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 120));
System.Diagnostics.Debug.WriteLine("Truncating Email2");
}
}
if (!string.IsNullOrEmpty(Email3))
{
if (levelStr == null)
{
levelStr = Util.IntToString(level);
}
string line = Email3.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelStr);
sw.Write(" EMAIL ");
if (line.Length <= 120)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 120));
System.Diagnostics.Debug.WriteLine("Truncating Email3");
}
}
if (!string.IsNullOrEmpty(Www1))
{
if (levelStr == null)
{
levelStr = Util.IntToString(level);
}
string line = Www1.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelStr);
sw.Write(" WWW ");
if (line.Length <= 120)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 120));
System.Diagnostics.Debug.WriteLine("Truncating Www1");
}
}
if (!string.IsNullOrEmpty(Www2))
{
if (levelStr == null)
{
levelStr = Util.IntToString(level);
}
string line = Www2.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelStr);
sw.Write(" WWW ");
if (line.Length <= 120)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 120));
System.Diagnostics.Debug.WriteLine("Truncating Www2");
}
}
if (!string.IsNullOrEmpty(Www3))
{
if (levelStr == null)
{
levelStr = Util.IntToString(level);
}
string line = Www3.Replace("@", "@@");
sw.Write(Environment.NewLine);
sw.Write(levelStr);
sw.Write(" WWW ");
if (line.Length <= 120)
{
sw.Write(line);
}
else
{
sw.Write(line.Substring(0, 120));
System.Diagnostics.Debug.WriteLine("Truncating Www3");
}
}
}
public void Update()
{
string strsql = "update Branch set " + "CompanyId= " + CompanyId + ", " + "BranchName= '" + BranchName.Replace("'", "''") + "', " + "AddressLine1= '" + AddressLine1.Replace("'", "''") + "', " + "AddressLine2= '" + AddressLine2.Replace("'", "''") + "', " + "CityId= " + CityId + ", " + "Pincode= '" + Pincode.Replace("'", "''") + "', " + "StateId= " + StateId + ", " + "CountryId= " + CountryId + ", " + "PhoneNumber1= '" + PhoneNumber1.Replace("'", "''") + "', " + "PhoneNumber2= '" + PhoneNumber2.Replace("'", "''") + "', " + "EmailId1= '" + EmailId1.Replace("'", "''") + "', " + "EmailId2= '" + EmailId2.Replace("'", "''") + "' " + " where ID =" + Id;
SqlConnection ObjConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyJobPortal"].ConnectionString);
ObjConnection.Open();
SqlCommand ObjCommand = new SqlCommand(strsql, ObjConnection);
ObjCommand.ExecuteNonQuery();
ObjConnection.Dispose();
ObjCommand.Dispose();
}
/// <summary>
/// Gets the hash code
/// </summary>
/// <returns>Hash code</returns>
public override int GetHashCode()
{
unchecked // Overflow is fine, just wrap
{
var hashCode = 41;
// Suitable nullity checks etc, of course :)
if (AddressId != null)
{
hashCode = hashCode * 59 + AddressId.GetHashCode();
}
if (Nickname != null)
{
hashCode = hashCode * 59 + Nickname.GetHashCode();
}
if (CountryId != null)
{
hashCode = hashCode * 59 + CountryId.GetHashCode();
}
if (Zip != null)
{
hashCode = hashCode * 59 + Zip.GetHashCode();
}
if (City != null)
{
hashCode = hashCode * 59 + City.GetHashCode();
}
if (AdministrativeArea != null)
{
hashCode = hashCode * 59 + AdministrativeArea.GetHashCode();
}
if (DependentLocality != null)
{
hashCode = hashCode * 59 + DependentLocality.GetHashCode();
}
if (SortingCode != null)
{
hashCode = hashCode * 59 + SortingCode.GetHashCode();
}
if (Organization != null)
{
hashCode = hashCode * 59 + Organization.GetHashCode();
}
if (AddressLine1 != null)
{
hashCode = hashCode * 59 + AddressLine1.GetHashCode();
}
if (AddressLine2 != null)
{
hashCode = hashCode * 59 + AddressLine2.GetHashCode();
}
if (IsPrimary != null)
{
hashCode = hashCode * 59 + IsPrimary.GetHashCode();
}
if (SessionToken != null)
{
hashCode = hashCode * 59 + SessionToken.GetHashCode();
}
return(hashCode);
}
}
/// <summary>
/// Returns true if AddressesModel2 instances are equal
/// </summary>
/// <param name="other">Instance of AddressesModel2 to be compared</param>
/// <returns>Boolean</returns>
public bool Equals(AddressesModel2 other)
{
if (ReferenceEquals(null, other))
{
return(false);
}
if (ReferenceEquals(this, other))
{
return(true);
}
return
((
AddressId == other.AddressId ||
AddressId != null &&
AddressId.Equals(other.AddressId)
) &&
(
Nickname == other.Nickname ||
Nickname != null &&
Nickname.Equals(other.Nickname)
) &&
(
CountryId == other.CountryId ||
CountryId != null &&
CountryId.Equals(other.CountryId)
) &&
(
Zip == other.Zip ||
Zip != null &&
Zip.Equals(other.Zip)
) &&
(
City == other.City ||
City != null &&
City.Equals(other.City)
) &&
(
AdministrativeArea == other.AdministrativeArea ||
AdministrativeArea != null &&
AdministrativeArea.Equals(other.AdministrativeArea)
) &&
(
DependentLocality == other.DependentLocality ||
DependentLocality != null &&
DependentLocality.Equals(other.DependentLocality)
) &&
(
SortingCode == other.SortingCode ||
SortingCode != null &&
SortingCode.Equals(other.SortingCode)
) &&
(
Organization == other.Organization ||
Organization != null &&
Organization.Equals(other.Organization)
) &&
(
AddressLine1 == other.AddressLine1 ||
AddressLine1 != null &&
AddressLine1.Equals(other.AddressLine1)
) &&
(
AddressLine2 == other.AddressLine2 ||
AddressLine2 != null &&
AddressLine2.Equals(other.AddressLine2)
) &&
(
IsPrimary == other.IsPrimary ||
IsPrimary != null &&
IsPrimary.Equals(other.IsPrimary)
) &&
(
SessionToken == other.SessionToken ||
SessionToken != null &&
SessionToken.Equals(other.SessionToken)
));
}
public string GenerateUpdateJsonFromObject(Household updateFrom)
{
// form the json (determine the fields that need to be updated)
var sb = new StringBuilder();
var sw = new StringWriter(sb);
var writer = new JsonTextWriter(sw)
{
Formatting = Formatting.None
};
writer.WriteStartObject();
writer.WritePropertyName(@"household");
writer.WriteStartObject();
if (!HouseholdName.Equals(updateFrom.HouseholdName))
{
writer.WritePropertyName("name");
writer.WriteValue(updateFrom.HouseholdName);
}
if (!IntakeDate.Equals(updateFrom.IntakeDate))
{
writer.WritePropertyName("intake_date");
writer.WriteValue(updateFrom.IntakeDate.ToString("yyyy-MM-dd"));
}
if (!AddressLine1.Equals(updateFrom.AddressLine1))
{
writer.WritePropertyName("address_line_1");
writer.WriteValue(updateFrom.AddressLine1);
}
if (!AddressLine2.Equals(updateFrom.AddressLine2))
{
writer.WritePropertyName("address_line_2");
writer.WriteValue(updateFrom.AddressLine2);
}
if (!PostalCode.Equals(updateFrom.PostalCode))
{
writer.WritePropertyName("postal_code");
writer.WriteValue(updateFrom.PostalCode);
}
if (!DependentLocality.Equals(updateFrom.DependentLocality))
{
writer.WritePropertyName("dependent_locality");
writer.WriteValue(updateFrom.DependentLocality);
}
if (!Locality.Equals(updateFrom.Locality))
{
writer.WritePropertyName("locality");
writer.WriteValue(updateFrom.Locality);
}
if (!AdminvArea.Equals(updateFrom.AdminvArea))
{
writer.WritePropertyName("adminv_area");
writer.WriteValue(updateFrom.AdminvArea);
}
if (!DependentAdminvArea.Equals(updateFrom.DependentAdminvArea))
{
writer.WritePropertyName("dependent_adminv_area");
writer.WriteValue(updateFrom.DependentAdminvArea);
}
if (!Country.Equals(updateFrom.Country))
{
writer.WritePropertyName("country");
writer.WriteValue(updateFrom.Country);
}
if (!AddressInfo.Equals(updateFrom.AddressInfo))
{
writer.WritePropertyName("address_info");
writer.WriteValue(updateFrom.AddressInfo);
}
if (!GpsLatitude.Equals(updateFrom.GpsLatitude))
{
writer.WritePropertyName("latitude");
writer.WriteValue(updateFrom.GpsLatitude ?? null);
}
if (!GpsLongitude.Equals(updateFrom.GpsLongitude))
{
writer.WritePropertyName("longitude");
writer.WriteValue(updateFrom.GpsLongitude ?? null);
}
if (!GpsPositionAccuracy.Equals(updateFrom.GpsPositionAccuracy))
{
writer.WritePropertyName("position_accuracy");
writer.WriteValue(updateFrom.GpsPositionAccuracy ?? null);
}
if (!GpsAltitude.Equals(updateFrom.GpsAltitude))
{
writer.WritePropertyName("altitude");
writer.WriteValue(updateFrom.GpsAltitude ?? null);
}
if (!GpsAltitudeAccuracy.Equals(updateFrom.GpsAltitudeAccuracy))
{
writer.WritePropertyName("altitude_accuracy");
writer.WriteValue(updateFrom.GpsAltitudeAccuracy ?? null);
}
if (!GpsHeading.Equals(updateFrom.GpsHeading))
{
writer.WritePropertyName("heading");
writer.WriteValue(updateFrom.GpsHeading ?? null);
}
if (!GpsSpeed.Equals(updateFrom.GpsSpeed))
{
writer.WritePropertyName("speed");
writer.WriteValue(updateFrom.GpsSpeed ?? null);
}
if (!GpsPositionTime.Equals(updateFrom.GpsPositionTime))
{
writer.WritePropertyName("gps_recorded_at");
writer.WriteValue(updateFrom.GpsPositionTime ?? null);
}
writer.WriteEndObject();
writer.WriteEndObject();
return(sw.ToString());
}
public bool GetObjectNeedsUpate(Household checkUpdateFrom)
{
if (!HouseholdName.Equals(checkUpdateFrom.HouseholdName))
{
return(true);
}
if (!IntakeDate.Equals(checkUpdateFrom.IntakeDate))
{
return(true);
}
if (!AddressLine1.Equals(checkUpdateFrom.AddressLine1))
{
return(true);
}
if (!AddressLine2.Equals(checkUpdateFrom.AddressLine2))
{
return(true);
}
if (!PostalCode.Equals(checkUpdateFrom.PostalCode))
{
return(true);
}
if (!DependentLocality.Equals(checkUpdateFrom.DependentLocality))
{
return(true);
}
if (!Locality.Equals(checkUpdateFrom.Locality))
{
return(true);
}
if (!AdminvArea.Equals(checkUpdateFrom.AdminvArea))
{
return(true);
}
if (!DependentAdminvArea.Equals(checkUpdateFrom.DependentAdminvArea))
{
return(true);
}
if (!Country.Equals(checkUpdateFrom.Country))
{
return(true);
}
if (!AddressInfo.Equals(checkUpdateFrom.AddressInfo))
{
return(true);
}
if (!GpsLatitude.Equals(checkUpdateFrom.GpsLatitude))
{
return(true);
}
if (!GpsLongitude.Equals(checkUpdateFrom.GpsLongitude))
{
return(true);
}
if (!GpsPositionAccuracy.Equals(checkUpdateFrom.GpsPositionAccuracy))
{
return(true);
}
if (!GpsAltitude.Equals(checkUpdateFrom.GpsAltitude))
{
return(true);
}
if (!GpsAltitudeAccuracy.Equals(checkUpdateFrom.GpsAltitudeAccuracy))
{
return(true);
}
if (!GpsHeading.Equals(checkUpdateFrom.GpsHeading))
{
return(true);
}
if (!GpsSpeed.Equals(checkUpdateFrom.GpsSpeed))
{
return(true);
}
if (!GpsPositionTime.Equals(checkUpdateFrom.GpsPositionTime))
{
return(true);
}
return(false);
}
