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