private Dictionary <string, object> prepareArtistParameters(clsArtist prArtist) { Dictionary <string, object> par = new Dictionary <string, object>(3); par.Add("Name", prArtist.Name); par.Add("Speciality", prArtist.Speciality); par.Add("Phone", prArtist.Phone); return(par); }
public string PutArtist(clsArtist prArtist) { // update try { int lcRecCount = clsDbConnection.Execute( "UPDATE Artist SET Speciality = @Speciality, Phone = @Phone WHERE Name = @Name", prepareArtistParameters(prArtist)); if (lcRecCount == 1) { return("One artist updated"); } else { return("Unexpected artist update count: " + lcRecCount); } } catch (Exception ex) { return(ex.GetBaseException().Message); } }
public string PostArtist(clsArtist prArtist) { // insert try { int lcRecCount = clsDbConnection.Execute( "Insert Into Artist(Name,Speciality,Phone) Values(@Name, @Speciality, @Phone)", prepareArtistParameters(prArtist)); if (lcRecCount == 1) { return("One artist inserted"); } else { return("Unexpected artist insert count: " + lcRecCount); } } catch (Exception ex) { return(ex.GetBaseException().Message); } }