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