private static RiderDeliver ReaderDataRiderDeliver(MySqlDataReader reader)
{
RiderDeliver objRD = new RiderDeliver();
objRD.RIDEID = DbCheck.IsValidInt(reader["rideid"]);
objRD.RIDERID = DbCheck.IsValidInt(reader["RiderID"]);
objRD.ASSIGNEDDATE = DbCheck.IsValidDateTime(reader["assigndate"]);
objRD.ACCEPTID = DbCheck.IsValidInt(reader["acceptid"]);
return(objRD);
}
public static List <RiderDeliver> GetRideDeliever(string whereclause, MySqlConnection conn = null)
{
RiderDeliver ObjRD = new RiderDeliver();
List <RiderDeliver> lstRD = new List <RiderDeliver>();
try
{
bool isConnArgNull = (conn != null) ? false : true;
MySqlConnection connection = (conn != null) ? conn : PrimaryConnection();
tryOpenConnection(connection);
string sql = "select * from riderdeliver";
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())
{
ObjRD = ReaderDataRiderDeliver(reader);
lstRD.Add(ObjRD);
}
}
else
{
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
}
//endtry
catch (Exception ex)
{
}
return(lstRD);
}
public static string SaveRiderDeliver(RiderDeliver ObjRd, MySqlConnection conn = null, MySqlTransaction trans = null)
{
string returnMessage = "";
string sRDID = "";
sRDID = ObjRd.RIDEID.ToString();
var templstEmp = GetRideDeliever("RIDEID = '" + sRDID + "'", 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 (templstEmp.Count <= 0)
{
isEdit = false;
sql = @"INSERT INTO RiderDeliver(
ACCEPTID,
RIDERID,
ASSIGNDATE
)
VALUES(
@ACCEPTID,
@RIDERID,
@ASSIGNDATE,
)";
}
else
{
sql = @"Update RiderDeliver set
RIDEID=@RIDEID,
RIDERID=@RIDERID,
ASSIGNDATE=@ASSIGNDATE,
ACCEPTID=@ACCEPTID,
Where RIDEID=@RIDEID";
}
if (trans != null)
{
command.Transaction = trans;
}
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = sql;
if (isEdit)
{
command.Parameters.AddWithValue("@RIDEID", ObjRd.RIDEID);
}
command.Parameters.AddWithValue("@RIDERID", ObjRd.RIDERID);
command.Parameters.AddWithValue("@ASSIGNDATE", ObjRd.ASSIGNEDDATE);
command.Parameters.AddWithValue("@ACCEPTID", ObjRd.ACCEPTID);
int affectedRows = command.ExecuteNonQuery();
var lastInsertID = command.LastInsertedId;
if (affectedRows > 0)
{
returnMessage = "OK";
}
else
{
returnMessage = Shared.Constants.MSG_ERR_DBSAVE.Text;
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
catch (Exception ex)
{
}
return(returnMessage);
}
