public ActionResult Create(Entity.ProfileStudent model)
{
var user = (Entity.User)Session["user"];
var id = user.User_id;
if (ModelState.IsValid)
{
var dal = new DAL.StudentDAL();
var chk = dal.Chkstud(model);
if (chk != null)
{
Response.Write("<script> alert('รหัสนักศึกษานี้ถูกลงทะเบียนเเล้ว')</script>");
}
else
{
var result = dal.Create(model, id);
if (result)
{
Response.Write("<script> alert('ลงทะเบียนสำเร็จ')</script>");
}
return(RedirectToAction("index", "User"));
}
return(View());
}
return(View(model));
}
public ActionResult EditStud(Entity.ProfileStudent model, string id)
{
try
{
var dal = new DAL.StudentDAL();
var stud = dal.Search(id);
stud.Stud_id = model.Stud_id;
stud.Pre_Name = model.Pre_Name;
stud.FristName = model.FristName;
stud.LastName = model.LastName;
stud.Group_id = model.Group_id;
stud.Branch = model.Branch;
stud.Faculty = model.Faculty;
var result = dal.EditeStud(stud);
if (result)
{
Response.Write("<script> alert('แก้ไข้ข้อมูลสำเร็จ')</script>");
}
return(RedirectToAction("StudentList"));
}
catch (Exception)
{
Response.Write("<scrip> aler('ไม่สำเร็จ')</scrip>");
}
return(View(model));
}
public Entity.ProfileStudent Chkstud(Entity.ProfileStudent model)
{
var stud = new Entity.ProfileStudent();
using (var db = new Entity.Entities())
{
stud = db.ProfileStudent.Where(a => a.Stud_id == model.Stud_id).FirstOrDefault();
}
return(stud);
}
public Entity.ProfileStudent Searchstud(int id)
{
var stud = new Entity.ProfileStudent();
using (var db = new Entity.Entities())
{
stud = db.ProfileStudent.Where(a => a.User_id == id).FirstOrDefault();
}
return(stud);
}
public Entity.ProfileStudent Search(string id)
{
var stud = new Entity.ProfileStudent();
using (var db = new Entity.Entities())
{
stud = db.ProfileStudent.Where(a => a.Stud_id == id).FirstOrDefault();
stud.PreName = stud.PreName;
stud.User = stud.User;
}
return(stud);
}
internal bool Delete(Entity.ProfileStudent model)
{
try
{
using (var db = new Entity.Entities())
{
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
internal bool Create(Entity.ProfileStudent model, int id)
{
try
{
int user = id;
using (var db = new Entity.Entities())
{
model.User_id = user;
db.Entry(model).State = System.Data.Entity.EntityState.Added;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
