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