public void RemoveAcompanier(string Id) { sqlConnection p1 = sqlConnection.Instance; //sql conection p1.sqlCommand("RemoveAcompanier"); //sql Procedure p1.InsertValstring("@Id", Id); //sending parameters p1.NonQueryE(); //Updating }
/// <summary> /// Update new password in database /// </summary> /// <param name="password"></param> /// <param name="id"></param> public void changePass(string password, string id) { sqlConnection p1 = sqlConnection.Instance; //sql conection p1.sqlCommand("changePassword"); //sql Procedure p1.InsertValstring("@id", id); //sending parameters p1.InsertValstring("@password", password); //sending parameters p1.NonQueryE(); //Updating }
/// <summary> /// Update new Accompanier Id in database /// </summary> /// <param name="accomId"></param> /// <param name="id"></param> public void addAccompanierId(string accomId, string id) { sqlConnection p1 = sqlConnection.Instance; //sql conection p1.sqlCommand("addAccompanierId"); //sql Procedure p1.InsertValstring("@id", id); //sending parameters p1.InsertValstring("@accomId", accomId); //sending parameters p1.NonQueryE(); //Updating }
public void unblockCalpi(String kalpiCode) { sqlConnection p1 = sqlConnection.Instance; //sql conection p1.sqlCommand("unblockKalpi"); //sql Procedure p1.InsertValstring("@kalpiCode", kalpiCode); //sending parameters p1.InsertValstring("@openKalpi", "True"); //sending parameters p1.NonQueryE(); //Updating }
/// <summary> /// the method unblockes a voter, allowing him to vote /// </summary> /// <param name="id">the id of the voter needs to be unblocked</param> public void UnblockedCitizen(string id) { sqlConnection p1 = sqlConnection.Instance; //sql conection p1.sqlCommand("unblockCitizen"); //sql Procedure p1.InsertValstring("@id", id); //sending parameters p1.InsertValstring("@isBlocked", "False"); //sending parameters p1.NonQueryE(); //Updating }
//Open to Kalpi change to True public void OpenKalpi() { con.sqlCommand("OpenKalpi"); con.NonQueryE(); }
public void removeKalpi(string kalpiCode) { con.sqlCommand("RemoveKalpi"); con.InsertValstring("@kalpiCode", kalpiCode); con.NonQueryE(); }