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 string AddPartyMember() { con.sqlCommand("newMemberParty"); con.InsertValint("@member", MemberCode); con.InsertValstring("@partyn", PartyName); con.InsertValstring("@name", FName); con.InsertValstring("@lastn", LName); con.InsertValDate("@dateT", GetDob()); con.InsertValint("@list", ListPlace); con.InsertValstring("@ediction", Education); con.InsertValstring("@exp", Experience); return(con.getVal("@Result").ToString()); }
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")); }
//Returns Result as int (1/0) if the action succeeded or not. public int AddNewKalpiManagerToArea(string id, string fname, string lname, string username, string password, DateTime birthDay, string address, string city, string tell, string area, string kalpiCode) { con.sqlCommand("AddNewKalpiManagerToArea"); //set new kalpi manager to area SQL query. con.InsertValstring("@id", id.ToString()); con.InsertValstring("@fname", fname); con.InsertValstring("@lname", lname); con.InsertValstring("@username", username); con.InsertValstring("@password", password); con.InsertValstring("@permission", "2"); con.InsertValDate("@birthDay", birthDay); con.InsertValstring("@city", city); con.InsertValstring("@address", address); con.InsertValstring("@area", area); con.InsertValstring("@kalpiCode", kalpiCode); con.InsertValstring("@tell", tell); return(int.Parse(con.getVal("Result").ToString())); }
//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")); }