public void Bind_Control_Expires() { if (SHS.BaseLayer.SharedTables.ApplicationSharedTables.GlobalCodes != null) { //DropDownList_CustomDocumentTransfers_LevelofCare binding DataView dataLevelofCare = new DataView(SHS.BaseLayer.SharedTables.ApplicationSharedTables.GlobalCodes); dataLevelofCare.RowFilter = "Category='XLEVELOFCARE' AND Active='Y' AND ISNULL(RecordDeleted,'N')<>'Y'"; dataLevelofCare.Sort = "CodeName"; //DropDownList_CustomDocumentReferrals_ReferralStatus.Items.Add(new ListItem("", "-1")); DropDownList_CustomDocumentTransfers_LevelofCare.DataTextField = "CodeName"; DropDownList_CustomDocumentTransfers_LevelofCare.DataValueField = "GlobalCodeId"; DropDownList_CustomDocumentTransfers_LevelofCare.DataSource = dataLevelofCare; DropDownList_CustomDocumentTransfers_LevelofCare.DataBind(); //Referring status DataView dataRefStatus = new DataView(SHS.BaseLayer.SharedTables.ApplicationSharedTables.GlobalCodes); dataRefStatus.RowFilter = "Category='REFERRALSTATUS' AND Active='Y' AND ISNULL(RecordDeleted,'N')<>'Y'"; dataRefStatus.Sort = "CodeName"; //DropDownList_CustomDocumentReferrals_ReferralStatus.Items.Add(new ListItem("", "-1")); DropDownList_CustomDocumentTransfers_TransferStatus.DataTextField = "CodeName"; DropDownList_CustomDocumentTransfers_TransferStatus.DataValueField = "GlobalCodeId"; DropDownList_CustomDocumentTransfers_TransferStatus.DataSource = dataRefStatus; DropDownList_CustomDocumentTransfers_TransferStatus.DataBind(); if (SetIndex == true) { DropDownList_CustomDocumentTransfers_TransferStatus.SelectedIndex = 1; } //Referral staff ///Staff DataRow[] DataRowStaff = SHS.BaseLayer.SharedTables.ApplicationSharedTables.Staff.Select("Active='Y' AND ISNULL(RecordDeleted,'N')<>'Y'"); DataTable dataTableStaff = new DataTable("Table"); dataTableStaff.Columns.Add("StaffID", System.Type.GetType("System.Int32")); dataTableStaff.Columns.Add("StaffName", System.Type.GetType("System.String")); dataTableStaff.Columns.Add("StaffCode", System.Type.GetType("System.String")); dataTableStaff.Columns.Add("clinician", System.Type.GetType("System.String")); dataTableStaff.Columns.Add("adminstaff", System.Type.GetType("System.String")); DataRow dataRowObject = dataTableStaff.NewRow(); string signerName = string.Empty; //For All Staff User for (int counter1 = 0; counter1 < DataRowStaff.Length; counter1++) { dataRowObject = dataTableStaff.NewRow(); dataRowObject["StaffID"] = DataRowStaff[counter1]["StaffId"]; signerName = Convert.ToString(DataRowStaff[counter1]["LastName"]).Trim() + ", " + Convert.ToString(DataRowStaff[counter1]["FirstName"]).Trim(); if (signerName.Length > 27) { dataRowObject["StaffName"] = signerName.Substring(0, 27) + "..."; } else { dataRowObject["StaffName"] = signerName; } dataRowObject["StaffCode"] = DataRowStaff[counter1]["UserCode"]; dataRowObject["clinician"] = DataRowStaff[counter1]["clinician"]; dataRowObject["adminstaff"] = DataRowStaff[counter1]["adminstaff"]; dataTableStaff.Rows.Add(dataRowObject); } DataView dataViewStaff = new DataView(dataTableStaff); //dataViewStaff.Sort = "StaffNameID,StaffName"; dataViewStaff.Sort = "StaffName"; DropDownList_CustomDocumentTransfers_TransferringStaff.DataTextField = "StaffName"; DropDownList_CustomDocumentTransfers_TransferringStaff.DataValueField = "StaffID"; DropDownList_CustomDocumentTransfers_TransferringStaff.DataSource = dataViewStaff; DropDownList_CustomDocumentTransfers_TransferringStaff.DataBind(); if (initilization == true) { DropDownList_CustomDocumentTransfers_TransferringStaff.ClearSelection(); DropDownList_CustomDocumentTransfers_TransferringStaff.Items.FindByValue(BaseCommonFunctions.ApplicationInfo.LoggedInUser.UserId.ToString()).Selected = true; initilization = false; } //Receiving staff DataView dvReceivingStaff = new DataView(dataTableStaff); dvReceivingStaff.RowFilter = "clinician='Y' OR adminstaff='Y' "; dvReceivingStaff.Sort = "StaffName"; DropDownList_CustomDocumentTransfers_ReceivingStaff.DataTextField = "StaffName"; DropDownList_CustomDocumentTransfers_ReceivingStaff.DataValueField = "StaffID"; DropDownList_CustomDocumentTransfers_ReceivingStaff.DataSource = dvReceivingStaff; DropDownList_CustomDocumentTransfers_ReceivingStaff.DataBind(); //Receiving program //DataView dataStaffProgram = new DataView(SHS.BaseLayer.SharedTables.StaffSharedTables.StaffProgram); ////DataView dataRecProgram = new DataView(SHS.BaseLayer.SharedTables.ApplicationSharedTables.GlobalCodes); ////dataRecProgram.RowFilter = "Category='RECEIVINGPROGRAM' AND Active='Y' AND ISNULL(RecordDeleted,'N')<>'Y'"; //dataStaffProgram.Sort = "CodeName"; ////DropDownList_CustomDocumentReferrals_ReferralStatus.Items.Add(new ListItem("", "-1")); //DropDownList_CustomDocumentTransfers_ReceivingProgram.DataTextField = "CodeName"; //DropDownList_CustomDocumentTransfers_ReceivingProgram.DataValueField = "GlobalCodeId"; //DropDownList_CustomDocumentTransfers_ReceivingProgram.DataSource = dataStaffProgram; //DropDownList_CustomDocumentTransfers_ReceivingProgram.DataBind(); //Service //DataView dataServices = new DataView(SHS.BaseLayer.SharedTables.ApplicationSharedTables.AuthorizationCodes); //dataServices.RowFilter = "Active='Y' AND ISNULL(RecordDeleted,'N')<>'Y'"; //dataServices.Sort = "AuthorizationCodeName"; ////DropDownList_CustomDocumentReferrals_ReferralStatus.Items.Add(new ListItem("", "-1")); //DropDownList_CustomDocumentTransferServices_AuthorizationCodeId.DataTextField = "AuthorizationCodeName"; //DropDownList_CustomDocumentTransferServices_AuthorizationCodeId.DataValueField = "AuthorizationCodeId"; //DropDownList_CustomDocumentTransferServices_AuthorizationCodeId.DataSource = dataServices; //DropDownList_CustomDocumentTransferServices_AuthorizationCodeId.DataBind(); using (SHS.UserBusinessServices.ReferralService objectReferralService = new SHS.UserBusinessServices.ReferralService()) { int DocumentCodeId = Convert.ToInt32(BaseCommonFunctions.CheckRowExists(BaseCommonFunctions.ScreenInfo.CurrentDocument.DocumentDataSet, "Documents") ? BaseCommonFunctions.ScreenInfo.CurrentDocument.DocumentDataSet.Tables["Documents"].Rows[0]["DocumentCodeId"] : 0); DataSet datasetReferralService = objectReferralService.GetReferralService(DocumentCodeId, Convert.ToInt32(BaseCommonFunctions.ApplicationInfo.Client.ClientId)); DataView dataViewReferralService = new DataView(datasetReferralService.Tables["AuthorizationCodes"]); dataViewReferralService.Sort = "DisplayAs"; DropDownList_CustomDocumentTransferServices_AuthorizationCodeId.DataTextField = "DisplayAs"; DropDownList_CustomDocumentTransferServices_AuthorizationCodeId.DataValueField = "AuthorizationCodeId"; DropDownList_CustomDocumentTransferServices_AuthorizationCodeId.DataSource = dataViewReferralService; DropDownList_CustomDocumentTransferServices_AuthorizationCodeId.DataBind(); } //Receiving action DataView dataRecAction = new DataView(SHS.BaseLayer.SharedTables.ApplicationSharedTables.GlobalCodes); dataRecAction.RowFilter = "Category='RECEIVINGACTION' AND Active='Y' AND ISNULL(RecordDeleted,'N')<>'Y'"; dataRecAction.Sort = "CodeName"; //DropDownList_CustomDocumentReferrals_ReferralStatus.Items.Add(new ListItem("", "-1")); DropDownList_CustomDocumentTransfers_ReceivingAction.DataTextField = "CodeName"; DropDownList_CustomDocumentTransfers_ReceivingAction.DataValueField = "GlobalCodeId"; DropDownList_CustomDocumentTransfers_ReceivingAction.DataSource = dataRecAction; DropDownList_CustomDocumentTransfers_ReceivingAction.DataBind(); //using (SHS.UserBusinessServices.DetailPages objectCpt = new SHS.UserBusinessServices.DetailPages()) //{ // DataSet dstGetStaffProgeram = new DataSet(); // // dstGetStaffProgeram = objectCpt.GetStaffProgeram(); // int counter = dstGetStaffProgeram.Tables[0].Rows.Count; // StringBuilder strhidden = new StringBuilder(); // for(int i=0;i<counter;i++) // { // strhidden.Append(dstGetStaffProgeram.Tables[0].Rows[i]["Program"]); // strhidden.Append(","); // strhidden.Append(dstGetStaffProgeram.Tables[0].Rows[i]["StaffProgramId"]); // strhidden.Append("||"); // } // hiddenProgramList.Value = strhidden.ToString(); // // cs.RegisterClientScriptBlock(GetType(), "BodyLoadUnloadScript", "<SCRIPT LANGUAGE='JavaScript'> alert('HAPPY CODING')</script>"); // //Page.ClientScript.RegisterClientScriptBlock(GetType(), "MyScript", "<script> alert('HAPPY CODING')</script>"); //} using (SHS.UserBusinessServices.DetailPages objectCpt = new SHS.UserBusinessServices.DetailPages()) { DataSet dstGetcustomconfigurationsURL = new DataSet(); dstGetcustomconfigurationsURL = objectCpt.GetcustomconfigurationsURL(); if (dstGetcustomconfigurationsURL.Tables["customconfigurations"].Rows.Count > 0) { HyperLink_help.NavigateUrl = Convert.ToString(dstGetcustomconfigurationsURL.Tables["customconfigurations"].Rows[0][0]); } } } }
private void BindControlGeneral() { if (SHS.BaseLayer.SharedTables.ApplicationSharedTables.GlobalCodes != null) { DataRow[] DataRowStaff = SHS.BaseLayer.SharedTables.ApplicationSharedTables.Staff.Select("Active='Y' AND ISNULL(RecordDeleted,'N')<>'Y'"); DataTable dataTableStaff = new DataTable("Table"); dataTableStaff.Columns.Add("StaffID", System.Type.GetType("System.Int32")); dataTableStaff.Columns.Add("FirstName", System.Type.GetType("System.String")); dataTableStaff.Columns.Add("LastName", System.Type.GetType("System.String")); dataTableStaff.Columns.Add("StaffName", System.Type.GetType("System.String")); dataTableStaff.Columns.Add("StaffCode", System.Type.GetType("System.String")); dataTableStaff.Columns.Add("clinician", System.Type.GetType("System.String")); dataTableStaff.Columns.Add("adminstaff", System.Type.GetType("System.String")); DataRow dataRowObject = dataTableStaff.NewRow(); string signerName = string.Empty; //For All Staff User for (int counter1 = 0; counter1 < DataRowStaff.Length; counter1++) { dataRowObject = dataTableStaff.NewRow(); dataRowObject["StaffID"] = DataRowStaff[counter1]["StaffId"]; signerName = Convert.ToString(DataRowStaff[counter1]["LastName"]).Trim() + ", " + Convert.ToString(DataRowStaff[counter1]["FirstName"]).Trim(); if (signerName.Length > 27) { dataRowObject["StaffName"] = signerName.Substring(0, 27) + "..."; } else { dataRowObject["StaffName"] = signerName; } dataRowObject["FirstName"] = DataRowStaff[counter1]["FirstName"]; dataRowObject["LastName"] = DataRowStaff[counter1]["LastName"]; dataRowObject["StaffCode"] = DataRowStaff[counter1]["UserCode"]; dataRowObject["clinician"] = DataRowStaff[counter1]["clinician"]; dataRowObject["adminstaff"] = DataRowStaff[counter1]["adminstaff"]; dataTableStaff.Rows.Add(dataRowObject); } DataView dataViewStaff = new DataView(dataTableStaff); //dataViewStaff.Sort = "StaffNameID,StaffName"; dataViewStaff.Sort = "StaffName"; //Referring status DataView dataRefStatus = new DataView(SHS.BaseLayer.SharedTables.ApplicationSharedTables.GlobalCodes); dataRefStatus.RowFilter = "Category='REFERRALSTATUS' AND Active='Y' AND ISNULL(RecordDeleted,'N')<>'Y'"; dataRefStatus.Sort = "SortOrder"; DropDownList_CustomDocumentReferrals_ReferralStatus.DataTextField = "CodeName"; DropDownList_CustomDocumentReferrals_ReferralStatus.DataValueField = "GlobalCodeId"; DropDownList_CustomDocumentReferrals_ReferralStatus.DataSource = dataRefStatus; DropDownList_CustomDocumentReferrals_ReferralStatus.DataBind(); if (SetIndex == true) { DropDownList_CustomDocumentReferrals_ReferralStatus.SelectedIndex = 1; } //Referral DocumentReferrals DropDownList_CustomDocumentReferrals_ReferringStaff.DataTextField = "StaffName"; DropDownList_CustomDocumentReferrals_ReferringStaff.DataValueField = "StaffId"; DropDownList_CustomDocumentReferrals_ReferringStaff.DataSource = dataViewStaff; DropDownList_CustomDocumentReferrals_ReferringStaff.DataBind(); if (initilization == true) { DropDownList_CustomDocumentReferrals_ReferringStaff.ClearSelection(); DropDownList_CustomDocumentReferrals_ReferringStaff.Items.FindByValue(BaseCommonFunctions.ApplicationInfo.LoggedInUser.UserId.ToString()).Selected = true; initilization = false; } //Receiving DocumentReferrals DataView dvReceivingStaff = new DataView(dataTableStaff); dvReceivingStaff.RowFilter = "clinician='Y' OR adminstaff='Y' "; dvReceivingStaff.Sort = "StaffName"; DropDownList_CustomDocumentReferrals_ReceivingStaff.DataTextField = "StaffName"; DropDownList_CustomDocumentReferrals_ReceivingStaff.DataValueField = "StaffId"; DropDownList_CustomDocumentReferrals_ReceivingStaff.DataSource = dvReceivingStaff; DropDownList_CustomDocumentReferrals_ReceivingStaff.DataBind(); //Receiving program //DataView dataRecProgram = new DataView(SHS.BaseLayer.SharedTables.ApplicationSharedTables.Programs); //dataRecProgram.RowFilter = "Active='Y' AND ISNULL(RecordDeleted,'N')='N'"; //dataRecProgram.Sort = "ProgramName"; //DropDownList_CustomDocumentReferrals_ReceivingProgram.DataTextField = "ProgramName"; //DropDownList_CustomDocumentReferrals_ReceivingProgram.DataValueField = "ProgramId"; //DropDownList_CustomDocumentReferrals_ReceivingProgram.DataSource = dataRecProgram; //DropDownList_CustomDocumentReferrals_ReceivingProgram.DataBind(); //DataView dataServices = new DataView(SHS.BaseLayer.SharedTables.ApplicationSharedTables.AuthorizationCodes); //dataServices.RowFilter = "Active='Y' AND ISNULL(RecordDeleted,'N')='N'"; //dataServices.Sort = "AuthorizationCodeName"; ////DropDownList_CustomDocumentReferrals_ReferralStatus.Items.Add(new ListItem("", "-1")); //DropDownList_CustomDocumentReferralServices_AuthorizationCodeId.DataTextField = "AuthorizationCodeName"; //DropDownList_CustomDocumentReferralServices_AuthorizationCodeId.DataValueField = "AuthorizationCodeId"; //DropDownList_CustomDocumentReferralServices_AuthorizationCodeId.DataSource = dataServices; //DropDownList_CustomDocumentReferralServices_AuthorizationCodeId.DataBind(); //Service //Modify by :RohitK,on 06-19-2012,1796,#81 Services Drop-Downs,Harbor Go Live Issues //This stored procedure is designed to restrict the authorization codes available based on DocumentCodeId and ClientId using (SHS.UserBusinessServices.ReferralService objectReferralService = new SHS.UserBusinessServices.ReferralService()) { int DocumentCodeId = Convert.ToInt32(BaseCommonFunctions.CheckRowExists(BaseCommonFunctions.ScreenInfo.CurrentDocument.DocumentDataSet, "Documents") ? BaseCommonFunctions.ScreenInfo.CurrentDocument.DocumentDataSet.Tables["Documents"].Rows[0]["DocumentCodeId"] : 0); DataSet datasetReferralService = objectReferralService.GetReferralService(DocumentCodeId, Convert.ToInt32(BaseCommonFunctions.ApplicationInfo.Client.ClientId)); DataView dataViewReferralService = new DataView(datasetReferralService.Tables["AuthorizationCodes"]); dataViewReferralService.Sort = "DisplayAs"; DropDownList_CustomDocumentReferralServices_AuthorizationCodeId.DataTextField = "DisplayAs"; DropDownList_CustomDocumentReferralServices_AuthorizationCodeId.DataValueField = "AuthorizationCodeId"; DropDownList_CustomDocumentReferralServices_AuthorizationCodeId.DataSource = dataViewReferralService; DropDownList_CustomDocumentReferralServices_AuthorizationCodeId.DataBind(); } //Receiving action DataView dataRecAction = new DataView(SHS.BaseLayer.SharedTables.ApplicationSharedTables.GlobalCodes); dataRecAction.RowFilter = "Category='RECEIVINGACTION' AND Active='Y' AND ISNULL(RecordDeleted,'N')='N'"; dataRecAction.Sort = "SortOrder"; DropDownList_CustomDocumentReferrals_ReceivingAction.DataTextField = "CodeName"; DropDownList_CustomDocumentReferrals_ReceivingAction.DataValueField = "GlobalCodeId"; DropDownList_CustomDocumentReferrals_ReceivingAction.DataSource = dataRecAction; DropDownList_CustomDocumentReferrals_ReceivingAction.DataBind(); using (SHS.UserBusinessServices.DetailPages objectCpt = new SHS.UserBusinessServices.DetailPages()) { DataSet dstGetcustomconfigurationsURL = new DataSet(); dstGetcustomconfigurationsURL = objectCpt.GetcustomconfigurationsURL(); if (dstGetcustomconfigurationsURL != null) { if (dstGetcustomconfigurationsURL.Tables["customconfigurations"].Rows.Count > 0) { HyperLink_help.NavigateUrl = Convert.ToString(dstGetcustomconfigurationsURL.Tables["customconfigurations"].Rows[0][0]); } } } } CustomGrid.Bind(ParentDetailPageObject.ScreenId); }