public bool delete(Model.ML_Location location)
{
var para = new MySqlParameter[1];
para[0] = new MySqlParameter("@unique_id", location.location_unique_id);
return(MySQLHelper.ExecuteNonQuery(DBConnection.connectionString, CommandType.Text, "DELETE FROM location WHERE location_unique_id = @unique_id", para) != -1);
}
public int update(Model.ML_Location location)
{
var para = new MySqlParameter[5];
para[0] = new MySqlParameter("@location", location.location_name);
para[1] = new MySqlParameter("@longitude", location.longitude);
para[2] = new MySqlParameter("@location_address", location.location_address);
para[3] = new MySqlParameter("@latitude", location.latitude);
para[4] = new MySqlParameter("@unique_id", location.location_unique_id);
return(MySQLHelper.ExecuteNonQuery(DBConnection.connectionString, CommandType.Text, "UPDATE `location` SET location_name = COALESCE(@location, location_name), location_address = COALESCE(@location_address, location_address), longitude = COALESCE(@longitude, longitude), latitude = COALESCE(@latitude, latitude), location_unique_id = COALESCE(@unique_id, location_unique_id) where location_unique_id = @unique_id", para));
}
public bool insert(Model.ML_Location location)
{
var para = new MySqlParameter[5];
para[0] = new MySqlParameter("@location", location.location_name);
para[1] = new MySqlParameter("@longitude", location.longitude);
para[2] = new MySqlParameter("@location_address", location.location_address);
para[3] = new MySqlParameter("@latitude", location.latitude);
para[4] = new MySqlParameter("@unique_id", location.location_unique_id);
return(MySQLHelper.ExecuteNonQuery(DBConnection.connectionString, CommandType.Text, "INSERT INTO location ( location_name ,location_address ,longitude ,latitude, location_unique_id ) VALUES ( @location ,@location_address ,@longitude ,@latitude, @unique_id )", para) != -1);
}
