public ActionResult Create(Appointment appointment)
{
try
{
if (ModelState.IsValid)
{
appointment.APPID = Guid.NewGuid();
var User = Session["Person"] as Person;
appointment.PersonID = User.ID;
appointment.Invoiced = false;
if (appointment.expences == null)
{
appointment.expences = 0;
}
if (appointment.VisitMileage == null)
{
appointment.VisitMileage = 0;
}
appointment.Total = appointment.Notes + appointment.expences + appointment.VisitMileage;
db.Appointments.Add(appointment);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
ModelState.AddModelError("_Form", ex.Message);
}
//_userMailer.Appointment(User.Email, User.UserName, appointment).Send();
////////////////change
var sessionDetail = db.Sessions.Where(ses => ses.ID == appointment.SessID).FirstOrDefault();
var practDetail = db.Practices.Where(p => p.ID == appointment.PracID).FirstOrDefault();
DateTime start = Convert.ToDateTime(appointment.startDate);
DateTime stTime = Convert.ToDateTime(sessionDetail.startTime);
DateTime end = Convert.ToDateTime(appointment.endDate);
DateTime enTime = Convert.ToDateTime(sessionDetail.EndTime);
var sesstionStartTime = Convert.ToDateTime(sessionDetail.startTime);
var sesstionEndTime = Convert.ToDateTime(sessionDetail.EndTime);
var Cal = new FullCalendarEvent();
Cal.id = appointment.APPID;
Cal.title = practDetail.Name;
Cal.Sessiontitle = sessionDetail.Name;
Cal.SessionStart = (sesstionStartTime).ToShortTimeString();
Cal.Sessionend = (sesstionEndTime).ToShortTimeString();
Cal.start = new DateTime(start.Year, start.Month, start.Day, stTime.Hour,stTime.Minute,stTime.Second).ToString("s");
Cal.end = new DateTime(end.Year, end.Month, end.Day, enTime.Hour, enTime.Minute, enTime.Second).ToString("s");
Cal.color = "#2d89ef";
return Json(Cal, JsonRequestBehavior.AllowGet);
////////////////////////////////////////
}
}
catch (Exception ex)
{
ModelState.AddModelError("_Form", ex.Message);
}
ViewBag.PracID = new SelectList(db.Practices, "ID", "Name", appointment.PracID);
ViewBag.SessID = new SelectList(db.Sessions, "ID", "Name", appointment.SessID);
return View(appointment);
}
public JsonResult GetAllAppointments(IEnumerable<Appointment> AP, Guid? Empid)
{
var count1 = 0;
try
{
var data = new List<FullCalendarEvent>();
var count = 0;
var User = Session["Person"] as Person;
var Appointment = new Appointment();
Appointment.PersonID = User.ID;
foreach (var item in db.Appointments.Include(p => p.sessionDetail).Include(p => p.Parctice).Where(A => A.PersonID == User.ID))
{
DateTime start = Convert.ToDateTime(item.startDate);
DateTime stTime = Convert.ToDateTime(item.sessionDetail.startTime);
DateTime end = Convert.ToDateTime(item.endDate);
DateTime enTime = Convert.ToDateTime(item.sessionDetail.EndTime);
var color1 = "";
if (item.Invoiced == true)
{
if (item.Paid == true)
{
color1 = "#00a300";
}
else
{
color1 = "#EE4646";
}
}
else
{
color1 = "#2d89ef";
}
var sesstionStartTime = Convert.ToDateTime(item.sessionDetail.startTime);
var sesstionEndTime = Convert.ToDateTime(item.sessionDetail.EndTime);
var Cal = new FullCalendarEvent()
{
id = item.APPID,
// Aid = item.APPID,
title = item.Parctice.Name,
Sessiontitle = item.sessionDetail.Name,
//SessionStart =item.sessionDetail.startTime,
//Sessionend = item.sessionDetail.EndTime,
SessionStart = sesstionStartTime.ToShortTimeString(),
Sessionend = sesstionEndTime.ToShortTimeString(),
color = color1,
start = new DateTime(start.Year, start.Month, start.Day, sesstionStartTime.Hour, sesstionStartTime.Minute, sesstionStartTime.Second).ToString("s"),
end = new DateTime(end.Year, end.Month, end.Day, sesstionEndTime.Hour, sesstionEndTime.Minute, sesstionEndTime.Second).ToString("s")
};
data.Add(Cal);
}
var returnData = data.ToArray();
return Json(returnData, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
ModelState.AddModelError("_Form", ex.Message);
}
return Json(count1, JsonRequestBehavior.AllowGet);
}
public ActionResult Edit(Appointment appointment)
{
if (ModelState.IsValid)
{
// appointment.Locumname = db.Practices.Where(a => a.ID == appointment.PracID).FirstOrDefault() != null ? db.Practices.Where(a => a.ID == appointment.PracID).FirstOrDefault().Name : "";
// appointment.Sessionname = db.Sessions.Where(a => a.ID == appointment.SessID).FirstOrDefault() != null ? db.Sessions.Where(a => a.ID == appointment.SessID).FirstOrDefault().Name : "";
// appointment.sstarttime = db.Sessions.Where(a => a.ID == appointment.SessID).FirstOrDefault() != null ? db.Sessions.Where(a => a.ID == appointment.SessID).FirstOrDefault().startTime : "";
// appointment.sendtime = db.Sessions.Where(a => a.ID == appointment.SessID).FirstOrDefault() != null ? db.Sessions.Where(a => a.ID == appointment.SessID).FirstOrDefault().EndTime : "";
var User = Session["Person"] as Person;
appointment.PersonID = User.ID;
appointment.Total = appointment.Notes + appointment.expences + appointment.VisitMileage;
db.Entry(appointment).State = EntityState.Modified;
db.SaveChanges();
// return Json(appointment, JsonRequestBehavior.AllowGet);
//Update Scheduler
var sessionDetail = db.Sessions.Where(ses => ses.ID == appointment.SessID).FirstOrDefault();
var practDetail = db.Practices.Where(p => p.ID == appointment.PracID).FirstOrDefault();
DateTime start = Convert.ToDateTime(appointment.startDate);
DateTime stTime = Convert.ToDateTime(sessionDetail.startTime);
DateTime end = Convert.ToDateTime(appointment.endDate);
DateTime enTime = Convert.ToDateTime(sessionDetail.EndTime);
var sesstionStartTime = Convert.ToDateTime(sessionDetail.startTime);
var sesstionEndTime = Convert.ToDateTime(sessionDetail.EndTime);
var Cal = new FullCalendarEvent();
Cal.id = appointment.APPID;
Cal.title = practDetail.Name;
Cal.Sessiontitle = sessionDetail.Name;
Cal.SessionStart = (sesstionStartTime).ToShortTimeString();
Cal.Sessionend = (sesstionEndTime).ToShortTimeString();
Cal.start = new DateTime(start.Year, start.Month, start.Day, stTime.Hour, stTime.Minute, stTime.Second).ToString("s");
Cal.end = new DateTime(end.Year, end.Month, end.Day, enTime.Hour, enTime.Minute, enTime.Second).ToString("s");
return Json(Cal, JsonRequestBehavior.AllowGet);
///////////////
}
ViewBag.PracID = new SelectList(db.Practices, "ID", "Name", appointment.PracID);
ViewBag.SessID = new SelectList(db.Sessions, "ID", "Name", appointment.SessID);
return View(appointment);
}