public List <StudentObjects> GetAll() { List <StudentObjects> lst = new List <StudentObjects>(); var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_Student_GetAll(); foreach (var item in list) { if (item.Deleted == true) { continue; } StudentObjects ob = new StudentObjects(); ob.StudetId = item.StudetId; ob.FullName = item.FullName; ob.CreatDate = (DateTime)item.CreateDate; ob.Email = new SecurityConexts().DecryptInfo(item.Email); ob.Mobile = new SecurityConexts().DecryptInfo(item.Mobile); ob.Address = item.Address; ob.Status = item.Status.Value; ob.Deleted = item.Deleted; lst.Add(ob); } return(lst); }
public bool Update(StudentObjects ob) { var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_Student_UPDATE(ob.StudetId, ob.FullName, ob.Email, ob.Mobile, ob.Address, ob.Status, ob.Deleted); return(true); }
public bool Insert(StudentObjects ob) { ob.StudetId = Guid.NewGuid(); var db = new eTrainingScheduleEntities(); var data = db.sp_tbl_S07_Student_INSERT(ob.StudetId, ob.FullName, ob.Email, ob.Mobile, ob.Address, ob.Status, ob.Deleted); return(true); }
public StudentObjects GetByStudetId(Guid ID) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_Student_GetByStudetId(ID); foreach (var item in list) { StudentObjects obj = new StudentObjects(); obj.StudetId = item.StudetId; obj.FullName = item.FullName; obj.Email = item.Email; obj.Mobile = item.Mobile; obj.Address = item.Address; obj.Status = item.Status; obj.Deleted = item.Deleted; return(obj); } return(null); }
public List <StudentObjects> GetAll() { List <StudentObjects> lst = new List <StudentObjects>(); var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_Student_GetAll(); foreach (var item in list) { if (item.Deleted == true) { continue; } StudentObjects ob = new StudentObjects(); ob.StudetId = item.StudetId; ob.FullName = item.FullName; ob.Email = item.Email; ob.Mobile = item.Mobile; ob.Address = item.Address; ob.Status = item.Status; ob.Deleted = item.Deleted; lst.Add(ob); } return(lst); }
public ActionResult Edit(StudentObjects objS) { objS.Deleted = false; if (!String.IsNullOrEmpty(objS.Email)) { objS.Email = new SecurityConexts().EncryptInfo(objS.Email); } if (!String.IsNullOrEmpty(objS.Mobile)) { objS.Mobile = new SecurityConexts().EncryptInfo(objS.Mobile); } var b = new StudentBCL().Update(objS); if (b) { return(RedirectToAction("Index", "Student")); } else { ModelState.AddModelError("", "Edit that bai"); } return(View()); }
public bool Insert(StudentObjects ob) { return(new StudentDao().Insert(ob)); }
public bool Update(StudentObjects ob) { return(new StudentDao().Update(ob)); }