private void cbSections_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Model.Sections sec = (Model.Sections)((ComboBox)sender).SelectedItem;
expQuestion.Header = string.Empty;
expQuestion.Content = null;
expQuestion.IsEnabled = false;
cbQuestions.SelectedItem = null;
cbQuestions.ItemsSource = model.Questions.Where(p => p.SectionId == sec.SectionId && p.IsDeleted == false).ToList();
}
private void cbSections_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Model.Sections sec = (Model.Sections)((ComboBox)sender).SelectedItem;
cbQuestions.ItemsSource = model.Questions.Where(p => p.SectionId == sec.SectionId && p.IsDeleted == false).ToList();
if (cbQuestions.Items.Count > 0)
{
cbQuestions.SelectedItem = cbQuestions.Items.GetItemAt(0);
}
}
public List <FAMA.AP.Model.Sections> SelectAll()
{
SqlConnection con = null;
DataSet ds = null;
List <FAMA.AP.Model.Sections> sectionList = null;
try
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConn"].ToString());
SqlCommand cmd = new SqlCommand("PR_AP_SEL_SECTIONS", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
ds = new DataSet();
da.Fill(ds);
sectionList = new List <FAMA.AP.Model.Sections>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
FAMA.AP.Model.Sections sobj = new Model.Sections();
sobj.idActiveSections = int.Parse(ds.Tables[0].Rows[i]["idActiveSections"].ToString());
sobj.active = Convert.ToBoolean(ds.Tables[0].Rows[i]["bActive"].ToString());
sectionList.Add(sobj);
}
System.Console.WriteLine(sectionList);
return(sectionList);
}
catch (Exception ex)
{
System.Console.WriteLine(ex);
return(sectionList);
}
finally
{
con.Close();
con.Dispose();
}
}
public FAMA.AP.Model.Sections SelectSectionById(int idSection)
{
SqlConnection con = null;
DataSet ds = null;
FAMA.AP.Model.Sections sobj = new Model.Sections();
try
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConn"].ToString());
SqlCommand cmd = new SqlCommand("PR_AP_SEL_SECTIONS_BY_ID", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.Parameters.AddWithValue("@idSection", idSection);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
ds = new DataSet();
da.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
sobj.idActiveSections = int.Parse(ds.Tables[0].Rows[i]["idActiveSections"].ToString());
sobj.idProcessType = int.Parse(ds.Tables[0].Rows[i]["idProcessType"].ToString());
sobj.idProcess = int.Parse(ds.Tables[0].Rows[i]["idProcess"].ToString());
sobj.name = ds.Tables[0].Rows[i]["Section"].ToString();
sobj.active = Convert.ToBoolean(ds.Tables[0].Rows[i]["bActive"].ToString());
}
return(sobj);
}
catch (Exception ex)
{
System.Console.WriteLine(ex);
return(sobj);
}
finally
{
con.Close();
con.Dispose();
}
}