public IEnumerable <Questions> GetAll()
{
List <Questions> QuestionList = new List <Questions>();
NlogerConfig config = new NlogerConfig();
DataTable data = new DataTable();
Logger logger = LogManager.GetLogger("Question");
SqlConnection con = new SqlConnection(connection.ConnectionString);
try
{
using (con)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select * from Question";
if (con.State != ConnectionState.Open)
{
con.Open();
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(data);
}
QuestionList = data.ToList <Questions>();
if (con.State != ConnectionState.Closed)
{
con.Close();
}
}
}
return(QuestionList);
}
catch (Exception ex)
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
logger.Error(ex, "An error occured fetching Questions.");
return(QuestionList);
}
}
public int validateUser(UserTable model)
{
int value = 99;
NlogerConfig config = new NlogerConfig();
Logger logger = LogManager.GetLogger("User");
SqlConnection conn = new SqlConnection(connection.ConnectionString);
try
{
using (conn)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select dbo.f_ValidateUser(@Username,@Password)";
cmd.Parameters.AddWithValue("@Username", model.Username);
cmd.Parameters.AddWithValue("@Password", model.Password);
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
value = (int)cmd.ExecuteScalar();
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}
}
catch (Exception ex)
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
logger.Error(ex, "An error occured when validating user.");
throw;
}
return(value);
}
public void insertLoginSuccess(string Username, string UserAgent)
{
NlogerConfig config = new NlogerConfig();
Logger logger = LogManager.GetLogger("User");
SqlConnection conn = new SqlConnection(connection.ConnectionString);
try
{
using (conn)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "s_LoginSuccess";
cmd.Parameters.AddWithValue("@Username", Username);
cmd.Parameters.AddWithValue("@userAgent", UserAgent);
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.ExecuteNonQuery();
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}
}
catch (Exception ex)
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
logger.Error(ex, "Error occured when inserting LoginSucess");
}
}
