public XmlDocument ReturnXml()
{
CampuswebDataContext campusweb = new CampuswebDataContext();
System.Xml.Linq.XElement xlinq = new XElement("course_offereds",
from c in campusweb.courses
join co in campusweb.course_offereds on c.c_id equals co.c_id
join s in campusweb.semesters on co.s_id equals s.s_id
select new XElement("course_offered", new XAttribute("co_id", co.co_id),
new XElement("course", new XAttribute("c_id", c.c_id), new XElement("name", c.c_code + c.c_name)),
new XElement("semester", new XAttribute("s_id", s.s_id), new XElement("name", s.s_year + s.s_sem))
)
);
var doc = new XmlDocument();
doc.LoadXml(xlinq.ToString());
return(doc);
// load some XML ...
}
public XmlDocument GetSection()
{
CampuswebDataContext campusweb = new CampuswebDataContext();
System.Xml.Linq.XElement xlinq = new XElement("sections",
from sec in campusweb.sections
join co in campusweb.course_offereds on sec.co_id equals co.co_id
join s in campusweb.semesters on co.s_id equals s.s_id
join c in campusweb.courses on co.c_id equals c.c_id
join p in campusweb.profiles on sec.u_name equals p.u_name
select new XElement("section", new XAttribute("sec_id", sec.sec_id),
new XElement("sec_no", sec.sec_no),
new XElement("user", new XAttribute("u_name", p.p_name), new XElement("name", p.u_name)),
new XElement("course", new XAttribute("c_id", c.c_id), new XElement("name", c.c_code + " " + c.c_name)),
new XElement("semester", new XAttribute("s_id", s.s_id), new XElement("name", s.s_year + "/" + s.s_sem))
)
);
var doc = new XmlDocument();
doc.LoadXml(xlinq.ToString());
return(doc);
// load some XML ...
}
protected void Page_Load(object sender, EventArgs e)
{
campusweb = new CampuswebDataContext();
Session["u_name"] = "teststudent";
}
protected void Page_Load(object sender, EventArgs e)
{
campusweb = new CampuswebDataContext();
}
protected void Button1_Click(object sender, EventArgs e)
{
var name = txt_name.Text;
using (CampuswebDataContext ctx = new CampuswebDataContext())
{
GridView1.DataSource = from a in ctx.section_marks
join b in ctx.student_marks on a.sm_id equals b.sm_id
join c in ctx.profiles on b.u_name equals c.u_name
where b.u_name == name
select new
{
u_name = c.u_name,
assestment = a.sm_item,
marks = b.stum_score,
totalMarks = a.sm_total,
percent = a.sm_percentage,
actualMarks = (b.stum_score / a.sm_total * a.sm_percentage)
};
GridView1.DataBind();
var result = (from a in ctx.section_marks
join b in ctx.student_marks on a.sm_id equals b.sm_id
join c in ctx.profiles on b.u_name equals c.u_name
where b.u_name == name
select new
{
actualMarks = (b.stum_score / a.sm_total * a.sm_percentage)
}).ToList();
System.Diagnostics.Debug.WriteLine(result);
double sum = 0;
foreach (var a in result)
{
sum += a.actualMarks;
}
if (sum >= 0.9)
{
finalMarks.Text = (sum * 100).ToString();
gred.Text = ("A+").ToString();
}
if (sum >= 0.8 && sum < 0.9)
{
finalMarks.Text = (sum * 100).ToString();
gred.Text = ("A").ToString();
}
if (sum >= 0.7 && sum < 0.8)
{
finalMarks.Text = (sum * 100).ToString();
gred.Text = ("B+").ToString();
}
if (sum >= 0.6 && sum < 0.7)
{
finalMarks.Text = (sum * 100).ToString();
gred.Text = ("B").ToString();
}
if (sum >= 0.55 && sum < 0.6)
{
finalMarks.Text = (sum * 100).ToString();
gred.Text = ("C").ToString();
}
if (sum >= 0.5 && sum < 0.55)
{
finalMarks.Text = (sum * 100).ToString();
gred.Text = ("D").ToString();
}
if (sum >= 0.4 && sum < 0.5)
{
finalMarks.Text = (sum * 100).ToString();
gred.Text = ("E").ToString();
}
if (sum <= 0.39)
{
finalMarks.Text = (sum * 100).ToString();
gred.Text = ("F").ToString();
}
}
}
protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
CampuswebDataContext linq = new CampuswebDataContext();
e.Result = linq.SelectStudentMarkWithStudentID("teststudent");
}
