public List<typediscountcard> GetAllTypeDiscount()
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("SELECT id, discount, coundition FROM TypeDiscountCard", con);
cmd.CommandType = CommandType.Text;
// Создать коллекцию для всех записей
List<typediscountcard> list = new List<typediscountcard>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
typediscountcard emp = new typediscountcard(
(int)reader["id"],
(int)reader["discount"],
(int)reader["coundition"]);
list.Add(emp);
}
reader.Close();
return list;
}
catch
{
throw new ApplicationException("Ошибка данныx. вернуть все типы дисконтов");
}
finally
{
con.Close();
}
}
public int AddTypeDiscount(typediscountcard emp1)
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("Insert into TypeDiscountCard(discount, coundition) values (@discount,@coundition) SET @id = @@IDENTITY ", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@discount", SqlDbType.Int, 3));
cmd.Parameters["@discount"].Value = emp1.Discount;
cmd.Parameters.Add(new SqlParameter("@coundition", SqlDbType.Int, 6));
cmd.Parameters["@coundition"].Value = emp1.Coundition;
cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.Int, 6));
cmd.Parameters["@id"].Direction = ParameterDirection.Output;
try
{
con.Open();
cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@id"].Value;
}
catch
{
return 0;
throw new ApplicationException("Ошибка данныx. добавление типа дисконта");
}
finally
{
con.Close();
}
}