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) { }