public FAgeDiscount()
{
InitializeComponent();
ageDiscountModel = new AgeDiscountModel();
listDiscount = new DataTable();
rowIndex = 0;
seletedFunction = 0;
ageDiscount = new AgeDiscount();
}
public bool updateAgeDiscount(AgeDiscount AgeDiscount)
{
bool updated = false;
SqlConnection connection;
SqlCommand command;
string sql = "UPDATE tbAgeDiscount SET MinAge = " + AgeDiscount.MinAge + ", MaxAge = " + AgeDiscount.MaxAge + ", Discount = " + AgeDiscount.DiscountRate + " WHERE DiscountId = " + AgeDiscount.DiscountId;
try
{
connection = new ConnectDB().connectToSQL();
command = new SqlCommand(sql, connection);
if (command.ExecuteNonQuery() == 1)
{
updated = true;
}
}
catch (Exception)
{
throw;
}
connection.Close();
return(updated);
}
public bool insertAgeDiscount(AgeDiscount discount)
{
bool inserted = false;
SqlConnection connection;
SqlCommand command;
string sql = "INSERT INTO tbAgeDiscount VALUES(" + discount.MinAge + ", " + discount.MaxAge + ", " + discount.DiscountRate + ")";
try
{
connection = new ConnectDB().connectToSQL();
command = new SqlCommand(sql, connection);
if (command.ExecuteNonQuery() == 1)
{
inserted = true;
}
}
catch (Exception)
{
throw;
}
connection.Close();
return(inserted);
}
