private void fillBtnPnl()
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
var SelectedPlant = Convert.ToInt32(Session["selectedPlant"]);
var SelectedCategory = Convert.ToInt32(Session["selectedCategory"]);
//create a list the holds the plants table
var b = (from equip in conn.Equipments
where equip.Category_ID == SelectedCategory & equip.Plant_ID == SelectedPlant
select equip).ToList();
for (int i = 0; i < b.Count; i++)
{
HyperLink equipmentButton = new HyperLink();
equipmentButton.Text = b[i].Name;
equipmentButton.Attributes.Add("data-role", "button");
equipmentButton.Attributes.Add("data-inline","true");
equipmentButton.NavigateUrl = "survey.aspx?selectedEquipment=" + b[i].Unit_Number;
pnlButtons.Controls.Add(equipmentButton);
}
//set the datasource to the created list and bind it to the dropdown
}
}
protected void btnSave_OnClick(object sender, EventArgs e)
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//instantiate a new deparment object in memory
Category c = new Category();
//decide if updating or adding, then save
if (Request.QueryString.Count > 0)
{
Int32 CategoryID = Convert.ToInt32(Request.QueryString["Category_ID"]);
c = (from category in conn.Categories
where category.Category_ID == CategoryID
select category).FirstOrDefault();
}
//fill the properties of our object from the form inputs
c.Category1 = txtCategory.Text;
if (Request.QueryString.Count == 0)
{
conn.Categories.Add(c);
}
conn.SaveChanges();
//redirect to updated departments page
Response.Redirect("categories.aspx");
}
}
protected void btnSave_OnClick(object sender, EventArgs e)
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//instantiate a new deparment object in memory
Heading c = new Heading();
//decide if updating or adding, then save
if (Request.QueryString.Count > 0)
{
Int32 HeadingID = Convert.ToInt32(Request.QueryString["Heading_ID"]);
c = (from head in conn.Headings
where head.Heading_ID == HeadingID
select head).FirstOrDefault();
}
//fill the properties of our object from the form inputs
c.Heading1 = txtHeading.Text;
// Create the list to store.
string selectedCategoryValues = null;
// Loop through each item.
foreach (ListItem item in chklstCategories.Items)
{
if (item.Selected)
{
// If the item is selected, add the value to the list.
selectedCategoryValues = selectedCategoryValues + item.Value;
}
else
{
// Item is not selected, do something else.
}
}
try
{
c.Categories_Under = selectedCategoryValues.ToString();
}
catch(NullReferenceException)
{
c.Categories_Under = "";
}
if (Request.QueryString.Count == 0)
{
conn.Headings.Add(c);
}
conn.SaveChanges();
//redirect to updated departments page
Response.Redirect("Headings.aspx");
}
}
public void loadImages(int hid,int eqid, DateTime dc)
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
var reqImageURLs = (from p in conn.Pictures
where p.equipment_ID == eqid && p.heading_ID == hid && p.DateSubmited == dc
select p).ToList();
DLTempImage.DataSource = reqImageURLs;
DLTempImage.DataBind();
}
}
protected void convertIDtoValue(int EquipmentID)
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
var equipName = (from q in conn.Equipments
where q.Unit_Number == EquipmentID
select q).FirstOrDefault();
txtEqID.Text = equipName.Name;
}
}
protected void fillDropDowns()
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//create a list the holds the plants table
var p = (from plnt in conn.Plants
select plnt).ToList();
//set the datasource to the created list and bind it to the dropdown
ddlPlant.DataSource = p;
ddlPlant.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//instantiate a new deparment object in memory
Question q = new Question();
//decide if updating or adding, then save
if (Request.QueryString.Count > 0)
{
Int32 QuestionID = Convert.ToInt32(Request.QueryString["Question_ID"]);
var c = (from head in conn.Questions
where head.Question_ID == QuestionID
select head).FirstOrDefault();
}
//fill the properties of our object from the form inputs
// Create the list to store.
string selectedHeadingValues = null;
// Loop through each item.
foreach (ListItem item in chklstHeadings.Items)
{
if (item.Selected)
{
// If the item is selected, add the value to the list.
selectedHeadingValues = selectedHeadingValues + item.Value;
}
else
{
}
}
q.Question1 = txtQuestion.Text;
q.Headings_Under = selectedHeadingValues.ToString();
q.Category_ID = 1;
if (Request.QueryString.Count == 0)
{
conn.Questions.Add(q);
}
conn.SaveChanges();
//redirect to updated departments page
Response.Redirect("questionList.aspx");
}
}
protected void getQuestion()
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
var questions = from q in conn.Questions
select q;
//bind the query result to the gridview
grdQuestions.DataSource = questions.ToList();
grdQuestions.DataBind();
}
}
protected void getReport(int EquipmentID, DateTime selectedDate)
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//use link to query the Departments model
var result = from r in conn.Results
where r.Equipment_ID == EquipmentID & r.Date_Completed == selectedDate
select r;
//bind the query result to the gridview
grdResults.DataSource = result.ToList();
grdResults.DataBind();
}
}
protected void GetCategories()
{
//connect using our connection string from web.config and EF context class
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//use link to query the Departments model
var cat = from c in conn.Categories
select c;
//bind the query result to the gridview
grdCategories.DataSource = cat.ToList();
grdCategories.DataBind();
}
}
protected void GetHeading()
{
//connect using our connection string from web.config and EF context class
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//use link to query the Departments model
var head = from c in conn.Headings
select c;
//bind the query result to the gridview
grdHeadings.DataSource = head.ToList();
grdHeadings.DataBind();
}
}
public void loadImages(int hid, int eqid, DateTime dc, int qid)
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
var reqImageURLs = (from p in conn.Pictures
where p.equipment_ID == eqid && p.heading_ID == hid && p.DateSubmited == dc && p.question_ID == qid
select p).ToList();
var count = reqImageURLs.Count();
var url = "/admin/surveyImages/surveyPics/qid~"+ qid + "heading-"+ hid + "eqid&" + eqid + "dc_"+ dc.ToString("MM.dd.yyyy.hh.mm.ss") + "image1" +".jpg";
DLTempImage.DataSource = reqImageURLs;
DLTempImage.DataBind();
}
}
protected void GetPlants()
{
//connect using our connection string from web.config and EF context class
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//use link to query the Departments model
var plnts = from d in conn.Plants
select d;
//bind the query result to the gridview
grdPlants.DataSource = plnts.ToList();
grdPlants.DataBind();
}
}
protected void GetPlant()
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//get id from url parameter and store in a variable
Int32 categoryID = Convert.ToInt32(Request.QueryString["Category_ID"]);
var c = (from category in conn.Categories
where category.Category_ID == categoryID
select category).FirstOrDefault();
//populate the form from our department object
txtCategory.Text = c.Category1;
}
}
protected void fillDropDown()
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
var c = (from cat in conn.Categories
select cat).ToList();
for (int t =0; t < c.Count; t++)
{
ListItem a = new ListItem();
a.Text= c[t].Category1;
a.Value = c[t].Category_ID + (",");
chklstCategories.Items.Add(a);
}
}
}
protected void convertIDtoValue()
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
var plantID = Convert.ToInt32(txtPlant.Text);
var catID = Convert.ToInt32(txtCategory.Text);
var plantName = (from p in conn.Plants
where p.Plant_ID == plantID
select p).FirstOrDefault();
txtPlant.Text = plantName.Plant_Name;
var catName = (from c in conn.Categories
where c.Category_ID == catID
select c).FirstOrDefault();
txtCategory.Text = catName.Category1;
}
}
protected void grdQuestions_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//get the selected DepartmentID
Int32 QuestionID = Convert.ToInt32(grdQuestions.DataKeys[e.RowIndex].Values["Question_ID"]);
var c = (from head in conn.Questions
where head.Question_ID == QuestionID
select head).FirstOrDefault();
//process the delete
conn.Questions.Remove(c);
conn.SaveChanges();
//update the grid
getQuestion();
}
}
protected void grdPlants_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//get the selected DepartmentID
Int32 PlantID = Convert.ToInt32(grdPlants.DataKeys[e.RowIndex].Values["Plant_ID"]);
var d = (from dep in conn.Plants
where dep.Plant_ID == PlantID
select dep).FirstOrDefault();
//process the delete
conn.Plants.Remove(d);
conn.SaveChanges();
//update the grid
GetPlants();
}
}
protected void GetPlant()
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//get id from url parameter and store in a variable
Int32 plantID = Convert.ToInt32(Request.QueryString["Plant_ID"]);
var p = (from plnt in conn.Plants
where plnt.Plant_ID == plantID
select plnt).FirstOrDefault();
//populate the form from our department object
txtPlantName.Text = p.Plant_Name;
txtAddress.Text = p.Address;
txtCity.Text = p.City;
txtPhoneNum.Text = p.Phone_Num;
txtPostalCode.Text = p.Postal_Code;
}
}
protected void grdHeadings_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//get the selected DepartmentID
Int32 HeadingID = Convert.ToInt32(grdHeadings.DataKeys[e.RowIndex].Values["Heading_ID"]);
var c = (from head in conn.Categories
where head.Category_ID == HeadingID
select head).FirstOrDefault();
//process the delete
conn.Categories.Remove(c);
conn.SaveChanges();
//update the grid
GetHeading();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//instantiate a new deparment object in memory
Equipment a = new Equipment();
//decide if updating or adding, then save
if (Request.QueryString.Count > 0)
{
Int32 EquipmentID = Convert.ToInt32(Request.QueryString["Equipment_ID"]);
a = (from equip in conn.Equipments
where equip.Equipment_ID == EquipmentID
select equip).FirstOrDefault();
}
//fill the properties of our object from the form inputs
a.Name = txtName.Text;
a.Unit_Number = Convert.ToInt32(txtUnitNumber.Text);
a.Belt_Type = txtBeltType.Text;
a.Num_Of_Belts = Convert.ToInt32(txtNumOfBelts.Text);
a.Description1 = txtDescription1.Text;
a.Category_ID = Convert.ToInt32(ddlCategory.SelectedValue);
a.Plant_ID = Convert.ToInt32(ddlPlant.SelectedValue);
if (Request.QueryString.Count == 0)
{
conn.Equipments.Add(a);
}
conn.SaveChanges();
//redirect to updated departments page
Response.Redirect("equipmentList.aspx");
}
}
protected void getEquipmentList()
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//get id from url parameter and store in a variable
Int32 EquipmentID = Convert.ToInt32(Request.QueryString["Equipment_ID"]);
var e = (from equip in conn.Equipments
where equip.Equipment_ID == EquipmentID
select equip).FirstOrDefault();
//populate the form from our department object
txtName.Text = e.Name;
txtBeltType.Text = e.Belt_Type;
txtNumOfBelts.Text = e.Num_Of_Belts.ToString();
txtUnitNumber.Text = e.Unit_Number.ToString();
txtDescription1.Text = e.Description1;
ddlPlant.SelectedIndex = ((e.Plant_ID) - 1);
ddlCategory.SelectedIndex = ((e.Category_ID)-1);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//instantiate a new deparment object in memory
Plant d = new Plant();
//decide if updating or adding, then save
if (Request.QueryString.Count > 0)
{
Int32 plantID = Convert.ToInt32(Request.QueryString["plant_ID"]);
d = (from dep in conn.Plants
where dep.Plant_ID == plantID
select dep).FirstOrDefault();
}
//fill the properties of our object from the form inputs
d.Plant_Name = txtPlantName.Text;
d.Address = txtAddress.Text;
d.City = txtCity.Text;
d.Phone_Num = txtPhoneNum.Text;
d.Postal_Code = txtPostalCode.Text;
if (Request.QueryString.Count == 0)
{
conn.Plants.Add(d);
}
conn.SaveChanges();
//redirect to updated departments page
Response.Redirect("plants.aspx");
}
}
private void fillBtnPnl()
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
var SelectedPlant = Convert.ToInt32(Session["selectedPlant"]);
//create a list the holds the plants table
var b = (from equip in conn.Equipments
where equip.Plant_ID == SelectedPlant
select equip).ToList();
for (int i = 0; i < b.Count; i++)
{
HyperLink equipmentButton = new HyperLink();
equipmentButton.Text = b[i].Name;
equipmentButton.ID = b[i].Unit_Number.ToString();
equipmentButton.Attributes.Add("data-role", "button");
equipmentButton.Attributes.Add("data-inline", "true");
equipmentButton.Attributes.Add("rel", "external");
equipmentButton.NavigateUrl = "report.aspx?selectedEquipment=" + b[i].Unit_Number;
pnlButtons.Controls.Add(equipmentButton);
}
var r = (from result in conn.Results
select result).ToList();
var reid = (from result in conn.Results
select result.Equipment_ID).ToList();
foreach (HyperLink hl in pnlButtons.Controls)
{
if(!reid.Contains (Convert.ToInt32(hl.ID)))
{
HyperLink buttonToHide = pnlButtons.FindControl(hl.ID) as HyperLink;
buttonToHide.Visible = false;
}
}
}
}
protected void btnUpload_Click1(object sender, EventArgs e)
{
var date = DateTime.Now.AddMinutes(-240).ToString();
Session["surveySubmitTime"] = date;
if (fuMain.HasFile)
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
IList<HttpPostedFile> collection = fuMain.PostedFiles;
foreach (HttpPostedFile ia in collection)
{
Picture p = new Picture();
string imgName = ia.FileName.ToString();
int imageLength = ia.ContentLength;
string imageType = ia.ContentType;
var binaryImagedata = new byte[imageLength];
ia.InputStream.Read(binaryImagedata, 0, imageLength);
var date1 = Convert.ToDateTime(Session["surveySubmitTime"]);
var date1String = date1.ToString("MM.dd.yyyy.HH.mm.ss");
string imgPath = ("surveyImages/mainPics/" +
"eqid&" + Convert.ToInt32(Request.QueryString["selectedEquipment"].ToString()) + "dc_" + date1String + "image" + ".jpg");
ia.SaveAs(Server.MapPath(("/admin/surveyImages/mainPics/" +
"eqid&" + Convert.ToInt32(Request.QueryString["selectedEquipment"].ToString()) + "dc_" + date1String + "image" + ".jpg")));
p.URL= imgPath;
p.DateSubmited = date1;
p.equipment_ID = Convert.ToInt32(Request.QueryString["selectedEquipment"].ToString());
p.name = imgName;
imgMain.ImageUrl = imgPath;
conn.Pictures.Add(p);
}
imgMain.Visible = true;
btnUpload.Visible = false;
fuMain.Visible = false;
tblSurvey.Visible = true;
input2.Visible = true;
hidenPic.Visible = true;
conn.SaveChanges();
}
}
}
protected void grdResults_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
GridViewRow dr = e.Row as GridViewRow;
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
Int32 qID = Convert.ToInt32(dr.Cells[0].Text);
var tempQuestion = (from q in conn.Questions
where q.Question_ID == qID
select q).FirstOrDefault();
dr.Cells[0].Text = tempQuestion.Question1;
var hID = Convert.ToInt32(dr.Cells[4].Text);
var tempDate = currentlySelectedDate;
var tempHeading = (from h in conn.Headings
where h.Heading_ID == hID
select h).FirstOrDefault();
//Button tempButton = new Button();
//tempButton.ID = "btnQid=" + qID + "Hid:" + hID;
//tempButton.Text = tempHeading.Heading1;
//tempButton.Attributes.Add("data-hid", hID.ToString());
//tempButton.Attributes.Add("data-date", ddlDates.SelectedValue.ToString());
//tempButton.Attributes.Add("data-eqid", txtEqID.Text.ToString());
//tempButton.Attributes.Add("onclick", "document.getElementById('" + Button2.ClientID + "').click(); return false;");
//tempButton.Click += new EventHandler(header_click);
Button tempButton2 = new Button();
tempButton2.ID = "btnQid=" + qID + "Hid:" + hID;
tempButton2.Text = "View Heading Images";
HyperLink hyperlink1 = new HyperLink();
hyperlink1.Attributes.Add("data-role", "button");
hyperlink1.Attributes.Add("data-inline", "true");
hyperlink1.Attributes.Add("rel", "external");
hyperlink1.ID = "hlQid=" + qID + "Hid=" + hID + "2";
hyperlink1.Text = "View Images";
hyperlink1.NavigateUrl = "~/lafargeUser/tempImages.aspx?qid=" + qID + "&Hid=" + hID + "&dc=" + tempDate + "&eqid=" + Convert.ToInt32(Request.QueryString["selectedEquipment"]);
HyperLink hyperlink2 = new HyperLink();
hyperlink2.Attributes.Add("data-role", "button");
hyperlink2.Attributes.Add("data-inline", "true");
hyperlink2.Attributes.Add("rel", "external");
hyperlink2.ID = "hlQid=" + qID + "Hid=" + hID;
hyperlink2.Text = "View Heading Images";
hyperlink2.NavigateUrl = "~/lafargeUser/tempImages.aspx?Hid=" + hID + "&dc=" + tempDate + "&eqid=" + Convert.ToInt32(Request.QueryString["selectedEquipment"]);
//tempButton2.Attributes.Add("onclick", "document.getElementById('" + Button2.ClientID + "').click(); return false;");
dr.Cells[7].Controls.Add(hyperlink2);
dr.Cells[8].Controls.Add(hyperlink1);
var response = dr.Cells[1].Text;
if (response == "True")
{
dr.Cells[1].Text = "yes";
}
else if (response == "False")
{
dr.Cells[1].Text = "no";
}
}
}
}
public void getHeadingsQuestions(int selectedID)
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
var qList = (from questions in conn.Questions
where questions.Headings_Under.Contains(selectedID.ToString())
select questions.Question1).ToList();
for (int i = 0; i < qList.Count; i++)
{
TableRow r = new TableRow();
var question = qList[i];
//ADD THE QUESTION
TableCell cellQuestion = new TableCell();
cellQuestion.Text = question;
cellQuestion.BackColor = Color.Lime;
cellQuestion.ForeColor = Color.Black;
var allIDs = (from questions in conn.Questions
where questions.Headings_Under.Contains(selectedID.ToString())
select questions.Question_ID).ToList();
cellQuestion.ID = allIDs[i].ToString() + ("_Question_H=") + selectedID;
TableCell cellResponse = new TableCell();
cellResponse.ID = allIDs[i].ToString() + ("_response_H=") + selectedID;
RadioButtonList resp = new RadioButtonList();
resp.Attributes.Add("ID", allIDs[i].ToString() + "_response_H=" + selectedID + "rbl");
for (int w = 0; w < 2; w++)
{
ListItem answer = new ListItem();
if (w == 0)
{
answer.Text = ("Yes");
answer.Value = ("true");
}
else if (w == 1)
{
answer.Text = ("No");
answer.Value = ("false");
}
resp.Items.Add(answer);
}
cellResponse.Controls.Add(resp);
TableCell cellDeficency = new TableCell();
TextBox txtDeficency = new TextBox();
txtDeficency.Width = 195;
txtDeficency.ID = allIDs[i] + ("_Deficency_H=") + selectedID;
txtDeficency.TextMode = TextBoxMode.MultiLine;
cellDeficency.Controls.Add(txtDeficency);
TableCell cellAP = new TableCell();
TextBox txtAP = new TextBox();
txtAP.Width = 195;
txtAP.ID = allIDs[i] + ("_ActionPlan_H=") + selectedID;
txtAP.TextMode = TextBoxMode.MultiLine;
cellAP.Controls.Add(txtAP);
TableCell cellUpload = new TableCell();
FileUpload fu = new FileUpload();
fu.AllowMultiple = true;
fu.Attributes.Add("capture", "camera");
fu.Attributes.Add("type", "file");
fu.Attributes.Add("capture", "camera");
cellUpload.Controls.Add(fu);
r.Controls.Add(cellQuestion);
r.Controls.Add(cellResponse);
r.Controls.Add(cellDeficency);
r.Controls.Add(cellAP);
r.Controls.Add(cellUpload);
tblSurvey.Controls.Add(r);
}
}
}
protected void buildTable()
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
var SelectedCategory = Session["selectedCategory"].ToString();
var neededHeadings = (from headings in conn.Headings
where headings.Categories_Under.Contains(SelectedCategory)
select headings.Heading1).ToList();
for (int i = 0; i < neededHeadings.Count; i++)
{
TableHeaderRow r = new TableHeaderRow();
var heading = neededHeadings[i];
TableHeaderCell c = new TableHeaderCell();
TableHeaderCell a1 = new TableHeaderCell();
TableHeaderCell cellUpload = new TableHeaderCell();
cellUpload.Width = 280;
FileUpload fu = new FileUpload();
fu.AllowMultiple = true;
fu.Attributes.Add("capture", "camera");
fu.Attributes.Add("type", "file");
fu.Attributes.Add("capture", "camera");
cellUpload.Controls.Add(fu);
cellUpload.ID = "upload" + i;
c.Text = heading;
c.ID = "heading" + i;
var allIDs = (from headings in conn.Headings
where headings.Categories_Under.Contains(SelectedCategory)
select headings.Heading_ID).ToList();
var selectedID = allIDs[i];
// c.ID = selectedID;
r.Controls.Add(c);
r.Controls.Add(a1);
r.Controls.Add(cellUpload);
tblSurvey.Controls.Add(r);
getHeadingsQuestions(selectedID);
if (i + 1 == neededHeadings.Count)
{
TableHeaderRow btnRow = new TableHeaderRow();
TableHeaderCell btnCell = new TableHeaderCell();
Button btnSubmit = new Button();
btnSubmit.Click += new EventHandler(btnSubmit_Click);
btnSubmit.Text = "submit";
btnCell.Controls.Add(btnSubmit);
btnRow.Controls.Add(btnCell);
tblSurvey.Controls.Add(btnRow);
}
}
}
}
protected void selectDate(int EquipmentID, int index)
{
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
var possibleDates = (from r in conn.Results
where r.Equipment_ID == EquipmentID
select r.Date_Completed).Distinct().ToList();
currentlySelectedDate = possibleDates[index];
getReport(EquipmentID, possibleDates[index]);
ddlDates.SelectedIndex = index;
}
}
protected void getQuestion()
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//get id from url parameter and store in a variable
Int32 QuestionID = Convert.ToInt32(Request.QueryString["Question_ID"]);
var c = (from head in conn.Questions
where head.Question_ID == QuestionID
select head).FirstOrDefault();
//populate the form from our department object
txtQuestion.Text = c.Question1;
var headingsUnder = c.Headings_Under.ToString();
var allHeadings = (from cat in conn.Headings
select cat.Heading_ID).ToList();
var headLength = allHeadings.Count();
int lastID = allHeadings[headLength - 1];
for (int i = 0; i < lastID; i++)
{
foreach(ListItem h in chklstHeadings.Items)
{
if (headingsUnder.Contains((i + 1).ToString()))
{
if( h.Value==((i+1)+","))
{
h.Selected=true;
}
}
}
}
}
}