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 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;
}
