public List <ComparisonTO> getByUsername(String userid)
{
ComparisonTO userComparison = new ComparisonTO();
SqlCommand retcmd = new SqlCommand("select comparisonText from [ProjectComparisonTable] where [username] = @userid", dbconnection);
SqlParameter useridparam = new SqlParameter("@userid", userid);
retcmd.Parameters.Add(useridparam);
List <ComparisonTO> finalValue = new List <ComparisonTO>();
try
{
dbconnection.Open();
reader = retcmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
userComparison = new ComparisonTO(reader.GetValue(0).ToString());
finalValue.Add(userComparison);
}
}
dbconnection.Close();
}
catch (Exception ee)
{
}
return(finalValue);
}
public void insertComparison(ComparisonTO comp)
{
SqlCommand retcmd = new SqlCommand("insert into [ProjectComparisonTable] ([username], [comparisonText]) values (@username, @comparisonText)", dbconnection);
SqlParameter usernameParam = new SqlParameter("@username", comp.usernameTextValue);
SqlParameter comparisonTextParam = new SqlParameter("@comparisonText", comp.comparisonTextValue);
retcmd.Parameters.Add(usernameParam);
retcmd.Parameters.Add(comparisonTextParam);
try
{
dbconnection.Open();
retcmd.ExecuteNonQuery();
}
catch (Exception ee)
{
}
}
