public ActionResult Create([Bind(Include = "PatientID,FirstName,LastName,DOB,Email,Phone,BloodGroup,Status,Photo,Gender,DoctorID")] Patient patient, HttpPostedFileBase postedFile, FormCollection fc)
{
string filename = System.IO.Path.GetFileName(postedFile.FileName);
string filepath = "~/Uploads/PatientImages/" + filename;
postedFile.SaveAs(Server.MapPath(filepath));
// if (ModelState.IsValid)
// {
/* db.Patients.Add(new Patient
* {
* FirstName=patient.FirstName,
* LastName=patient.LastName,
* DOB= patient.DOB.ToString("mm-dd-yyyy")),
* Email =patient.Email,
* Gender=fc["RbGender"],
* Phone=patient.Phone,
* BloodGroup=patient.BloodGroup,
* Status=patient.Status,
* Photo=filepath,
* DoctorID=patient.DoctorID
* });*/
patient.Gender = fc["RbGender"];
patient.DOB.ToString("mm-dd-yyyy");
patient.Photo = filepath;
db.Patients.Add(patient);
db.SaveChanges();
return(RedirectToAction("Index", "Patients", new { l = 2 }));
// }
// return View(patient);
}
public ActionResult Create([Bind(Include = "StaffID,FirstName,LastName,Email,Phone,SCategory")] Staff staff, FormCollection fc)
{
staff.SCategory = fc["Category"];
db.Staffs.Add(staff);
db.SaveChanges();
return(RedirectToAction("Index"));
//return View(staff);
}
public ActionResult Create([Bind(Include = "DoctorID,FirstName,LastName,Email,Phone,Status")] Doctor doctor)
{
if (ModelState.IsValid)
{
db.Doctors.Add(doctor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(doctor));
}
public ActionResult Create([Bind(Include = "PaymentID,PatientID,PayableAmount,PaymentDate,PaymentMethod,Status")] Payment payment, FormCollection fc)
{
//if (ModelState.IsValid)
//{
payment.PaymentMethod = fc["RbPM"];
payment.Status = fc["RbStatus"];
payment.PaymentDate.ToString("mm-dd-yyyy");
db.Payments.Add(payment);
db.SaveChanges();
return(RedirectToAction("PatientListAcc", "Payments", new { id = payment.PatientID, l = 3 }));
//}
//ViewBag.PatientID = new SelectList(db.Patients, "PatientID", "FirstName", payment.PatientID);
//return View(payment);
}
public void ExecuteSystemJob(SystemJob SystemJob)
{
var storedProcedure = SystemJob.StoredProcedure;
db.Database.ExecuteSqlRaw("EXEC {0}", storedProcedure);
SystemJob.LastRan = DateTime.Now;
db.SystemJobs.Update(SystemJob);
db.SaveChanges();
}
public void AddPatient(Patient patient)
{
if (patient == null)
{
throw new ArgumentNullException(nameof(patient));
}
_context.Patients.Add(patient);
_context.SaveChanges();
}
public ActionResult Edit([Bind(Include = "SID,FirstName,MiddleName,LastName,Phone,Email,Password,Status")] SuperAdmin superAdmin)
{
if (ModelState.IsValid)
{
db.Entry(superAdmin).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("DashSuper", "Home"));
}
return(View(superAdmin));
}
public ActionResult Create([Bind(Include = "TreatmentID,PatientID,CheckupDate,Symptoms,Diagnosis,Medicine,Doses,BeforeMeal,Advice")] Treatment treatment, FormCollection fc)
{
//if (ModelState.IsValid)
//{
treatment.Doses = fc["Doses"];
treatment.BeforeMeal = fc["RbBeforeMeal"];
treatment.CheckupDate.ToString("mm-dd-yyyy");
List <Patient> patient = db.Patients.ToList();
var result = patient.Where(x => x.PatientID.Equals(treatment.PatientID)).Select(x => x.DoctorID);
var DocId = result.ToList();
db.Treatments.Add(treatment);
db.SaveChanges();
return(RedirectToAction("ExistingPatientReport", "Patients", new { id = treatment.PatientID, Did = DocId[0], l = 1 }));
//}
// ViewBag.PatientID = new SelectList(db.Patients, "PatientID", "FirstName", treatment.PatientID);
//return View(treatment);
}
public virtual TEntity Add(TEntity item)
{
using (var transaction = Context.Database.BeginTransaction()) {
try {
var propertyInfo = item.GetType().GetProperty("LastModifiedDate");
if (propertyInfo != null)
{
propertyInfo.SetValue(item, DateTime.Now);
}
Context.Set <TEntity>().Add(item);
Context.SaveChanges();
transaction.Commit();
return(item);
} catch (Exception ex) {
transaction.Rollback();
throw new Exception(ex.Message);
}
}
}
public ActionResult Register(Registration user)
{
if (ModelState.IsValid)
{
using (HMSDbContext db = new HMSDbContext())
{
//user.Category = fc["Category"];
//var NewUser = db.Registrations.Create();
//NewUser.Email = user.Email;
//NewUser.Password = user.Password;
db.Registrations.Add(user);
db.SaveChanges();
return(RedirectToAction("LogIn", "", new { s = "Registered Succesfully" }));
}
}
return(View(user));
}
public int AddDetail(room Room)
{
db.rooms.Add(Room);
db.SaveChanges();
return(Room.RoomNo);
}
public int SaveChanges()
{
return(db.SaveChanges());
}
public int AddDetail(booking Booking)
{
db.bookings.Add(Booking);
db.SaveChanges();
return(Booking.BookingNo);
}
public string AddDetail(user boarder)
{
db.users.Add(boarder);
db.SaveChanges();
return(boarder.Emailid);
}
