public async Task <string> Save() { try { string PostObjectStr = await GetPostData(); PO_Result_Save PostObject = JsonConvert.DeserializeObject <PO_Result_Save>(PostObjectStr); DB = new DBSContext(); string Message = ""; if (!IsValid(PostObject, out Message)) { return(JsonConvert.SerializeObject(new { IsSuccess = false, Message = Message })); } Result _Result = 0 == PostObject.Id ? new Result() : DB.Results.Find(PostObject.Id); _Result.StudentId = PostObject.StudentId; _Result.SubjectId = PostObject.SubjectId; _Result.Mark = Math.Round(PostObject.Mark, 2); if (0 == PostObject.Id) { _Result.DateOfEntry = DateTime.Now; DB.Results.Add(_Result); } DB.SaveChanges(); return(JsonConvert.SerializeObject(new { IsSuccess = true })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { IsSuccess = false, Message = Common.GetError(ex) })); } }
public async Task <string> Save() { try { string PostObjectStr = await GetPostData(); PO_Class_Save PostObject = JsonConvert.DeserializeObject <PO_Class_Save>(PostObjectStr); DB = new DBSContext(); string Message = ""; if (!IsValid(PostObject, out Message)) { return(JsonConvert.SerializeObject(new { IsSuccess = false, Message = Message })); } Class _Class = 0 == PostObject.Id ? new Class() : DB.Classes.Find(PostObject.Id); _Class.Name = PostObject.Name; _Class.Section = PostObject.Section; if (0 == PostObject.Id) { _Class.DateOfEntry = DateTime.Now; DB.Classes.Add(_Class); } DB.SaveChanges(); return(JsonConvert.SerializeObject(new { IsSuccess = true })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { IsSuccess = false, Message = Common.GetError(ex) })); } }
public JsonResult GetStudentList(int classId) { DB = new DBSContext(); var _List = DB.Students.Where(x => x.ClassId == classId).Select(x => new { id = x.StudentId, name = x.Name }).OrderBy(x => x.name).ToList(); return(Json(_List)); }
public JsonResult GetSubjectList() { DB = new DBSContext(); var _List = DB.Subjects.Select(x => new { id = x.SubjectId, name = x.Name }).OrderBy(x => x.name).ToList(); return(Json(_List)); }
public JsonResult GetClassList() { DB = new DBSContext(); var _List = DB.Classes.Select(x => new { id = x.ClassId, name = x.Name + " (" + x.Section + ")" }).OrderBy(x => x.name).ToList(); return(Json(_List)); }
public TodoController(DBSContext context) { _context = context; // if (_context.TodoItems.Count() == 0) // { // // Create a new TodoItem if collection is empty, // // which means you can't delete all TodoItems. // _context.TodoItems.Add(new TodoItem { Name = "Item1" }); // _context.SaveChanges(); // } }
public JsonResult GetStudentDetails(int Id) { DB = new DBSContext(); var StudentObj = DB.Students.Where(x => x.StudentId == Id).Select(x => new { name = x.Name, classId = x.ClassId, roll = x.Roll, phone = x.Phone, email = x.Email }).First(); return(Json(StudentObj)); }
public JsonResult GetStudentList() { DB = new DBSContext(); var _List = (from S in DB.Students join C in DB.Classes on S.ClassId equals C.ClassId select new { id = S.StudentId, name = S.Name, roll = S.Roll, className = C.Name + " (" + C.Section + ")" }).OrderBy(x => x.className).ThenBy(x => x.name).ToList(); return(Json(_List)); }
public JsonResult GetResultDetails(int Id) { DB = new DBSContext(); var ResultObj = (from R in DB.Results join S in DB.Students on R.StudentId equals S.StudentId where R.ResultId == Id select new { classId = S.ClassId, studentId = R.StudentId, subjectId = R.SubjectId, mark = R.Mark }).First(); return(Json(ResultObj)); }
public JsonResult GetResultList() { DB = new DBSContext(); var _List = (from R in DB.Results join S in DB.Students on R.StudentId equals S.StudentId join C in DB.Classes on S.ClassId equals C.ClassId join SJ in DB.Subjects on R.SubjectId equals SJ.SubjectId select new { id = R.ResultId, className = C.Name + " (" + C.Section + ")", name = S.Name, subjectName = SJ.Name, mark = R.Mark }).OrderBy(x => x.className).ThenBy(x => x.name).ThenBy(x => x.subjectName).ToList(); return(Json(_List)); }
public async Task <string> Delete() { try { string PostObjectStr = await GetPostData(); int Id = JsonConvert.DeserializeObject <int>(PostObjectStr); DB = new DBSContext(); Class _Class = DB.Classes.Find(Id); DB.Classes.Remove(_Class); DB.SaveChanges(); return(JsonConvert.SerializeObject(new { IsSuccess = true })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { IsSuccess = false, Message = Common.GetError(ex) })); } }
public async Task <string> Save() { try { string PostObjectStr = await GetPostData(); PO_Student_Save PostObject = JsonConvert.DeserializeObject <PO_Student_Save>(PostObjectStr); DB = new DBSContext(); string Message = ""; if (!IsValid(PostObject, out Message)) { return(JsonConvert.SerializeObject(new { IsSuccess = false, Message = Message })); } Student _Student = 0 == PostObject.Id ? new Student() : DB.Students.Find(PostObject.Id); _Student.ClassId = PostObject.ClassId; _Student.Name = PostObject.Name; _Student.Roll = PostObject.Roll; _Student.Phone = PostObject.Phone; _Student.Email = PostObject.Email; if (0 == PostObject.Id) { _Student.DateOfEntry = DateTime.Now; DB.Students.Add(_Student); } DB.SaveChanges(); return(JsonConvert.SerializeObject(new { IsSuccess = true })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { IsSuccess = false, Message = Common.GetError(ex) })); } }