/// <summary>
/// Insert new Bus instance in database
/// </summary>
/// <param name="bus"></param>
public void Insert(Bus bus)
{
if (bus != null)
{
string insert_statement = string.Format("INSERT INTO tbl_bus (bus_number, bus_capacity, bus_details, bus_lattitude, bus_longitude, bus_occupied, bus_vacant) VALUES('{0}',{1},'{2}','{3}','{4}',{5},{6})"
, bus.BusNumber
, bus.Capacity
, bus.Details
, bus.Lattitude
, bus.Longitude
, bus.Occupied
, bus.Vacancy);
using (MySqlCommand command = new MySqlCommand(insert_statement, this.connection))
{
using (MySqlDataReader reader = command.ExecuteReader())
{
}
}
}
}
/// <summary>
/// Parse data to Bus object
/// ("bus_number"&"lattitude"&"longitude"&"capacity"&"vacant"&"occupied"&"details)
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static Bus ParseData(string data)
{
string substringdata = data.Substring(data.IndexOf("("));
string substringremove = substringdata.Substring(substringdata.IndexOf(")"));
substringdata = substringdata.Replace("(","").Replace(substringremove, "");
string[] splittedbycomma = substringdata.Split('&');
Bus bus = new Bus
{
Action = ActionType.Transmit,
BusNumber = splittedbycomma[0],
Lattitude = splittedbycomma[1],
Longitude = splittedbycomma[2],
Capacity = splittedbycomma[3],
Vacancy = splittedbycomma[4],
Occupied = splittedbycomma[5],
Details = splittedbycomma[6],
};
return bus;
}
/// <summary>
/// Update record base on Bus Instance
/// </summary>
/// <param name="bus"></param>
public void Update(Bus bus)
{
if (bus != null)
{
string update_statement = string.Format("UPDATE tbl_bus SET bus_lattitude='{1}', bus_longitude='{2}', bus_vacant={3}, bus_occupied={4} WHERE bus_number='{0}'"
, bus.BusNumber
, bus.Lattitude
, bus.Longitude
, bus.Vacancy
, bus.Occupied);
using (MySqlCommand command = new MySqlCommand(update_statement, this.connection))
{
using (MySqlDataReader reader = command.ExecuteReader())
{
}
}
}
}