public static void UpdateTerritory(Territory territory) { string sqlQuery = "UPDATE Territory SET ParentTerritoryID=@ParentTerritoryID, FullDescription=@FullDescription, Name=@Name WHERE TerritoryID=" + territory.TerritoryID; Database db = new SqlDatabase(DBHelper.GetConnectionString()); DbCommand dbCommand = db.GetSqlStringCommand(sqlQuery); db.AddInParameter(dbCommand, "ParentTerritoryID", DbType.Int32, territory.ParentTerritoryID); db.AddInParameter(dbCommand, "FullDescription", DbType.String, territory.FullDescription); db.AddInParameter(dbCommand, "Name", DbType.String, territory.Name); db.ExecuteNonQuery(dbCommand); }
public static Territory InsertTerritory(Territory territory) { string sqlQuery = "INSERT INTO Territory(ParentTerritoryID,FullDescription,Name) " + " VALUES(@ParentTerritoryID,@FullDescription,@Name);SELECT @@Identity"; Database db = new SqlDatabase(DBHelper.GetConnectionString()); DbCommand dbCommand = db.GetSqlStringCommand(sqlQuery); db.AddInParameter(dbCommand, "ParentTerritoryID", DbType.Int32, territory.ParentTerritoryID); db.AddInParameter(dbCommand, "FullDescription", DbType.String, territory.FullDescription); db.AddInParameter(dbCommand, "Name", DbType.String, territory.Name); territory.TerritoryID = Convert.ToInt32(db.ExecuteScalar(dbCommand)); return territory; }
public static void UpdateTerritory(Territory territory) { TerritoryDB.UpdateTerritory(territory); }
public static Territory InsertTerritory(Territory territory) { return TerritoryDB.InsertTerritory(territory); }
private static Territory GetTerritoryFromReader(IDataReader dataReader) { Territory territory = new Territory(); territory.TerritoryID = DBHelper.GetInt(dataReader, "TerritoryID"); territory.ParentTerritoryID = DBHelper.GetInt(dataReader, "ParentTerritoryID"); territory.Name = DBHelper.GetString(dataReader, "Name"); territory.FullDescription = DBHelper.GetString(dataReader, "FullDescription"); return territory; }