private void btnManageProduct_Click(object sender, EventArgs e) { frmProductList productList = new frmProductList(); productList.TopLevel = false; panelContainer.Controls.Add(productList); productList.BringToFront(); productList.LoadRecords(); productList.Show(); }
private void btnSave_Click(object sender, EventArgs e) { try { using (SqlConnection sqlConnection = new SqlConnection(DBConnection.MyConnection())) { string brandid = "", categoryid = ""; SqlCommand sqlCommand; SqlDataReader sqlDataReader; #region Select BrandId string BQuery = @"select id from tblBrand where brand like @brand"; sqlConnection.Open(); sqlCommand = new SqlCommand(BQuery, sqlConnection); sqlCommand.Parameters.AddWithValue("@brand", SqlDbType.VarChar).Value = cmbBrand.Text; sqlDataReader = sqlCommand.ExecuteReader(); sqlDataReader.Read(); if (sqlDataReader.HasRows) { brandid = sqlDataReader[0].ToString(); } sqlConnection.Close(); sqlDataReader.Close(); #endregion #region Select CategoryId string CQuery = @"select id from tblcategory where category like @category"; sqlConnection.Open(); sqlCommand = new SqlCommand(CQuery, sqlConnection); sqlCommand.Parameters.AddWithValue("@category", SqlDbType.VarChar).Value = cmbCategory.Text; sqlDataReader = sqlCommand.ExecuteReader(); sqlDataReader.Read(); if (sqlDataReader.HasRows) { categoryid = sqlDataReader[0].ToString(); } sqlConnection.Close(); sqlDataReader.Close(); #endregion #region Insert Product string PQuery = @"insert into tblProduct (pcode,barcode,pdesc,brandid,categoryid,price) values (@pcode,@barcode,@pdesc,@brandid,@categoryid,@price)"; sqlConnection.Open(); sqlCommand = new SqlCommand(PQuery, sqlConnection); sqlCommand.Parameters.AddWithValue("@pcode", txtProductCode.Text); sqlCommand.Parameters.AddWithValue("@barcode", txtBarcode.Text); sqlCommand.Parameters.AddWithValue("@pdesc", txtDescription.Text); if (string.IsNullOrEmpty(brandid)) { brandid = "0"; } sqlCommand.Parameters.AddWithValue("@brandid", int.Parse(brandid)); if (string.IsNullOrEmpty(categoryid)) { categoryid = "0"; } sqlCommand.Parameters.AddWithValue("@categoryid", int.Parse(categoryid)); if (string.IsNullOrEmpty(txtPrice.Text.Trim())) { txtPrice.Text = "0"; } sqlCommand.Parameters.AddWithValue("@price", decimal.Parse(txtPrice.Text.Trim())); sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); #endregion MessageBox.Show("Product has been successfully saved.", _msg, MessageBoxButtons.OK, MessageBoxIcon.Information); Clear(); _frmProductList.LoadRecords(); } } catch (Exception ex) { MessageBox.Show(ex.ToString(), _msg, MessageBoxButtons.OK, MessageBoxIcon.Error); } }