/// <summary> /// calculates votes amount ,in a given kalpi, for a given party /// </summary> /// <param name="partyName">name of given party</param> /// <param name="kalpiCode">code of given kalpi</param> /// <returns></returns> private int partyVoteNum(string partyName, string kalpiCode) { con.sqlCommand("IsInVoteDB"); con.InsertValstring("@partyName", partyName); con.InsertValstring("@kalpiCode", kalpiCode); return(int.Parse(con.getVal("Result").ToString())); }
public int addNewVoterToKalpi(string kalpiCode) { con.sqlCommand("addVoterToKalpi"); //updateVoterKalpi SQL query for add exist voter to the kalpi. con.InsertValstring("@ID", Id); //ID for query check. con.InsertValstring("@kalpiCode", KalpiCode); //Change kalpiCode to kalpi manager code. return(int.Parse(con.getVal("Result").ToString())); }
/// <summary> /// The function removes the member from the Data Base. /// </summary> /// <returns></returns> If the reomving succeseed or not public string RemoveMember() { con.sqlCommand("RemovePartyMember"); con.InsertValint("@member_code", MemberCode); con.InsertValstring("@mode", Mode.ToString()); return(con.getVal("@Result").ToString()); }
/// <summary> /// The function updates the party details. /// </summary> /// <returns></returns> Returns if the update succseed or not public string UpdateParty() { con.sqlCommand("UpdatePartyDetails"); con.InsertValstring("@partyName", PartyName.Trim()); con.InsertValint("@member_size", membersSize); con.InsertValstring("@platform", platform.Trim()); return(con.getVal("@Result")); }
//Cheacking name of parties public string CheakParty(string name) { sqlConnection sql = sqlConnection.Instance; //sql conection sql.sqlCommand("CheakParty"); //sql Procedure sql.InsertValstring("@partyName", name); //sending parameters return(sql.getVal("@Result")); }
private string RemoveVoter(string id) { sqlConnection con = sqlConnection.Instance; con.sqlCommand("RemoveVoter"); con.InsertValstring("@id", id); return(con.getVal("@result")); }
public int CountMandate(string partyName) { con.sqlCommand("CountMandate"); con.InsertValstring("@partyName", partyName); int res = int.Parse(con.getVal("Result").ToString()); return(res / 3); }
public string addKalpiToVoter(String id, String kalpiCode) { sqlConnection p1 = sqlConnection.Instance; //sql conection p1.sqlCommand("addKalpiToVoter"); //sql Procedure p1.InsertValstring("@id", id); //sending parameters p1.InsertValstring("@kalpiCode", kalpiCode); //sending parameters return(p1.getVal("@Result")); //Updating }
private string UpdateLastDate(string id) { sqlConnection con = sqlConnection.Instance; con.sqlCommand("UpdateLastDate"); con.InsertValstring("@id", id); con.InsertValDate("@lastdate", DateTime.Now.Date); return(con.getVal("@result")); }
public int changeKalpiVote(string kalpiC) { sqlConnection con = sqlConnection.Instance; con.sqlCommand("updateVoterKalpi"); con.InsertValstring("@prev_kalpi", kalpiCode); con.InsertValstring("@kalpiCode", kalpiC); con.InsertValstring("@id", id); return(int.Parse(con.getVal("res").ToString())); }
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())); }
//the procedur of searching invalid kalpies private void butt_Click(object sender, EventArgs e) { comBox1.Text = "Select"; //show at first "select" con.sqlCommand("SearchKalpiByCity"); //the procedure con.InsertValstring("@city", voter.City); String result = con.getVal("@Result"); if (result.Equals("1")) { con.sqlCommand("SearchInvalidKalpies"); //the procedure con.InsertValstring("@city", voter.City); DataTable KalpiCode = con.GetData("SearchInvalidKalpies"); foreach (DataRow code in KalpiCode.Rows) { comBox1.Items.Add(code["kalpiCode"].ToString()); //add kalpies codes } } else { MessageBox.Show("There are no kalpies with invalid access"); } }
public string UpdateVoterDetails(string Id, string fname, string lName, string addres, string area, string city, string tell) { sqlConnection p1 = sqlConnection.Instance; //sql conection p1.sqlCommand("UpdateVoterDetails"); //sql Procedure p1.InsertValstring("@Id", Id); //sending parameters p1.InsertValstring("@fname", fname.Trim()); //sending parameters p1.InsertValstring("@lname", lName.Trim()); //sending parameters p1.InsertValstring("@address", addres.Trim()); //sending parameters p1.InsertValstring("@area", area.Trim()); //sending parameters p1.InsertValstring("@city", city.Trim()); //sending parameters p1.InsertValstring("@tell", tell.Trim()); //sending parameters return(p1.getVal("@Result").ToString()); // p1.NonQueryE(); //Updating }
//Update worker to Commissioner public string DeleteWorker(Voter worker) { try { sqlConnection con = sqlConnection.Instance; con.sqlCommand("RemoveWorker"); con.InsertValstring("@id", worker.Id); string value = con.getVal("@Result"); return(value); } catch { return("Data Base id Filed"); } }
public int countWhiteNots(KalpiManager kalpiManager) { try { int count = 0; sqlConnection con = sqlConnection.Instance; con.sqlCommand("getNumOfWhiteNotes"); con.InsertValstring("@kalpiCode", kalpiManager.KalpiCode); count = int.Parse(con.getVal("@Result")); return(count); } catch { return(0); } }
public string updateAreaManager(string id, string name, string lastname, string username, string password, DateTime birthDay, string addres, string area, string city, string tell) { sqlConnection con = sqlConnection.Instance; con.sqlCommand("updateAreaManager"); con.InsertValstring("@idVoter", id); con.InsertValstring("@name", name); con.InsertValstring("@lastname", lastname); con.InsertValstring("@username", username); con.InsertValstring("@password", password); con.InsertValDate("@birthDay", birthDay); con.InsertValstring("@address", addres); con.InsertValstring("@area", area); con.InsertValstring("@city", city); con.InsertValstring("@tell", tell); return(con.getVal("@Result")); }
//Update worker to Commissioner public string updateWorker(string id, string kalpiCode, string name, string lastname, string username, string password, string permission, DateTime birthDay, string addres, string area, string city, string tell) { Voter worker = new Voter(id, kalpiCode, name, lastname, username, password, permission, birthDay, addres, area, city, tell, "Commissioner", true, false, true); sqlConnection con = sqlConnection.Instance; con.sqlCommand("updateWorker"); con.InsertValstring("@idVoter", worker.Id); con.InsertValstring("@kalpiCode", worker.KalpiCode); con.InsertValstring("@name", worker.FName); con.InsertValstring("@lastname", worker.LName); con.InsertValstring("@username", worker.username); con.InsertValstring("@password", worker.Passowrd); con.InsertValstring("@permission", worker.Permission); con.InsertValstring("@address", worker.Address); con.InsertValstring("@area", worker.Area); con.InsertValstring("@city", worker.City); con.InsertValDate("@birthDay", worker.DOB); con.InsertValstring("@tell", worker.Tell); return(con.getVal("@Result")); }
private void button1_Click(object sender, EventArgs e) { comboBox1.Text = "Select"; //show at first "select" con.sqlCommand("SearchKalpiesByArea"); //the procedure con.InsertValstring("@area", area_manager.Area); //pass the area manager area String result = con.getVal("@Result"); if (result.Equals("1")) { con.sqlCommand("ReturnKalpiCode"); //the procedure DataTable KalpiCode = con.GetData("ReturnKalpiCode"); foreach (DataRow code in KalpiCode.Rows) { comboBox1.Items.Add(code["kalpiCode"].ToString()); //add kalpies codes } } else { MessageBox.Show("There are no kalpies who don't hava manager"); } }