private void StallForm_Load(object sender, EventArgs e) { switch (state) { case 0: textBoxName.Enabled = true; textBoxDescription.Enabled = true; buttonStall.Text = "Add Stall"; break; case 1: SL = SQLServerConnection.GetStallList(); foreach (StallList tempList in SL) { comboBoxID.Items.Add(tempList.StallID); } comboBoxID.Enabled = true; buttonStall.Text = "Update Stall"; break; case 2: SL = SQLServerConnection.GetStallList(); foreach (StallList tempList in SL) { comboBoxID.Items.Add(tempList.StallID); } comboBoxID.Enabled = true; buttonStall.Text = "Delete Stall"; break; default: Error("Unkown Error"); break; } }
private void FoodTypeForm_Load(object sender, EventArgs e) { switch (state) { case 0: textBoxName.Enabled = true; textBoxDescription.Enabled = true; buttonType.Text = "Add Food Type"; break; case 1: TL = SQLServerConnection.GetFoodTypeList(); foreach (TypeList tempList in TL) { comboBoxID.Items.Add(tempList.FoodTypeID); } comboBoxID.Enabled = true; buttonType.Text = "Update Food Type"; break; case 2: TL = SQLServerConnection.GetFoodTypeList(); foreach (TypeList tempList in TL) { comboBoxID.Items.Add(tempList.FoodTypeID); } comboBoxID.Enabled = true; buttonType.Text = "Delete Food Type"; break; default: Error("Unkown Error"); break; } }
public static void DeleteStall(SqlConnection SQLconn, int StallID) { using (SqlCommand command = new SqlCommand("dbo.DeleteStall", SQLconn)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@IDStall", SqlDbType.Int).Value = StallID; SQLconn.Open(); command.ExecuteNonQuery(); } SQLServerConnection.CloseSQLConnection(SQLconn); }
public static void AddType(SqlConnection SQLconn, string FoodType, string TypeDescription) { using (SqlCommand command = new SqlCommand("dbo.AddNewFoodType", SQLconn)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@TypeFood", SqlDbType.VarChar, 100).Value = FoodType; command.Parameters.Add("@DescType", SqlDbType.VarChar, 200).Value = TypeDescription; SQLconn.Open(); command.ExecuteNonQuery(); } SQLServerConnection.CloseSQLConnection(SQLconn); }
public static void UpdateStall(SqlConnection SQLconn, int StallID, string StallTypeName, string StallDescription) { using (SqlCommand command = new SqlCommand("dbo.UpdateStall", SQLconn)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@IDStall", SqlDbType.Int).Value = StallID; command.Parameters.Add("@NameStall", SqlDbType.VarChar, 100).Value = StallTypeName; command.Parameters.Add("@DescStall", SqlDbType.VarChar, 200).Value = StallDescription; SQLconn.Open(); command.ExecuteNonQuery(); } SQLServerConnection.CloseSQLConnection(SQLconn); }
private void buttonView_Click(object sender, EventArgs e) { SqlConnection SQLconn = SQLServerConnection.SQLConnection(); using (SqlDataAdapter dataAdapter = new SqlDataAdapter("dbo.ViewMenu", SQLconn)) { var command = new SqlCommandBuilder(dataAdapter); var ds = new DataSet(); dataAdapter.Fill(ds); dataGridView.DataSource = ds.Tables[0]; } SQLServerConnection.CloseSQLConnection(SQLconn); }
private void buttonSearchStall_Click(object sender, System.EventArgs e) { string Stall = "%" + textBoxStallName.Text + "%"; SqlConnection SQLconn = SQLServerConnection.SQLConnection(); using (SqlCommand command = new SqlCommand("dbo.SearchStall", SQLconn)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@NameStall", SqlDbType.VarChar, 100).Value = Stall; var ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); SQLconn.Open(); da.SelectCommand = command; da.Fill(ds); MMF.dataGridView.DataSource = ds.Tables[0]; } SQLServerConnection.CloseSQLConnection(SQLconn); }
public static List <StallList> GetStallList(SqlConnection SQLconn) { List <StallList> SL = new List <StallList>(); using (SqlCommand command = new SqlCommand("dbo.GetStallList", SQLconn)) { command.CommandType = CommandType.StoredProcedure; SQLconn.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { StallList tempSL = new StallList(); tempSL.StallID = reader.GetInt32(0); tempSL.StallName = reader.GetString(1); tempSL.StallDescription = reader.GetString(2); SL.Add(tempSL); } } } SQLServerConnection.CloseSQLConnection(SQLconn); return(SL); }
public static List <TypeList> GetTypeList(SqlConnection SQLconn) { List <TypeList> TL = new List <TypeList>(); using (SqlCommand command = new SqlCommand("dbo.GetFoodTypeList", SQLconn)) { command.CommandType = CommandType.StoredProcedure; SQLconn.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { TypeList tempTL = new TypeList(); tempTL.FoodTypeID = reader.GetInt32(0); tempTL.FoodType = reader.GetString(1); tempTL.TypeDescription = reader.GetString(2); TL.Add(tempTL); } } } SQLServerConnection.CloseSQLConnection(SQLconn); return(TL); }
private void buttonType_Click(object sender, EventArgs e) { SQLServerConnection.FTF = this; switch (state) { case 0: if (textBoxName.Text == "") { MessageBox.Show("Error: Empty Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { try { SQLServerConnection.AddFoodType(textBoxName.Text, textBoxDescription.Text); } catch (Exception ex) { Error(ex.ToString()); } MessageBox.Show("Food Type with name: " + textBoxName.Text + " has been successfully added to the database.", "New Food Type Added", MessageBoxButtons.OK, MessageBoxIcon.Information); } break; case 1: try { if (textBoxName.Text != "") { SQLServerConnection.UpdateFoodType(Convert.ToInt32(comboBoxID.Text), textBoxName.Text, textBoxDescription.Text); } else { Error("No selected item to update"); } MessageBox.Show("Food Type with ID: " + comboBoxID.Text + " has been successfully updated.", "Food Type Updated", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { Error(ex.ToString()); } break; case 2: try { if (textBoxName.Text != "") { SQLServerConnection.DeleteFoodType(Convert.ToInt32(comboBoxID.Text)); } else { Error("No selected item to update"); } } catch (Exception ex) { Error(ex.ToString()); } MessageBox.Show("Food Type with ID: " + comboBoxID.Text + " has been successfully deleted.", "Food Type Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); break; default: Error("Unkown Error"); break; } this.Close(); }
private void buttonItem_Click(object sender, EventArgs e) { SQLServerConnection.IF = this; switch (state) { case 0: if (comboBoxStallName.Text == "" || textBoxFoodName.Text == "" || comboBoxFoodType.Text == "" || textBoxPrice.Text == "") { MessageBox.Show("Error: Empty items", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { try { SQLServerConnection.AddItem(Convert.ToInt32(textBoxStallID.Text), Convert.ToInt32(textBoxFoodTypeID.Text), textBoxFoodName.Text, textBoxFoodDescription.Text, Convert.ToDecimal(textBoxPrice.Text)); } catch (Exception ex) { Error(ex.ToString()); } MessageBox.Show("Item with name: " + textBoxFoodName.Text + " has been successfully added to the database.", "New Item Added", MessageBoxButtons.OK, MessageBoxIcon.Information); } break; case 1: try { if (comboBoxFoodID.Text != "") { SQLServerConnection.UpdateItem(Convert.ToInt32(comboBoxFoodID.Text), Convert.ToInt32(textBoxStallID.Text), Convert.ToInt32(textBoxFoodTypeID.Text), textBoxFoodName.Text, textBoxFoodDescription.Text, Convert.ToDecimal(textBoxPrice.Text)); } else { Error("No selected item to update"); } MessageBox.Show("Item with ID: " + comboBoxFoodID.Text + " has been successfully updated.", "Item Updated", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { Error(ex.ToString()); } break; case 2: try { if (comboBoxFoodID.Text != "") { SQLServerConnection.DeleteItem(Convert.ToInt32(comboBoxFoodID.Text)); } else { Error("No selected item to update"); } } catch (Exception ex) { Error(ex.ToString()); } MessageBox.Show("Item with ID: " + comboBoxFoodID.Text + " has been successfully deleted.", "Item Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); break; default: Error("Unkown Error"); break; } this.Close(); }
private void ItemForm_Load(object sender, EventArgs e) { switch (state) { case 0: comboBoxStallName.Enabled = true; textBoxFoodName.Enabled = true; comboBoxFoodType.Enabled = true; textBoxFoodDescription.Enabled = true; textBoxPrice.Enabled = true; SL = SQLServerConnection.GetStallList(); TL = SQLServerConnection.GetFoodTypeList(); foreach (TypeList tempList in TL) { comboBoxFoodType.Items.Add(tempList.FoodType); } foreach (StallList tempList in SL) { comboBoxStallName.Items.Add(tempList.StallName); } buttonItem.Text = "Add Item"; break; case 1: SL = SQLServerConnection.GetStallList(); TL = SQLServerConnection.GetFoodTypeList(); IL = SQLServerConnection.GetItemList(); foreach (TypeList tempList in TL) { comboBoxFoodType.Items.Add(tempList.FoodType); } foreach (StallList tempList in SL) { comboBoxStallName.Items.Add(tempList.StallName); } foreach (ItemList tempList in IL) { comboBoxFoodID.Items.Add(tempList.FoodID); } comboBoxFoodID.Enabled = true; buttonItem.Text = "Update Item"; break; case 2: SL = SQLServerConnection.GetStallList(); TL = SQLServerConnection.GetFoodTypeList(); IL = SQLServerConnection.GetItemList(); foreach (TypeList tempList in TL) { comboBoxFoodType.Items.Add(tempList.FoodType); } foreach (StallList tempList in SL) { comboBoxStallName.Items.Add(tempList.StallName); } foreach (ItemList tempList in IL) { comboBoxFoodID.Items.Add(tempList.FoodID); } comboBoxFoodID.Enabled = true; buttonItem.Text = "Delete Item"; break; default: Error("Unkown Error"); break; } }
private void comboBoxFoodID_SelectedIndexChanged(object sender, EventArgs e) { switch (state) { case 1: comboBoxStallName.Enabled = true; textBoxFoodName.Enabled = true; comboBoxFoodType.Enabled = true; textBoxFoodDescription.Enabled = true; textBoxPrice.Enabled = true; textBoxStallID.Text = IL[comboBoxFoodID.SelectedIndex].StallID.ToString(); textBoxFoodTypeID.Text = IL[comboBoxFoodID.SelectedIndex].FoodTypeID.ToString(); SL.Clear(); TL.Clear(); SL = SQLServerConnection.GetStallList(); TL = SQLServerConnection.GetFoodTypeList(); int x = 0; foreach (StallList tempList in SL) { if (tempList.StallID == Convert.ToInt32(textBoxStallID.Text)) { comboBoxStallName.SelectedIndex = x; } x++; } textBoxFoodName.Text = IL[comboBoxFoodID.SelectedIndex].FoodName; x = 0; foreach (TypeList tempList in TL) { if (tempList.FoodTypeID == Convert.ToInt32(textBoxFoodTypeID.Text)) { comboBoxFoodType.SelectedIndex = x; } x++; } textBoxFoodDescription.Text = IL[comboBoxFoodID.SelectedIndex].FoodDescription; textBoxPrice.Text = IL[comboBoxFoodID.SelectedIndex].FoodPrice.ToString("0.00"); break; case 2: textBoxStallID.Text = IL[comboBoxFoodID.SelectedIndex].StallID.ToString(); textBoxFoodTypeID.Text = IL[comboBoxFoodID.SelectedIndex].FoodTypeID.ToString(); SL.Clear(); TL.Clear(); SL = SQLServerConnection.GetStallList(); TL = SQLServerConnection.GetFoodTypeList(); int y = 0; foreach (StallList tempList in SL) { if (tempList.StallID == Convert.ToInt32(textBoxStallID.Text)) { comboBoxStallName.SelectedIndex = y; } y++; } textBoxFoodName.Text = IL[comboBoxFoodID.SelectedIndex].FoodName; y = 0; foreach (TypeList tempList in TL) { if (tempList.FoodTypeID == Convert.ToInt32(textBoxFoodTypeID.Text)) { comboBoxFoodType.SelectedIndex = y; } y++; } textBoxFoodDescription.Text = IL[comboBoxFoodID.SelectedIndex].FoodDescription; textBoxPrice.Text = IL[comboBoxFoodID.SelectedIndex].FoodPrice.ToString("0.00"); break; default: Error("Unkown Error"); break; } }