Пример #1
0
        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();
            }
        }
Пример #2
0
        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;
        }
Пример #3
0
        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;
        }