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));
}
