public async Task Save(IPersonEntity person)
{
var data = JsonConvert.SerializeObject(person);
HttpContent httpContent = new StringContent(data, Encoding.UTF8, "application/json");
HttpResponseMessage response;
// Update or Create?
if (person.ID > 0)
{
response = await _httpClient.PutAsync("api/Person", httpContent);
}
else
{
response = await _httpClient.PostAsync("api/Person", httpContent);
}
if (response.IsSuccessStatusCode)
{
_logger.Write($"Person ID {person.ID} was successfully updated", enLogType.Info);
}
else
{
_logger.Write($"Person ID {person.ID} failed to be updated: {response.ReasonPhrase}", enLogType.Error);
}
}
public Person(IPersonEntity entity)
{
Id = entity.Id;
FirstName = entity.FirstName;
LastName = entity.LastName;
DateOfBirth = entity.DateOfBirth;
}
public DataTable InsertPerson(string userRole, string roleData, string userLogin, IPersonEntity person)
{
//ConnectDB("ConnectionString");
//string queryString = "Insert into Person([person_type_ref], [title], [firstname], [lastname], [emailprimary], [emailalternate], [fax], [phoneprimary], [phonehome], [phonemobile], [phonework], [phoneemergency], [companyname], [position], [description]) values ('" +
// person.PersonType + "','" +
// person.PersonTitle + "','" +
// person.PersonFirstName + "','" +
// person.PersonLastName + "','" +
// person.PersonEmailPrimary + "','" +
// person.PersonEmailAlternate + "','" +
// person.PersonFax + "','" +
// person.PersonPhonePrimary + "','" +
// person.PersonPhoneHome + "','" +
// person.PersonPhoneMobile + "','" +
// person.PersonPhoneWork + "','" +
// person.PersonPhoneEmergency + "','" +
// person.PersonCompanyName + "','" +
// person.PersonPosition + "','" +
// person.PersonDescription + "')";
//SqlCommand sqlcmd = new SqlCommand(queryString, Connection);
//sqlcmd.Connection.Open();
//sqlcmd.ExecuteNonQuery();
//sqlcmd.Connection.Close();
DB obj = new DB();
String storedProcName = "[usp_InsertPerson]";
//List of parameter required
SqlParameter[] param = {
new SqlParameter("@UserRole", userRole),
new SqlParameter("@RoleData", roleData),
new SqlParameter("@UserLogin", userLogin),
new SqlParameter("@PersonType", person.PersonType),
new SqlParameter("@PersonTitle", person.PersonTitle),
new SqlParameter("@PersonFirstName", person.PersonFirstName),
new SqlParameter("@PersonLastName", person.PersonLastName),
new SqlParameter("@PersonEmailPrimary", person.PersonEmailPrimary),
new SqlParameter("@PersonEmailAlternate", person.PersonEmailAlternate),
new SqlParameter("@PersonFax", person.PersonFax),
new SqlParameter("@PersonPhonePrimary", person.PersonPhonePrimary),
new SqlParameter("@PersonPhoneHome", person.PersonPhoneHome),
new SqlParameter("@PersonPhoneMobile", person.PersonPhoneMobile),
new SqlParameter("@PersonPhoneWork", person.PersonPhoneWork),
new SqlParameter("@PersonPhoneEmergency", person.PersonPhoneEmergency),
new SqlParameter("@PersonCompanyName", person.PersonCompanyName),
new SqlParameter("@PersonPosition", person.PersonPosition),
new SqlParameter("@PersonDescription", person.PersonDescription),
new SqlParameter("@IsActive", person.PersonIsActive)
};
DataTable dt = obj.getSPRecords("ConnectionString", storedProcName, param);
return dt;
}
/// <summary>
/// Create a new person. Normally SPROC time and we would return the ID - not sure
/// if SQLite supports peeking identity columns, and the day is drawing
/// to a close.
/// </summary>
/// <param name="person"></param>
/// <returns></returns>
public int CreatePerson(IPersonEntity person)
{
string sql = "INSERT INTO Person (FirstName, LastName, Age) VALUES (@FirstName, @LastName, @Age) ";
var parms = new List <SQLiteParameter>();
parms.Add(new SQLiteParameter("@FirstName", person.FirstName));
parms.Add(new SQLiteParameter("@LastName", person.LastName));
parms.Add(new SQLiteParameter("@Age", person.Age));
ExecuteNonQuery(sql, parms);
return(1);
}
public DataTable ApprovePerson(string userRole, string roleData, string userLogin, IPersonEntity person)
{
DB obj = new DB();
String storedProcName = "[usp_ApprovePerson]";
//List of parameter required
SqlParameter[] param = {
new SqlParameter("@UserRole", userRole),
new SqlParameter("@RoleData", roleData),
new SqlParameter("@UserLogin", userLogin),
new SqlParameter("@PersonID", person.PersonID),
new SqlParameter("@IsActive", person.PersonIsActive)
};
DataTable dt = obj.getSPRecords("ConnectionString", storedProcName, param);
return dt;
}
/// <summary>
/// Returns a PersonEntity, without ID, as a concatenated
/// string to allow shallow comparison.
/// </summary>
/// <param name="person"></param>
/// <returns></returns>
private string GetPersonString(IPersonEntity person)
{
return($"{person.FirstName}|{person.LastName}|{person.Age}");
}
public IPersonEntity Save(IPersonEntity person)
{
throw new NotImplementedException();
}
public int CreatePerson(IPersonEntity person)
{
throw new NotImplementedException();
}
public int CreatePerson(IPersonEntity person)
{
return(1);
}
public DataTable UpdatePerson(string userRole, string roleData, string userLogin, IPersonEntity person)
{
DB obj = new DB();
String storedProcName = "[usp_UpdatePerson]";
//List of parameter required
SqlParameter[] param = {
new SqlParameter("@UserRole", userRole),
new SqlParameter("@RoleData", roleData),
new SqlParameter("@UserLogin", userLogin),
new SqlParameter("@PersonID", person.PersonID),
//new SqlParameter("@PersonType", person.PersonType),
//new SqlParameter("@PersonTitle", person.PersonTitle),
new SqlParameter("@PersonFirstName", person.PersonFirstName),
new SqlParameter("@PersonLastName", person.PersonLastName),
//new SqlParameter("@PersonEmailPrimary", person.PersonEmailPrimary),
//new SqlParameter("@PersonEmailAlternate", person.PersonEmailAlternate),
//new SqlParameter("@PersonFax", person.PersonFax),
new SqlParameter("@PersonPhonePrimary", person.PersonPhonePrimary),
//new SqlParameter("@PersonPhoneHome", person.PersonPhoneHome),
new SqlParameter("@PersonPhoneMobile", person.PersonPhoneMobile),
//new SqlParameter("@PersonPhoneWork", person.PersonPhoneWork),
//new SqlParameter("@PersonPhoneEmergency", person.PersonPhoneEmergency),
//new SqlParameter("@PersonCompanyName", person.PersonCompanyName),
//new SqlParameter("@PersonPosition", person.PersonPosition),
//new SqlParameter("@PersonDescription", person.PersonDescription),
//new SqlParameter("@IsActive", person.PersonIsActive)
};
DataTable dt = obj.getSPRecords("ConnectionString", storedProcName, param);
return dt;
}
public void Remove(IPersonEntity entity)
{
}
public void Add(IPersonEntity entity)
{
}