private static Passenger_Request ReaderDataPRequest(MySqlDataReader reader)
{
Passenger_Request objPReq = new Passenger_Request();
objPReq.REQUESTID = Converter.IsValidInt(reader["REQUESTID"]);
objPReq.USERID = Converter.IsValidInt(reader["USERID"]);
objPReq.DATE = Converter.IsValidString(reader["DATE"]);
objPReq.FROM = Converter.IsValidString(reader["FROM"]);
objPReq.TO = Converter.IsValidString(reader["TO"]);
objPReq.TIME = Converter.IsValidString(reader["TIME"]);
objPReq.STATUS = Converter.IsValidString(reader["STATUS"]);
//will add for image
return(objPReq);
}
public static List <PRequestManager> GetPRequest(string whereclause, MySqlConnection conn = null)
{
Passenger_Request objPReq = null;
List <PRequestManager> lstPreq = new List <PRequestManager>();
try
{
bool isConnArgNull = (conn != null) ? false : true;
MySqlConnection connection = (conn != null) ? conn : PrimaryConnection();
tryOpenConnection(connection);
string sql = "select * from Passenger_Request";
if (!string.IsNullOrEmpty(whereclause))
{
sql += " where " + whereclause;
}
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = sql;
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
objPReq = ReaderDataUser(reader);
lstPreq.Add(objPReq);
}
}
else
{
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
}
//endtry
catch (Exception ex)
{
}
return(lstPreq);
}
public static string SavePRequest(Passenger_Request objPReq, MySqlConnection conn = null, MySqlTransaction trans = null)
{
string returnMessage = "";
string sREQUESTID = "";
sREQUESTID = objPReq.REQUESTID.ToString();
var templstPReq = GetPRequest("REQUESTID = '" + sREQUESTID + "'", conn);
try
{
bool isConnArgNull = (conn != null) ? false : true;
MySqlConnection connection = (conn != null) ? conn : PrimaryConnection();
tryOpenConnection(connection);
using (MySqlCommand command = new MySqlCommand())
{
string sql;
bool isEdit = true;
if (templstPReq.Count <= 0)
{
isEdit = false;
sql = @"INSERT INTO PASSENGER_REQUEST(
USERID,
DATE,
FROM,
TO,
TIME,
STATUS
)
VALUES(
@USERID,
@DATE,
@FROM,
@TO,
@TIME,
@STATUS
)";
}
else
{
sql = @"Update PASSENGER_REQUEST set
REQUESTID=@REQUESTID,
USERID=@USERID,
DATE=@DATE,
FROM=@FROM,
TO=@TO,
TIME=@TIME,
STATUS=@STATUS
Where REQUESTID=@REQUESTID";
}
if (trans != null)
{
command.Transaction = trans;
}
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = sql;
if (isEdit)
{
command.Parameters.AddWithValue("@REQUESTID", objPReq.REQUESTID);
}
command.Parameters.AddWithValue("@FIRSTNAME", objPReq.FIRSTNAME);
command.Parameters.AddWithValue("@USERID", objPReq.USERID);
command.Parameters.AddWithValue("@DATE", objPReq.DATE);
command.Parameters.AddWithValue("@FROM", objPReq.FROM);
command.Parameters.AddWithValue("@TO", objPReq.TO);
command.Parameters.AddWithValue("@TIME", objPReq.TIME);
command.Parameters.AddWithValue("@STATUS", objPReq.STATUS);
int affectedRows = command.ExecuteNonQuery();
var lastInsertID = command.LastInsertedId;
if (affectedRows > 0)
{
// if (!isEdit)
// {
// returnMessage = lastInsertID.ToString();
// }
// else
{
returnMessage = Shared.Constants.MSG_OK_DBSAVE.Text;
}
}
else
{
returnMessage = Shared.Constants.MSG_ERR_DBSAVE.Text;
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
catch (Exception ex)
{
}
return(returnMessage);
}