public void CreateSetting(Setting setting)
{
SqlParameter[] param = new SqlParameter[]{
SqlUtilities.GenerateInputNVarcharParameter("@title",200,setting.Title),
SqlUtilities.GenerateInputNVarcharParameter("@keyword",500,setting.Keyword),
SqlUtilities.GenerateInputNVarcharParameter("@description",500,setting.Description),
SqlUtilities.GenerateInputNVarcharParameter("@phone",100,setting.Phone),
SqlUtilities.GenerateInputNVarcharParameter("@fax",100,setting.Fax),
SqlUtilities.GenerateInputNVarcharParameter("@email",50,setting.Email),
SqlUtilities.GenerateInputNVarcharParameter("@msn",50,setting.Msn),
SqlUtilities.GenerateInputNVarcharParameter("@postalcode",10,setting.Postalcode),
SqlUtilities.GenerateInputNVarcharParameter("@address",200,setting.Address),
SqlUtilities.GenerateInputNVarcharParameter("@copyright",200,setting.Copyright),
SqlUtilities.GenerateInputNVarcharParameter("@record",100,setting.Record)
};
string sql = "INSERT INTO settings (title, keyword, description, phone, fax, email, postalcode, address, copyright, record, msn ) VALUES (@title, @keyword, @description, @phone, @fax, @email, @postalcode, @address, @copyright, @record, @msn )";
SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public void UpdateSetting(Setting setting)
{
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@id",setting.Id),
SqlUtilities.GenerateInputNVarcharParameter("@title",200,setting.Title),
SqlUtilities.GenerateInputNVarcharParameter("@keyword",500,setting.Keyword),
SqlUtilities.GenerateInputNVarcharParameter("@description",500,setting.Description),
SqlUtilities.GenerateInputNVarcharParameter("@phone",100,setting.Phone),
SqlUtilities.GenerateInputNVarcharParameter("@fax",100,setting.Fax),
SqlUtilities.GenerateInputNVarcharParameter("@email",50,setting.Email),
SqlUtilities.GenerateInputNVarcharParameter("@msn",50,setting.Msn),
SqlUtilities.GenerateInputNVarcharParameter("@postalcode",10,setting.Postalcode),
SqlUtilities.GenerateInputNVarcharParameter("@address",200,setting.Address),
SqlUtilities.GenerateInputNVarcharParameter("@copyright",200,setting.Copyright),
SqlUtilities.GenerateInputNVarcharParameter("@record",100,setting.Record)
};
string sql = "UPDATE settings SET title = @title, keyword = @keyword, description = @description, phone = @phone, fax = @fax, email= @Email, msn = @msn, postalcode = @postalcode, copyright = @copyright, address = @Address, record = @record WHERE id = @id";
SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public static void UpdateSetting(Setting setting)
{
dal.UpdateSetting(setting);
}
public Setting GetSetting()
{
Setting setting = null;
string sql = "SELECT id, title, keyword, description, phone, fax, email, postalcode, address, copyright, record, msn FROM settings";
using(SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, null))
{
while(dr.Read())
{
setting = new Setting();
setting.Id = dr.GetInt32(0);
setting.Title = dr.GetString(1);
setting.Keyword = dr.GetString(2);
setting.Description = dr.GetString(3);
setting.Phone = dr.GetString(4);
setting.Fax = dr.GetString(5);
setting.Email = dr.GetString(6);
setting.Postalcode = dr.GetString(7);
setting.Address = dr.GetString(8);
setting.Copyright = dr.GetString(9);
setting.Record = dr.GetString(10);
setting.Msn = dr.GetString(11);
}
}
return setting;
}
public static void CreateSetting(Setting setting)
{
dal.CreateSetting(setting);
}
