//retrieve list of postage types
public static List <PostageOptions> GetPostageOption(int s)
{
List <PostageOptions> options = new List <PostageOptions>();
using (SqlConnection connection = new SqlConnection(m_connectionString))
{
// Get all data about product with product category name
string sql = "select postageOptionsID, name, price, estimatedDays, description, isDeleted " +
"FROM PostageOptions WHERE postageOptionsID = @s";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@s", s);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
//Reading data from the database and adding it to a list
while (reader.Read())
{
PostageOptions o = new PostageOptions();
o.ID = (int)reader["postageOptionsID"];
o.Name = reader["name"].ToString();
o.Price = Convert.ToDouble(reader["price"]);
o.ETA = (int)reader["estimatedDays"];
o.Description = reader["description"].ToString();
o.IsDeleted = Convert.ToBoolean(reader["isDeleted"]);
}
reader.Close();
}
}
return(options);
}
//create a new postage type
public static void AddPostageOption(PostageOptions o)
{
using (SqlConnection connection = new SqlConnection(m_connectionString))
{
string sql = "INSERT INTO PostageOptions (name, price, estimatedDays, description, isDeleted) " +
"VALUES (@name, @price, @estimatedDays, @description, 0)";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@name", o.Name);
command.Parameters.AddWithValue("@price", o.Price);
command.Parameters.AddWithValue("@estimatedDays", o.ETA);
command.Parameters.AddWithValue("@description", o.Description);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
reader.Close();
}
}
}
//update an existing postage type
public static void UpdatePostageOption(PostageOptions o)
{
using (SqlConnection connection = new SqlConnection(m_connectionString))
{
// Get all data about product with product category name
string sql = "UPDATE PostageOptions" +
"SET name = @name, price = @price, estimatedDays = @estimatedDays, description = @description " +
"WHERE postageOptionsID = @poi";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@poi", o.ID);
command.Parameters.AddWithValue("@name", o.Name);
command.Parameters.AddWithValue("@price", o.Price);
command.Parameters.AddWithValue("@estimatedDays", o.ETA);
command.Parameters.AddWithValue("@description", o.Description);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
reader.Close();
}
}
}
