public void InsertData(string currUser, PatientAppointmentModel oClass)
{
strSql = strSql + "INSERT INTO " + TABLE_NAME + " (" +
COLUMN_CASE_NO + ", " +
COLUMN_PATIENT_NO + ", " +
COLUMN_DATE + ", " +
COLUMN_APPOINTMENT_TYPE + ", " +
COLUMN_PHYSICIAN_ID + ", " +
COLUMN_STATUS_ID + ", " +
COLUMN_REMARKS + ", " +
"created_by, created_date, updated_by, updated_date) ";
strSql = strSql + "values ('" +
oClass.CaseNo + "', '" +
oClass.PatientNo + "', '" +
oClass.AppointmentDate.ToString("yyyy-MM-d HH:MM:ss") + "', '" +
oClass.AppointmentType + "', '" +
oClass.PhysicianID + "', '" +
oClass.StatusID + "', '" +
oClass.Remarks.Replace("'", "") + "', '" +
currUser + "', " +
"CurDate(), '" +
currUser + "', " +
"CurDate() " +
") ";
SaveData(strSql);
}
private void SaveData()
{
string sUserName = Session["User"].ToString();
oDAL = new PatientAppointmentDAL();
oClass = new PatientAppointmentModel();
oClass.PatientNo = PatientNo.Value;
oClass.CaseNo = "";
oClass.AppointmentDate = Convert.ToDateTime(AppointmentDate.Value);
oClass.PhysicianID = Convert.ToInt16(ddlPhysician.SelectedValue);
oClass.HospitalID = Convert.ToInt16(ddlHospital.SelectedValue);
oClass.StatusID = 3;
oClass.Remarks = txtRemarks.InnerText;
string id = AppointmentID.Value;
if (id == "")
{
oDAL.InsertData(sUserName, oClass);
//lblMsg.Text = "New Record has been saved";
}
else
{
oClass.ID = Convert.ToInt16(id);
oDAL.UpdateData(sUserName, oClass);
// lblMsg.Text = "Record has been updated";
}
}
public JsonResult ReleasePatientFromWards(int id, int wardId)
{
using (var db = new MedicalContext())
{
PatientAppointmentModel appoint = db.Appointment.Find(id);
appoint.WardId = 0;
db.SaveChanges();
}
return(Json(1));
}
public DataSet SelectByID(PatientAppointmentModel oClass)
{
strSql = "SELECT A.*, Concat(B.FirstName, ' ', B.LastName) as PatientName, B.dob, C.FacilityName, Concat(D.FirstName, ' ', D.LastName) as PhysicianName, E.dname as Status " +
"FROM " + TABLE_NAME + " A INNER JOIN " + TABLE_PATIENT + " B on A.PatientNo = B.PatientNo " +
" LEFT OUTER JOIN " + TABLE_FACILITY + " C ON C.ID = A." + COLUMN_HOSPITAL_ID +
" LEFT OUTER JOIN " + TABLE_PHYSICIAN + " D ON D.ID = A." + COLUMN_PHYSICIAN_ID +
" LEFT OUTER JOIN " + TABLE_STATUS + " E ON E.ID = A." + COLUMN_STATUS_ID +
" WHERE A." + COLUMN_ID + " = '" + oClass.ID + "' ";
return(Select(strSql));
}
public void DeleteData(string user, PatientAppointmentModel oClass)
{
strSql = "UPDATE " + TABLE_NAME + " SET " +
" isDeeleted = 1, " +
" ReasonDelete = '" + oClass.ReasonDelete.Replace("'", "''") + "', " +
" updated_by = '" + user + "', " +
" updated_date = '" + DateTime.Now.ToString("yyyy-MM-d HH:MM:ss") + "' " +
" WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
SaveData(strSql);
}
public void CreateAppointment(PatientAppointmentModel model)
{
var appointment = ModelMapper.Instance.To <PatientAppointment>(model);
var appointmentAdded = _patientAppointmentLogic.Add(appointment);
if (appointmentAdded)
{
_unitOfWork.SaveChanges();
}
}
public ActionResult Prescription(Prescription prescription, int AppointmentId)
{
prescription.DocId = Convert.ToInt32(Session["DoctorId"]);
ViewBag.Prescription = "active";
string searchdate = DateTime.Now.ToString("MM/dd/yyyy");
string pdfname;
pdfname = DateTime.Now.ToString("dd-MM-yyyy") + "_" + Guid.NewGuid() + ".pdf";
using (var db = new MedicalContext())
{
if (prescription.WardId > 0)
{
PatientAppointmentModel appointment = db.Appointment.Find(AppointmentId);
appointment.WardId = prescription.WardId;
db.SaveChanges();
}
var presdoc = from ap in db.Appointment
join p in db.Registers
on ap.PatientId equals p.Id
join d in db.Doctors
on ap.DoctorId equals d.Id
where ap.Id == AppointmentId
select new
{
PatientName = p.Name,
PatientAge = p.Age
};
foreach (var v in presdoc)
{
prescription.PatientName = privacy.Decrypt(v.PatientName);
prescription.PatientAge = v.PatientAge;
}
PatientAppointmentModel app = db.Appointment.Single(c => c.Id == AppointmentId && c.DoctorId == prescription.DocId &&
c.Date == searchdate);
app.Prescription = "Prescriptions/" + pdfname;
db.SaveChanges();
}
var printpdf = new ActionAsPdf("MakePdf", prescription)
{
FileName = pdfname
};
string path = Server.MapPath("~/Prescriptions");
string a = Path.Combine(path, pdfname);
var byteArray = printpdf.BuildPdf(ControllerContext);
var fileStream = new FileStream(a, FileMode.Create, FileAccess.Write);
fileStream.Write(byteArray, 0, byteArray.Length);
fileStream.Close();
return(printpdf);
}
private void LoadAppointment(int appointmentID)
{
PatientAppointmentDAL appointmentDAL = new PatientAppointmentDAL();
PatientAppointmentModel appointmentModel = new PatientAppointmentModel();
appointmentModel.ID = appointmentID;
oDs = new DataSet();
oDs = appointmentDAL.SelectByID(appointmentModel);
// ddlHospitalName.SelectedValue = oDs.Tables[0].Rows[0]["FacilityID"].ToString();
ddlPhysician.SelectedValue = oDs.Tables[0].Rows[0]["PhysicianID"].ToString();
LoadPatient(oDs.Tables[0].Rows[0]["PatientNo"].ToString());
}
public void UpdateData(string user, PatientAppointmentModel oClass)
{
strSql = "UPDATE " + TABLE_NAME + " SET " +
COLUMN_CASE_NO + " = '" + oClass.CaseNo + "', " +
COLUMN_PATIENT_NO + " = '" + oClass.PatientNo + "', " +
COLUMN_DATE + " = '" + oClass.AppointmentDate.ToString("yyyy-MM-d HH:MM:ss") + "', " +
COLUMN_APPOINTMENT_TYPE + " = '" + oClass.AppointmentType + "', " +
COLUMN_PHYSICIAN_ID + " = '" + oClass.PhysicianID + "', " +
COLUMN_HOSPITAL_ID + " = '" + oClass.HospitalID + "', " +
COLUMN_REMARKS + " = '" + oClass.Remarks.Replace("'", "''") + "', " +
" updated_by = '" + user + "', " +
" updated_date = '" + DateTime.Now.ToString("yyyy-MM-d HH:MM:ss") + "' " +
" WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
SaveData(strSql);
}
protected void Ok_ServerClick(object sender, EventArgs e)
{
string UserName = Session["User"].ToString();
int ID = Convert.ToInt32(HiddenFieldItem.Value);
oDAL = new PatientAppointmentDAL();
oClass = new PatientAppointmentModel();
oDs = new DataSet();
oClass.IsDeleted = true;
oClass.ReasonDelete = itemname.InnerText;
string lbl = lblSelectedItem.Text;
oClass.ID = ID;
oDAL.DeleteData(UserName, oClass);
PopulateGrid();
}
public ActionResult PatientHistory(int id)
{
List <PatientAppointmentModel> appointmentlist = new List <PatientAppointmentModel>();
using (var db = new MedicalContext())
{
int s = db.Appointment.Where(c => c.Id == id).Select(c => c.PatientId).FirstOrDefault();
var data = db.Appointment.Where(c => c.PatientId == s).Select(c => new { c.Prescription, c.Date });
foreach (var d in data)
{
PatientAppointmentModel appoint = new PatientAppointmentModel();
appoint.Prescription = d.Prescription;
appoint.Date = d.Date;
appointmentlist.Add(appoint);
}
}
return(View(appointmentlist));
}
public ActionResult Appointment(PatientAppointmentModel patientAppointment)
{
ViewBag.patient = "active";
patientAppointment.PatientId = Convert.ToInt32(Session["PatientId"]);
List <SpecialistModel> specialists;
using (var db = new MedicalContext())
{
patientAppointment.Accepted = 3;
db.Appointment.Add(patientAppointment);
db.SaveChanges();
specialists = db.Specialist.ToList();
}
ViewBag.Category = specialists;
ViewBag.Error = '1';
return(View());
}
private void PopulateData(int id)
{
oDAL = new PatientAppointmentDAL();
oClass = new PatientAppointmentModel();
oDs = new DataSet();
oClass.ID = id;
oDs = oDAL.SelectByID(oClass);
AppointmentID.Value = oDs.Tables[0].Rows[0][0].ToString();
// CaseNo.Value = oDs.Tables[0].Rows[0][1].ToString();
AppointmentDate.Value = oDs.Tables[0].Rows[0][2].ToString();
PatientNo.Value = oDs.Tables[0].Rows[0]["PatientNo"].ToString();
PatientName.Value = oDs.Tables[0].Rows[0]["PatientName"].ToString();
DOB.Value = Convert.ToDateTime(oDs.Tables[0].Rows[0]["DOB"]).ToShortDateString();
ddlPhysician.SelectedValue = oDs.Tables[0].Rows[0]["PhysicianID"].ToString();
ddlHospital.SelectedValue = oDs.Tables[0].Rows[0]["FacilityID"].ToString();
// ddlStatus.SelectedValue = oDs.Tables[0].Rows[0]["StatusID"].ToString();
txtRemarks.Value = oDs.Tables[0].Rows[0][6].ToString();
}
public JsonResult GetAllPatientByDoctorId(int id, string date)
{
List <PatientAppointmentModel> patients = new List <PatientAppointmentModel>();
using (var db = new MedicalContext())
{
var a = db.Appointment.Where(s => s.DoctorId == id && s.Date == date);
foreach (var k in a)
{
PatientAppointmentModel patient = new PatientAppointmentModel();
patient.PatientName = k.PatientName;
patient.Number = k.Number;
patient.Email = k.Email;
patient.Sex = k.Sex;
patients.Add(patient);
}
}
return(Json(patients));
}
