public ActionResult ViewOrders() { CASDatabaseEntities db = new CASDatabaseEntities(); List <PatientOrderModel> list = new List <PatientOrderModel>(); PatientOrderModel dt = new PatientOrderModel(); int id = Convert.ToInt32(Session["ID"]); var getDetails = from o in db.PatientOrderDetails join d in db.Drugs on o.DrugID equals d.DrugID where o.PatientID == id select new { d.DrugName, o.OrderNumber, o.OrderDate, o.OrderStatus, o.Quantity }; foreach (var item in getDetails) { list.Add(new PatientOrderModel { DrugName = item.DrugName, OrderNumber = item.OrderNumber, OrderDate = Convert.ToDateTime(item.OrderDate), OrderStatus = item.OrderStatus, Quantity = Convert.ToInt32(item.Quantity) }); } dt.ListOrder = list; return(View(dt)); }
public ActionResult UpdateOrder(int?ID, string str) { CASDatabaseEntities db = new CASDatabaseEntities(); PatientOrderModel dt = new PatientOrderModel(); PatientOrderDetail objOrder = new PatientOrderDetail(); DrugDelivery objDelivery = new DrugDelivery(); var id = Convert.ToInt32(ID); var getData = db.PatientOrderDetails.Where(m => m.PatientOrderID == id).FirstOrDefault(); if (str == "Deliver") { getData.OrderStatus = "Delivered"; objDelivery.PatientOrderID = getData.PatientOrderID; objDelivery.DeliveryDate = DateTime.Today; db.DrugDeliveries.Add(objDelivery); Session["Deliver"] = "Delivered"; } else { getData.OrderStatus = "Rejected"; } dt.OrderStatus = getData.OrderStatus; db.SaveChanges(); return(RedirectToAction("ViewPatientOrders", "Salesperson")); }
public ActionResult OrderDrugs() { CASDatabaseEntities db = new CASDatabaseEntities(); PatientOrderModel dt = new PatientOrderModel(); List <SelectListItem> list = new List <SelectListItem>(); var getDrugDetails = from d in db.Drugs where d.IsDeleted == false select new { d.DrugID, d.DrugName, }; foreach (var item in getDrugDetails) { list.Add(new SelectListItem { Text = item.DrugName, Value = item.DrugID.ToString() }); } dt.ListDrug = list; return(View(dt)); }
public ActionResult PlaceOrders() { CASDatabaseEntities db = new CASDatabaseEntities(); List <SupplierDataModel> list = new List <SupplierDataModel>(); SupplierDataModel dt = new SupplierDataModel(); var getData = from s in db.Suppliers where s.CurrentStatus == "Active" select new { s.SupplierID, s.FirstName, s.LastName, s.CompanyName, s.CompanyAddress }; foreach (var item in getData) { list.Add(new SupplierDataModel { SupplierID = item.SupplierID, FirstName = item.FirstName, LastName = item.LastName, CompanyName = item.CompanyName, CompanyAddress = item.CompanyAddress }); } dt.ListSupplier = list; return(View(dt)); }
public ActionResult EditDetails() { CASDatabaseEntities db = new CASDatabaseEntities(); PatientDataModel dt = new PatientDataModel(); var id = Convert.ToInt32(Session["UserID"]);; var getData = db.Patients.Where(m => m.UserID == id).FirstOrDefault(); if (getData != null) { dt.FirstName = getData.FirstName; dt.LastName = getData.LastName; dt.Gender = getData.Gender; dt.DOB = Convert.ToDateTime(getData.DOB); dt.Address = getData.Address; dt.ContactNo = getData.ContactNo; dt.EmgContactName = getData.EmgContactName; dt.EmgContactNo = getData.EmgContactNo; } else { dt.FirstName = null; } return(View(dt)); }
public ActionResult SendMessages() { CASDatabaseEntities db = new CASDatabaseEntities(); List <AppointmentDataModel> list = new List <AppointmentDataModel>(); AppointmentDataModel dt = new AppointmentDataModel(); int ID = Convert.ToInt32(Session["ID"]);; var getDetails = from a in db.Appointments join p in db.Physicians on a.PhysicianID equals p.PhysicianID where (a.PatientID == ID && a.AppointmentStatus == "Accepted") select new { p.FirstName, p.LastName, a.AppointmentID, a.AppointmentDate }; foreach (var item in getDetails) { list.Add(new AppointmentDataModel { AppointmentID = item.AppointmentID, PhysicianName = item.FirstName + " " + item.LastName, AppointmentDate = item.AppointmentDate, }); } dt.ListData = list; return(View(dt)); }
public ActionResult ViewAllSupplierMessages(int?ID) { CASDatabaseEntities db = new CASDatabaseEntities(); List <InboxDataModel> list = new List <InboxDataModel>(); InboxDataModel dt = new InboxDataModel(); int id = Convert.ToInt32(ID); var getData = from i in db.Inboxes where i.ReplyID == id select new { i.FromEmailID, i.MessageDetail, i.MessageDate }; if (getData != null) { foreach (var item in getData) { list.Add(new InboxDataModel { FromEmailID = item.FromEmailID, MessageDetail = item.MessageDetail, MessageDate = item.MessageDate }); } dt.ListData = list; } return(View(dt)); }
private void GetLists(AppointmentDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); List <SelectListItem> lists = new List <SelectListItem>(); List <SelectListItem> listp = new List <SelectListItem>(); var getSpecialization = db.SpecializationDatas.ToList(); foreach (var item in getSpecialization) { lists.Add(new SelectListItem { Text = item.SpecializationName, Value = item.SpecializationID.ToString() }); } dt.ListSpecialization = lists; if (dt.ListSpecialization != null) { var getPhysician = db.Physicians.ToList(); foreach (var item in getPhysician) { listp.Add(new SelectListItem { Text = item.FirstName + " " + item.LastName, Value = item.PhysicianID.ToString() }); } dt.ListPhysician = listp; } }
public ActionResult ViewOrders() { CASDatabaseEntities db = new CASDatabaseEntities(); List <SalesOrderModel> list = new List <SalesOrderModel>(); SalesOrderModel dt = new SalesOrderModel(); int id = Convert.ToInt32(Session["ID"]); var getData = from so in db.SalespersonOrderDetails where so.SupplierID == id select new { so.DrugName, so.SalespersonOrderID, so.OrderNumber, so.OrderDate, so.Quantity, so.OrderStatus }; foreach (var item in getData) { list.Add(new SalesOrderModel { SalespersonOrderID = item.SalespersonOrderID, OrderNumber = item.OrderNumber, DrugName = item.DrugName, Quantity = Convert.ToInt32(item.Quantity), OrderStatus = item.OrderStatus, OrderDate = Convert.ToDateTime(item.OrderDate) }); } dt.ListOrder = list; return(View(dt)); }
public ActionResult ViewAllSupplierMessages(int?ID, InboxDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); Inbox objInbox = new Inbox(); var id = Convert.ToInt32(ID); var getData = db.Inboxes.Where(m => m.MessageID == id).FirstOrDefault(); if (ModelState.IsValid) { if (getData != null) { objInbox.FromEmailID = getData.FromEmailID; objInbox.ToEmailID = getData.ToEmailID; objInbox.MessageDetail = dt.MessageDetail; objInbox.MessageDate = DateTime.Now; objInbox.ReplyID = id; objInbox.IsRead = false; db.Inboxes.Add(objInbox); db.SaveChanges(); } else { ViewBag.text = "Failed"; } } return(RedirectToAction("ViewAllSupplierMessages", "Salesperson")); }
public ActionResult Register() { CASDatabaseEntities db = new CASDatabaseEntities(); List <SelectListItem> list = new List <SelectListItem>(); DataViewModel dt = new DataViewModel(); var getData = db.RoleDetails.ToList(); foreach (var item in getData) { if (item.RoleID == 1) { continue; } else { list.Add(new SelectListItem { Text = item.RoleName, Value = item.RoleID.ToString() }); } } dt.ListRole = list; return(View(dt)); }
public ActionResult ViewSalesperson() { CASDatabaseEntities db = new CASDatabaseEntities(); List <SalesDataModel> list = new List <SalesDataModel>(); SalesDataModel dt = new SalesDataModel(); var getData = from s in db.Salespersons join u in db.Users on s.UserID equals u.UserID where s.FirstName != null select new { s.SalespersonID, s.FirstName, s.LastName, s.CurrentStatus, u.EmailID }; foreach (var item in getData) { list.Add(new SalesDataModel { SalespersonID = item.SalespersonID, FirstName = item.FirstName, LastName = item.LastName, CurrentStatus = item.CurrentStatus, EmailID = item.EmailID, }); } dt.ListSalesperson = list; return(View(dt)); }
public ActionResult EditDetails(PhysicianDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); Physician objPhysician = new Physician(); List <SelectListItem> list = new List <SelectListItem>(); var getSpecData = db.SpecializationDatas.ToList(); foreach (var item in getSpecData) { list.Add(new SelectListItem { Text = item.SpecializationName, Value = item.SpecializationID.ToString() }); } dt.ListSpecialization = list; var id = Convert.ToInt32(Session["UserID"]); var getData = db.Physicians.Where(a => a.UserID == id).FirstOrDefault(); if (ModelState.IsValid) { if (getData != null) { getData.FirstName = dt.FirstName; getData.LastName = dt.LastName; getData.Gender = dt.Gender; getData.SpecializationID = dt.SpecializationID; getData.TotalExperience = dt.TotalExperience; getData.Education = dt.Education; getData.CurrentStatus = dt.CurrentStatus; } else { objPhysician.FirstName = dt.FirstName; objPhysician.LastName = dt.LastName; objPhysician.Gender = dt.Gender; objPhysician.TotalExperience = dt.TotalExperience; objPhysician.SpecializationID = dt.SpecializationID; objPhysician.Education = dt.Education; objPhysician.CurrentStatus = dt.CurrentStatus; db.Physicians.Add(objPhysician); } db.SaveChanges(); } var checkName = db.Physicians.Where(a => a.UserID == id).FirstOrDefault(); if (checkName.FirstName != null) { Session["Name"] = checkName.FirstName; } else { Session["Name"] = null; } Session["ID"] = checkName.PhysicianID; return(View(dt)); }
public ActionResult SendMessages(InboxDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); Inbox objInbox = new Inbox(); if (ModelState.IsValid) { var salesData = (from u in db.Users where u.RoleID == 4 select new { u.EmailID }).SingleOrDefault(); string ToEmailID = salesData.EmailID; objInbox.FromEmailID = Session["EmailID"].ToString(); objInbox.ToEmailID = ToEmailID; objInbox.Subject = dt.Subject; objInbox.MessageDetail = dt.MessageDetail; objInbox.MessageDate = DateTime.Now; objInbox.IsRead = false; db.Inboxes.Add(objInbox); db.SaveChanges(); ViewBag.text = "Message Sent"; } else { ViewBag.text = "Message Not Sent"; } return(View(dt)); }
public ActionResult EditDrugs(int?ID) { CASDatabaseEntities db = new CASDatabaseEntities(); DrugDataModel dt = new DrugDataModel(); int id = Convert.ToInt32(ID); var getData = db.Drugs.Where(m => m.DrugID == id).FirstOrDefault(); if (getData != null) { dt.DrugName = getData.DrugName; dt.Manufacturer = getData.Manufacturer; dt.Substitutions = getData.Substitutions; dt.Uses = getData.Uses; dt.SideEffects = getData.SideEffects; dt.NotRecommended = getData.NotRecommended; dt.MfgDate = getData.MfgDate; dt.ExpDate = getData.ExpDate; dt.QOH = getData.QOH; dt.QOHType = getData.QOHType; dt.Price = Convert.ToDouble(getData.Price); dt.DiscountAmount = Convert.ToDouble(getData.DiscountAmount); dt.IsDeleted = getData.IsDeleted; } return(View(dt)); }
public ActionResult UpdateHistory(int?ID, PatientDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); Patient objPatient = new Patient(); int id = Convert.ToInt32(ID); var getData = db.Patients.Where(m => m.PatientID == id).FirstOrDefault(); getData.History = dt.History; db.SaveChanges(); return(RedirectToAction("History", "Physician")); }
public ActionResult DeleteUser(int id, string str) { switch (str) { case "Patient": CASDatabaseEntities db = new CASDatabaseEntities(); var getPatient = db.Patients.Where(m => m.PatientID == id).FirstOrDefault(); var getPUser = db.Users.Where(m => m.UserID == getPatient.UserID).FirstOrDefault(); if (getPUser != null) { getPUser.IsLocked = true; } db.SaveChanges(); return(RedirectToAction("ViewPatient", "Admin")); case "Physician": CASDatabaseEntities dbp = new CASDatabaseEntities(); var getPhysician = dbp.Physicians.Where(m => m.PhysicianID == id).FirstOrDefault(); var getPhUser = dbp.Users.Where(m => m.UserID == getPhysician.UserID).FirstOrDefault(); if (getPhUser != null) { getPhUser.IsLocked = true; } dbp.SaveChanges(); return(RedirectToAction("ViewPhysician", "Admin")); case "Salesperson": CASDatabaseEntities dbs = new CASDatabaseEntities(); var getSales = dbs.Salespersons.Where(m => m.SalespersonID == id).FirstOrDefault(); var getSaUser = dbs.Users.Where(m => m.UserID == getSales.UserID).FirstOrDefault(); if (getSaUser != null) { getSaUser.IsLocked = true; } dbs.SaveChanges(); return(RedirectToAction("ViewSalesperson", "Admin")); case "Supplier": CASDatabaseEntities dbss = new CASDatabaseEntities(); var getSupplier = dbss.Suppliers.Where(m => m.SupplierID == id).FirstOrDefault(); var getSUser = dbss.Users.Where(m => m.UserID == getSupplier.UserID).FirstOrDefault(); if (getSUser != null) { getSUser.IsLocked = true; } dbss.SaveChanges(); return(RedirectToAction("ViewSupplier", "Admin")); default: return(RedirectToAction("Index", "Admin")); } }
public ActionResult AddDrugs(DrugDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); Drug objDrug = new Drug(); if (ModelState.IsValid) { var getData = db.Drugs.Where(m => m.DrugName == dt.DrugName).FirstOrDefault(); if (getData != null) { ViewBag.Text = "Drug Already Present. Only Updation Allowed"; } else { if (dt.QOH == 0) { ViewBag.Text = "New Drug Cannot Be Entered With ZERO Quantity."; } else { if (dt.MfgDate > DateTime.Today || dt.ExpDate < DateTime.Today) { ViewBag.Text = "Invalid Manufacturing or Expiry Date"; } else { objDrug.DrugName = dt.DrugName; objDrug.Manufacturer = dt.Manufacturer; objDrug.Substitutions = dt.Substitutions; objDrug.MfgDate = dt.MfgDate; objDrug.ExpDate = dt.ExpDate; objDrug.Uses = dt.Uses; objDrug.SideEffects = dt.SideEffects; objDrug.NotRecommended = dt.NotRecommended; objDrug.QOH = dt.QOH; objDrug.QOHType = dt.QOHType; objDrug.Price = Convert.ToDecimal(dt.Price); objDrug.DiscountAmount = Convert.ToDecimal(dt.DiscountAmount); objDrug.IsDeleted = false; db.Drugs.Add(objDrug); db.SaveChanges(); ViewBag.Text = "Drug Inserted Successfully"; } } } } return(View(dt)); }
public ActionResult RequestAdmin(RequestDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); RequestAdmin objRequest = new RequestAdmin(); List <SelectListItem> list = new List <SelectListItem>(); var getData = db.RoleDetails.ToList(); foreach (var item in getData) { if (item.RoleID == 1 || item.RoleID == 4) { continue; } else { list.Add(new SelectListItem { Text = item.RoleName, Value = item.RoleID.ToString() }); } } dt.ListRole = list; if (ModelState.IsValid) { var getEmail = db.Users.Where(m => m.EmailID == dt.EmailID).FirstOrDefault(); if (getEmail != null) { ViewBag.text = "This E-mail ID is already registered."; } else { objRequest.FirstName = dt.FirstName; objRequest.LastName = dt.LastName; objRequest.EmailID = dt.EmailID; objRequest.RoleID = dt.RoleID; objRequest.Status = "Requested"; db.RequestAdmins.Add(objRequest); db.SaveChanges(); ViewBag.text = "Request has been sent. Please wait for the E-mail."; } } return(View(dt)); }
public ActionResult EditDetails(PatientDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); Patient objPatient = new Patient(); var id = Convert.ToInt32(Session["UserID"]);; var getData = db.Patients.Where(m => m.UserID == id).FirstOrDefault(); if (ModelState.IsValid) { if (getData != null) { getData.FirstName = dt.FirstName; getData.LastName = dt.LastName; getData.Gender = dt.Gender; getData.DOB = dt.DOB; getData.Address = dt.Address; getData.ContactNo = dt.ContactNo; getData.EmgContactName = dt.EmgContactName; getData.EmgContactNo = dt.EmgContactNo; } else { objPatient.FirstName = dt.FirstName; objPatient.LastName = dt.LastName; objPatient.Gender = dt.Gender; objPatient.DOB = dt.DOB; objPatient.Address = dt.Address; objPatient.ContactNo = dt.ContactNo; objPatient.EmgContactName = dt.EmgContactName; objPatient.EmgContactNo = dt.EmgContactNo; db.Patients.Add(objPatient); } db.SaveChanges(); } var checkName = db.Patients.Where(a => a.UserID == id).FirstOrDefault(); if (checkName.FirstName != null) { Session["Name"] = checkName.FirstName; } else { Session["Name"] = null; } Session["ID"] = checkName.PatientID; return(View(dt)); }
public ActionResult DeleteDrugs(int?ID) { CASDatabaseEntities db = new CASDatabaseEntities(); DrugDataModel dt = new DrugDataModel(); int id = Convert.ToInt32(ID); var getData = db.Drugs.Where(m => m.DrugID == id).FirstOrDefault(); if (getData != null) { getData.IsDeleted = true; dt.IsDeleted = getData.IsDeleted; db.SaveChanges(); } return(RedirectToAction("ViewDrugs", "Admin")); }
public ActionResult Index() { CASDatabaseEntities db = new CASDatabaseEntities(); var id = Convert.ToInt32(Session["UserID"]); var checkName = db.Admins.Where(a => a.UserID == id).FirstOrDefault(); if (checkName.FirstName != null) { Session["Name"] = checkName.FirstName; } else { Session["Name"] = null; } Session["ID"] = checkName.AdminID; return(View()); }
public ActionResult Drugs() { CASDatabaseEntities db = new CASDatabaseEntities(); List <DrugDataModel> list = new List <DrugDataModel>(); DrugDataModel dt = new DrugDataModel(); var getDetails = from d in db.Drugs where d.IsDeleted == false select new { d.DrugName, d.Manufacturer, d.Substitutions, d.Uses, d.SideEffects, d.NotRecommended, d.MfgDate, d.ExpDate, d.QOH, d.QOHType, d.Price, d.DiscountAmount, }; foreach (var item in getDetails) { list.Add(new DrugDataModel { DrugName = item.DrugName, Manufacturer = item.Manufacturer, Substitutions = item.Substitutions, Uses = item.Uses, SideEffects = item.SideEffects, NotRecommended = item.NotRecommended, MfgDate = item.MfgDate, ExpDate = item.ExpDate, QOH = item.QOH, QOHType = item.QOHType, Price = Convert.ToDouble(item.Price), DiscountAmount = Convert.ToDouble(item.DiscountAmount), }); } dt.ListDrugs = list; return(View(dt)); }
public ActionResult ChangePassword(PasswordDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); User objUser = new User(); var id = Convert.ToInt32(Session["UserID"]); var getData = db.Admins.Where(a => a.UserID == id).FirstOrDefault(); if (ModelState.IsValid) { if (getData != null) { var getInfo = (from u in db.Users where (u.UserID == id) select new { u.EmailID, u.Password, }).FirstOrDefault(); if (dt.OldPassword == dt.NewPassword) { ViewBag.text = "New Password Cannot Be Same As Old Password"; } else { if (getInfo.Password == dt.OldPassword) { var getEmail = db.Users.FirstOrDefault(m => m.EmailID == getInfo.EmailID); if (getEmail != null) { getEmail.Password = dt.NewPassword; db.SaveChanges(); ViewBag.text = "Password Updated Successfully."; } } else { ViewBag.text = "Password Incorrect. Please Enter Correct Password."; } } } } return(View(dt)); }
public ActionResult OnRequest(int id, string str) { CASDatabaseEntities db = new CASDatabaseEntities(); var getData = db.RequestAdmins.Where(m => m.RequestID == id).FirstOrDefault(); if (str == "Accepted") { getData.Status = "Accepted"; db.SaveChanges(); return(RedirectToAction("Register", "Admin")); } db.RequestAdmins.Remove(getData); db.SaveChanges(); return(RedirectToAction("ViewRequests", "Admin")); }
public ActionResult ViewPhysician() { CASDatabaseEntities db = new CASDatabaseEntities(); List <PhysicianDataModel> list = new List <PhysicianDataModel>(); PhysicianDataModel dt = new PhysicianDataModel(); var getData = from p in db.Physicians join s in db.SpecializationDatas on p.SpecializationID equals s.SpecializationID join u in db.Users on p.UserID equals u.UserID where p.FirstName != null select new { p.PhysicianID, p.FirstName, p.LastName, p.Gender, p.TotalExperience, p.Education, p.CurrentStatus, s.SpecializationName, u.EmailID }; foreach (var item in getData) { list.Add(new PhysicianDataModel { PhysicianID = item.PhysicianID, FirstName = item.FirstName, LastName = item.LastName, Gender = item.Gender, TotalExperience = item.TotalExperience, Education = item.Education, CurrentStatus = item.CurrentStatus, SpecializationName = item.SpecializationName, EmailID = item.EmailID, }); } dt.ListPhysician = list; return(View(dt)); }
public ActionResult ViewPatient() { CASDatabaseEntities db = new CASDatabaseEntities(); List <PatientDataModel> list = new List <PatientDataModel>(); PatientDataModel dt = new PatientDataModel(); var getData = from p in db.Patients join u in db.Users on p.UserID equals u.UserID where p.FirstName != null select new { p.PatientID, p.FirstName, p.LastName, p.DOB, p.Gender, p.Address, p.ContactNo, p.EmgContactName, p.EmgContactNo, u.EmailID }; foreach (var item in getData) { list.Add(new PatientDataModel { PatientID = item.PatientID, FirstName = item.FirstName, LastName = item.LastName, DOB = Convert.ToDateTime(item.DOB), Gender = item.Gender, Address = item.Address, ContactNo = item.ContactNo, EmgContactName = item.EmgContactName, EmgContactNo = item.EmgContactNo, EmailID = item.EmailID, }); } dt.ListPatient = list; return(View(dt)); }
public ActionResult EditDetails(SupplierDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); Supplier objSupplier = new Supplier(); var id = Convert.ToInt32(Session["UserID"]); var getData = db.Suppliers.Where(a => a.UserID == id).FirstOrDefault(); if (ModelState.IsValid) { if (getData != null) { getData.FirstName = dt.FirstName; getData.LastName = dt.LastName; getData.CompanyName = dt.CompanyName; getData.CompanyAddress = dt.CompanyAddress; getData.CurrentStatus = dt.CurrentStatus; } else { objSupplier.FirstName = dt.FirstName; objSupplier.LastName = dt.LastName; objSupplier.CompanyName = dt.CompanyName; objSupplier.CompanyAddress = dt.CompanyAddress; objSupplier.CurrentStatus = dt.CurrentStatus; db.Suppliers.Add(objSupplier); } db.SaveChanges(); } var checkName = db.Suppliers.Where(a => a.UserID == id).FirstOrDefault(); if (checkName.FirstName != null) { Session["Name"] = checkName.FirstName; } else { Session["Name"] = null; } Session["ID"] = checkName.SupplierID; return(View(dt)); }
public ActionResult Inbox(int?ID, InboxDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); Inbox objInbox = new Inbox(); var id = Convert.ToInt32(ID); var getData = db.SalespersonOrderDetails.Where(m => m.SalespersonOrderID == id).FirstOrDefault(); if (ModelState.IsValid) { if (getData != null) { var supplierData = (from o in db.SalespersonOrderDetails join s in db.Suppliers on o.SupplierID equals s.SupplierID join u in db.Users on s.UserID equals u.UserID where o.SalespersonOrderID == id select new { u.EmailID }).FirstOrDefault(); string ToEmailID = supplierData.EmailID; objInbox.FromEmailID = Session["EmailID"].ToString(); objInbox.ToEmailID = ToEmailID; objInbox.Subject = dt.Subject; objInbox.MessageDetail = dt.MessageDetail; objInbox.MessageDate = DateTime.Now; objInbox.IsRead = false; db.Inboxes.Add(objInbox); db.SaveChanges(); ViewBag.text = "Message Sent"; } } else { ViewBag.text = "Message Not Sent"; } return(View(dt)); }
public ActionResult MakeAppointments(AppointmentDataModel dt) { CASDatabaseEntities db = new CASDatabaseEntities(); Appointment objAppointment = new Appointment(); var id = Convert.ToInt32(Session["UserID"]); var getData = db.Patients.Where(m => m.UserID == id).FirstOrDefault(); if (ModelState.IsValid) { GetLists(dt); if (getData != null) { if (dt.AppointmentDate.DayOfWeek == 0 || (dt.AppointmentDate.Hour < 9 || dt.AppointmentDate.Hour > 17)) { ViewBag.text = "Please Enter Time Between 9 AM and 5 PM"; } else if (dt.AppointmentDate.Date < DateTime.Today) { ViewBag.text = "Please Enter a Valid Date"; } else { objAppointment.PatientID = getData.PatientID; objAppointment.PhysicianID = dt.PhysicianID; objAppointment.Subject = dt.Subject; objAppointment.Description = dt.Description; objAppointment.AppointmentDate = dt.AppointmentDate; objAppointment.AppointmentStatus = "Requested"; db.Appointments.Add(objAppointment); db.SaveChanges(); ViewBag.text = "Appointment Requested"; } } else { ViewBag.text = "Cannot Request Appointment"; } } return(View(dt)); }