public void LayoutTable(string id, string tableid)
{
m_TableID = tableid;
m_TempleteID = id;
Test_Table_Templete tabletemplete = SystemManager.Instance.Services.Test_Table_TempleteService.GetModel(int.Parse(id));
List <Test_Field_Templete> Fieldtempletelist = SystemManager.Instance.Services.Test_Field_TempleteService.GetModelList("F_PID=" + id);
Test_Table testTable = SystemManager.Instance.Services.Test_TableService.GetModel(int.Parse(tableid));
List <Library.Model.Test_Field> testFields = SystemManager.Instance.Services.Test_FieldService.GetModelList("F_PID=" + tableid);
if (!string.IsNullOrEmpty(tabletemplete.F_Banner))
{
Banner_1_Edit bannerEdit = new Banner_1_Edit();
bannerEdit.LoadTemplete(tabletemplete);
bannerEdit.LoadData(testTable);
XGrid.Children.Add(bannerEdit);
m_BannerEdit = bannerEdit;
}
m_Control = new GridAutoControl();
m_Control.LayoutEditGrid(tabletemplete, Fieldtempletelist);
m_Control.LoadData(testFields);
XGrid.Children.Add(m_Control);
}
public void LoadData(int templeteid, int id)
{
Test_Table_Templete tabletemplete = SystemManager.Instance.Services.Test_Table_TempleteService.GetModel(templeteid);
List <Test_Field_Templete> Fieldtempletelist = SystemManager.Instance.Services.Test_Field_TempleteService.GetModelList("F_PID=" + templeteid);
Test_Table testTable = SystemManager.Instance.Services.Test_TableService.GetModel(id);
List <Library.Model.Test_Field> testFields = SystemManager.Instance.Services.Test_FieldService.GetModelList("F_PID=" + id);
TextBlock txtBander = new TextBlock();
string[] values = testTable.F_BannerContent.Split('$');
txtBander.FontSize = double.Parse(tabletemplete.F_ShowFontSize.ToString());
txtBander.Foreground = new SolidColorBrush(tabletemplete.ShowFontColor);
txtBander.Margin = new Thickness(0, 10, 0, 10);
foreach (string value in values)
{
if (string.IsNullOrEmpty(value))
{
txtBander.Text += "--- ";
}
else
{
txtBander.Text += value + " ";
}
}
XGrid.Children.Add(txtBander);
GridAutoControl m_Control = new GridAutoControl();
m_Control.LayoutShowGrid(tabletemplete, Fieldtempletelist, testFields);
XGrid.Children.Add(m_Control);
}
internal void LoadData(Test_Table testTable)
{
string[] Inputs = testTable.F_BannerContent.Split('$');
for (int i = 0; i < index; i++)
{
object o = GetObjectByName("txt" + i);
if (o != null)
{
TextBox txt = o as TextBox;
if (txt != null)
{
txt.Text = Inputs[i];
}
}
}
}
private void BtnSetIsShow_Click(object sender, RoutedEventArgs e)
{
DataRow row = this.GridView.GetFocusedDataRow();
if (row != null)
{
int id = int.Parse(row["F_ID"].ToString());
Test_Table tb = Library.Controller.SystemManager.Instance.Services.Test_TableService.GetModel(id);
tb.F_IsShow = 1;
Library.Controller.SystemManager.Instance.Services.Test_TableService.Update(tb);
BandGridData();
}
else
{
MessageBox.Show("请选择一行数据！");
}
}
public static Common.Business.Test_Table Fetch(Test_Table data)
{
Common.Business.Test_Table item = (Common.Business.Test_Table)Activator.CreateInstance(typeof(Common.Business.Test_Table));
//using (ObjectFactory.BypassPropertyChecks(item))
{
item.Year = data.Year;
item.ProjCode = data.ProjCode;
item.TaskCode = data.TaskCode;
item.FundCode = data.FundCode;
item.ProjName = data.ProjName;
item.TaskName = data.TaskName;
item.FundName = data.FundName;
item.Test = data.Test;
}
ObjectFactory.MarkAsChild(item);
ObjectFactory.MarkOld(item);
return(item);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
string sTitile = m_BannerEdit.GetValue();
List <Test_Field> l = m_Control.GetFields();
Test_Table table = new Test_Table();
table.F_TempleteID = int.Parse(m_TempleteID);
table.F_Time = DateTime.Now;
table.F_BannerContent = sTitile;
table.F_IsShow = 1;
SystemManager.Instance.Services.Test_TableService.UpdateClearShow(table.F_TempleteID.Value);
int tableid = SystemManager.Instance.Services.Test_TableService.Add(table);
foreach (Test_Field f in l)
{
f.F_PID = tableid;
SystemManager.Instance.Services.Test_FieldService.Add(f);
}
MessageBox.Show("添加成功！");
}
public ActionResult TakeTest(Test_Table test, string searchtest, string submittechnology, string technology, string submitdomain, QuestionBank qu, string domain, string checkscore, string _1, string _2, string _3, string _4, string _5, string _6, string _7, string _8, string _9, string _10)
{
/*provides dropdown to select domain*/
/*Lists the technologies after selecting the respective domain*/
if (domain != null && submittechnology == null)
{
DbAccessEntity tec = new DbAccessEntity();
//fetch technology id
var techlist = (from p in tec.Technology_Table
join q in tec.Domain_Table
on p.did equals q.did
where q.domain == domain
select new
{
Technology = p.technology,
}).ToList();
Session["Domain"] = domain;
var domainlist = (from p in tec.Domain_Table
where p.domain != domain
select new
{
domain = p.domain //gets the domain list
}).ToList();
List <QuestionBank> li = new List <QuestionBank>();
foreach (var p in techlist)
{
QuestionBank q = new QuestionBank();
q.techlist = p.Technology;
li.Add(q);
}
qu.domainlist = domain;
li.Add(qu);
foreach (var p in domainlist)
{
QuestionBank q = new QuestionBank();
q.domainlist = p.domain;
li.Add(q);
}
return(View(li)); //returns the list of domain and technology
}
/*submitting the technology and domain and starting the test*/
else if (submittechnology != null)
{
DbAccessEntity db = new DbAccessEntity();
//fetch technologyID
var techidquery = (from p in db.Technology_Table
where p.technology == technology
select new
{
Technology = p.tid
});
foreach (var p in techidquery)
{
qu.idtech = p.Technology;
}
Session["TechnologyID"] = qu.idtech;
//fetch the questions and options based on TechnologyID
var query = (from p in db.Question_Bank_Table
where p.TechnologyId == qu.idtech
select new
{
Question = p.Question,
QuestionID = p.QuestionID,
Options = p.Options,
CorrectAnswer = p.CorrectAnswer
});
List <QuestionBank> li = new List <QuestionBank>();
int no = 1;
foreach (var p in query)
{
QuestionBank qi = new QuestionBank();
qi.QuestionID = p.QuestionID;
qi.Question = p.Question;
qi.qno = no;
qi.CorrectAnswer = p.CorrectAnswer;
string[] tempsplit = p.Options.Split(',');
qi.Options = tempsplit;
li.Add(qi);
no++;
}
Session["listOfObjects"] = li;
return(View("TestPage", li));
}
/*Checking the score after end of test*/
else if (checkscore != null)
{
qu.idtech = Int32.Parse(Session["TechnologyID"].ToString());
DbAccessEntity db = new DbAccessEntity();
//Fetch Domain ID
var iddomain = (from p in db.Technology_Table
where p.tid == qu.idtech
select new
{
DomainID = p.did
});
foreach (var p in iddomain)
{
qu.count = p.DomainID;
}
//Based on the technology ID retrieve the correct answers
var query = (from p in db.Question_Bank_Table
where p.TechnologyId == qu.idtech
select new
{
Question = p.Question,
QuestionID = p.QuestionID,
Options = p.Options,
Answer = p.CorrectAnswer
});
List <string> correctanswer = new List <string>();
//Append the selected options and enter into test_table
string selectedoptions = "";
foreach (var p in query)
{
qu.qid = qu.qid + p.QuestionID + ",";
correctanswer.Add(p.Answer);
}
selectedoptions = _1 + "," + _2 + "," + _3 + "," + _4 + "," + _5 + "," + _6 + "," + _7 + "," + _8 + "," + _9 + "," + _10;
Session["selectedoptions"] = selectedoptions;
/*evaluate the score by checking each of radio button with the correct answer*/
if (_1 == correctanswer[0])
{
qu.score += 1;
}
if (_2 == correctanswer[1])
{
qu.score += 1;
}
if (_3 == correctanswer[2])
{
qu.score += 1;
}
if (_4 == correctanswer[3])
{
qu.score += 1;
}
if (_5 == correctanswer[4])
{
qu.score += 1;
}
if (_6 == correctanswer[5])
{
qu.score += 1;
}
if (_7 == correctanswer[6])
{
qu.score += 1;
}
if (_8 == correctanswer[7])
{
qu.score += 1;
}
if (_9 == correctanswer[8])
{
qu.score += 1;
}
if (_10 == correctanswer[9])
{
qu.score += 1;
}
string userid = Session["userid"].ToString();
test.UserId = userid;
test.TechnologyID = (qu.idtech);
test.DomainID = (qu.count);
test.SelectedOptions = selectedoptions;
test.Score = qu.score;
db.Test_Table.Add(test);
db.SaveChanges();
//saving the results of the test in the database
return(View("TestResult", qu));
}
else
{
DbAccessEntity tec = new DbAccessEntity();
int i = 0;
var domainlist = (from p in tec.Domain_Table
select new
{
domain = p.domain //select domain from domain table
}).ToList();
List <QuestionBank> li = new List <QuestionBank>();
foreach (var p in domainlist)
{
QuestionBank q = new QuestionBank();
if (i == 0)
{
q.domainlist = p.domain;
Session["domaintrack"] = p.domain;
li.Add(q);
}
else
{
q.domainlist = p.domain;
li.Add(q);
}
i++;
}
string firstdomain = Session["domaintrack"].ToString();
var techlist = (from p in tec.Technology_Table
join q in tec.Domain_Table
on p.did equals q.did
where q.domain == firstdomain
select new
{
Technology = p.technology,
}).ToList();
foreach (var q in techlist)
{
QuestionBank que = new QuestionBank();
que.techlist = q.Technology;
li.Add(que);
}
return(View(li));
}
}
