public int InsertNewStop(DsBusWeb.StopsRow dr)
{
_db.Open();
_db.BeginTrans();
int stopID = 0;
try
{
_db.ExecuteCommand.CommandText = string.Format("INSERT INTO Stops(StopName, Longitude, Latitude, CreatorLongitude, CreatorLatitude, Owner, Culture) VALUES({0}, {1}, {2}, {3}, {4}, {5}, {6})",
OleDbStrHelper.getParamStr(dr.StopName),
OleDbStrHelper.getParamStr(new decimal(dr.Longitude)),
OleDbStrHelper.getParamStr(new decimal(dr.Latitude)),
OleDbStrHelper.getParamStr(new decimal(dr.CreatorLongitude)),
OleDbStrHelper.getParamStr(new decimal(dr.CreatorLatitude)),
OleDbStrHelper.getParamStr(dr.Owner),
OleDbStrHelper.getParamStr(dr.Culture));
_db.Execute();
_db.ExecuteCommand.CommandText = "SELECT MAX(StopID) FROM Stops";
stopID = Convert.ToInt32(_db.ExecuteScalar());
_db.ExecuteCommand.CommandText = string.Format("INSERT INTO StopRating(StopID) VALUES({0})",
OleDbStrHelper.getParamStr(stopID));
_db.Execute();
_db.CommitTrans();
}
catch
{
_db.RollBack();
throw;
}
finally
{
_db.Close();
}
return(stopID);
}
public void UpdateStop(DsBusWeb.StopsRow dr)
{
ExecuteNonQuery(string.Format("UPDATE Stops SET StopName={0} WHERE StopID={1}",
OleDbStrHelper.getParamStr(dr.StopName),
OleDbStrHelper.getParamStr(dr.StopID)));
}
