public ActionResult Patient_Visit(TBL_R_RECEIPT objRecept)
{
ViewBag.departments = new SelectList(db.TBL_R_DEPT, "DEPT_ID", "DEPT_NAME");
ViewBag.consultants = new SelectList(db.TBL_CONSULTANT, "CON_JOB_ID", "CON_NAME");
TBL_R_PATIENT patient = new TBL_R_PATIENT();
patient.AGE = objRecept.TBL_R_PATIENT.AGE;
patient.FIRST_NAME = objRecept.TBL_R_PATIENT.FIRST_NAME;
patient.ADDRESS1 = objRecept.TBL_R_PATIENT.ADDRESS1;
patient.TEL_NO = objRecept.TBL_R_PATIENT.TEL_NO;
patient.GENDER = objRecept.TBL_R_PATIENT.GENDER;
patient.F_NAME = objRecept.TBL_R_PATIENT.F_NAME;
patient.CNIC_NO = objRecept.TBL_R_PATIENT.CNIC_NO;
patient.DATEOFBIRTH = objRecept.TBL_R_PATIENT.DATEOFBIRTH;
db.TBL_R_PATIENT.Add(patient);
db.SaveChanges();
int last_insert_id = patient.MR_NO;
TBL_R_RECEIPT recept = new TBL_R_RECEIPT();
recept.MR_NO = last_insert_id;
recept.DEPT_ID = objRecept.DEPT_ID;
recept.CONSULTANT_ID = objRecept.CONSULTANT_ID;
db.TBL_R_RECEIPT.Add(recept);
db.SaveChanges();
int last_insert_idd = recept.R_ID;
return(RedirectToAction("reporting", new { id = "pdf", sub = last_insert_idd }));
}
public ActionResult Edit_Patient(TBL_R_RECEIPT objrcpt)
{
ViewBag.departments = new SelectList(db.TBL_R_DEPT, "DEPT_ID", "DEPT_NAME");
ViewBag.consultants = new SelectList(db.TBL_CONSULTANT, "CON_JOB_ID", "CON_NAME");
db.Entry(objrcpt).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
int last_insert_idd = objrcpt.R_ID;
return(RedirectToAction("reporting", new { id = "pdf", sub = last_insert_idd }));
}
public ActionResult Patient_Visit(TBL_R_RECEIPT objRecept)
{
ViewBag.departments = new SelectList(db.TBL_R_DEPT, "DEPT_ID", "DEPT_NAME");
ViewBag.consultants = new SelectList(db.TBL_CONSULTANT, "CON_JOB_ID", "CON_NAME");
ViewBag.gendr = new SelectList(db.TBL_Gender, "G_id", "G_name");
TBL_R_PATIENT patient = new TBL_R_PATIENT();
patient.AGE = objRecept.TBL_R_PATIENT.AGE;
patient.FIRST_NAME = objRecept.TBL_R_PATIENT.FIRST_NAME;
patient.ADDRESS1 = objRecept.TBL_R_PATIENT.ADDRESS1;
patient.TEL_NO = objRecept.TBL_R_PATIENT.TEL_NO;
patient.EMAIL = objRecept.TBL_R_PATIENT.EMAIL;
patient.GENDER = objRecept.TBL_R_PATIENT.GENDER;
patient.F_NAME = objRecept.TBL_R_PATIENT.F_NAME;
patient.PATIENTTYPE = objRecept.TBL_R_PATIENT.PATIENTTYPE;
patient.CNIC_NO = objRecept.TBL_R_PATIENT.CNIC_NO;
patient.DATEOFBIRTH = objRecept.TBL_R_PATIENT.DATEOFBIRTH;
db.TBL_R_PATIENT.Add(patient);
db.SaveChanges();
int last_insert_id = patient.MR_NO;
TBL_R_RECEIPT recept = new TBL_R_RECEIPT();
recept.MR_NO = last_insert_id;
recept.DEPT_ID = objRecept.DEPT_ID;
recept.CONSULTANT_ID = objRecept.CONSULTANT_ID;
recept.PAYMENT_AMOUNT = objRecept.PAYMENT_AMOUNT;
recept.rec_datetime = System.DateTime.Now;
recept.R_LOGIC_DATE = System.DateTime.Now;
recept.R_LOGIC_ID = Convert.ToInt32(Session["user_id"]);
recept.org_id = Convert.ToInt32(Session["user_org"]);
db.TBL_R_RECEIPT.Add(recept);
db.SaveChanges();
int last_insert_idd = recept.R_ID;
return(RedirectToAction("reporting", new { id = "pdf", sub = last_insert_idd }));
}
public ActionResult Edit_Patient(TBL_R_RECEIPT objrcpt)
{
ViewBag.departments = new SelectList(db.TBL_R_DEPT, "DEPT_ID", "DEPT_NAME");
ViewBag.consultants = new SelectList(db.TBL_CONSULTANT, "CON_JOB_ID", "CON_NAME");
Int32 Patient_Id = (int)TempData["Patient_ID"];
var Patient_Data = db.TBL_R_PATIENT.Where(x => x.MR_NO == Patient_Id).FirstOrDefault();
if (Patient_Data != null)
{
Patient_Data.FIRST_NAME = objrcpt.TBL_R_PATIENT.FIRST_NAME;
Patient_Data.AGE = objrcpt.TBL_R_PATIENT.AGE;
Patient_Data.TEL_NO = objrcpt.TBL_R_PATIENT.TEL_NO;
Patient_Data.ADDRESS1 = objrcpt.TBL_R_PATIENT.ADDRESS1;
Patient_Data.DATEOFBIRTH = objrcpt.TBL_R_PATIENT.DATEOFBIRTH;
Patient_Data.F_NAME = objrcpt.TBL_R_PATIENT.F_NAME;
Patient_Data.CNIC_NO = objrcpt.TBL_R_PATIENT.CNIC_NO;
db.Entry(Patient_Data).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
int last_insert_id = Patient_Data.MR_NO;
Int32 Reciept_Id = (int)TempData["Reciept_Id"];
var Reciept_Data = db.TBL_R_RECEIPT.Where(x => x.R_ID == Reciept_Id).FirstOrDefault();
Reciept_Data.MR_NO = last_insert_id;
Reciept_Data.DEPT_ID = objrcpt.DEPT_ID;
Reciept_Data.CONSULTANT_ID = objrcpt.CONSULTANT_ID;
db.Entry(Reciept_Data).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
int last_insert_idd = objrcpt.R_ID;
return(RedirectToAction("reporting", new { id = "pdf", sub = last_insert_idd }));
}
else
{
return(RedirectToAction("List_Patients"));
}
}
