public JsonResult SavedEvent(string eventTitle, string startTime, string endTime, bool isAllDay, bool isFixed)
{
try
{
if (Session["student"] == null)
{
return Json(false);
}
EventModel eventModel = new EventModel
{
EndTime = DateTime.Parse(endTime),
StartTime = DateTime.Parse(startTime),
EventTitle = eventTitle,
IsAllDay = isAllDay,
IsFixed = isFixed,
Color = isFixed ? "green" : "red"
};
Guid id = Guid.Parse((string)Session["student"]);
using (var context = new TobyDBContext())
{
eventModel.StudentId = id;
context.EventModels.Add(eventModel);
context.SaveChanges();
}
return Json(eventModel.Id);
}
catch { return Json(false); }
}
public JsonResult SaveGradeItem(string examName, string scoreAmount, string examDate, Guid studentId)
{
decimal scroe;
DateTime date;
GradeItemModel gradeItem = new GradeItemModel { ExamName = examName, StudentId = studentId };
try
{
if (!Decimal.TryParse(scoreAmount, out scroe) || !DateTime.TryParse(examDate, out date))
{
throw new Exception();
}
gradeItem.Grades = scroe;
gradeItem.ExamDate = date;
using (var context = new TobyDBContext())
{
context.GradeItemModels.Add(gradeItem);
context.SaveChanges();
}
return Json(new
{
item_id = gradeItem.Id,
grade = gradeItem.Grades,
exam_name = gradeItem.ExamName,
exam_date = gradeItem.ExamDate.ToString("MM/dd/yyyy")
});
}
catch
{
this.Response.StatusCode = 500;
return Json(null);
}
}
public JsonResult SavedNewPayment(string dealineTime, string paymentAmount, string paymentName, List<string> studentIds)
{
Guid studentId;
DateTime deadline;
decimal payment;
PaymentModel paymentModel = new PaymentModel();
PaymentJson paymentJson;
List<PaymentJson> paymentJsonList = new List<PaymentJson>();
try
{
using (var context = new TobyDBContext())
{
if (studentIds != null && studentIds.Count != 0)
{
studentIds.ForEach(id =>
{
paymentModel = new PaymentModel { PaymentName = paymentName };
paymentJson = new PaymentJson { payment_name = paymentName };
if (decimal.TryParse(paymentAmount, out payment) && DateTime.TryParse(dealineTime, out deadline)
&& Guid.TryParse(id, out studentId))
{
paymentModel.Payment = payment;
paymentModel.PaymentDeadLine = deadline;
paymentModel.StudentId = studentId;
var student = context.StudentModels.Where(s => s.Id == studentId).Single();
paymentJson.deadline = deadline.ToString("MM/dd/yyyy");
paymentJson.payment = paymentAmount;
paymentJson.student_name = string.Format("{0}({1})", student.Name, student.EnglishName);
paymentJson.class_id = student.TobyClassId.GetValueOrDefault().ToString();
}
else
{
throw new Exception();
}
context.PaymentModels.Add(paymentModel);
context.SaveChanges();
paymentJson._id = paymentModel.Id.ToString();
paymentJsonList.Add(paymentJson);
});
}
else
{
throw new Exception();
}
}
return Json(paymentJsonList.ToArray());
}
catch
{
this.Response.StatusCode = 500;
return Json(null);
}
}
public JsonResult SavedEvents(EventJsonModel jsonModel)
{
DateTime start, end, temp;
EventModel eventModel;
try
{
if (jsonModel.studentIds == null)
{
throw new Exception();
}
if (DateTime.TryParse(jsonModel.startTime, out start) && DateTime.TryParse(jsonModel.endTime, out end))
{
if (start > end)
{
temp = start;
start = end;
end = temp;
}
}
else
{
throw new Exception();
}
using (var context = new TobyDBContext())
{
jsonModel.studentIds.ForEach(id =>
{
eventModel = new EventModel
{
EventTitle = jsonModel.eventTile,
StartTime = start,
EndTime = end,
StudentId = id,
TeacherId = jsonModel.teacherId,
WorkTypeId = jsonModel.workTypeId,
Color = "red",
IsFixed = false,
IsAllDay = false
};
context.EventModels.Add(eventModel);
});
context.SaveChanges();
}
return Json(true);
}
catch
{
return Json(false);
}
}
private void AutoGeneratedFixedEvents()
{
Mapper.Reset();
Mapper.CreateMap<EventModel, EventModel>().ForMember(dest => dest.Id, opt => opt.Ignore());
List<EventModel> events;
EventModel eventModel;
List<StudentModel> students;
DateTime currentDate = DateTime.Today, startTime, endTime;
using (var context = new TobyDBContext())
{
students = context.StudentModels.ToList();
students.ForEach(student =>
{
events = context.EventModels.Where(models => models.IsFixed && models.StudentId == student.Id && models.StartTime < currentDate).ToList();
foreach (EventModel model in events)
{
startTime = model.StartTime.AddDays(7);
endTime = model.EndTime.AddDays(7);
if (!CheckEventIsExist(startTime, endTime, model.StudentId))
{
context.EventModels.Attach(model);
eventModel = Mapper.Map<EventModel, EventModel>(model);
eventModel.StartTime = startTime;
eventModel.EndTime = endTime;
eventModel.Color = "green";
context.EventModels.Add(eventModel);
model.IsFixed = false;
model.Color = "red";
}
}
});
context.SaveChanges();
}
}
public JsonResult GeneratedFixedEvents()
{
Mapper.Reset();
Mapper.CreateMap<EventModel, EventModel>().ForMember(dest => dest.Id, opt => opt.Ignore());
List<EventModel> events;
EventModel eventModel;
DateTime startTime, endTime;
try
{
if (Session["student"] != null)
{
using (var context = new TobyDBContext())
{
Guid id = Guid.Parse((string)Session["student"]);
events = context.EventModels.Where(models => models.IsFixed && models.StudentId == id).ToList();
foreach (EventModel model in events)
{
startTime = model.StartTime.AddDays(7);
endTime = model.EndTime.AddDays(7);
if (!CheckEventIsExist(startTime, endTime, model.StudentId))
{
context.EventModels.Attach(model);
eventModel = Mapper.Map<EventModel, EventModel>(model);
eventModel.StartTime = startTime;
eventModel.EndTime = endTime;
eventModel.Color = "green";
context.EventModels.Add(eventModel);
model.IsFixed = false;
model.Color = "red";
}
}
context.SaveChanges();
}
}
else
{
return Json(false);
}
return Json(true);
}
catch
{
return Json(false);
}
}
