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