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