protected void GridView1_SelectedIndexChanged(object sender, GridViewSelectEventArgs e) { MultiView1.ActiveViewIndex = 1; txtSiteName.Text = grdConfirmation.Rows[e.NewSelectedIndex].Cells[2].Text.Replace("amp;", string.Empty); txtFName.Text = grdConfirmation.Rows[e.NewSelectedIndex].Cells[4].Text; string status = grdConfirmation.Rows[e.NewSelectedIndex].Cells[5].Text; string siteID = grdConfirmation.Rows[e.NewSelectedIndex].Cells[6].Text; string schdID = grdConfirmation.Rows[e.NewSelectedIndex].Cells[7].Text; string sqlquery2 = "SELECT UN.Name, ST.Sites, ST.PhoneNumber,ST.ZipCode, ST.MICEHV, SCHD.VisitDate, " + "SCHD.Schd_ID, SCHD.Status, ST.SiteID, ST.Site_Address, ST.City, ST.State " + "FROM [ISBEPI_DEV].[dbo].[Scheduling] SCHD JOIN [ISBEPI_DEV].[dbo].[UserNames] UN ON " + " UN.NameID=SCHD.[NameID] JOIN [ISBEPI_DEV].[dbo].[Sites] ST ON ST.SiteID = SCHD.SiteID " + " WHERE SCHD.Schd_ID ='" + schdID + "';"; DataTable dt2 = DBHelper.GetDataTable(sqlquery2); if (dt2.Rows.Count > 0) { string address = dt2.Rows[0]["Site_Address"].ToString(); string city = dt2.Rows[0]["City"].ToString(); string state = dt2.Rows[0]["State"].ToString(); txtSiteAddress.Text = address; txtState.Text = state; txtCity.Text = city; string phone = dt2.Rows[0]["PhoneNumber"].ToString(); txtPhoneNumber.Text = phone; string zip = dt2.Rows[0]["ZipCode"].ToString(); txtZipV2.Text = zip; bool miechv = Convert.ToBoolean(dt2.Rows[0]["MICEHV"].ToString()); chkbxMiechv.Checked = miechv; if (dt2.Rows[0]["VisitDate"].ToString().Length > 1) { visitdate = DateTime.Parse(dt2.Rows[0]["VisitDate"].ToString()).ToShortDateString(); txtVisitingdate.Text = visitdate; } else { txtVisitingdate.Text = null; } toGetInfo getuserInfo = new toGetInfo(); getuserInfo.setSchdID(dt2.Rows[0]["Schd_ID"].ToString()); getuserInfo.setVlaue(txtFName.Text, siteID, txtSiteName.Text, address, city, state, visitdate, status, phone, zip, miechv); if (status == "Confirmed" || txtVisitingdate.Text.Length < 1) { lnkbtnConfirm.Enabled = false; } else if (status == "Closed" || txtVisitingdate.Text.Length < 1) { lnkbtnConfirm.Enabled = false; } if (Roles.IsUserInRole(Page.User.Identity.Name, "Administrator")) { lnkbtnVisiting.Enabled = true; if (status == "Confirmed" && (DateTime.Parse(visitdate)) <= DateTime.Parse(DateTime.Now.ToShortDateString().ToString())) { lnkbtnConfirm.Enabled = false; lnkbtnVisiting.Enabled = true; } else if (status == "Closed") { lnkbtnConfirm.Enabled = false; lnkbtnVisiting.Enabled = false; } } else if (!Roles.IsUserInRole(Page.User.Identity.Name, "Administrator")) { lnkbtnVisiting.Enabled = false; if (status == "Confirmed" && (DateTime.Parse(visitdate) <= DateTime.Parse(DateTime.Now.ToShortDateString().ToString()))) { lnkbtnConfirm.Enabled = false; lnkbtnVisiting.Enabled = true; } else if (status == "Closed") { lnkbtnConfirm.Enabled = false; lnkbtnVisiting.Enabled = false; } } } }
protected void lnkbtnDateSchedule_Command(object sender, CommandEventArgs e) { string schdID = e.CommandArgument.ToString(); toGetInfo setinfo = new toGetInfo(); setinfo.setSchdID(schdID); string sqlquery = "SELECT [ISBEPI_DEV].[dbo].[UserNames].Name, [ISBEPI_DEV].[dbo].[Sites].Sites,[ISBEPI_DEV].[dbo].[Sites].PhoneNumber,[ISBEPI_DEV].[dbo].[Sites].ZipCode,[ISBEPI_DEV].[dbo].[Sites].MICEHV, [ISBEPI_DEV].[dbo].[Scheduling].VisitDate,[ISBEPI_DEV].[dbo].[Scheduling].Schd_ID, [ISBEPI_DEV].[dbo].[Scheduling].Status, [ISBEPI_DEV].[dbo].[Sites].SiteID, " + "[ISBEPI_DEV].[dbo].[Sites].Site_Address, [ISBEPI_DEV].[dbo].[Sites].City, [ISBEPI_DEV].[dbo].[Sites].State FROM [ISBEPI_DEV].[dbo].[Scheduling] JOIN [ISBEPI_DEV].[dbo].[UserNames] " + "ON [ISBEPI_DEV].[dbo].[UserNames].NameID=[ISBEPI_DEV].[dbo].[Scheduling].[NameID] JOIN [ISBEPI_DEV].[dbo].[Sites] " + "ON [ISBEPI_DEV].[dbo].[Sites].SiteID = [ISBEPI_DEV].[dbo].[Scheduling].SiteID " + "WHERE [ISBEPI_DEV].[dbo].[Scheduling].Schd_ID ='" + setinfo.getSchdID() + "';"; DataTable dt = DBHelper.GetDataTable(sqlquery); if (dt.Rows.Count > 0) { toGetInfo getuserInfo = new toGetInfo(); getuserInfo.setVlaue(dt.Rows[0]["Name"].ToString(), dt.Rows[0]["SiteID"].ToString(), dt.Rows[0]["Sites"].ToString(), dt.Rows[0]["Site_Address"].ToString(), dt.Rows[0]["City"].ToString(), dt.Rows[0]["State"].ToString(), dt.Rows[0]["VisitDate"].ToString(), dt.Rows[0]["Status"].ToString(), dt.Rows[0]["PhoneNumber"].ToString(), dt.Rows[0]["ZipCode"].ToString(), Convert.ToBoolean(dt.Rows[0]["MICEHV"].ToString())); MultiView1.ActiveViewIndex = 2; txtFNameV3.Text = dt.Rows[0]["Name"].ToString(); txtSiteNameV3.Text = dt.Rows[0]["Sites"].ToString(); 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; 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; chkbxMiechvV3.Enabled = false; chkbxMiechvV3.Checked = setinfo.getMiechv(); } }
protected void dispalyView2info() { MultiView1.ActiveViewIndex = 1; toGetInfo setinfo = new toGetInfo(); string sqlquery = "SELECT [ISBEPI_DEV].[dbo].[UserNames].Name, [ISBEPI_DEV].[dbo].[Sites].Sites, [ISBEPI_DEV].[dbo].[Scheduling].VisitDate,[ISBEPI_DEV].[dbo].[Sites].PhoneNumber,[ISBEPI_DEV].[dbo].[Sites].ZipCode, [ISBEPI_DEV].[dbo].[Sites].MICEHV,[ISBEPI_DEV].[dbo].[Scheduling].Schd_ID, [ISBEPI_DEV].[dbo].[Scheduling].Status, [ISBEPI_DEV].[dbo].[Sites].SiteID, " + "[ISBEPI_DEV].[dbo].[Sites].Site_Address, [ISBEPI_DEV].[dbo].[Sites].City, [ISBEPI_DEV].[dbo].[Sites].State FROM [ISBEPI_DEV].[dbo].[Scheduling] JOIN [ISBEPI_DEV].[dbo].[UserNames] " + "ON [ISBEPI_DEV].[dbo].[UserNames].NameID=[ISBEPI_DEV].[dbo].[Scheduling].[NameID] JOIN [ISBEPI_DEV].[dbo].[Sites] " + "ON [ISBEPI_DEV].[dbo].[Sites].SiteID = [ISBEPI_DEV].[dbo].[Scheduling].SiteID " + "WHERE [ISBEPI_DEV].[dbo].[Scheduling].Schd_ID ='" + setinfo.getSchdID() + "';"; DataTable dt2 = DBHelper.GetDataTable(sqlquery); txtSiteName.Text = dt2.Rows[0]["Sites"].ToString().Replace("amp;", string.Empty); txtFName.Text = dt2.Rows[0]["Name"].ToString(); string status = dt2.Rows[0]["Status"].ToString(); string siteID = dt2.Rows[0]["SiteID"].ToString(); string address = dt2.Rows[0]["Site_Address"].ToString(); string city = dt2.Rows[0]["City"].ToString(); string state = dt2.Rows[0]["State"].ToString(); string phone = dt2.Rows[0]["PhoneNumber"].ToString(); txtPhoneNumber.Text = phone; string zip = dt2.Rows[0]["ZipCode"].ToString(); txtZipV2.Text = zip; bool miechv = Convert.ToBoolean(dt2.Rows[0]["MICEHV"].ToString()); chkbxMiechv.Checked = miechv; txtSiteAddress.Text = address; txtState.Text = state; txtCity.Text = city; if (dt2.Rows[0]["VisitDate"].ToString().Length > 1) { visitdate = DateTime.Parse(dt2.Rows[0]["VisitDate"].ToString()).ToShortDateString(); txtVisitingdate.Text = visitdate; } else { txtVisitingdate.Text = null; } toGetInfo getuserInfo = new toGetInfo(); getuserInfo.setVlaue(txtFName.Text, siteID, txtSiteName.Text, address, city, state, visitdate, status, phone, zip, miechv); if (status == "Confirmed" || txtVisitingdate.Text.Length < 1) { lnkbtnConfirm.Enabled = false; } else if (status == "Closed" || txtVisitingdate.Text.Length < 1) { lnkbtnConfirm.Enabled = false; } if (Roles.IsUserInRole(Page.User.Identity.Name, "Administrator")) { lnkbtnVisiting.Enabled = true; if (status == "Confirmed" && (DateTime.Parse(visitdate)) <= DateTime.Parse(DateTime.Now.ToShortDateString().ToString())) { lnkbtnConfirm.Enabled = false; lnkbtnVisiting.Enabled = true; } else if (status == "Closed") { lnkbtnConfirm.Enabled = false; lnkbtnVisiting.Enabled = false; } } else if (!Roles.IsUserInRole(Page.User.Identity.Name, "Administrator")) { lnkbtnVisiting.Enabled = false; if (status == "Confirmed" && (DateTime.Parse(visitdate) <= DateTime.Parse(DateTime.Now.ToShortDateString().ToString()))) { lnkbtnConfirm.Enabled = false; lnkbtnVisiting.Enabled = true; } else if (status == "Closed") { lnkbtnConfirm.Enabled = false; lnkbtnVisiting.Enabled = false; } } }