private void BindGrid() { using (QuestionaireEntities context = new QuestionaireEntities()) { int FormID = int.Parse(Request.QueryString["frmID"]); QuestionsForms qfrm = context.QuestionsForms.First(frm => frm.ID == FormID); txtformName.Text = qfrm.FormName; txtClarification.Text = qfrm.Clarification; grdQuestion.DataSource = context.Questions.Where(qs => qs.FormID == FormID && (qs.IsDeleted != true || qs.IsDeleted == null)).ToList(); grdQuestion.DataBind(); } }
protected void RegisterUser_CreatedUser(object sender, EventArgs e) { using (QuestionaireEntities context = new QuestionaireEntities()) { int FormID = int.Parse(Request.QueryString["frmID"]); DateTimeFormatInfo DTFormat = new DateTimeFormatInfo(); QuestionsForms qfrm = context.QuestionsForms.First(frm => frm.ID == FormID); qfrm.FormName = txtformName.Text; qfrm.Clarification = txtClarification.Text; context.SaveChanges(); Response.Redirect("Qformslist"); } }
private void BindGrid() { using (QuestionaireEntities context = new QuestionaireEntities()) { int FormID = int.Parse(Request.QueryString["frmID"]); int Year = int.Parse(Request.QueryString["year"]); Guid GUID = new Guid(Membership.GetUser(User.Identity.Name).ProviderUserKey.ToString()); AnswersForm answfrm = context.AnswersForm.FirstOrDefault(frm => frm.QuestionFormID == FormID && frm.Year == Year && frm.UserID == GUID); if (answfrm == null) { QuestionsForms qfrm = context.QuestionsForms.First(frm => frm.ID == FormID); txtformName.Text = qfrm.FormName; grdQuestion.DataSource = context.Questions.Where(qs => qs.FormID == FormID && (qs.IsDeleted != true || qs.IsDeleted == null)).ToList(); grdQuestion.DataBind(); grdAnswers.Visible = false; grdQuestion.Visible = true; } else { txtAuditor.Text = answfrm.AuditorName; txtAuditorOn.Text = answfrm.AuditorOnName; txtDate.Text = answfrm.HijriDate; txtOpsCode.Text = answfrm.OpsCode; txtOpsName.Text = answfrm.OpsName; txtReviewer.Text = answfrm.ReviewerName; txtReviewerOn.Text = answfrm.ReviewerOnName; txtAuditSign.Text = answfrm.Sign1; txtAuditonSign.Text = answfrm.Sign2; foreach (Questions row in context.Questions.Where(que => que.FormID == FormID).ToList()) { if (!context.Answers.Any(ans => ans.AnswerFormID == answfrm.ID && ans.QuestionID == row.ID)) { Answers ans = new Answers(); ans.AnswerFormID = answfrm.ID; ans.QuestionID = row.ID; context.Answers.Add(ans); context.SaveChanges(); } } grdAnswers.DataSource = context.Answers.Where(ans => ans.AnswerFormID == answfrm.ID).Select(ans => new { Id = ans.ID, QuestionText = ans.Questions.QuestionText, Answer = ans.AnswerBody }).ToList(); grdAnswers.DataBind(); grdAnswers.Visible = true; grdQuestion.Visible = false; } } }
protected void RegisterUser_CreatedUser(object sender, EventArgs e) { using (QuestionaireEntities context = new QuestionaireEntities()) { DateTimeFormatInfo DTFormat = new DateTimeFormatInfo(); DTFormat = new System.Globalization.CultureInfo("ar-sa", false).DateTimeFormat; DTFormat.FullDateTimePattern = "dd/MM/yyyy"; QuestionsForms dept = new QuestionsForms(); dept.CreatedDate = DateTime.Now; string x = DateTime.Now.ToString("dd/MM/yyyy", DTFormat); dept.FormName = txtformName.Text; dept.Clarification = txtClarification.Text; dept.idDeleted = false; context.QuestionsForms.Add(dept); context.SaveChanges(); Response.Redirect("QformUpdate?frmID=" + dept.ID); } }