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