public EmployeeValidation GetEmployeeValidation(int id)
{
string query = "select [dbo].[EmployeeValidation].[Question1], [dbo].[EmployeeValidation].[Question2], [dbo].[EmployeeValidation].[Question3] from [dbo].[EmployeeValidation] where [dbo].[EmployeeValidation].[EmployeeID] = " + id;
EmployeeValidation e = new EmployeeValidation();
using (var command = new SqlCommand(query, con))
{
var dependency = new SqlDependency(command);
dependency.OnChange -= new OnChangeEventHandler(dependency_OnChange);
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet ds = new DataSet();
adapter.Fill(ds);
DataTable dTable = ds.Tables[0];
foreach (DataRow row in dTable.Rows)
{
e.Question1 = row["Question1"].ToString();
e.Question2 = row["Question2"].ToString();
e.Question3 = row["Question3"].ToString();
}
}
return(e);
}
public int AddEmployeeValidation(int id, EmployeeValidation ev)
{
String query = "insert into EmployeeValidation values(" + id + ", '" + ev.Question1 + "', '" + ev.Question2 + "', '" + ev.Question3 + "')";
var command = new SqlCommand(query, con);
int err = 1;
counter = 0;
try
{
command.ExecuteNonQuery();
err = 0;
}
catch (Exception e)
{
err = 1;
}
return(err);
}