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 (); }