public bool Insert(DTO_FOOD food) { try { conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO [FOOD] VALUES(@ID_FOD, @ID_CAT, @DISPLAYNAME, @OUTPUTPRICE)", conn); cmd.Parameters.AddWithValue("@ID_FOD", food.ID_FOD); cmd.Parameters.AddWithValue("@ID_CAT", food.ID_CAT); cmd.Parameters.AddWithValue("@DISPLAYNAME", food.DISPLAYNAME); cmd.Parameters.AddWithValue("@OUTPUTPRICE", food.OUTPUTPRICE); if (cmd.ExecuteNonQuery() > 0) { return(true); } } catch (Exception e) { } finally { conn.Close(); } return(false); }
private void btUpdate_Click(object sender, EventArgs e) { int currentRowIndex = dgvFoodCategory.CurrentCellAddress.Y; if (-1 < currentRowIndex && currentRowIndex < dgvFoodCategory.RowCount) { try { DTO_FOOD food_DTO = new DTO_FOOD(); food_DTO.ID_FOD = txbID.Text; food_DTO.OUTPUTPRICE = txbPrice.Text; food_DTO.DISPLAYNAME = txbName.Text; food_DTO.ID_CAT = cbCategory.SelectedValue.ToString(); bool result = food_BUS.Update(food_DTO); if (result) { MessageBox.Show("Updated...", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); cbCategory_SelectedIndexChanged(sender, e); } else { MessageBox.Show("Error...", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception f) { } finally { } } }
public bool Update(DTO_FOOD food) { try { conn.Open(); SqlCommand cmd = new SqlCommand( "UPDATE [FOOD] SET " + "[ID_CAT]=@ID_CAT, " + "[DISPLAYNAME]=@DISPLAYNAME, " + "[OUTPUTPRICE]=@OUTPUTPRICE " + "WHERE [ID_FOD]=@ID_FOD", conn ); cmd.Parameters.AddWithValue("@ID_FOD", food.ID_FOD); cmd.Parameters.AddWithValue("@ID_CAT", food.ID_CAT); cmd.Parameters.AddWithValue("@DISPLAYNAME", food.DISPLAYNAME); cmd.Parameters.AddWithValue("@OUTPUTPRICE", food.OUTPUTPRICE); if (cmd.ExecuteNonQuery() > 0) { return(true); } } catch (Exception e) { } finally { conn.Close(); } return(false); }
public bool Select_ID(ref DTO_FOOD food, string id_food) { try { conn.Open(); SqlCommand cmd = new SqlCommand( "SELECT [ID_FOD],[ID_CAT],[DISPLAYNAME], " + "[OUTPUTPRICE] FROM [FOOD] " + "WHERE [FOOD].[ID_FOD] = @ID_FOD ", conn ); cmd.Parameters.AddWithValue("@ID_FOD", id_food); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { food = new DTO_FOOD(dr["ID_FOD"].ToString(), dr["ID_CAT"].ToString() , dr["DISPLAYNAME"].ToString(), dr["OUTPUTPRICE"].ToString()); } if (cmd.ExecuteNonQuery() > 0) { return(true); } } catch (Exception e) { } finally { conn.Close(); } return(false); }
private void cbx_food_SelectedIndexChanged(object sender, EventArgs e) { DTO_FOOD _food = new DTO_FOOD(); food_BUS.Select_ID(ref _food, cbx_food.SelectedValue.ToString()); //MessageBox.Show("price: " + _food.OUTPUTPRICE); lb_price_food.Text = _food.OUTPUTPRICE; }
private void btAdd_Click(object sender, EventArgs e) { DTO_FOOD food_DTO = new DTO_FOOD(); food_DTO.ID_FOD = txbID.Text; food_DTO.ID_CAT = cbCategory.SelectedValue.ToString(); food_DTO.DISPLAYNAME = txbName.Text; food_DTO.OUTPUTPRICE = txbPrice.Text; bool result = food_BUS.Insert(food_DTO); if (result) { MessageBox.Show("Inserted...", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); String nextID = ""; food_BUS.NextID(ref nextID); txbID.Text = nextID.ToString(); } else { MessageBox.Show("Error...", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool Update(DTO_FOOD dal) { return(food.Update(dal)); }
public bool Select_ID(ref DTO_FOOD _food, string id_food) { return(food.Select_ID(ref _food, id_food)); }
public bool Insert(DTO_FOOD ifood) { return(food.Insert(ifood)); }