public List <VoteDetail> GetVoteList(out string errormsg) { SqlConnection dbConnection = new SqlConnection(); dbConnection.ConnectionString = @"Data Source = (localdb)\MSSQLLocalDB;Initial Catalog = Idag_Inatt; Integrated Security = True;"; string sqlstring = "Select * From Tbl_Vote"; SqlCommand dbCommand = new SqlCommand(sqlstring, dbConnection); SqlDataReader reader = null; List <VoteDetail> VoteList = new List <VoteDetail>(); errormsg = ""; try { dbConnection.Open(); reader = dbCommand.ExecuteReader(); while (reader.Read()) { VoteDetail vote = new VoteDetail(); vote.Vote_Id = Convert.ToInt16(reader["Vo_Id"]); vote.Vote_Motivation = reader["Vo_Motivation"].ToString(); vote.Vote_Nominee = Convert.ToInt16(reader["Vo_VotedOn"]); VoteList.Add(vote); } return(VoteList); } catch (Exception e) { errormsg = e.Message; return(null); } finally { dbConnection.Close(); } }
public List <VoteDetail> GetMotivationListById(int id, out string errormsg) { SqlConnection dbConnection = new SqlConnection(); dbConnection.ConnectionString = @"Data Source = (localdb)\MSSQLLocalDB;Initial Catalog = Idag_Inatt; Integrated Security = True;"; string sqlstring = "Select Vo_Motivation From Tbl_Vote Where Vo_VotedOn = @id"; SqlCommand dbCommand = new SqlCommand(sqlstring, dbConnection); dbCommand.Parameters.Add("id", SqlDbType.Int).Value = id; SqlDataReader reader = null; List <VoteDetail> VoteList = new List <VoteDetail>(); errormsg = ""; try { dbConnection.Open(); reader = dbCommand.ExecuteReader(); while (reader.Read()) { VoteDetail vote = new VoteDetail(); vote.Vote_Motivation = reader["Vo_Motivation"].ToString(); VoteList.Add(vote); } return(VoteList); } catch (Exception e) { errormsg = e.Message; return(null); } finally { dbConnection.Close(); } }
public int InsertVote(VoteDetail vd, int nomineeId, out string errormsg) { SqlConnection dbConnection = new SqlConnection(); dbConnection.ConnectionString = @"Data Source = (localdb)\MSSQLLocalDB;Initial Catalog = Idag_Inatt; Integrated Security = True;"; string sqlstring = "INSERT INTO Tbl_Vote (Vo_Motivation,Vo_VotedOn) VALUES (@motivation,@votedOn)"; SqlCommand dbCommand = new SqlCommand(sqlstring, dbConnection); dbCommand.Parameters.Add("motivation", SqlDbType.NVarChar, 100).Value = vd.Vote_Motivation; dbCommand.Parameters.Add("votedOn", SqlDbType.Int).Value = nomineeId; try { dbConnection.Open(); int i = 0; i = dbCommand.ExecuteNonQuery(); if (i == 1) { errormsg = ""; } else { errormsg = "Det skapas inte en röst i databasen"; } return(i); } catch (Exception e) { errormsg = e.Message; return(0); } finally { dbConnection.Close(); } }