public ActionResult IntelligenceReportHistory() { List <check> checkList = new List <check>(); using (dbChecks checkModel = new dbChecks()) { checkList = checkModel.Checks.ToList <check>(); } return(View(checkList)); }
public ActionResult ReportAdmin(int?id) { dbChecks checkModel = new dbChecks(); checkList checkList = new checkList(); check_list _List = checkList.check_list.Find(id); check edit = checkModel.Checks.Find(id); string serverIp = "localhost"; string username = "******"; string password = ""; string databaseName = "bgcheck"; string dbConnectionString = string.Format("server={0};uid={1};pwd={2};database={3};", serverIp, username, password, databaseName); string query = "SELECT * FROM checks WHERE id = '" + id + "'"; var conn = new MySqlConnection(dbConnectionString); conn.Open(); TempData["checkID"] = id; var cmd = new MySqlCommand(query, conn); var reader = cmd.ExecuteReader(); while (reader.Read()) { var u_id = reader["check_id"]; TempData["checkID"] = u_id; } conn.Close(); string query1 = "SELECT * FROM check_list WHERE checks_id = '" + TempData["checkID"] + "'"; conn.Open(); var cmd1 = new MySqlCommand(query1, conn); var reader1 = cmd1.ExecuteReader(); while (reader1.Read()) { var checks = reader1["checks"]; TempData["checks"] = checks; } return(View(edit)); }
public check GetHistory(int?id) { check chec = new check(); dbChecks bgDBModel = new dbChecks(); List <check> checkList = new List <check>(); using (dbChecks checkModel = new dbChecks()) { var mail = "1"; chec = checkModel.Checks.Find(id); string serverIp = "localhost"; string username = "******"; string password = ""; string databaseName = "jcred"; //string serverIp = "197.242.148.16"; ////string username = "******"; //string username = "******"; //string password = "******"; //string databaseName = "cykgxznt_jcred"; //string port = "3306"; string dbConnectionString = string.Format("server={0};uid={1};pwd={2};database={3};", serverIp, username, password, databaseName); string query = "SELECT * FROM checks WHERE id = '" + mail + "'"; //string query = "SELECT * FROM checks, check_list WHERE checks.check_id = check_list.checks_id AND checks.check_id = '" + TempData["check_id"] + "'"; var conn = new MySql.Data.MySqlClient.MySqlConnection(dbConnectionString); conn.Open(); var cmd = new MySql.Data.MySqlClient.MySqlCommand(query, conn); var reader = cmd.ExecuteReader(); while (reader.Read()) { chec = new check(); chec.first_name = reader["first_name"].ToString(); chec.surname = reader["surname"].ToString(); chec.check_id = Convert.ToInt32(reader["check_id"]); chec.IDNum = reader["IDNum"].ToString(); chec.reason = reader["reason"].ToString(); chec.user_email = reader["user_email"].ToString(); chec.search_date = DateTime.Parse(reader["search_date"].ToString()); } conn.Close(); string query1 = "SELECT * FROM check_list WHERE checks_id = '" + chec.check_id + "'"; conn.Open(); var cmd1 = new MySql.Data.MySqlClient.MySqlCommand(query1, conn); var reader1 = cmd1.ExecuteReader(); while (reader1.Read()) { chec.status = reader1["checks"].ToString(); } } return(chec); }