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