// Token: 0x06000795 RID: 1941 RVA: 0x00034660 File Offset: 0x00032860 private static void AddParams(SqlCommand command, ExternalWebsite site) { command.Parameters.AddWithValue("site", site.ID); command.Parameters.AddWithValue("short", site.ShortTitle); command.Parameters.AddWithValue("full", site.FullTitle); command.Parameters.AddWithValue("url", site.URL); }
private static void AddParams(SqlCommand command, ExternalWebsite site) { command.Parameters.AddWithValue(nameof(site), (object)site.get_ID()); command.Parameters.AddWithValue("short", (object)site.get_ShortTitle()); command.Parameters.AddWithValue("full", (object)site.get_FullTitle()); command.Parameters.AddWithValue("url", (object)site.get_URL()); }
// Token: 0x06000794 RID: 1940 RVA: 0x00034618 File Offset: 0x00032818 public static void Update(ExternalWebsite site) { using (SqlCommand textCommand = SqlHelper.GetTextCommand("UPDATE ExternalWebsites SET ShortTitle=@short, FullTitle=@full, URL=@url WHERE ExternalWebsiteID=@site")) { ExternalWebsitesDAL.AddParams(textCommand, site); SqlHelper.ExecuteNonQuery(textCommand); } ExternalWebsitesDAL.ClearMenuCache(); }
private static ExternalWebsite Create(IDataReader reader) { ExternalWebsite externalWebsite = new ExternalWebsite(); externalWebsite.set_ID((int)reader["ExternalWebsiteID"]); externalWebsite.set_ShortTitle((string)reader["ShortTitle"]); externalWebsite.set_FullTitle((string)reader["FullTitle"]); externalWebsite.set_URL((string)reader["URL"]); return(externalWebsite); }
// Token: 0x06000793 RID: 1939 RVA: 0x000345C8 File Offset: 0x000327C8 public static int Insert(ExternalWebsite site) { int result; using (SqlCommand textCommand = SqlHelper.GetTextCommand("INSERT ExternalWebsites (ShortTitle, FullTitle, URL) VALUES (@short, @full, @url)\nSELECT scope_identity()")) { ExternalWebsitesDAL.AddParams(textCommand, site); result = Convert.ToInt32(SqlHelper.ExecuteScalar(textCommand)); } ExternalWebsitesDAL.ClearMenuCache(); return(result); }