public int addNewKalpi(Kalpi kalpi) { con.sqlCommand("addNewKalpi"); con.InsertValstring("@kalpiCode", kalpi.KalpiCode); con.InsertValstring("@kalpiName", kalpi.KalpiName); con.InsertValstring("@address", kalpi.Address); con.InsertValstring("@city", kalpi.City); con.InsertValstring("@area", this.Area); con.InsertValint("@maxVoters", kalpi.MaxVoters); return(int.Parse(con.getVal("Result").ToString())); }
private void buttonAdd_Click(object sender, EventArgs e) { if (textBoxAddress.Text.Trim() == "" || textBoxCity.Text.Trim() == "" || textBoxCode.Text.Trim() == "" || textBoxKalpiName.Text.Trim() == "" || textBoxMaxVoters.Text.Trim() == "") { MessageBox.Show("One or more of the fields is empty.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } int maxVoters = 0; try { maxVoters = int.Parse(textBoxMaxVoters.Text.Trim()); if (maxVoters <= 0 || maxVoters > 1000) { throw new Exception(); } } catch { MessageBox.Show("Invalid input in 'maximum Voters'.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } try { Kalpi kalpi = new Kalpi(textBoxCode.Text, "", textBoxKalpiName.Text, textBoxAddress.Text, textBoxCity.Text, areaManager.Area, 0, maxVoters, true); int flag = areaManager.addNewKalpi(kalpi); if (flag == 1) { MessageBox.Show("The new Kalpi added to the DataBase.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("There is already kalpi with that kalpiCode", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch { MessageBox.Show("Add New Kalpi Failed", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// Search for kalpi manager by his id, and show his details and his kalpi details /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void search_button_Click(object sender, EventArgs e) { clearFields(); search_success = false; if (isIdValid() == false) { MessageBox.Show("Enter Valid ID."); } else { kalpi_mngr = area_mngr.SearchKalpiManager(IDtextBox.Text.ToString().Trim(), area_mngr.Area); if (kalpi_mngr == null) { MessageBox.Show("No such kalpi manager in " + area_mngr.Area + " area."); } else { search_success = true; first_text.Text = kalpi_mngr.FName; last_text.Text = kalpi_mngr.LName; address_text.Text = kalpi_mngr.Address + ", " + kalpi_mngr.City; phone_text.Text = kalpi_mngr.Tell; kalpi = area_mngr.SearchKalpiByManager(IDtextBox.Text.ToString().Trim()); if (kalpi != null) { code_text.Text = kalpi.KalpiCode; area_text.Text = kalpi.Area; city_text.Text = kalpi.City; location_text.Text = kalpi.Address; } } } }