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)
}));
}
}
