Day 5 - Frampton's Wolves

public void UpdateCells() {
  // load the cell information from the Cell table
  List<Cell> cellsList = DAL.DBWorld.GetCellList(this.Name);
  // The above was previously commented out in favor of:
  //    List<Cell> cellsList = new List<Cell>();

  foreach (string tempKey in this.cells.Keys) {
    this.cells[tempKey].IsMapPortal = false;
  }

  string key = "";
  foreach (Cell iCell in cellsList)
  {
    key = iCell.X.ToString() + "," + iCell.Y.ToString() + "," + iCell.Z.ToString();
    if (this.cells.ContainsKey(key))
    {
      this.cells[key].Segue = iCell.Segue;
      this.cells[key].Description.Trim();
      this.cells[key].Description = iCell.Description + " " + this.cells[key].Description;
      this.cells[key].Description.Trim();
      this.cells[key].cellLock = iCell.cellLock;
      this.cells[key].IsMapPortal = iCell.IsMapPortal;
      this.cells[key].IsTeleport = iCell.IsTeleport;
      this.cells[key].IsSingleCustomer = iCell.IsSingleCustomer;
    }
  }
}

void Update () {
  if (Time.time > nextDBUpdate) {
    print("Time to update the DB! " + Time.time);
    nextDBUpdate = Time.time + dbUpdateDelta;
    UpdateCellContents();
    foreach (Transform t in portalTransforms) {
      Destroy(t.gameObject);
    }
    portalTransforms = new List<Transform>();
    foreach (Vector3 v in cellsKeys) {
      if (cells[v].IsMapPortal) {
        Vector3 position = new Vector3((-1f) * cells[v].X, (-1f) * cells[v].Y, (0.1f * cells[v].Z) + 0.5f);
        print(cells[v].IsMapPortal + "Portal at " + position);
        Transform tempts = Instantiate(portalPrefab, 
                                       position,
                                       Quaternion.identity) as Transform;
        portalTransforms.Add(tempts);
      }
    }
  }
}

void UpdateCellContents() {
  ourMap.UpdateCells();
}

/****** Object:  Table [dbo].[NPCLocation] ******/
CREATE TABLE [dbo].[NPCLocation](
  [NPCIndex] [int] NOT NULL,
  [active] [int] NOT NULL,
  [name] [nvarchar](255) NOT NULL,
  [facet] [smallint] NOT NULL,
  [land] [smallint] NOT NULL,
  [map] [smallint] NOT NULL,
  [xCord] [smallint] NOT NULL,
  [yCord] [smallint] NOT NULL,
  [zCord] [int] NOT NULL,
 CONSTRAINT [PK_NPCLocation] PRIMARY KEY CLUSTERED 
(
  [NPCIndex] ASC,
  [facet] ASC,
  [land] ASC,
  [map] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, 
  IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 
  ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

/****** Object:  StoredProcedure [dbo].[prApp_NPCLocation_By_MapID] ******/
CREATE PROCEDURE [dbo].[prApp_NPCLocation_By_MapID] 
  -- Add the parameters for the stored procedure here
  @facet smallint,
  @land smallint,
  @map smallint
AS
BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;

  SELECT *
  FROM NPCLocation
  WHERE facet=@facet AND land=@land AND map=@map 
END

GO

/****** Object:  StoredProcedure [dbo].[prApp_NPCLocation_Update] ******/
CREATE PROCEDURE [dbo].[prApp_NPCLocation_Update] 
  -- Add the parameters for the stored procedure here
  @NPCIndex int, 
  @active int,
  @name nvarchar(255),
  @facet smallint,
  @land smallint,
  @map smallint,
  @xCord smallint,
  @yCord smallint,
  @zCord int
AS
BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;

  UPDATE NPCLocation
  SET name=@name, active=@active, xCord=@xCord, yCord=@yCord, zCord=@zCord
  WHERE NPCIndex=@NPCIndex AND facet=@facet AND land=@land AND map=@map; 
  IF @@ROWCOUNT=0
    INSERT INTO NPCLocation (NPCIndex, active, name, facet, land, map, xCord, yCord, zCord)
    VALUES (@NPCIndex, @active, @name, @facet, @land, @map, @xCord, @yCord, @zCord)
END

GO

public static List<NPC> GetWolves()
{
  List<NPC> npclist = new List<NPC>();

  using (SqlConnection tempConnection = DataAccess.GetSQLConnection())
  using (SqlStoredProcedure sp = new SqlStoredProcedure("prApp_NPCLocation_by_MapID", tempConnection)) {
    sp.AddParameter("@facet", SqlDbType.Int, 4, ParameterDirection.Input, 0);
    sp.AddParameter("@land", SqlDbType.Int, 4, ParameterDirection.Input, 0);
    sp.AddParameter("@map", SqlDbType.Int, 4, ParameterDirection.Input, 0);
    DataTable dtNPCs = sp.ExecuteDataTable();
    foreach (DataRow dr in dtNPCs.Rows)
    {
      if (dr["name"].ToString() == "wolf") {
        NPC wolf = new NPC();
        wolf.Name = dr["name"].ToString();
        wolf.X = Convert.ToInt16(dr["xCord"]);
        wolf.Y = Convert.ToInt16(dr["yCord"]);
        wolf.Z = Convert.ToInt16(dr["zCord"]);
        npclist.Add(wolf);
      }
    }
  }
  return npclist;
}

List<NPC> wolves = DragonsSpine.DAL.DBNPC.GetWolves();
print("Wolves?  I found: " + wolves.Count);
foreach (Transform t in wolfTransforms) {
  Destroy(t.gameObject);
}
wolfTransforms = new List<Transform>();
foreach (NPC wolf in wolves) {
  Vector3 position = new Vector3((-1f) * wolf.X, (-1f) * wolf.Y, (0.1f * wolf.Z) + 0.2f);
  print("Wolf at " + position);
  Transform tempts = Instantiate(wolfPrefab, 
                                  position,
                                  Quaternion.identity) as Transform;
  wolfTransforms.Add(tempts);
}