public void dbInsertOptions(OptionDetails option)
{
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("INSERT INTO [Option] (Theme,Font,Notification,UserNickname) VALUES(@Theme,@Font,@Notification,@Nickname)", con);
cmd.Parameters.Add("@Theme", SqlDbType.VarChar).Value = option.Theme;
cmd.Parameters.Add("@Font", SqlDbType.VarChar).Value = option.Font;
cmd.Parameters.Add("@Notification", SqlDbType.Bit).Value = option.Notification;
cmd.Parameters.Add("@Nickname", SqlDbType.VarChar).Value = option.UserNickname;
int test = cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public void dbModifyOptions(OptionDetails option)
{
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("UPDATE [Option] SET Font=@Font, Theme=@Theme, Notification=@Notification WHERE UserNickname=@Nickname", con);
cmd.Parameters.Add("@Nickname", System.Data.SqlDbType.VarChar).Value = option.UserNickname;
cmd.Parameters.Add("@Font", System.Data.SqlDbType.VarChar).Value = option.Font;
cmd.Parameters.Add("@Theme", System.Data.SqlDbType.VarChar).Value = option.Theme;
cmd.Parameters.Add("@Notification", System.Data.SqlDbType.VarChar).Value = option.Notification;
int test = cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public OptionDetails dbGetOptions(string Nickname)
{
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
OptionDetails option = new OptionDetails();
SqlCommand cmd = new SqlCommand("SELECT * FROM [Option] WHERE UserNickname=@Nickname", con);
cmd.Parameters.Add("@Nickname", SqlDbType.VarChar).Value = Nickname;
SqlDataReader reader = cmd.ExecuteReader();
bool x = reader.Read();
option.Theme = reader.GetValue(0).ToString();
option.Font = reader.GetValue(1).ToString();
option.Notification = bool.Parse(reader.GetValue(2).ToString());
reader.Close();
cmd.Dispose();
con.Close();
return(option);
}
