Comments by Member 4419121 (Top 2 by date)

i think this line in controller is not can't be triggered
// initialize MySql connector
mySQLWrapper mSQLObj = new mySQLWrapper(HttpContext.Application["MySQLConnString"].ToString());


and also in model
using MySql.Data;
using MySql.Data.MySqlClient;

namespace Request_Tracker.Models
{
public class mySQLWrapper
{
private const string cTicketNumbers = "pTicketNumbers";
private const string cFormCode = "pFormCode";
private const string cStatus = "pStatus";
private const string cDateRequestedFrom = "pDateRequestedFrom";
private const string cDateRequestedTo = "pDateRequestedTo";
private const string cDateOpenedFrom = "pDateOpenedFrom";
private const string cDateOpenedTo = "pDateOpenedTo";
private const string cDateNBSActionFrom = "pDateNBSActionFrom";
private const string cDateNBSActionTo = "pDateNBSActionTo";
private const string cProcAllStatus = "uspgetrequestsheader";
private const string cProcMarketPending = "uspgetpendingheader";
private const string cProcNBSPending = "uspgetnbspendingheader";
private const string cProcRawData = "uspgetrawdataclosed";

//this wrapper is exclusively for select only, reading data
private MySqlConnection mConn { get; set; }
private MySqlCommand mComm { get; set; }
public long mRowCount { get; set; }
public MySqlDataReader mReader { get; set; }
public long mRowsPerPage { get; set; }
public long mPageNum { get; set; }

public mySQLWrapper(string sConn)
{
//default values
mRowsPerPage = 0;
mPageNum = 1;
mConn = new MySqlConnection(sConn);
mConn.Open();
mComm = new MySqlCommand();
mComm.Connection = mConn;
}

public void retrieveRows(string argSQL)
{

mComm.CommandText = countRowSQL(argSQL);
var objRowCount = mComm.ExecuteScalar();
mRowCount = objRowCount == null ? 0 : (long)objRowCount;
if (mRowCount > 0)
{
if (mRowsPerPage == 0)//return all rows
{
mComm.CommandText = argSQL;
mReader = mComm.ExecuteReader();
mRowsPerPage = mRowCount;
}
else
{
mComm.CommandText = argSQL + " LIMIT " + ((mPageNum * mRowsPerPage) - mRowsPerPage) + "," + mRowsPerPage;
mReader = mComm.ExecuteReader();
}

}
}

public void runSpAllStatus(clsAllStatusParams objParams)
{

mComm.CommandText = cProcAllStatus;
mComm.CommandType = System.Data.CommandType.StoredProcedure;

mComm.Parameters.AddWithValue(cTicketNumbers,objParams.pTicketNumbers);
mComm.Parameters.AddWithValue(cFormCode, objParams.pFormCode);
mComm.Parameters.AddWithValue(cStatus, objParams.pStatus);
mComm.Parameters.AddWithValue(cDateRequestedFrom, objParams.pDateRequestedFrom);
mComm.Parameters.AddWithValue(cDateRequestedTo, objParams.pDateRequestedTo);
mComm.Parameters.AddWithValue(cDateOpenedFrom, objParams.pDateOpenedFrom);
mComm.Parameters.AddWithValue(cDateOpenedTo, objParams.pDateOpenedTo);
mComm.Parameters.AddWithValue(cDateNBSActionFrom, objParams.pDateNBSActionFrom);
mComm.Parameters.AddWithValue(cDateNBSActionTo, objParams.pDateNBSActionTo);
mReader = mComm.ExecuteReader();

}

in Global.asax
Application["ConnString"] = "server=phsscd0004;user=root;database=db_request_manager_es;port=3306;password=N8sD%ve10p;";

in Web.config