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));
}
