示例#1
0
        private void btnSub_Click(object sender, EventArgs e)
        {
            //Create an instance of a person
            RecipeClass temp = new RecipeClass();

            //Assign the instance of a person a name
            //temp.Feedback = "";
            //temp.Id = txtFName.Text;
            temp.Name     = txtName.Text; // txtMName.Text;
            temp.Desc     = txtDesc.Text; // txtLName.Text;
            temp.Ingr     = txtIngr.Text;
            temp.Favorite = ckbxFav.Checked;
            temp.Notes    = txtNotes.Text;
            temp.Reci     = txtRecipe.Text;
            temp.Type     = cboType.Text;

            if (temp.validEntry())
            {
                label1.Text = temp.AddRecipe();
                if (label1.Text == "1Record(s) Added")
                {
                    this.Close();
                }
            }
            else
            {
                MessageBox.Show("More data must be entered.");
            }
        }//End
示例#2
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            pictureBox1.InitialImage = null;
            pictureBox1.Image        = null;

            RecipeClass temp       = new RecipeClass();
            Int32       intG_ID    = Convert.ToInt32(lblID.Text);
            Int32       intRecords = temp.DeleteOneRec(intG_ID);

            MessageBox.Show(intRecords.ToString() + " Records Deleted.");

            this.Close();
        }//End delete
示例#3
0
        //OVERLOADED CONSTRUCTOR - Meant to pull up existing data
        public NewRec(Int32 intR_ID)
        {
            InitializeComponent();
            cboType.SelectedIndex = 0;
            btnSub.Enabled        = false;
            btnSub.Visible        = false;

            //Gather info about this one person and store it in a datareader
            RecipeClass     temp = new RecipeClass();
            OleDbDataReader dr   = temp.FindOneRecipe(intR_ID);

            //Use that info to fill out the form
            //Loop through the records
            while (dr.Read())
            {
                //Take the Name(s) from the datareader and copy them
                // into the appropriate text fields
                txtDesc.Text   = dr["rDesc"].ToString();
                txtIngr.Text   = dr["ingr"].ToString();
                txtName.Text   = dr["rName"].ToString();
                txtNotes.Text  = dr["notes"].ToString();
                txtRecipe.Text = dr["recipe"].ToString();
                cboType.Text   = dr["type"].ToString();

                if (Boolean.Parse(dr["favorite"].ToString()) == true)
                {
                    ckbxFav.Checked = true;
                }

                //added to store the ID in a label
                lblID.Text = dr["id"].ToString();

                string curFile = @"Data\Image\" + txtName.Text + ".bmp";//@"Data\Image\" +txtName.Text+".bmp"

                if (File.Exists(curFile))
                { //pictureBox1.Image = Image.FromFile(curFile);
                    Image image = Image.FromFile(curFile);
                    // Set the PictureBox image property to this image.
                    // ... Then, adjust its height and width properties.
                    pictureBox1.Image = image.GetThumbnailImage(257, 163, null, new IntPtr());
                    //pictureBox1.Height = image.Height = 163;
                    //pictureBox1.Width = image.Width = 257;
                } //end if
            }     //End wile
        }
示例#4
0
        }//End picbox

        private void btnUpdate_Click(object sender, EventArgs e)
        {
            RecipeClass temp = new RecipeClass();

            temp.Name     = txtName.Text; // txtMName.Text;
            temp.Desc     = txtDesc.Text; // txtLName.Text;
            temp.Ingr     = txtIngr.Text;
            temp.Favorite = ckbxFav.Checked;
            temp.Notes    = txtNotes.Text;
            temp.Reci     = txtRecipe.Text;
            temp.Type     = cboType.Text;
            temp.Id       = Int32.Parse(lblID.Text);

            if (temp.validEntry())
            {
                label1.Text = temp.UpdateRec();
            }
            else
            {
                MessageBox.Show("More data must be entered.");
            }
        }
示例#5
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            //get data
            RecipeClass temp = new RecipeClass();
            //preform search

            RecipeClass temp2 = new RecipeClass();

            temp2.Name     = txtRname.Text;
            temp2.Ingr     = txtIngr.Text;
            temp2.Favorite = chkBxFav.Checked;
            try { temp2.Id = Convert.ToInt32(txtID.Text); }
            catch { temp2.Id = -1; }
            temp2.Type = cboType.Text;

            DataSet ds = temp.SearchRec(temp2);

            //DataSet ds = temp.SearchRec(txtRname.Text);

            //display data
            gv_results.DataSource = ds;
            gv_results.DataMember = ds.Tables["RecipeTable"].ToString();//.DataSource
        }
示例#6
0
        }//End add Recipe

        //DataSet

        public DataSet SearchRec(RecipeClass temp)//String RecName)
        {
            //Create a dataset to return filled
            DataSet ds = new DataSet();


            //Create a command for our SQL statement
            OleDbCommand comm = new OleDbCommand();


            //SQL Statement
            String strSQL = "Select id as ID, rName as Recipe_Name, rDesc as Recipe_Description, type as Type, ingr as Ingredients, recipe as Recipe, favorite as Favorite FROM RecipeTable WHERE 0=0";

            //If the First/Last Name is filled in include it as search criteria
            if (temp.name.Length > 0)
            {
                strSQL += " AND rName LIKE @RecName";
                comm.Parameters.AddWithValue("@RecName", "%" + temp.name + "%");
            }

            if (temp.id != null && temp.id > 0)
            {
                strSQL += " AND id LIKE @id";
                comm.Parameters.AddWithValue("@id", "%" + temp.id + "%");
            }

            if (temp.type.Length > 0)
            {
                strSQL += " AND type LIKE @ty";
                comm.Parameters.AddWithValue("@ty", "%" + temp.type + "%");
            }

            if (temp.ingr.Length > 0)
            {
                strSQL += " AND ingr LIKE @ing";
                comm.Parameters.AddWithValue("@ing", "%" + temp.ingr + "%");
            }

            if (temp.favorite == true)
            {
                strSQL += " AND favorite LIKE @fv";
                comm.Parameters.AddWithValue("@fv", "%" + -1 + "%");
            }

            //Create DB tools and Configure
            //************************************************
            OleDbConnection conn = new OleDbConnection();

            string strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Data\Data.accdb;Persist Security Info=False;";//@SqlDb_Game.GetConnected();

            conn.ConnectionString = strConn;

            comm.Connection  = conn;
            comm.CommandText = strSQL;

            //Create Data Adapter
            OleDbDataAdapter da = new OleDbDataAdapter();

            da.SelectCommand = comm;

            //************************************************

            //Get Data
            conn.Open();
            da.Fill(ds, "RecipeTable");
            conn.Close();


            return(ds);
        }//End Search Game