public static void Creatdb(db s)
{
var xml = XElement.Load("ex.xml");
var hwnode = xml.Descendants("Info").ToList();
for (int i = 0; i < hwnode.Count(); i++)
{
var hw_node = hwnode[i];
}
int j = 0;
foreach (var hw_node in hwnode)
{
j++;
var name = hw_node.Attribute("name").Value.Trim();
var address = hw_node.Attribute("address").Value.Trim();
var openTime = hw_node.Attribute("openTime").Value.Trim();
var phone = hw_node.Attribute("phone").Value.Trim();
homework homeworkdata = new homework();
homeworkdata.name = name;
homeworkdata.address = address;
homeworkdata.openTime = openTime;
homeworkdata.phone = phone;
s.Creat(homeworkdata);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
bool st = true;
if (chkStatus.Checked)
{
st = true;
}
else
{
st = false;
}
homework hw = new homework
{
course_id = drpCourse.SelectedValue.ToString(),
title = txtTitle.Text,
description = txtDescription.Text,
startdate = Convert.ToDateTime(txtStart.Text),
duedate = Convert.ToDateTime(txtDue.Text),
status = st
};
db.homeworks.InsertOnSubmit(hw);
try
{
db.SubmitChanges();
Response.Write("<script>alert('Homework Created')</script>");
Response.Redirect("index.aspx?ID=" + id);
}
catch (Exception)
{
throw;
}
}
public void Push()
{
homework wx = new homework();
wx.Push(1);
Assert.AreEqual(wx.Pop(), 1);
Assert.AreEqual(wx.Pop(), null);
}
public ActionResult Save(HomeworkJSON data)
{
var date = Utility.GetDBDate();
var homework = new homework();
if (!string.IsNullOrEmpty(data.id))
{
homework = repository.GetHomeworks(sessionid.Value, date.Year).Single(x => x.id.ToString() == data.id);
repository.DeleteHomeworkClasses(homework.id);
}
homework.title = data.title;
homework.message = data.message;
homework.subjectid = data.subject;
homework.created = date;
homework.creator = sessionid.Value;
homework.notifyme = data.notifyme;
// need to save first to get homework id
repository.Save();
foreach (var s in data.students)
{
var student = new homework_student();
student.studentid = s;
student.classid = db.classes_students_allocateds.First(x => x.year == date.Year && x.studentid == s).classid;
homework.homework_students.Add(student);
}
// now to update all relevant homework files
foreach (var file in data.files)
{
var hfile = repository.GetHomeworkFile(long.Parse(file.id));
hfile.homeworkid = homework.id;
homework.homework_files.Add(hfile);
}
if (string.IsNullOrEmpty(data.id))
{
repository.AddHomework(homework);
}
repository.Save();
var viewmodel = "Homework saved successfully".ToJsonOKMessage();
viewmodel.data = this.RenderViewToString("Single", homework.ToModel(true, homework.created.Year));
return(Json(viewmodel));
}
public RedirectToRouteResult AgregarTarea(homework home, string filenames)
{
if (Session["id"] != null)
{
home.idUs = (int)Session["id"];
}
if (db.insertHomeworks(home, filenames))
{
return(RedirectToAction("Lista"));
}
else
{
return(RedirectToAction("AgregarTarea"));
}
}
public RedirectToRouteResult actualizarTarea(homework home, string filenames)
{
db.updateTarea(home, filenames);
return(RedirectToAction("Lista"));
}
/*
* Edicion de archivos
*/
public ViewResult actualizarTarea(int id)
{
homework tarea = db.getTareas(id);
return(View(tarea));
}
public void AddHomework(homework homework)
{
db.homeworks.InsertOnSubmit(homework);
Save();
}
