// insert a sale
public bool insertSale(SALE sale)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `sale`(`property_id`,`selling_price`, `sale_date`) VALUES (@pid,@slprice,@sldate)");
// @pid,@clid,@slprice,@sldate
command.Parameters.Add("@pid", MySqlDbType.Int32).Value = sale.propertyid;
command.Parameters.Add("@slprice", MySqlDbType.Int32).Value = sale.sellingprice;
command.Parameters.Add("@sldate", MySqlDbType.Date).Value = sale.sellingdate;
return(func.ExecQuery(command));
}
// edit the selected sale
public bool updateSale(SALE sale)
{
MySqlCommand command = new MySqlCommand("UPDATE `sale` SET `property_id`=@pid,`selling_price`=@slprice,`sale_date`=@sldate WHERE `id`=@id");
//@id,@pid,@clid,@slprice,@sldate
command.Parameters.Add("@pid", MySqlDbType.Int32).Value = sale.propertyid;
command.Parameters.Add("@slprice", MySqlDbType.Int32).Value = sale.sellingprice;
command.Parameters.Add("@sldate", MySqlDbType.Date).Value = sale.sellingdate;
command.Parameters.Add("@id", MySqlDbType.Int32).Value = sale.id;
return(func.ExecQuery(command));
}