Dynamicweb 8 Dynamicweb.DataManager refactoring

class DataManagerSample
{
	public int Save(int id)
	{
		//Create a new datamanager instance
		using (var dtm = new DataManager())
		{
			//Create a dataset with zero, one or more rows to update.
			var ds = dtm.CreateDataSet("SELECT * FROM UrlPath WHERE UrlPathID=" + id, "Dynamic.mdb");
			DataRow row;

			//If the id is 0, there will be no records in the returned dataset
			if (id == 0)
			{
				//Add a new row to the table in the dataset
				row = ds.Tables[0].NewRow();
				ds.Tables[0].Rows.Add(row);
				//Set column values that only needs to be set on new rows
				row["UrlPathCreated"] = System.DateTime.Now;
			}
			else
			{
				//We had a record in the table
				row = ds.Tables[0].Rows[0];
			}

			//Update the column values
			row["UrlPathPath"] = "Contact";
			row["UrlPathRedirect"] = "Default.aspx?ID=1";
			row["UrlPathStatus"] = 301;
			row["UrlPathUpdated"] = System.DateTime.Now;
			row["UrlPathActive"] = true;

			//Pass the dataset to the datamanagers UpdateDataset method that will commit our changes to the database
			dtm.Update(ds);

			//If the id is 0, it was a new record - GetIdentity will return the id of the newest row added.
			if (id == 0)
			{
				id = dtm.GetAddedIdentityKey();
			}

			//Dispose the dataset
			ds.Dispose();
		}
		return id;
	}

}