private bool CheckFields()
{
if (AddressStreet.Equals(string.Empty) || AddressCity.Equals(string.Empty) || AddressHouseNo.Equals(string.Empty))
{
throw new Exception("Please fill in the fields");
}
if (!FieldValidation.ValidateInt(AddressZip))
{
throw new Exception("Invalid Zip Code");
}
return(true);
}
public void AddCity(ref AddressCity city)
{
string insertStringParam = @"INSERT INTO [City] (CityName, PostalCode)
OUTPUT INSERTED.CityID
VALUES (@City, @PostalCode)";
using (var cmd = new SqlCommand(insertStringParam, OpenConnection))
{
cmd.Parameters.AddWithValue("@City", city.City);
cmd.Parameters.AddWithValue("@PostalCode", city.PostalCode);
city.CityID = (int)cmd.ExecuteScalar();
}
}
public static AddressCity CreateAddressCity(string cityKey, global::Microsoft.Dynamics.DataEntities.AddressState state, global::Microsoft.Dynamics.DataEntities.AddressCountryRegion countryRegion)
{
AddressCity addressCity = new AddressCity();
addressCity.CityKey = cityKey;
if ((state == null))
{
throw new global::System.ArgumentNullException("state");
}
addressCity.State = state;
if ((countryRegion == null))
{
throw new global::System.ArgumentNullException("countryRegion");
}
addressCity.CountryRegion = countryRegion;
return(addressCity);
}
void IObjectValidation.AddParametersToRequest(RestRequest request)
{
if (Token.HasValue())
{
request.AddParameter("source", Token);
}
else
{
request.AddParameter("source[object]", "card");
request.AddParameter("source[number]", Number);
request.AddParameter("source[exp_month]", ExpMonth);
request.AddParameter("source[exp_year]", ExpYear);
if (Cvc.HasValue())
{
request.AddParameter("source[cvc]", Cvc);
}
if (Name.HasValue())
{
request.AddParameter("source[name]", Name);
}
if (AddressLine1.HasValue())
{
request.AddParameter("source[address_line1]", AddressLine1);
}
if (AddressLine2.HasValue())
{
request.AddParameter("source[address_line2]", AddressLine2);
}
if (AddressCity.HasValue())
{
request.AddParameter("source[address_city]", AddressCity);
}
if (AddressState.HasValue())
{
request.AddParameter("source[address_state]", AddressState);
}
if (AddressZip.HasValue())
{
request.AddParameter("source[address_zip]", AddressZip);
}
if (AddressCountry.HasValue())
{
request.AddParameter("source[address_country]", AddressCountry);
}
}
}
public override string ToString()
{
StringBuilder sb = new StringBuilder(base.ToString());
sb.Append("USR");
if (IsOnline.HasValue)
{
sb.AppendFormat("-A{0}", IsOnline.Value ? "1" : "0");
}
if (!string.IsNullOrEmpty(Vorname))
{
sb.AppendFormat("-B{0}", Vorname.ToLower());
}
if (!string.IsNullOrEmpty(Name))
{
sb.AppendFormat("-C{0}", Name.ToLower());
}
if (!string.IsNullOrEmpty(Sex))
{
sb.AppendFormat("-D{0}", Sex.ToLower());
}
if (!string.IsNullOrEmpty(RelationStatus))
{
sb.AppendFormat("-E{0}", RelationStatus.ToLower());
}
if (!string.IsNullOrEmpty(AttractedTo))
{
sb.AppendFormat("-F{0}", AttractedTo.ToLower());
}
if (!string.IsNullOrEmpty(EyeColor))
{
sb.AppendFormat("-G{0}", EyeColor.ToLower());
}
if (!string.IsNullOrEmpty(HairColor))
{
sb.AppendFormat("-H{0}", HairColor.ToLower());
}
if (BodyHeightFrom.HasValue)
{
sb.AppendFormat("-I{0}", BodyHeightFrom.Value);
}
if (BodyHeightTo.HasValue)
{
sb.AppendFormat("-J{0}", BodyHeightTo.Value);
}
if (BodyWeightFrom.HasValue)
{
sb.AppendFormat("-K{0}", BodyWeightFrom.Value);
}
if (BodyWeightTo.HasValue)
{
sb.AppendFormat("-L{0}", BodyWeightTo.Value);
}
if (AgeFrom.HasValue)
{
sb.AppendFormat("-M{0}", AgeFrom.Value);
}
if (AgeTo.HasValue)
{
sb.AppendFormat("-N{0}", AgeTo.Value);
}
if (CommunityIDMember.HasValue)
{
sb.AppendFormat("-O{0}", CommunityIDMember.Value);
}
if (!string.IsNullOrEmpty(AddressCity))
{
sb.AppendFormat("-P{0}", AddressCity.ToLower());
}
if (!string.IsNullOrEmpty(AddressZip))
{
sb.AppendFormat("-Q{0}", AddressZip.ToLower());
}
if (!string.IsNullOrEmpty(AddressLand))
{
sb.AppendFormat("-R0}", AddressLand.ToLower());
}
if (AddressRangeKM.HasValue)
{
sb.AppendFormat("-S{0}", AddressRangeKM.Value);
}
if (!string.IsNullOrEmpty(InterestTopic))
{
sb.AppendFormat("-T0}", InterestTopic.ToLower());
}
if (!string.IsNullOrEmpty(Interesst))
{
sb.AppendFormat("-U0}", Interesst.ToLower());
}
if (!string.IsNullOrEmpty(Talent))
{
sb.AppendFormat("-V0}", Talent.ToLower());
}
if (ForObjectType.HasValue)
{
sb.AppendFormat("-W{0}", ForObjectType.Value);
}
if (LoadVisits.HasValue)
{
sb.AppendFormat("-X{0}", LoadVisits.Value ? "1" : "0");
}
return(sb.ToString());
}
static void Main(string[] args)
{
Console.WriteLine("Hello ... " +
"\n ... " +
"\n .. " +
"\n . " +
"\n" +
"Starting Database\n");
DBUtilities entry = new DBUtilities();
AddressCity _newcity = new AddressCity()
{
City = "Viby J",
PostalCode = "8260"
};
entry.AddCity(ref _newcity);
Address _newaddress = new Address()
{
RoadName = "østergade",
HouseNumber = "44",
Story = "3",
IsRegisteredAddress = "Primær",
AddressType = "Home",
CityID = _newcity.CityID
};
_newcity.Addresses = new List <Address>();
_newcity.Addresses.Add(_newaddress);
entry.AddAddressToDB(ref _newaddress);
Person _newPerson = new Person()
{
FirstName = "Test",
MiddleName = "Tester",
LastName = "Testersen",
ContactType = "Privat",
//Note = "Hader DAB",
};
_newPerson.AddressRelations.Add(new PersonAddressRelations()
{
Address = _newaddress
});
_newaddress.Persons = new List <Person>();
_newaddress.Persons.Add(_newPerson);
entry.AddPerson(ref _newPerson);
var newRelations = new PersonAddressRelations()
{
PersonID = _newPerson.PersonID, AddressID = _newaddress.AddressID
};
entry.AddPersonAddressRelation(ref newRelations);
//var _person = entry.GetPersonByName(ref _newPerson);
var kartotek = new DBUtilities();
var PersonsInDB = kartotek.GetAllThePersonS();
foreach (Person Persons in PersonsInDB)
{
Console.WriteLine(" ");
Console.WriteLine("Personens ID: \t" + Persons.PersonID);
Console.WriteLine("Personens Fornavn er: \t" + Persons.FirstName);
Console.WriteLine("Personens Mellemnavn er: \t" + Persons.MiddleName);
Console.WriteLine("Personens Efternavn er: \t" + Persons.LastName);
Console.WriteLine("Kontakt typen for personen er \t" + Persons.ContactType);
foreach (var addressRelation in Persons.AddressRelations)
{
Console.WriteLine("Adressen er: ");
Console.WriteLine($"{addressRelation.Address.RoadName}, {addressRelation.Address.HouseNumber}");
Console.WriteLine($"{addressRelation.Address.AddressCity.PostalCode} {addressRelation.Address.AddressCity.City}");
}
//for (int i = 0; i < Persons.AddressRelations.Count; i++)
//{
// var addressRelation = Persons.AddressRelations.ElementAt(i);
// Console.WriteLine($"Adresse #{i+1} er:");
// Console.WriteLine($"{addressRelation.Address.RoadName}, {addressRelation.Address.HouseNumber}");
// Console.WriteLine($"{addressRelation.Address.AddressCity.PostalCode} {addressRelation.Address.AddressCity.City}");
//}
//Console.WriteLine("Note om Personen \t" + Persons.Note);
}
Console.WriteLine();
//DBCalls test = new DBCalls();
//test.CreateEntryInDB();
//var FN = "test";
//var LN = "tester";
//var MN = "testesen";
//var CT = "noob";
//var Note = "træt af dab";
//DBUtilities newperson = new DBUtilities(0,FN,MN,LN,CT,Note);
//var temp = newperson.ListPersons();
//foreach (Person person in temp)
//{
// Console.WriteLine("ID \t" + person.PersonID);
// Console.WriteLine("Fornavn \t" + person.FirstName);
// Console.WriteLine("Mellemnavn \t" + person.MiddleName);
// Console.WriteLine("Efternavn \t" + person.LastName);
//}
//Console.WriteLine("Creating new entry... ");
//var NewEntry = new Person();
//Console.WriteLine("Please enter First Name: ");
//NewEntry.FirstName = (Console.ReadLine());
//Console.WriteLine("Please enter Middle Name (Optional): ");
//NewEntry.MiddleName = (Console.ReadLine());
//Console.WriteLine("Please enter Last Name: ");
//NewEntry.LastName = (Console.ReadLine());
//Console.WriteLine("Please enter contact type (Business, Private etc.: ");
//NewEntry.ContactType = (Console.ReadLine());
//Console.WriteLine("Please enter any notes");
//NewEntry.Note = (Console.ReadLine());
Console.ReadLine();
}
