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