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 void SetDetails(clsArtist prArtist)
{
_Artist = prArtist;
txtName.Enabled = string.IsNullOrEmpty(_Artist.Name);
UpdateForm();
UpdateDisplay();
frmMain.Instance.GalleryNameChanged += new frmMain.Notify(updateTitle);
// updateTitle(_Artist.ArtistList.GalleryName);
Show();
}
public string PostArtist(clsArtist prArtist)
{
try
{
int lcRecCount = clsDbConnection.Execute(
"INSERT INTO Artist (Speciality, Phone, Name) VALUES (@Speciality, @Phone, @Name)", prepareArtistParameters(prArtist));
if (lcRecCount == 1)
{
return("One artist added");
}
else
{
return("Unexpected artist insert count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
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);
}
}
internal async static Task <string> UpdateArtistAsync(clsArtist prArtist)
{
return(await InsertOrUpdateAsync(prArtist, "http://localhost:60064/api/gallery/PutArtist", "PUT"));
}