public bool Update_FixedPrice(DTO_FixedPrice Fixed)
        {
            connect();

            string sql = "UPDATE  capston1_customers.FixedPrice SET  Amount=@Amount,Date =@Date, Description=@Description WHERE  No =  @No";

            try
            {
                _cmd = new MySqlCommand(sql, _cnn);
                _cmd.Parameters.Add("@No", MySqlDbType.VarChar).Value       = Fixed.No;
                _cmd.Parameters.Add("@Amount", MySqlDbType.Decimal).Value   = Fixed.Amount;
                _cmd.Parameters.Add("@Date", MySqlDbType.Text).Value        = Fixed.Date;
                _cmd.Parameters.Add("@Description", MySqlDbType.Text).Value = Fixed.Description;
                _cmd.ExecuteNonQuery();
                _cmd.Dispose();
                disconnect();
            }
            catch (Exception ex)
            {
                disconnect();
                return(false);

                throw ex;
            }
            return(true);
        }
        public bool Insert_FixedPrice(DTO_FixedPrice Fixed)
        {
            connect();

            string sql = "INSERT INTO capston1_customers.FixedPrice (No,Matter_ID, Date, Description, Amount) VALUES (@No,@Matter_ID, @Date, @Description, @Amount)";

            try
            {
                _cmd = new MySqlCommand(sql, _cnn);
                _cmd.Parameters.Add("@No", MySqlDbType.VarChar).Value            = Fixed.No;
                _cmd.Parameters.Add("@Matter_ID", MySqlDbType.VarChar, 30).Value = Fixed.Matter_ID;
                _cmd.Parameters.Add("@Amount", MySqlDbType.Decimal).Value        = Fixed.Amount;
                _cmd.Parameters.Add("@Date", MySqlDbType.Text).Value             = Fixed.Date;
                _cmd.Parameters.Add("@Description", MySqlDbType.Text).Value      = Fixed.Description;
                _cmd.ExecuteNonQuery();
                _cmd.Dispose();
                disconnect();
            }
            catch (Exception ex)
            {
                disconnect();
                return(false);

                throw ex;
            }
            return(true);
        }
        public bool Delete_FixedPrice(DTO_FixedPrice Fixed)
        {
            connect();

            string sql = "DELETE FROM FixedPrice WHERE  No =  @No";

            try
            {
                _cmd = new MySqlCommand(sql, _cnn);
                _cmd.Parameters.Add("@No", MySqlDbType.VarChar).Value = Fixed.No;
                _cmd.ExecuteNonQuery();
                _cmd.Dispose();
                disconnect();
            }
            catch (Exception ex)
            {
                disconnect();
                return(false);

                throw ex;
            }
            return(true);
        }
 public bool Delete_FixedPrice(DTO_FixedPrice Fixed)
 {
     return(_DAO_Time.Delete_FixedPrice(Fixed));
 }
 public bool Update_FixedPrice(DTO_FixedPrice Fixed)
 {
     return(_DAO_Time.Update_FixedPrice(Fixed));
 }
 public bool Insert_FixedPrice(DTO_FixedPrice Fixed)
 {
     return(_DAO_Time.Insert_FixedPrice(Fixed));
 }