public JsonResult GridMvcWithJquery()
{
date = Convert.ToDateTime(day);
OPDManagementEntities db = new OPDManagementEntities();
var result = (from c in db.OPDManagements
join d in db.DoctorMasters on c.DoctorId equals d.SerialNo
where d.DoctorName == DoctorName && c.AppointmentDate == date.Date
select new Appointment
{
ReferenceNo = c.ReferenceNo,
FullName = c.FullName,
PhoneNo = c.PhoneNo.ToString(),
Email = c.EmailId,
Doctorcode = c.DoctorCode,
TimeSlot = c.AppointmentTime,
PatientAge = c.Age,
Gender = c.Gender,
AllergyDetail = c.AllergyDetail,
CaseDetail = c.Casedetail,
}).ToList();
Dictionary <string, object> jsonResult = new Dictionary <string, object>();
jsonResult.Add("Html", RenderRazorViewToString("~/Views/Physician/mvcgridpartial.cshtml", result));
jsonResult.Add("Status", "Success");
return(Json(jsonResult, JsonRequestBehavior.AllowGet));
}
public Appointment GetAppointmentModelReferenceId(string refernceId)
{
Appointment model = new Appointment();
OPDManagement objOPDManagement = new OPDManagement();
OPDManagementEntities context = new OPDManagementEntities();
objOPDManagement = context.OPDManagements.Where(a => a.ReferenceNo == refernceId).FirstOrDefault();
if (objOPDManagement != null)
{
model.Email = objOPDManagement.EmailId;
model.ReferenceNo = objOPDManagement.ReferenceNo;
model.FullName = objOPDManagement.FullName;
model.doctorId = objOPDManagement.DoctorId ?? 0;
model.Doctorcode = objOPDManagement.DoctorCode;
model.PhoneNo = Convert.ToString(objOPDManagement.PhoneNo);
model.Age = Convert.ToInt32(objOPDManagement.Age);
model.AllergyDetail = objOPDManagement.AllergyDetail;
model.CaseDetail = objOPDManagement.Casedetail;
model.CaseImagePath = objOPDManagement.CaseImage;
model.Gender = objOPDManagement.Gender;
model.PeviousPrescriptionPath = objOPDManagement.PreviousPrescreption;
model.Treated = objOPDManagement.Treated;
model.DoctorFeedback = objOPDManagement.DoctorFeedback;
if (objOPDManagement.DoctorId != null && objOPDManagement.DoctorId > 0)
{
model.DoctorName = Doctorlist().Where(a => a.SerialNo == objOPDManagement.DoctorId).Select(a => a.DoctorName).FirstOrDefault();
}
}
return(model);
}
public List <Avaibility> AvaibilityList(int doctorId)
{
OPDManagementEntities context = new OPDManagementEntities();
List <Avaibility> result = new List <Avaibility>();
List <AvaibilityMaster> obj = new List <AvaibilityMaster>();
if (doctorId == 0)
{
obj = context.AvaibilityMasters.ToList();
}
else
{
obj = context.AvaibilityMasters.Where(a => a.DoctorId == doctorId).ToList();
}
if (obj != null && obj.Count() > 0)
{
foreach (var data in obj)
{
Avaibility model = new Avaibility();
model.SerialNo = data.SerialNo;
model.Avaibilityslot = data.AvaibilitySlot;
result.Add(model);
}
}
return(result);
}
public ActionResult getAvailablityListAction(int doctorId, string Appointemntdate)
{
OPDManagementEntities context = new OPDManagementEntities();
DateTime appointmentDate = Convert.ToDateTime(Appointemntdate);
List <string> objExcludeTimeSlot = context.OPDManagements.Where(a => a.DoctorId == doctorId && a.AppointmentDate == appointmentDate).Select(a => a.AppointmentTime).ToList();
var objAvaibilityMasters = context.AvaibilityMasters.Where(a => a.DoctorId == doctorId && !objExcludeTimeSlot.Contains(a.AvaibilitySlot)).Select(a => "<option value='" + a.SerialNo + "'>" + a.AvaibilitySlot + "</option>");
return(Content(String.Join("", objAvaibilityMasters)));
}
public ActionResult AppointmentBooked(PatientLogin model)
{
OPDManagementEntities context = new OPDManagementEntities();
if (context.OPDManagements.Where(a => a.ReferenceNo == model.RefrenceNo && a.PhoneNo == model.MobileNumber).Count() > 0)
{
return(RedirectToAction("AddCaseDetail", "Appointment", new { refernceNo = model.RefrenceNo }));
}
return(View(model));
}
public ActionResult Treat(Appointment model)
{
OPDManagementEntities db = new OPDManagementEntities();
OPDManagement obj = db.OPDManagements.Where(a => a.ReferenceNo == model.ReferenceNo).FirstOrDefault();
Appointment ph = new Appointment();
if (obj != null)
{
obj.Treated = "Yes";
obj.DoctorFeedback = model.DoctorFeedback;
db.SaveChanges();
ViewBag.Message = "Record updated successfully.";
}
return(View(model));
}
public List <Doctor> Doctorlist()
{
OPDManagementEntities context = new OPDManagementEntities();
List <Doctor> result = new List <Doctor>();
var obj = context.DoctorMasters.Select(u => u).ToList();
if (obj != null && obj.Count() > 0)
{
foreach (var data in obj)
{
Doctor model = new Doctor();
model.SerialNo = data.SerialNo;
model.DoctorName = data.DoctorName;
model.DoctorCode = data.DoctorCode;
result.Add(model);
}
}
return(result);
}
public ActionResult Index(Appointment model)
{
Common obj = new Common();
model.doctordropdown = obj.Doctorlist();
OPDManagement objOPDManagement = new OPDManagement();
OPDManagementEntities context = new OPDManagementEntities();
objOPDManagement.FullName = model.FullName;
objOPDManagement.DoctorId = model.doctorId;
objOPDManagement.EmailId = model.Email;
objOPDManagement.PhoneNo = model.PhoneNo;
objOPDManagement.AppointmentDate = Convert.ToDateTime(model.AppointmentDate);
objOPDManagement.AvaibilityMasterId = Convert.ToInt16(model.TimeSlot);
objOPDManagement.AppointmentTime = obj.GetTimeSlot(Convert.ToInt16(model.TimeSlot));
objOPDManagement.DoctorCode = model.doctordropdown.Where(a => a.SerialNo == model.doctorId).Select(a => a.DoctorCode).FirstOrDefault();
context.OPDManagements.Add(objOPDManagement);
context.SaveChanges();
return(RedirectToAction("AppointmentBooked", "Appointment", new { refernceId = objOPDManagement.ReferenceNo }));
}
public ActionResult AddCaseDetail(Appointment model)
{
OPDManagementEntities context = new OPDManagementEntities();
OPDManagement objOPDManagement = new OPDManagement();
objOPDManagement = context.OPDManagements.Where(a => a.ReferenceNo == model.ReferenceNo).FirstOrDefault();
if (model.PeviousPrescription != null && model.PeviousPrescription.ContentLength > 0)
{
string pic = Guid.NewGuid() + System.IO.Path.GetExtension(model.PeviousPrescription.FileName);
string path = System.IO.Path.Combine(
Server.MapPath("~/UploadFile"), pic);
// file is uploaded
model.PeviousPrescription.SaveAs(path);
objOPDManagement.PreviousPrescreption = model.PeviousPrescriptionPath = "/UploadFile/" + pic;
}
if (model.CaseImage != null && model.CaseImage.ContentLength > 0)
{
string pic = Guid.NewGuid() + System.IO.Path.GetExtension(model.CaseImage.FileName);
string path = System.IO.Path.Combine(
Server.MapPath("~/UploadFile"), pic);
// file is uploaded
model.CaseImage.SaveAs(path);
objOPDManagement.CaseImage = model.CaseImagePath = "/UploadFile/" + pic;;
}
objOPDManagement.EmailId = model.Email;
objOPDManagement.ReferenceNo = model.ReferenceNo;
objOPDManagement.FullName = model.FullName;
objOPDManagement.DoctorCode = model.Doctorcode;
objOPDManagement.Age = Convert.ToString(model.Age);
objOPDManagement.Gender = model.Gender;
objOPDManagement.PhoneNo = model.PhoneNo;
objOPDManagement.AllergyDetail = model.AllergyDetail;
objOPDManagement.Casedetail = model.CaseDetail;
context.SaveChanges();
return(RedirectToAction("AppointmentBooked", "Appointment", new { refernceId = string.Empty }));
}
public string GetTimeSlot(int id)
{
OPDManagementEntities context = new OPDManagementEntities();
return(context.AvaibilityMasters.Where(a => a.SerialNo == id).Select(a => a.AvaibilitySlot).FirstOrDefault());
}
public bool CheckLogin(string reference, string password)
{
OPDManagementEntities context = new OPDManagementEntities();
return(context.OPDManagements.Where(a => a.ReferenceNo.Trim().ToLower() == reference.Trim().ToLower() && a.PhoneNo == password).Count() > 0 ? true : false);
}
