public int AddContributor(Contributor contributor) { using (MySqlConnection dbConn = new MySqlConnection(_connString)) { dbConn.Open(); string sql = $@" INSERT INTO bipc.contributor(contributor_id, first_name, last_name, family_name, status, date_added) VALUES (bipc.fn_get_nextid('contributor'), @firstName, @lastName, @familyName, 1, now());"; return(dbConn.Execute(sql, new { @firstName = contributor.FirstName, @lastName = contributor.LastName, @familyName = contributor.FamilyName })); } }
public IActionResult Add(ChurchLibrary.Model.Contributor contributor) { var apiContributor = new ApiCallerContributor("http://localhost:8080/"); if (apiContributor.GetAllFullNames().Contains($"{contributor.LastName}, {contributor.FirstName}")) { ModelState.AddModelError("Error", "Member already exists"); } else { try { apiContributor.AddContributor(contributor); } catch (Exception ex) { ModelState.AddModelError("Error", ex.Message); } } return(View("Add", contributor)); }
/// <summary> /// Update contributor /// </summary> /// <param name="contributor"></param> public int UpdateContributor(Contributor contributor) { using (MySqlConnection dbConn = new MySqlConnection(_connString)) { dbConn.Open(); string sql = $@"UPDATE contributor SET first_name = @firstName, last_name = @lastName, family_name = @familyName, date_changed = now() WHERE contributor_id = @contributorId AND status = 1;"; return(dbConn.Execute(sql, new { @firstName = contributor.FirstName, @lastName = contributor.LastName, @familyName = contributor.FamilyName, @contributorId = contributor.Id })); } }