protected void lnkbtnStatus_Click(object sender, EventArgs e) { MultiView1.ActiveViewIndex = 3; toGetInfo getinfo = new toGetInfo(); string schdID = getinfo.getSchdID(); string sqlquery = "SELECT SCHD.Schd_ID, SCHD.SiteID, SCHD.VisitDate, UN.Name,PDS.Completed, coalesce( HVS.Survey_Count, 0) AS NumberOFSurvey " + "FROM Scheduling SCHD RIGHT JOIN UserNames UN " + "ON SCHD.NameID = UN.NameID " + "LEFT JOIN Program_Director_Survey PDS " + "ON PDS.Schd_ID = SCHD.Schd_ID " + "LEFT JOIN (SELECT COUNT(*) AS Survey_Count, Schd_ID " + "FROM HomeVisitorSiteVisitSurvey WHERE Schd_ID =Schd_ID " + "GROUP BY Schd_ID) AS HVS ON HVS.Schd_ID = SCHD.Schd_ID " + "WHERE SCHD.Schd_ID= '" + schdID + "' " + "GROUP BY SCHD.Schd_ID, SCHD.SiteID, SCHD.VisitDate, UN.Name,PDS.Completed, HVS.Survey_Count"; DataTable dtGetTable = DBHelper.GetDataTable(sqlquery); string schdid = dtGetTable.Rows[0]["Schd_ID"].ToString(); string sqlquerystatus = " SELECT SCHD.STATUS FROM [ISBEPI_DEV].[dbo].[Scheduling] SCHD WHERE SCHD.Schd_ID ='" + schdid + "'"; DataTable dtGetTableStatus = DBHelper.GetDataTable(sqlquerystatus); if ((dtGetTable.Rows.Count > 0) && (dtGetTableStatus.Rows.Count > 0)) { if (dtGetTableStatus.Rows[0]["Status"].ToString() != "Closed") { lblStatus.Text = "Active";//dtGetTableStatus.Rows[0]["Status"].ToString(); } else { lblStatus.Text = "Closed"; } lblStatusMonitorName.Text = dtGetTable.Rows[0]["Name"].ToString(); if (dtGetTable.Rows[0]["Completed"].ToString() == "Completed") { lblStatusPD.Text = "Yes"; } else { lblStatusPD.Text = "NO"; } lblStausHVS.Text = dtGetTable.Rows[0]["NumberOFSurvey"].ToString(); lblStatusSIteName.Text = getinfo.getValueSiteName(); } }
protected void lnkbtnReschedule1_Click(object sender, EventArgs e) { toGetInfo setinfo = new toGetInfo(); MultiView1.ActiveViewIndex = 2; txtFNameV3.Text = setinfo.getValueFname(); txtSiteNameV3.Text = setinfo.getValueSiteName(); txtSiteAddressV3.Text = setinfo.getValueSiteAddress(); txtCityV3.Text = setinfo.getValueCity(); txtStateV3.Text = setinfo.getValueState(); lbltitleEditorReschedule.Text = "<div> <h4 class='users'>Schedule Information</h1></div>"; //calV3.SelectedDate = calV3; txtCalV3.Text = null; lnkbtnSaveChanges.Visible = false; lnkbtnReschedule.Visible = true; txtCalV3.Visible = true; lblVisitDateV3.Visible = true; chkbxMiechvV3.Checked = setinfo.getMiechv(); chkbxMiechvV3.Enabled = false; calV3.Visible = true; txtSiteAddressV3.Enabled = false; txtStateV3.Enabled = false; txtCityV3.Enabled = false; txtPhoneNumberV3.Text = setinfo.getPhone(); txtZipV3.Text = setinfo.getZip(); txtZipV3.Enabled = false; txtPhoneNumberV3.Enabled = false; }
protected void btnEdit_Click(object sender, EventArgs e) { toGetInfo setinfo = new toGetInfo(); MultiView1.ActiveViewIndex = 2; txtFNameV3.Text = setinfo.getValueFname(); txtSiteNameV3.Text = setinfo.getValueSiteName(); txtSiteAddressV3.Text = setinfo.getValueSiteAddress(); txtCityV3.Text = setinfo.getValueCity(); txtStateV3.Text = setinfo.getValueState(); txtPhoneNumberV3.Text = setinfo.getPhone(); txtZipV3.Text = setinfo.getZip(); txtZipV3.Enabled = true; txtPhoneNumberV3.Enabled = true; txtSiteAddressV3.Enabled = true; txtCityV3.Enabled = true; txtStateV3.Enabled = true; chkbxMiechvV3.Enabled = true; chkbxMiechvV3.Checked = setinfo.getMiechv(); txtCalV3.Visible = false; lbltitleEditorReschedule.Text = "Edit Information"; lblVisitDateV3.Visible = false; calV3.Visible = false; lnkbtnReschedule.Visible = false; lnkbtnSaveChanges.Visible = true; }