public async Task <ActionResult> DeleteConfirmed(int id)
        {
            Referral_v2 referral_v2 = await db.Referral_V2s.FindAsync(id);

            db.Referral_V2s.Remove(referral_v2);
            await db.SaveChangesAsync();

            return(RedirectToAction("Index"));
        }
        public async Task <ActionResult> Edit([Bind(Include = "refferal_ID,referral_Doctors_Name,referral_doctor_Add,referral_doctor_num,referral_doctor_Email,refferal_Date,referral_ValidDate,refferal_Location,referral_Reasoning,PatientName,PatientID")] Referral_v2 referral_v2)
        {
            if (ModelState.IsValid)
            {
                db.Entry(referral_v2).State = EntityState.Modified;
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }
            return(View(referral_v2));
        }
        // GET: Referral_v2/Edit/5
        public async Task <ActionResult> Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Referral_v2 referral_v2 = await db.Referral_V2s.FindAsync(id);

            if (referral_v2 == null)
            {
                return(HttpNotFound());
            }
            return(View(referral_v2));
        }
        public async Task <ActionResult> Create([Bind(Include = "refferal_ID,referral_Doctors_Name,referral_doctor_Add,referral_doctor_num,referral_doctor_Email,refferal_Date,referral_ValidDate,refferal_Location,referral_Reasoning,PatientName,PatientID")] Referral_v2 referral_v2)
        {
            if ((ModelState.IsValid) && (referral_v2.referral_ValidDate > DateTime.Now))
            {
                referral_v2.refferal_Date         = DateTime.Now;
                referral_v2.referral_Doctors_Name = "Dr. J Govender";
                referral_v2.referral_doctor_Add   = "37 Magaliesberg Street, Shallcross, Durban, 4079";
                referral_v2.referral_doctor_num   = "0314099088";
                referral_v2.referral_doctor_Email = "*****@*****.**";
                db.Referral_V2s.Add(referral_v2);
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }

            return(View(referral_v2));
        }