public ActionResult Index()
{
DatabaseConnectionSchema dataSchema = new DatabaseConnectionSchema();
ThreadStart ChildThread = new ThreadStart(() => dataSchema.ConnectionSchema());
Thread parentThread = new Thread(ChildThread);
parentThread.Start();
Thread.Sleep(3000); //this will be needed in other for database connection to be ex
//tablished successfully
SqlCommand command;
SqlDataReader dataReader;
String sql;
sql = "select * from registration";
command = new SqlCommand(sql, dataSchema.GetConnection());
dataReader = command.ExecuteReader();
Console.WriteLine(dataReader);
var data = new { message = "From Registration Controller" };
return(Json(data));
}
public ActionResult RegisterCompany(FormCollection collection)
{
Console.WriteLine(collection["phoneNumber"]);
DatabaseConnectionSchema dataSchema = new DatabaseConnectionSchema();
ThreadStart ChildThread = new ThreadStart(() => dataSchema.ConnectionSchema());
Thread parentThread = new Thread(ChildThread);
parentThread.Start();
Thread.Sleep(3000); //this will be needed in other for database connection to be ex
//tablished successfully
//SqlCommand command;
//SqlDataReader dataReader;
//String sql;
//sql = "select * from registration";
//command = new SqlCommand(sql, dataSchema.GetConnection());
//dataReader = command.ExecuteReader();
//Console.WriteLine(dataReader);
//Console.WriteLine("check data reader above");
var data = new { message = "From Registration Controller" };
return(Json(data));
//return View ();
}