public static NLog.Logger logger = NLog.LogManager.GetCurrentClassLogger(); //logger.Info(e.Message);
static void Main(string[] args)
{
PersonSqlDbAccess.Add(
new Models.Person.PersonModel
{
Firstname = "Mike",
Lastname = "Corso",
Age = 32,
Gender = "Male",
Address = new Models.Person.AddressModel
{
AddrLine1 = "32 West 32nd St",
AddrLine2 = "Room 218",
City = "New York",
State = "New York",
FK_Country = 1,
Zipcode = "10003"
},
ContactInfo = new Models.Person.ContactInfoModel
{
Number = "1234567890",
Ext = "",
Email = "*****@*****.**"
}
}
);
Console.ReadLine();
}
public IHttpActionResult Delete(Guid Id)
{
try
{
PersonSqlDbAccess.Delete(Id);
logger.Info($"PersonController.Delete successfully deleted pid {Id}");
return(Ok());
}
catch (Exception ex)
{
logger.Info($"PersonController.Delete threw error {ex.Message} trying to delete {Id}");
return(BadRequest());
}
}
public IHttpActionResult Post(PersonModel p)
{
if (p != null)
{
try
{
// Convert ISO2 to CountryModel objects
p.Address.FK_Country = Guid.Empty;
if (p.Address.CountryISO2 != null)
{
p.Address.FK_Country = CountrySqlDbAccess.GetByISO2(p.Address.CountryISO2).Id;
}
p.ContactInfo.FK_Country = Guid.Empty;
if (p.Address.CountryISO2 != null)
{
p.ContactInfo.FK_Country = CountrySqlDbAccess.GetByISO2(p.ContactInfo.CountryISO2).Id;
}
// Create new Guid for Person, Address, ContactInfo
p.Id = p.Address.Id = p.ContactInfo.Id = Guid.NewGuid();
PersonSqlDbAccess.Add(p);
logger.Info($"PersonController.Post successfully added {p.Print()}");
return(Ok());
}
catch (Exception ex)
{
logger.Info($"PersonController.Post threw error {ex.Message} trying to add {p.Print()}");
return(BadRequest());
}
}
else
{
logger.Info($"PersonController.Post failed to add {p.Print()}");
return(BadRequest());
}
}
public IHttpActionResult Put(Guid Id, [FromBody] PersonModel p)
{
if (p != null)
{
try
{
PersonModel original = PersonSqlDbAccess.GetPersonById(Id);
if (p.Firstname != null)
{
original.Firstname = p.Firstname;
}
if (p.Lastname != null)
{
original.Lastname = p.Lastname;
}
if (p.Age != null)
{
original.Age = p.Age;
}
if (p.Gender != null)
{
original.Gender = p.Gender;
}
if (p.Address.AddrLine1 != null)
{
original.Address.AddrLine1 = p.Address.AddrLine1;
}
if (p.Address.AddrLine2 != null)
{
original.Address.AddrLine2 = p.Address.AddrLine2;
}
if (p.Address.City != null)
{
original.Address.City = p.Address.City;
}
if (p.Address.State != null)
{
original.Address.State = p.Address.State;
}
if (p.Address.CountryISO2 != null)
{
original.Address.FK_Country = CountrySqlDbAccess.GetByISO2(p.Address.CountryISO2).Id;
}
if (p.Address.Zipcode != null)
{
original.Address.Zipcode = p.Address.Zipcode;
}
if (p.ContactInfo.CountryISO2 != null)
{
original.ContactInfo.FK_Country = CountrySqlDbAccess.GetByISO2(p.ContactInfo.CountryISO2).Id;
}
if (p.ContactInfo.Number != null)
{
original.ContactInfo.Number = p.ContactInfo.Number;
}
if (p.ContactInfo.Ext != null)
{
original.ContactInfo.Ext = p.ContactInfo.Ext;
}
if (p.ContactInfo.Email != null)
{
original.ContactInfo.Email = p.ContactInfo.Email;
}
PersonSqlDbAccess.Update(original);
logger.Info($"PersonController.Put successfully edited {p.Print()}");
return(Ok());
}
catch (Exception ex)
{
logger.Info($"PersonController.Put threw error {ex.Message} trying to edit {p.Print()}");
return(BadRequest());
}
}
else
{
logger.Info($"PersonController.Put failed to edit {p.Print()}");
return(BadRequest());
}
}
public JsonResult <PersonModel> Get(Guid Id)
{
return(Json <PersonModel>(PersonSqlDbAccess.GetPersonById(Id)));
}
public JsonResult <IEnumerable <PersonModel> > Get()
{
return(Json <IEnumerable <PersonModel> >(PersonSqlDbAccess.GetAll()));
}
public void Test_PersonSqlDbCRUD()
{
Guid[] guids = new Guid[] { new Guid("F7AB131E-354C-4698-A673-BB27D0D0D64F"),
new Guid("92115905-9A48-4A17-9521-E35560F74674") };
/* Create */
// DB before changes
List <PersonModel> before = PersonSqlDbAccess.GetAll();
// Changes
PersonSqlDbAccess.Add(
new Models.Person.PersonModel
{
Id = guids[0],
Firstname = "Mike",
Lastname = "Corso",
Age = 32,
Gender = "Male",
Address = new Models.Person.AddressModel
{
Id = Guid.NewGuid(),
AddrLine1 = "32 West 32nd St",
AddrLine2 = "Room 218",
City = "New York",
State = "New York",
FK_Country = new Guid("DC9E0EF0-EC74-4E4D-A7DA-00754C3D2616"),
Zipcode = "10003"
},
ContactInfo = new Models.Person.ContactInfoModel
{
Id = Guid.NewGuid(),
FK_Country = new Guid("DC9E0EF0-EC74-4E4D-A7DA-00754C3D2616"),
Number = "1234567890",
Ext = "",
Email = "*****@*****.**"
}
}
);
PersonSqlDbAccess.Add(
new Models.Person.PersonModel
{
Id = guids[1],
Firstname = "Samantha",
Lastname = "Corso",
Age = 25,
Gender = "Female",
Address = new Models.Person.AddressModel
{
Id = Guid.NewGuid(),
AddrLine1 = "31 West 32nd St",
AddrLine2 = "Room 217",
City = "New York",
State = "New York",
FK_Country = new Guid("DC9E0EF0-EC74-4E4D-A7DA-00754C3D2616"),
Zipcode = "10004"
},
ContactInfo = new Models.Person.ContactInfoModel
{
Id = Guid.NewGuid(),
FK_Country = new Guid("DC9E0EF0-EC74-4E4D-A7DA-00754C3D2616"),
Number = "349667890",
Ext = "",
Email = "*****@*****.**"
}
}
);
// DB after changes
List <PersonModel> after = PersonSqlDbAccess.GetAll();
// Assert
Assert.True(after.Count - before.Count == 2);
/* Update */
// DB before changes
before = PersonSqlDbAccess.Search("John");
// Changes
PersonSqlDbAccess.Update(
new Models.Person.PersonModel
{
Id = guids[0],
Firstname = "John",
Lastname = "Corso",
Age = 32,
Gender = "Male",
Address = new Models.Person.AddressModel
{
Id = Guid.NewGuid(),
AddrLine1 = "32 West 32nd St",
AddrLine2 = "Room 218",
City = "New York",
State = "New York",
FK_Country = new Guid("DC9E0EF0-EC74-4E4D-A7DA-00754C3D2616"),
Zipcode = "10003"
},
ContactInfo = new Models.Person.ContactInfoModel
{
Id = Guid.NewGuid(),
FK_Country = new Guid("DC9E0EF0-EC74-4E4D-A7DA-00754C3D2616"),
Number = "1234567890",
Ext = "",
Email = "*****@*****.**"
}
}
);
// After changes
after = PersonSqlDbAccess.Search("John");
// Assert
Assert.True(after.Count - before.Count == 1);
/* Delete */
// Changes
PersonSqlDbAccess.Delete(guids[0]);
PersonSqlDbAccess.Delete(guids[1]);
// Assert
Assert.True(PersonSqlDbAccess.GetPersonById(guids[0]) == null);
Assert.True(PersonSqlDbAccess.GetPersonById(guids[1]) == null);
}
public void Test_MessageSqlDbCRUD()
{
Guid[] guids = new Guid[] { new Guid("F7AB131E-354C-4698-A673-BB27D0D0D64F"),
new Guid("92115905-9A48-4A17-9521-E35560F74674") };
/* Create */
// DB before changes
List <MessageModel> before = MessageSqlDbAccess.GetAll();
// Changes
MessageSqlDbAccess.Add(
new Models.ContactMe.MessageModel
{
Id = guids[0],
WasRead = false,
FullName = "Michael Corso",
Email = "*****@*****.**",
Message = "This is a test message."
}
);
// DB after changes
List <MessageModel> after = MessageSqlDbAccess.GetAll();
// Assert
Assert.True(after.Count - before.Count == 1);
/* Update */
// DB before changes
before = MessageSqlDbAccess.Search("John Corso");
foreach (MessageModel m in before)
{
output.WriteLine(m.Print());
}
// Changes
MessageSqlDbAccess.Update(
new Models.ContactMe.MessageModel
{
Id = guids[0],
WasRead = true,
FullName = "John Corso",
Email = "*****@*****.**",
Message = "This is a test message."
}
);
// After changes
after = MessageSqlDbAccess.Search("John Corso");
foreach (MessageModel m in after)
{
output.WriteLine(m.Print());
}
// Assert
Assert.True(after.Count - before.Count == 1);
/* Delete */
// Changes
PersonSqlDbAccess.Delete(guids[0]);
//PersonSqlDbAccess.Delete(guids[1]);
// Assert
Assert.True(PersonSqlDbAccess.GetPersonById(guids[0]) == null);
//Assert.True(PersonSqlDbAccess.GetPersonById(guids[1]) == null);
}
