protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { hfschd.Value = getdt.getSchdID(); getdt.setSchdID(null); hfID.Value = getdt.getID(); getdt.setID(null); if (string.IsNullOrEmpty(hfschd.Value)) { //ClientScript.RegisterStartupScript(typeof(Page), "closePage", "<script type='text/JavaScript'>window.close();</script>"); Response.Redirect("~/UnauthorizedAccess.aspx"); } else { BindQuestionQestions(); DataTable dt = new DataTable(); dt = getdt.getQuestions(); if (dt.Rows.Count > 0) { getData(dt); toGetInfo tocheck = new toGetInfo(); tocheck.setStarted(true); getdt.getQuestions().Clear(); } } } }
protected void lnkbtnNewSurvey_Command(object sender, CommandEventArgs e) { toGetInfo getinfo = new toGetInfo(); string schdid = e.CommandArgument.ToString(); string name = Page.User.Identity.Name; string userID = Membership.GetUser(name).ProviderUserKey.ToString(); string sqlquerysiteID = " Select PD.Staff_ID, PD.SiteID From [ISBEPI_DEV].[dbo].[ProgramDirector] PD RIGHT JOIN " + "[ISBEPI_DEV].[dbo].Staff ST " + "ON PD.Staff_ID = ST.Staff_ID WHERE ST.UserId ='" + userID + "' ;"; DataTable dt = DBHelper.GetDataTable(sqlquerysiteID); string sqlQueryGetSurveyStatus = "SELECT PD.Staff_ID, PD.Completed, PD.Schd_ID FROM " + "[ISBEPI_DEV].[dbo].[Program_Director_Survey] PD WHERE PD.Schd_ID ='" + schdid + "'" + "AND PD.Staff_ID ='" + dt.Rows[0]["Staff_ID"].ToString() + "'"; DataTable dtgetStatus = DBHelper.GetDataTable(sqlQueryGetSurveyStatus); if (dtgetStatus.Rows.Count < 1) { //row = pd.Program_Director_Survey.NewRow(); //row["Staff_ID"] = dt.Rows[0]["Staff_ID"].ToString(); //row["Schd_ID"] = schdid; //row["StartedDate"] = DateTime.Now.ToShortDateString(); //row["Completed"] = "Started"; string sqlUpdate_NewRow = "INSERT INTO [ISBEPI_DEV].[dbo].[Program_Director_Survey] (Staff_ID, Schd_ID, StartedDate, Completed)" + " VALUES ('" + dt.Rows[0]["Staff_ID"].ToString() + "', '" + schdid + "', GETDATE(), 'Started');"; int count = DBHelper.ExecuteSQL(sqlUpdate_NewRow); //pd.Program_Director_Survey.Rows.Add(row); //HVSurveyTableAdapters.Program_Director_SurveyTableAdapter PDSA = new HVSurveyTableAdapters.Program_Director_SurveyTableAdapter(); //PDSA.Update(row); if (count > 0) { toGetInfo setinfo = new toGetInfo(); setinfo.setSiteID(dt.Rows[0]["SiteID"].ToString()); Session["staffid"] = dt.Rows[0]["Staff_ID"].ToString(); setinfo.setSchdID(schdid); setinfo.setStarted(false); Response.Redirect("~/ProgramDirector/DirectorSurvey.aspx"); } else { Response.Redirect("~/UnauthorizedAccess.aspx"); } } else { toGetInfo setinfo = new toGetInfo(); setinfo.setSiteID(dt.Rows[0]["SiteID"].ToString()); Session["staffid"] = dt.Rows[0]["Staff_ID"].ToString(); setinfo.setSchdID(schdid); setinfo.setStarted(true); Response.Redirect("~/ProgramDirector/DirectorSurvey.aspx"); } }