//private void ListUnboxedSpecimens(int colId) //{ // SpecimenManagerDa da = new SpecimenManagerDa(); // DataTable dt = da.GetUnboxedSpecimensByCollectionId(colId); // this.unboxedSpecList.DataSource = dt.DefaultView; // this.unboxedSpecList.DataBind(); //} private void BindOriginSelectBoxes() { if (QueryBoxId > 0) { SpecimenManagerDa da = new SpecimenManagerDa(); DataSet resultsDataSet = da.GetBoxAndAncestors(QueryBoxId); SpecimenBox box = new SpecimenBox(); box.Get(QueryBoxId); DataTable boxesDT = resultsDataSet.Tables[0]; Boxes.DataSource = boxesDT; Boxes.DataBind(); Boxes.Value = box[SpecimenBox.BoxId].ToString(); DataTable containersDT = resultsDataSet.Tables[1]; Containers.DataSource = containersDT; Containers.DataBind(); Containers.Value = boxesDT.Rows[0][SpecimenBox.ContainerId].ToString(); DataTable storagesDT = resultsDataSet.Tables[2]; Storages.DataSource = storagesDT; Storages.DataBind(); Storages.Value = containersDT.Rows[0][SpecimenContainer.StorageId].ToString(); string siteId = resultsDataSet.Tables[3].Rows[0][SpecimenSite.SiteId].ToString(); Sites.Value = siteId; } }
//Reloads Parent window by getting all the parameters through BoxId //checks for the Box delete private void ReloadSpecimenStorageManager(int boxId, bool isDelete) { DataSet resultsDataSet = da.GetBoxAndAncestors(boxId); DataTable boxesDT = resultsDataSet.Tables[0]; string boxIdStr = boxId.ToString(); DataTable containersDT = resultsDataSet.Tables[1]; string containerIdStr = boxesDT.Rows[0][SpecimenBox.ContainerId].ToString(); DataTable storagesDT = resultsDataSet.Tables[2]; string storagesIdStr = containersDT.Rows[0][SpecimenContainer.StorageId].ToString(); string siteId = resultsDataSet.Tables[3].Rows[0][SpecimenSite.SiteId].ToString(); Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "RefreshStorageManger", "refreshStorageManger(" + siteId + "," + storagesIdStr + "," + containerIdStr + "," + boxIdStr + "," + isDelete.ToString().ToLower() + ");", true); }
protected void GetBoxMatrix() { string myBoxId = Request.Form["BoxId"]; int boxId; if (int.TryParse(myBoxId, out boxId)) { SpecimenBox box = new SpecimenBox(); box.Get(boxId); //SpecimenPosition pos = new SpecimenPosition(); //pos.GetByParent(boxId); //// Build a string array of position indexes //DataTable positionDataTable = pos.DataSourceView.Table; DataTable positionDataTable = BusinessObject.GetByParentAsDataView <SpecimenPosition>(boxId).Table; int positionIndexCount = positionDataTable.Rows.Count; string[] posIndexes = new string[positionIndexCount]; string posIndexStringArray = "["; for (int i = 0; i < positionIndexCount; i++) { object val = positionDataTable.Rows[i][SpecimenPosition.Position]; if (val != null) { int index; if (int.TryParse(val.ToString(), out index)) { posIndexStringArray += index + ","; } } } posIndexStringArray = posIndexStringArray.TrimEnd(",".ToCharArray()); posIndexStringArray += "]"; int rows = 20; if (box[SpecimenBox.NoOfRows] != null && !string.IsNullOrEmpty(box[SpecimenBox.NoOfRows].ToString())) { rows = int.Parse(box[SpecimenBox.NoOfRows].ToString()); } int cols = 20; if (box[SpecimenBox.NoOfColumns] != null && !string.IsNullOrEmpty(box[SpecimenBox.NoOfColumns].ToString())) { cols = int.Parse(box[SpecimenBox.NoOfColumns].ToString()); } string boxType = String.Empty; if (box[SpecimenBox.BoxType] != null && !string.IsNullOrEmpty(box[SpecimenBox.BoxType].ToString())) { boxType = box[SpecimenBox.BoxType].ToString(); } int maxPos = rows * cols; if (box[SpecimenBox.MaxPositionNo] != null && !string.IsNullOrEmpty(box[SpecimenBox.MaxPositionNo].ToString())) { maxPos = int.Parse(box[SpecimenBox.MaxPositionNo].ToString()); } // Check if calling for transfer SpecimenManagerDa da = new SpecimenManagerDa(); string transferPositionsArray = ""; if (!string.IsNullOrEmpty(Request.Form["getTransfers"]) && !string.IsNullOrEmpty(Request.Form["collectionId"])) { int collectionId = int.Parse(Request.Form["collectionId"]); DataTable specsInBoxDT = da.GetSpecimensByBoxId(boxId, collectionId); ArrayList oBoxTransferPosArr = new ArrayList(); foreach (DataRow dr in specsInBoxDT.Rows) { if (dr["Transferable"].ToString() == "yes") { oBoxTransferPosArr.Add(dr[SpecimenPosition.Position].ToString()); } } string oBoxTransferPos = String.Join(", ", (string[])oBoxTransferPosArr.ToArray(typeof(string))); transferPositionsArray = "[" + oBoxTransferPos + "]"; } string clientTransferArray = !string.IsNullOrEmpty(transferPositionsArray) ? ("," + transferPositionsArray) : string.Empty; //if (!string.IsNullOrEmpty(Request.Form["NeedPath"]) || true) //{ int specimensInBox = da.GetSpecimensInBox(boxId).Rows.Count; DataSet resultsDataSet = da.GetBoxAndAncestors(boxId); DataTable boxesDT = resultsDataSet.Tables[0]; string boxIdStr = boxId.ToString(); DataRow boxRow = boxesDT.Select(SpecimenBox.BoxId + "=" + boxIdStr)[0]; string boxName = PageUtil.EscapeSingleQuotes(boxRow[SpecimenBox.BoxName].ToString()); DataTable containersDT = resultsDataSet.Tables[1]; string containerIdStr = boxesDT.Rows[0][SpecimenBox.ContainerId].ToString(); DataRow containerRow = containersDT.Select(SpecimenContainer.ContainerId + " = " + containerIdStr)[0]; string containerName = PageUtil.EscapeSingleQuotes(containerRow[SpecimenContainer.ContainerName].ToString()); DataTable storagesDT = resultsDataSet.Tables[2]; string storagesIdStr = containersDT.Rows[0][SpecimenContainer.StorageId].ToString(); DataRow specimenRow = storagesDT.Select(SpecimenStorage.StorageId + " = " + storagesIdStr)[0]; string storageName = PageUtil.EscapeSingleQuotes(specimenRow[SpecimenStorage.StorageName].ToString()); DataTable siteDT = resultsDataSet.Tables[3]; string siteId = siteDT.Rows[0][SpecimenSite.SiteId].ToString(); DataRow siteRow = siteDT.Select(SpecimenSite.SiteId + " = " + siteId)[0]; string siteName = PageUtil.EscapeSingleQuotes(siteRow[SpecimenSite.SiteName].ToString()); BindDropDownList(StoragesDropDown, storagesDT, SpecimenStorage.StorageName, SpecimenStorage.StorageId, storagesIdStr); BindDropDownList(ContainersDropDown, containersDT, SpecimenContainer.ContainerName, SpecimenContainer.ContainerId, containerIdStr); BindDropDownList(BoxesDropDown, boxesDT, SpecimenBox.BoxName, SpecimenBox.BoxId, boxIdStr); SiteId.Text = siteId; //} string js = "new Array(" + rows + "," + cols + "," + maxPos + "," + posIndexStringArray + clientTransferArray + ",'" + siteName + "','" + storageName + "','" + containerName + "'," + specimensInBox + ",'" + boxName + "','" + boxType + "')"; BoxMatrix.Text = js; } }
private void LoadSpecimenInfo() { CurrentSpecimen = new Specimen(); CurrentSpecimen.Get(this.specimenId); string parentspecId = CurrentSpecimen[Specimen.ParentSpecimenId].ToString(); pspecId.Value = parentspecId.ToString(); //if (!string.IsNullOrEmpty(parentspecId)) //{ // Specimen ParentSpecimen = new Specimen(); // ParentSpecimen.Get(Int32.Parse(parentspecId.ToString())); // pRemQty.Value = ParentSpecimen[Specimen.SpecimenRemainingQty].ToString(); //} //RemQty.Value = CurrentSpecimen[Specimen.SpecimenRemainingQty].ToString(); CICHelper.SetFieldValues(this.inputControlsRow.Controls, CurrentSpecimen); //load box and position from SpecimenBoxes and SpecimenPositions tables string sBoxId = CurrentSpecimen[Specimen.BoxId].ToString(); if (!String.IsNullOrEmpty(sBoxId)) { int boxId = int.Parse(sBoxId); SpecimenBox box = new SpecimenBox(); box.Get(boxId); this.BoxId.Value = box[SpecimenBox.BoxId].ToString(); this.BoxName.Value = box[SpecimenBox.BoxName].ToString(); DataSet hierarchySet = da.GetBoxAndAncestors(boxId); DataTable boxesDT = hierarchySet.Tables[0]; DataTable containersDT = hierarchySet.Tables[1]; DataTable storagesDT = hierarchySet.Tables[2]; DataTable siteDT = hierarchySet.Tables[3]; if (boxesDT.Rows.Count >= 1) { string containerIdStr = boxesDT.Rows[0][SpecimenBox.ContainerId].ToString(); DataRow containerRow = containersDT.Select(SpecimenContainer.ContainerId + " = " + containerIdStr)[0]; this.ContainerName.Value = PageUtil.EscapeSingleQuotes(containerRow[SpecimenContainer.ContainerName].ToString()); } if (containersDT.Rows.Count >= 1) { string storagesIdStr = containersDT.Rows[0][Caisis.BOL.SpecimenContainer.StorageId].ToString(); DataRow specimenRow = storagesDT.Select(Caisis.BOL.SpecimenStorage.StorageId + " = " + storagesIdStr)[0]; this.StorageName.Value = PageUtil.EscapeSingleQuotes(specimenRow[Caisis.BOL.SpecimenStorage.StorageName].ToString()); } if (siteDT.Rows.Count >= 1) { string siteId = siteDT.Rows[0][SpecimenSite.SiteId].ToString(); DataRow siteRow = siteDT.Select(SpecimenSite.SiteId + " = " + siteId)[0]; this.SiteName.Value = PageUtil.EscapeSingleQuotes(siteRow[SpecimenSite.SiteName].ToString()); } } string sPositionId = CurrentSpecimen[Specimen.PositionId].ToString(); if (!String.IsNullOrEmpty(sPositionId)) { int positionId = int.Parse(sPositionId); pos.Get(positionId); this.PositionName.Value = pos[SpecimenPosition.Position].ToString(); this.PositionId.Value = pos[SpecimenPosition.PositionId].ToString(); } }
private void LoadSpecimenInfo() { Specimen specimen = new Specimen(); specimen.Get(this.specimenId); string parentspecId = specimen[Specimen.ParentSpecimenId].ToString(); pspecId.Value = parentspecId.ToString(); //if (!string.IsNullOrEmpty(parentspecId)) //{ // Specimen ParentSpecimen = new Specimen(); // ParentSpecimen.Get(Int32.Parse(parentspecId.ToString())); // pRemQty.Value = ParentSpecimen[Specimen.SpecimenRemainingQty].ToString(); //} CICHelper.SetFieldValues(this.inputControlsRow.Controls, specimen); //getting patient identifier PtId.Text = _identifierType + " :"; SpecimenManagerDa da = new SpecimenManagerDa(); string datasetSql = CacheManager.GetDatasetSQL(Session[SessionKey.DatasetId]); DataTable dt = da.GetIdentifier(this.specimenId, _identifierType, datasetSql); string identifier = dt.Rows[0].ItemArray[2].ToString(); TumorBankNumber.Text = identifier.ToString(); //load box and position from SpecimenBoxes and SpecimenPositions tables string sBoxId = specimen[Specimen.BoxId].ToString(); if (!String.IsNullOrEmpty(sBoxId)) { int boxId = int.Parse(sBoxId); SpecimenBox box = new SpecimenBox(); box.Get(boxId); this.BoxId.Value = box[SpecimenBox.BoxId].ToString(); this.BoxName.Value = box[SpecimenBox.BoxName].ToString(); DataSet hierarchySet = da.GetBoxAndAncestors(boxId); DataTable boxesDT = hierarchySet.Tables[0]; DataTable containersDT = hierarchySet.Tables[1]; DataTable storagesDT = hierarchySet.Tables[2]; DataTable siteDT = hierarchySet.Tables[3]; if (boxesDT.Rows.Count >= 1) { string containerIdStr = boxesDT.Rows[0][SpecimenBox.ContainerId].ToString(); DataRow containerRow = containersDT.Select(SpecimenContainer.ContainerId + " = " + containerIdStr)[0]; this.ContainerName.Value = PageUtil.EscapeSingleQuotes(containerRow[SpecimenContainer.ContainerName].ToString()); } if (containersDT.Rows.Count >= 1) { string storagesIdStr = containersDT.Rows[0][Caisis.BOL.SpecimenContainer.StorageId].ToString(); DataRow specimenRow = storagesDT.Select(Caisis.BOL.SpecimenStorage.StorageId + " = " + storagesIdStr)[0]; this.StorageName.Value = PageUtil.EscapeSingleQuotes(specimenRow[Caisis.BOL.SpecimenStorage.StorageName].ToString()); } if (siteDT.Rows.Count >= 1) { string siteId = siteDT.Rows[0][SpecimenSite.SiteId].ToString(); DataRow siteRow = siteDT.Select(SpecimenSite.SiteId + " = " + siteId)[0]; this.SiteName.Value = PageUtil.EscapeSingleQuotes(siteRow[SpecimenSite.SiteName].ToString()); } } string sPositionId = specimen[Specimen.PositionId].ToString(); if (!String.IsNullOrEmpty(sPositionId)) { int positionId = int.Parse(sPositionId); SpecimenPosition pos = new SpecimenPosition(); pos.Get(positionId); this.PositionName.Value = pos[SpecimenPosition.Position].ToString(); this.PositionId.Value = pos[SpecimenPosition.PositionId].ToString(); } }