public ActionResult Create(Entity.Open_Subjects model)
{
var teacher = (Entity.ProfileTeacher)Session["Teacher"];
var id = teacher.Teacher_id;
if (ModelState.IsValid)
{
var dal = new DAL.OpensubDAL();
var chk = dal.ChkSub(model);
if (chk != null)
{
Response.Write("<script> alert('รหัสวิชานี้ถูกเปิดสอนเเล้ว')</script>");
}
else
{
var result = dal.Create(model, id);
if (result)
{
if (result)
{
Response.Write("<script> alert('เปิดวิชาเรียนสำเร็จ')</script>");
}
}
return(RedirectToAction("Subject", "RegisterSub"));
}
}
return(View(model));
}
public Entity.Open_Subjects ChkSub(Entity.Open_Subjects model)
{
var Sub = new Entity.Open_Subjects();
using (var db = new Entity.Entities())
{
Sub = db.Open_Subjects.Where(a => a.Sub_id == model.Sub_id).FirstOrDefault();
}
return(Sub);
}
public Entity.Open_Subjects Search(int id)
{
var sub = new Entity.Open_Subjects();
using (var db = new Entity.Entities())
{
sub = db.Open_Subjects.Where(a => a.Sub_id == id).FirstOrDefault();
sub.ProfileTeacher = sub.ProfileTeacher;
}
return(sub);
}
public List <Entity.Register_Subjects> SubGradList()
{
var model = new Entity.Open_Subjects();
var Sub = new List <Entity.Register_Subjects>();
using (var db = new Entity.Entities())
{
Sub = db.Register_Subjects.ToList();
foreach (var s in Sub)
{
s.Open_Subjects = s.Open_Subjects;
}
}
return(Sub);
}
internal bool Create(Entity.Open_Subjects model, string id)
{
try
{
string tecger = id;
using (var db = new Entity.Entities())
{
model.Teacher_id = tecger;
db.Entry(model).State = System.Data.Entity.EntityState.Added;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
