public ActionResult TakeAppointment(PatientModel pm) { ClASDBEntities db = new ClASDBEntities(); List <SelectListItem> lst1 = new List <SelectListItem>(); var getdata = db.Doctors.Select(m => new { m.DoctorId, m.FirstName }).ToList(); foreach (var item in getdata) { lst1.Add(new SelectListItem { Text = item.FirstName, Value = item.DoctorId.ToString() }); } pm.ListD = lst1; var memId = Convert.ToInt32(Session["MemberId"]); var pid = db.Patients.Where(m => m.MemberID == memId).FirstOrDefault(); DoctorAppointment obj = new DoctorAppointment(); obj.DoctorId = pm.DoctorId; obj.AppointmentDate = pm.AppointDate; obj.AppointmentStatus = "Requested"; obj.PatientId = pid.PatientID; obj.Description = pm.AppointDesc; obj.Subject = pm.AppointSub; db.DoctorAppointments.Add(obj); db.SaveChanges(); ViewBag.text = "Appointment Requested"; return(View(pm)); }
public ActionResult EditProfile(DoctorModel dm) { ClASDBEntities db = new ClASDBEntities(); List <SelectListItem> lst1 = new List <SelectListItem>(); var getd = db.SpecializedDatas.ToList(); foreach (var item in getd) { lst1.Add(new SelectListItem { Text = item.SpecializedName, Value = item.SpecializedId.ToString() }); } int MemId = Convert.ToInt32(Session["MemberId"]); var getdata = db.Doctors.FirstOrDefault(m => m.MemberId == MemId); getdata.FirstName = dm.FName; getdata.LastName = dm.LName; getdata.SpecislizeId = dm.SpecializeId; getdata.TotalExperience = dm.Experience; getdata.Gender = dm.Gender; DoctorModel dt = new DoctorModel(); dt.ListS = lst1; db.SaveChanges(); ViewBag.text = "Edited Successfully"; return(View(dt)); }
public ActionResult ChangePassword(ChangePasswordModel cm) { int MemId = Convert.ToInt32(Session["MemberID"]); ClASDBEntities db = new ClASDBEntities(); var getPass = db.MemberLogins.FirstOrDefault(m => m.MemberID == MemId); if (ModelState.IsValid) { if (getPass.Password == cm.OldPassword) { getPass.Password = cm.NewPassword; db.SaveChanges(); ViewBag.text = "Password changed..."; } else { ViewBag.text = "Old Password did not match!!!"; } } else { ViewBag.text = "Confirm new Password once again..."; } return(View(cm)); }
public ActionResult OrderDrug(OrderModel od) { ClASDBEntities db = new ClASDBEntities(); PatientOrderDetail pod = new PatientOrderDetail(); List <SelectListItem> listD = new List <SelectListItem>(); var getdata = (from d in db.Drugs where d.IsDeleted == "No" select new { d.DrugID, d.DrugName }).ToList(); foreach (var item in getdata) { listD.Add(new SelectListItem { Text = item.DrugName, Value = Convert.ToString(item.DrugID) }); } od.ListDrug = listD; Random r = new Random(); var patId = Convert.ToInt32(Session["ID"]); var getd = db.Drugs.Where(m => m.DrugID == od.DrugId).FirstOrDefault(); var getQtty = getd.TotalQuantityAvailable; //od.TotalQtty = getQtty; if (ModelState.IsValid) { if (od.OrderQtty == 0) { ViewBag.text = "Enter order quantity more than 0!"; } else if (od.OrderQtty <= getQtty) { //getd.TotalQuantityAvailable = getQtty - od.OrderQtty; ViewBag.text = "Placing Order..."; pod.DrugId = od.DrugId; pod.OrderStatus = "Requested"; pod.PatientID = patId; pod.Quantity = od.OrderQtty; pod.OrderNumber = r.Next(1, 1000); pod.OrderDate = DateTime.Now; db.PatientOrderDetails.Add(pod); db.SaveChanges(); } else { ViewBag.text = "Enter order quantity less than available quantity!"; } ViewBag.text2 = "Order Placed!"; } else { ViewBag.text2 = "Error Occurred!"; } return(View(od)); }
public ActionResult DeleteDrug(int id) { ClASDBEntities db = new ClASDBEntities(); var d = db.Drugs.Where(m => m.DrugID == id).FirstOrDefault(); d.IsDeleted = "Yes"; db.SaveChanges(); ViewBag.Text = "Deleted Successfully"; return(RedirectToAction("ViewEditDrug", "Admin")); }
public ActionResult UpdateAppointments(int id, string str) { ClASDBEntities db = new ClASDBEntities(); //DoctorAppointment obj = new DoctorAppointment(); var getApp = db.DoctorAppointments.FirstOrDefault(m => m.AppointmentId == id); getApp.AppointmentStatus = str; db.SaveChanges(); return(RedirectToAction("ViewAppointments", "Doctor")); }
public ActionResult Assign(int sid, int ono) { ClASDBEntities db = new ClASDBEntities(); DrugDelivery dd = new DrugDelivery(); var getdata = db.PatientOrderDetails.Where(m => m.OrderID == ono).FirstOrDefault(); getdata.OrderStatus = "Assigned"; dd.OrderID = ono; dd.SupplierId = sid; db.DrugDeliveries.Add(dd); db.SaveChanges(); return(RedirectToAction("ViewPatientOrders", "Admin")); }
public ActionResult EditProfile(PatientModel dm) { ClASDBEntities db = new ClASDBEntities(); int MemId = Convert.ToInt32(Session["MemberId"]); var getdata = db.Patients.FirstOrDefault(m => m.MemberID == MemId); getdata.FirstName = dm.FName; getdata.LastName = dm.LName; getdata.Address = dm.Address; getdata.DOB = dm.DOB; getdata.Gender = dm.Gender; db.SaveChanges(); ViewBag.text = "Edited Successfully"; return(View(dm)); }
public ActionResult Inbox(PatientModel pm) { ClASDBEntities db = new ClASDBEntities(); Inbox obj = new Inbox(); var memId = Convert.ToInt32(Session["MemberId"]); var sender = db.MemberLogins.Where(m => m.MemberID == memId).FirstOrDefault(); //Id = Convert.ToInt32(Id); pm.FrmEmail = sender.EmailId; //if(ModelState.IsValid) //{ //var sender = Session["EmailId"].ToString(); //string sender = db.MemberLogins.Where(m => m.MemberID == memId).Select(a => new { a.EmailId }).ToString(); var doc = (from da in db.DoctorAppointments join d in db.Doctors on da.DoctorId equals d.DoctorId join m in db.MemberLogins on d.MemberId equals m.MemberID where da.AppointmentId == pm.AppointId select new { m.EmailId }).FirstOrDefault(); obj.Subject = pm.MsgSub; obj.MessageDetail = pm.MsgDetail; obj.MessageDate = System.DateTime.Now; obj.IsRead = "0"; obj.FromEmailId = sender.EmailId; obj.ToEmailId = doc.EmailId; db.Inboxes.Add(obj); db.SaveChanges(); ViewBag.text = "Message Sent"; //} //else //{ // ViewBag.Text = "Message not sent"; //} return(View(pm)); }
public ActionResult EditProfile(SupplierModel sm) { ClASDBEntities db = new ClASDBEntities(); if (ModelState.IsValid) { int MemId = Convert.ToInt32(Session["MemberId"]); var getdata = db.Suppliers.FirstOrDefault(m => m.MemberId == MemId); getdata.FirstName = sm.FName; getdata.LastName = sm.LName; getdata.CompanyName = sm.CompName; getdata.CompanyAddress = sm.CompAdd; db.SaveChanges(); ViewBag.text = "Edited Successfully"; } else { ViewBag.text = "Error Occurred!!"; } return(View(sm)); }
public ActionResult EditDrug(AddDrugModel ad, int id) { if (ModelState.IsValid) { ClASDBEntities db = new ClASDBEntities(); var d = db.Drugs.Where(m => m.DrugID == id).FirstOrDefault(); d.DrugName = ad.DName; d.ManufactureDate = ad.MfgDate; d.ExpiryDate = ad.ExpDate; d.SideEffect = ad.SideEff; d.TotalQuantityAvailable = ad.Qtty; d.IsDeleted = ad.IsDeleted; d.UsedFor = ad.Use; db.SaveChanges(); ViewBag.text = "Edited Successfully"; } else { ViewBag.text = "Error Occured"; } return(RedirectToAction("ViewEditDrug", "Admin")); }
public ActionResult ViewAllMessages(MessageModel pm, int id) { ClASDBEntities db = new ClASDBEntities(); Inbox obj = new Inbox(); List <MessageModel> lst1 = new List <MessageModel>(); //var patId = Convert.ToInt32(Session["ID"]); var getdata = db.Inboxes.Where(m => m.ReplyId == id).Select(a => new { a.MessageDate, a.MessageDetail, a.Subject, a.MessageId, a.ToEmailId, a.FromEmailId }).ToList(); foreach (var item in getdata) { lst1.Add(new MessageModel { //DoctorId=item.DoctorId, MsgId = item.MessageId, FrmEmail = item.FromEmailId, ToEmail = item.ToEmailId, MsgDate = item.MessageDate, MsgSub = item.Subject, MsgDetail = item.MessageDetail }); } pm.ListApp = lst1; var sender = Convert.ToString(Session["EmailId"]); var memId = Convert.ToInt32(Session["MemberId"]); var getd = db.Inboxes.FirstOrDefault(m => m.MessageId == id); obj.FromEmailId = sender; obj.ToEmailId = getd.FromEmailId; obj.MessageDetail = pm.MsgDetail; obj.MessageDate = DateTime.Now; obj.ReplyId = id; db.Inboxes.Add(obj); db.SaveChanges(); ViewBag.text = "Message Sent"; return(View(pm)); }
public ActionResult EditProfile(AdminModel dm) { ClASDBEntities db = new ClASDBEntities(); var memId = Convert.ToInt32(Session["MemberId"]); string checkRole = Convert.ToString(Session["RoleName"]); if (checkRole == "Admin") { var getdata = db.Admins.FirstOrDefault(m => m.MemberId == memId); getdata.FirstName = dm.FName; getdata.LastName = dm.LName; getdata.Address = dm.Address; getdata.Gender = dm.Gender; db.SaveChanges(); ViewBag.text = "Edited Successfully"; } else { ViewBag.text = "Error Occurred!"; } return(View(dm)); }
public ActionResult UpdateOrders(int id, string str) { ClASDBEntities db = new ClASDBEntities(); //DoctorAppointment obj = new DoctorAppointment(); var getOrd = db.PatientOrderDetails.FirstOrDefault(m => m.OrderID == id); var getDel = db.DrugDeliveries.FirstOrDefault(m => m.OrderID == id); var getDrug = db.Drugs.FirstOrDefault(m => m.DrugID == getOrd.DrugId); var q = getDrug.TotalQuantityAvailable; if (str == "Delivered") { getDel.DeliveryDate = DateTime.Now; getOrd.OrderStatus = str; getDrug.TotalQuantityAvailable = q - getOrd.Quantity; } else { getOrd.OrderStatus = str; db.DrugDeliveries.Remove(getDel); } db.SaveChanges(); return(RedirectToAction("ViewOrders", "Supplier")); }
public ActionResult AddDrugDetails(AddDrugModel ad) { if (ModelState.IsValid) { ClASDBEntities db = new ClASDBEntities(); Drug d = new Drug(); d.DrugName = ad.DName; d.ManufactureDate = ad.MfgDate; d.ExpiryDate = ad.ExpDate; d.SideEffect = ad.SideEff; d.TotalQuantityAvailable = ad.Qtty; d.UsedFor = ad.Use; d.IsDeleted = "No"; db.Drugs.Add(d); db.SaveChanges(); ViewBag.text = "Drug Inserted Succesfully"; } else { ViewBag.text = "Drug Not Inserted"; } return(View(ad)); }
public ActionResult Register(DataModel dt) { ClASDBEntities db = new ClASDBEntities(); MemberLogin obj = new MemberLogin(); List <SelectListItem> l = new List <SelectListItem>(); var getdata = db.RoleDetails.ToList(); foreach (var item in getdata) { if (item.RoleId == 1) { continue; } else { l.Add(new SelectListItem { Text = item.RoleName, Value = item.RoleId.ToString() }); } } dt.ListR = l; if (ModelState.IsValid) { obj.EmailId = dt.Email; obj.Password = dt.Password; obj.RoleId = dt.RoleId; db.MemberLogins.Add(obj); db.SaveChanges(); var getMemId = db.MemberLogins.Where(m => m.RoleId == dt.RoleId).OrderByDescending(o => o.MemberID).FirstOrDefault(); dt.MemberId = getMemId.MemberID; if (dt.RoleId == 2) { Doctor d = new Doctor(); d.MemberId = getMemId.MemberID; db.Doctors.Add(d); db.SaveChanges(); } else if (dt.RoleId == 3) { Patient p = new Patient(); p.MemberID = getMemId.MemberID; db.Patients.Add(p); db.SaveChanges(); } else if (dt.RoleId == 4) { Supplier s = new Supplier(); s.MemberId = getMemId.MemberID; db.Suppliers.Add(s); db.SaveChanges(); } ViewBag.text = "Registration successful"; } else { ViewBag.text = "Registration Unsuccessful"; } return(View(dt)); }