public bool UpdateStaffSocialMedia(StaffSocialMedia stMedia)
{
bool result = false;
var sql = "Update StaffSocialMedia set StaffID=@staffid,PlatformName=@name,PlatformIcon=@icon,AccountName=@acc,AccountURL=@url,Status=@status where ID=@id;";
int resultExecuteNonQuery = con.Execute(sql, new { staffid = stMedia.StaffID, name = stMedia.PlatformName, icon = stMedia.PlatformIcon, acc = stMedia.AccountName, url = stMedia.AccountURL, status = true });
if (resultExecuteNonQuery == 1)
{
result = true;
}
return(result);
}
public bool AddStaffSocialMedia(StaffSocialMedia stMedia)
{
bool result = false;
var sql = "INSERT INTO StaffSocialMedia (StaffID,PlatformName,PlatformIcon,AccountName,AccountURL,Status) values (@staffid,@name,@icon,@acc,@url,@status);";
int resultExecuteNonQuery = con.Execute(sql, new { staffid = stMedia.StaffID, name = stMedia.PlatformName, icon = stMedia.PlatformIcon, acc = stMedia.AccountName, url = stMedia.AccountURL, status = true });
if (resultExecuteNonQuery == 1)
{
result = true;
}
return(result);
}
