public ActionResult AppointmentDetails()
{
using (KIITEntities db = new KIITEntities())
{
int memid = Convert.ToInt32(Session["Memberid"]);
int doc_id = db.Doctors.Where(a => a.MemberId == memid).Select(a => a.DoctorId).SingleOrDefault();
var patient = db.DoctorAppointments.Where(a => a.DoctorId == doc_id);
List <AppointmentViewModel> lst = new List <AppointmentViewModel>();
foreach (var item in patient)
{
string pat_name = db.Patients.Where(a => a.PatientId == item.PatientId).Select(a => a.FirstName).SingleOrDefault();
lst.Add(new AppointmentViewModel
{
AppId = item.AppointmentId,
PName = pat_name,
Subject = item.Subject,
Description = item.Description,
Date = item.AppointmentDate,
AppStatus = item.AppointmentStatus
});
}
AppointmentViewModel model = new AppointmentViewModel();
model.lst = lst;
return(View(model));
}
}
public ActionResult JS_Drugs()
{
int memid = Convert.ToInt32(Session["Memberid"]);
using (KIITEntities db = new KIITEntities())
{
var data = db.Drugs;
List <DrugModel> lst = new List <DrugModel>();
foreach (var item in data)
{
lst.Add(new DrugModel
{
DrugId = item.DrugId,
DrugName = item.DrugName,
Man_Date = item.ManufactureDate,
Exp_Date = item.ExpiredDate,
UsedFor = item.UsedFor,
SideEffects = item.SideEffects,
Quantity = item.TotalQuantityAvailable,
});
}
DrugModel model = new DrugModel();
model.lstDrugs = lst;
return(View(model));
}
}
public ActionResult View_Messages()
{
int memid = Convert.ToInt32(Session["Memberid"]);
using (KIITEntities db = new KIITEntities())
{
string email = db.MemberLogins.Where(a => a.MemberId == memid).Select(a => a.EmailId).SingleOrDefault();
var sent_data = db.Inboxes.Where(a => (a.FromEmailId == email) || (a.ToEmailId == email));
List <MessageViewModel> lst = new List <MessageViewModel>();
foreach (var item in sent_data)
{
lst.Add(new MessageViewModel
{
From_Email = item.FromEmailId,
To_Email = item.ToEmailId,
Subject = item.Subject,
MessageDetail = item.MessageDetail,
Date = item.MessageDate
});
}
MessageViewModel model = new MessageViewModel();
model.lstMessage = lst;
return(View(model));
}
}
public ActionResult View_Order_Details()
{
int memid = Convert.ToInt32(Session["Memberid"]);
using (KIITEntities db = new KIITEntities())
{
int sid = db.Suppliers.Where(a => a.MemberId == memid).Select(a => a.SupplierId).SingleOrDefault();
var data = from pod in db.PatientOrderDetails
join dd in db.DrugDeliveries on pod.OrderId equals dd.OrderId
where dd.SupplierId == sid
select new { pod.DrugId, pod.Quantity, pod.OrderedDate, dd.OrderId, pod.OrderStatus, pod.OrderNumber, dd.DeliveredDate, pod.PatientId };
List <DrugViewModel> lst = new List <DrugViewModel>();
foreach (var item in data)
{
string pat_name = db.Patients.Where(a => a.PatientId == item.PatientId).Select(a => a.FirstName).FirstOrDefault();
string drug_name = db.Drugs.Where(a => a.DrugId == item.DrugId).Select(a => a.DrugName).SingleOrDefault();
lst.Add(new DrugViewModel
{
OrderNumber = item.OrderNumber,
PatientName = pat_name,
DeliveryDate = Convert.ToDateTime(item.DeliveredDate),
DrugName = drug_name,
Quantity = item.Quantity,
OrderDate = item.OrderedDate,
OrderId = item.OrderId,
OrderStatus = item.OrderStatus
});
}
DrugViewModel model = new DrugViewModel();
model.lstData = lst;
return(View(model));
}
}
public ActionResult Login(LoginViewModel model)
{
using (KIITEntities db = new KIITEntities())
{
var checkuser = (from m in db.MemberLogins
join r in db.RoleDetails on m.RoleId equals r.RoleId
where m.EmailId == model.Username && m.Password == model.PassWord
select new { m.EmailId, r.RoleName, m.MemberId }).FirstOrDefault();
if (checkuser != null && checkuser.RoleName == "Admin")
{
FormsAuthentication.SetAuthCookie(checkuser.EmailId, false);
var authTicket = new FormsAuthenticationTicket(2, // version
checkuser.EmailId, //username
DateTime.Now, // current date and time
DateTime.Now.AddMinutes(10), // time out
false,
"Admin" //userdata , store a role
);
string encryptedTicket = FormsAuthentication.Encrypt(authTicket);
var authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
Response.Cookies.Add(authCookie);
Session["Memberid"] = checkuser.MemberId;
return(RedirectToAction("DashBoard", "Admin"));
}
else
{
ViewBag.message = "Invalid Credentials";
}
}
return(View());
}
public ActionResult View_Order_Details()
{
int memid = Convert.ToInt32(Session["Memberid"]);
using (KIITEntities db = new KIITEntities())
{
var data = db.PatientOrderDetails.Select(a => new { a.DrugId, a.OrderNumber, a.Quantity, a.OrderedDate, a.OrderStatus });
List <DrugViewModel> lst = new List <DrugViewModel>();
foreach (var item in data)
{
string drug_name = db.Drugs.Where(a => a.DrugId == item.DrugId).Select(a => a.DrugName).SingleOrDefault();
lst.Add(new DrugViewModel
{
OrderNumber = item.OrderNumber,
DrugName = drug_name,
Quantity = item.Quantity,
OrderDate = item.OrderedDate,
OrderStatus = item.OrderStatus
});
}
DrugViewModel model = new DrugViewModel();
model.lstData = lst;
return(View(model));
}
}
public ActionResult EditProfile()
{
using (KIITEntities db = new KIITEntities())
{
int memid = Convert.ToInt32(Session["Memberid"]);
var getdata = db.Doctors.SingleOrDefault(a => a.MemberId == memid);
DoctorViewModel model = new DoctorViewModel();
if (getdata != null)
{
model.FirstName = getdata.FirstName;
model.LastName = getdata.LastName;
model.Gender = getdata.Gender;
model.TotalExperience = getdata.TotalExperience;
model.SpecializedId = getdata.SpecializedId;
model.lstSpec = CommonData.GetSpecs();
return(View(model));
}
else
{
model.lstSpec = CommonData.GetSpecs();
return(View(model));
}
}
}
public ActionResult View_App_Details()
{
using (KIITEntities db = new KIITEntities())
{
int memid = Convert.ToInt32(Session["Memberid"]);
var p = db.Patients.Where(a => a.MemberId == memid).Select(a => new { a.FirstName, a.PatientId }).SingleOrDefault();
var da = db.DoctorAppointments.Where(a => a.PatientId == p.PatientId);
List <DoctorAppointmentViewModel> lst = new List <DoctorAppointmentViewModel>();
foreach (var item in da)
{
var d = db.Doctors.Where(a => a.DoctorId == item.DoctorId).SingleOrDefault();
lst.Add(new DoctorAppointmentViewModel
{
PatientName = p.FirstName,
DoctorName = d.FirstName,
Subject = item.Subject,
Description = item.Description,
AppointmentDate = item.AppointmentDate,
AppointmentStatus = item.AppointmentStatus
});
}
DoctorAppointmentViewModel model = new DoctorAppointmentViewModel();
model.lstApp = lst;
return(View(model));
}
}
public JsonResult UpdateStatus(AppointmentViewModel model)
{
using (KIITEntities entities = new KIITEntities())
{
entities.UpdateAppStatus(model.AppStatus, model.AppId);
}
return(Json(model));
}
public ActionResult UpdateDrug(DrugModel drug)
{
using (KIITEntities entities = new KIITEntities())
{
entities.UpdateDrug(drug.DrugId, drug.DrugName, drug.Man_Date, drug.Exp_Date, drug.UsedFor, drug.SideEffects, drug.Quantity);
}
return(new EmptyResult());
}
public JsonResult DeleteDrug(DrugModel drug)
{
using (KIITEntities entities = new KIITEntities())
{
entities.RemoveDrug(drug.DrugId);
}
return(Json(drug));
}
public JsonResult InsertDrug(DrugModel drug)
{
using (KIITEntities entities = new KIITEntities())
{
entities.InsertDrug(drug.DrugName, drug.Man_Date, drug.Exp_Date, drug.UsedFor, drug.SideEffects, drug.Quantity);
}
return(Json(drug));
}
public ActionResult UpdateMessage(MessageViewModel message)
{
using (KIITEntities entities = new KIITEntities())
{
entities.InsertReplyMessage(message.From_Email, message.To_Email, message.Subject, message.MessageDetail, DateTime.Now, message.MessageId);
entities.UpdateMessageStatus(message.MessageId);
}
return(Json(message));
}
// GET: Supplier
public ActionResult DashBoard()
{
using (KIITEntities db = new KIITEntities())
{
DashView model = new DashView();
model.TotOrd = db.PatientOrderDetails.Count();
model.DelOrd = db.PatientOrderDetails.Where(a => a.OrderStatus == "Delivered").Count();
model.DisOrd = db.PatientOrderDetails.Where(a => a.OrderStatus == "Dispatched").Count();
model.ReqOrd = db.PatientOrderDetails.Where(a => a.OrderStatus == "Requested").Count();
return(View(model));
}
}
public ActionResult Send_Message(MessageViewModel model)
{
int memid = Convert.ToInt32(Session["Memberid"]);
MessageViewModel p_model = new MessageViewModel();
p_model.lstDocId = CommonData.GetDocsId();
using (KIITEntities db = new KIITEntities())
{
string email = db.MemberLogins.Where(a => a.MemberId == memid).Select(a => a.EmailId).SingleOrDefault();
db.InsertMessage(email, model.To_Email, model.Subject, model.MessageDetail, DateTime.Now, model.ReplyId, 0);
}
return(View(p_model));
}
public ActionResult UpdateStatus(DrugViewModel drug)
{
using (KIITEntities db = new KIITEntities())
{
db.UpdateOrderStatus(drug.OrderStatus, drug.OrderId);
if (drug.OrderStatus == "Delivered")
{
int did = db.DrugDeliveries.Where(a => a.OrderId == drug.OrderId).Select(a => a.DeliveryId).SingleOrDefault();
db.UpdateDeliveryDate(did, DateTime.Now);
}
}
return(Json(drug));
}
public ActionResult Register(MemberViewModel model)
{
MemberViewModel model_post = new MemberViewModel();
model_post.lstRoles = CommonData.GetRoles();
if (model.EmailId != null && model.Password != null && model.RoleId != 0)
{
KIITEntities db = new KIITEntities();
db.InsertMember(model.EmailId, model.Password, model.RoleId);
return(View(model_post));
}
else
{
return(View(model_post));
}
}
public ActionResult Doctor_Appointment(DoctorAppointmentViewModel model)
{
int memid = Convert.ToInt32(Session["Memberid"]);
DoctorAppointmentViewModel model_post = new DoctorAppointmentViewModel();
model_post.lstDocs = CommonData.GetDocs();
if (model.PatientName != null && model.Subject != null && model.DoctorId != 0)
{
KIITEntities db = new KIITEntities();
int p_id = db.Patients.Where(a => a.MemberId == memid).Select(a => a.PatientId).SingleOrDefault();
db.InsertAppointment(p_id, model.DoctorId, model.Subject, model.Description, model.AppointmentDate);
return(View(model_post));
}
else
{
return(View(model_post));
}
}
public ActionResult InsertSupplier(DrugViewModel drug)
{
using (KIITEntities entities = new KIITEntities())
{
var quan = (from d in entities.Drugs where d.DrugId == drug.DrugId select d.TotalQuantityAvailable).FirstOrDefault();
if (drug.Quantity < quan)
{
entities.InsertDelivery(drug.OrderId, drug.SupplierId);
entities.UpdateDQuan(quan - drug.Quantity, drug.DrugId);
}
else
{
throw new Exception("abc");
}
}
return(Json(drug));
}
// GET: Patient
public ActionResult DashBoard()
{
int memid = Convert.ToInt32(Session["Memberid"]);
using (KIITEntities db = new KIITEntities())
{
DashView model = new DashView();
int pid = db.Patients.Where(a => a.MemberId == memid).Select(a => a.PatientId).SingleOrDefault();
model.App = db.DoctorAppointments.Where(a => a.PatientId == pid).Count();
model.AprApp = db.DoctorAppointments.Where(a => (a.PatientId == pid) && (a.AppointmentStatus == "Accept")).Count();
model.RejApp = db.DoctorAppointments.Where(a => (a.PatientId == pid) && (a.AppointmentStatus == "Reject")).Count();
model.ProcApp = db.DoctorAppointments.Where(a => (a.PatientId == pid) && (a.AppointmentStatus == "Requested")).Count();
model.TotOrd = db.PatientOrderDetails.Where(a => a.PatientId == pid).Count();
model.DelOrd = db.PatientOrderDetails.Where(a => (a.PatientId == pid) && (a.OrderStatus == "Delivered")).Count();
model.ReqOrd = db.PatientOrderDetails.Where(a => (a.PatientId == pid) && (a.OrderStatus == "Requested") || (a.OrderStatus == "Dispatched")).Count();
return(View(model));
}
}
public ActionResult Raise_Drug_Request(DrugViewModel model)
{
int memid = Convert.ToInt32(Session["Memberid"]);
DrugViewModel model_post = new DrugViewModel();
model_post.lstDrugs = CommonData.GetDrugs();
int day = DateTime.Now.Day;
int hrs = DateTime.Now.Hour;
int min = DateTime.Now.Minute;
int sec = DateTime.Now.Second;
string odrno = string.Format("{0}{1}{2}{3}", day, hrs, min, sec);
using (KIITEntities db = new KIITEntities())
{
int p_id = db.Patients.Where(a => a.MemberId == memid).Select(a => a.PatientId).SingleOrDefault();
db.OrderDrug(p_id, model.DrugId, Convert.ToInt32(odrno), model.Quantity, DateTime.Now);
}
return(View(model_post));
}
// GET: Doctor
public ActionResult DashBoard()
{
int memid = Convert.ToInt32(Session["Memberid"]);
using (KIITEntities db = new KIITEntities())
{
DashView model = new DashView();
string doceid = db.MemberLogins.Where(a => a.MemberId == memid).Select(a => a.EmailId).SingleOrDefault();
int docid = db.Doctors.Where(a => a.MemberId == memid).Select(a => a.DoctorId).SingleOrDefault();
model.App = db.DoctorAppointments.Where(a => a.DoctorId == docid).Count();
model.AprApp = db.DoctorAppointments.Where(a => (a.AppointmentStatus == "Accept") && (a.DoctorId == docid)).Count();
model.RejApp = db.DoctorAppointments.Where(a => (a.AppointmentStatus == "Reject") && (a.DoctorId == docid)).Count();
model.ProcApp = db.DoctorAppointments.Where(a => (a.AppointmentStatus == "Requested") && (a.DoctorId == docid)).Count();
model.Inbox = db.Inboxes.Where(a => a.ToEmailId == doceid).Count();
model.RInbox = db.Inboxes.Where(a => (a.ToEmailId == doceid) && (a.IsRead == true)).Count();;
model.URInbox = db.Inboxes.Where(a => (a.ToEmailId == doceid) && (a.IsRead == false)).Count();;
return(View(model));
}
}
public ActionResult Change_Password(LoginViewModel model)
{
int memid = Convert.ToInt32(Session["Memberid"]);
using (KIITEntities db = new KIITEntities())
{
var getdata = db.MemberLogins.FirstOrDefault(a => a.MemberId == memid);
if (model.Old_Password == getdata.Password)
{
db.UpdatePassword(model.PassWord, memid);
ViewBag.message = "Password Updated";
}
else
{
ViewBag.message = "Wrong Password Entered";
}
}
return(View());
}
public ActionResult View_Order_Details()
{
string sname;
int memid = Convert.ToInt32(Session["Memberid"]);
using (KIITEntities db = new KIITEntities())
{
var data = db.PatientOrderDetails;
List <DrugViewModel> lst = new List <DrugViewModel>();
foreach (var item in data)
{
string drug_Name = db.Drugs.Where(a => a.DrugId == item.DrugId).Select(a => a.DrugName).SingleOrDefault();
int sid = db.DrugDeliveries.Where(a => a.OrderId == item.OrderId).Select(a => a.SupplierId).SingleOrDefault();
if (sid > 0)
{
sname = db.Suppliers.Where(a => a.SupplierId == sid).Select(a => a.FirstName).SingleOrDefault();
}
else
{
sname = null;
}
lst.Add(new DrugViewModel
{
OrderId = item.OrderId,
DrugId = item.DrugId,
OrderNumber = item.OrderNumber,
DrugName = drug_Name,
Quantity = item.Quantity,
OrderDate = item.OrderedDate,
SupplierName = sname
});
}
DrugViewModel model = new DrugViewModel();
model.lstShowDrugs = lst;
model.lstSupplier = CommonData.GetSuppliers();
return(View(model));
}
}
public ActionResult EditProfile(SupplierViewModel model)
{
int memid = Convert.ToInt32(Session["Memberid"]);
using (KIITEntities db = new KIITEntities())
{
var getdata = db.Suppliers.FirstOrDefault(a => a.MemberId == memid);
if (getdata != null)
{
db.UpdateSupplier(model.FirstName, model.LastName, model.CompanyName, model.CompanyAddress, memid);
ViewBag.message = "Updated";
}
else
{
db.InsertSupplier(model.FirstName, model.LastName, model.CompanyName, model.CompanyAddress, memid);
ViewBag.message = "Inserted";
}
}
return(View());
}
public ActionResult EditProfile()
{
using (KIITEntities db = new KIITEntities())
{
int memid = Convert.ToInt32(Session["Memberid"]);
ProfileViewModel model = new ProfileViewModel();
var getdata = db.Admins.SingleOrDefault(a => a.MemberId == memid);
if (getdata != null)
{
model.FirstName = getdata.FirstName;
model.LastName = getdata.LastName;
model.Gender = getdata.Gender;
model.Address = getdata.Address;
return(View(model));
}
else
{
return(View());
}
}
}
public ActionResult EditProfile(ProfileViewModel model)
{
int memid = Convert.ToInt32(Session["Memberid"]);
using (KIITEntities db = new KIITEntities())
{
var getdata = db.Patients.FirstOrDefault(a => a.MemberId == memid);
if (getdata != null)
{
db.UpdatePatient(model.FirstName, model.LastName, model.DateOfBirth, model.Gender, model.Address, memid);
ViewBag.message = "Updated";
}
else
{
db.InsertPatient(model.FirstName, model.LastName, model.DateOfBirth, model.Gender, model.Address, memid);
ViewBag.message = "Inserted";
}
}
return(View());
}
public ActionResult EditProfile(DoctorViewModel model)
{
int memid = Convert.ToInt32(Session["Memberid"]);
DoctorViewModel model_post = new DoctorViewModel();
model_post.lstSpec = CommonData.GetSpecs();
using (KIITEntities db = new KIITEntities())
{
var getdata = db.Patients.FirstOrDefault(a => a.MemberId == memid);
if (getdata != null)
{
db.UpdateDoctor(model.FirstName, model.LastName, model.TotalExperience, model.SpecializedId, model.Gender, memid);
ViewBag.message = "Updated";
}
else
{
db.InsertDoctor(model.FirstName, model.LastName, model.TotalExperience, model.SpecializedId, model.Gender, memid);
ViewBag.message = "Inserted";
}
}
return(View(model_post));
}