public ActionResult Register(DataModel dm)
{
Clinic_automation_systemEntities db = new Clinic_automation_systemEntities();
System.Data.Entity.Core.Objects.ObjectParameter Memberid = new System.Data.Entity.Core.Objects.ObjectParameter("id", typeof(int));
if (ModelState.IsValid)
{
db.AddMember(dm.Email, dm.Password, dm.RoleId, Memberid);
db.SaveChanges();
dm.MemberId = Convert.ToInt32(Memberid.Value);
Session["MemberId"] = dm.MemberId;
ViewBag.text = "Registerd Successfuly";
}
List <SelectListItem> lst = new List <SelectListItem>();
var getdata = db.RoleDetails.ToList();
for (int i = 0; i < 3; i++)
{
lst.Add(new SelectListItem
{
Text = getdata[i].RoleName,
Value = getdata[i].RoleId.ToString()
});
}
dm.RoleList = lst;
return(View(dm));
}
public ActionResult ViewAllMessage(DataModel dt)
{
List <DataModel> dlst = new List <DataModel>();
Clinic_automation_systemEntities db = new Clinic_automation_systemEntities();
Inbox obj = new Inbox();
obj.FromEmailId = dt.DMail;
obj.ToEmailId = dt.PMail;
obj.Subject = dt.Subject;
obj.MessageDetail = dt.MessageDetails;
obj.MessageDate = DateTime.Now;
obj.ReplyId += 1;
db.Inboxes.Add(obj);
db.SaveChanges();
var getdata = db.Inboxes.Where(m => (m.FromEmailId == dt.DMail && m.ToEmailId == dt.PMail) || (m.FromEmailId == dt.PMail && m.ToEmailId == dt.DMail)).ToList();
foreach (var item in getdata)
{
dlst.Add(new DataModel
{
From = item.FromEmailId,
MessageDetails = item.MessageDetail,
MsgDate = item.MessageDate
});
}
dt.MsgViewList = dlst;
return(View(dt));
}
public ActionResult EditProfile(DataModel dt)
{
Clinic_automation_systemEntities db = new Clinic_automation_systemEntities();
var id = Convert.ToInt32(Session["MemberId"]);
dt.MemberId = id;
Doctor objDoctor = new Doctor();
var getdata = db.Doctors.Where(m => m.MemberId == id).FirstOrDefault();
if (getdata != null)
{
getdata.FirstName = dt.FirstName;
getdata.LastName = dt.LastName;
getdata.Gender = dt.Gender;
getdata.SpecializedId = dt.SpecializationId;
getdata.TotalExperience = dt.TotalExperience;
}
else
{
objDoctor.FirstName = dt.FirstName;
objDoctor.LastName = dt.LastName;
objDoctor.TotalExperience = dt.TotalExperience;
objDoctor.Gender = dt.Gender;
objDoctor.SpecializedId = dt.SpecializationId;
objDoctor.MemberId = dt.MemberId;
db.Doctors.Add(objDoctor);
}
db.SaveChanges();
ViewBag.text = "data inserted";
List <SelectListItem> lst = new List <SelectListItem>();// LOCAL LIST
var getSpec = db.SpecializedDetails.ToList();
foreach (var item in getSpec)
{
lst.Add(new SelectListItem
{
Text = item.SpecializedName,
Value = item.SpecializedId.ToString()
});
dt.SpecList = lst;
}
var chkname = db.Doctors.Where(m => m.MemberId == id).FirstOrDefault();
if (chkname != null)
{
Session["name"] = chkname.FirstName;
}
else
{
Session["name"] = null;
}
return(View(dt));
}
public ActionResult DeleteDrug(string id)
{
Clinic_automation_systemEntities db = new Clinic_automation_systemEntities();
var did = Convert.ToInt32(id);
var getdata = db.Drugs.Where(m => m.DrugId == did).FirstOrDefault();
getdata.IsDeleted = true;
db.SaveChanges();
return(RedirectToAction("ViewEditDrugs", "Admin"));
}
public ActionResult UpdateAppointments(int id, string str)
{
Clinic_automation_systemEntities db = new Clinic_automation_systemEntities();
var obj = db.DoctorAppointments.Where(m => m.AppointmentId == (id)).FirstOrDefault();
obj.AppointmentStatus = str;
db.SaveChanges();
return(RedirectToAction("ViewAppointment", "Doctor"));
}
public ActionResult OrderDrug(DrugModel dm)
{
Clinic_automation_systemEntities db = new Clinic_automation_systemEntities();
var getqty = db.Drugs.Where(m => m.DrugId == dm.DrugId).FirstOrDefault();
int id = Convert.ToInt32(Session["MemberId"]);
var getpid = db.Patients.Where(m => m.MemberId == id).FirstOrDefault();
int month = DateTime.Now.Month;
PatientOrderDetail obj = new PatientOrderDetail();
if (dm.OrderQuantity < getqty.TotalQuantityAvailable)
{
obj.PatientId = getpid.PatientId;
obj.DrugId = dm.DrugId;
obj.OrderDate = DateTime.Now;
obj.Quantity = dm.OrderQuantity;
obj.OrderStatus = "Requested";
db.PatientOrderDetails.Add(obj);
getqty.TotalQuantityAvailable = getqty.TotalQuantityAvailable - dm.OrderQuantity;
db.SaveChanges();
ViewBag.text = "Order placed successfully";
}
else
{
ViewBag.text = "Order Quantity cannot exceed Total Quantity";
}
var getdata = db.Drugs.Where(m => m.IsDeleted == false).ToList();
List <SelectListItem> lst = new List <SelectListItem>();
if (getdata != null)
{
foreach (var item in getdata)
{
lst.Add(new SelectListItem
{
Text = item.DrugName,
Value = item.DrugId.ToString()
});
}
dm.DrugNameList = lst;
}
return(View(dm));
}
public ActionResult EditProfile(DataModel dt)
{
Clinic_automation_systemEntities db = new Clinic_automation_systemEntities();
var id = Convert.ToInt32(Session["MemberId"]);
dt.MemberId = id;
var getdata = db.Suppliers.Where(m => m.MemberId == id).FirstOrDefault();
Supplier objSupplier = new Supplier();
if (getdata != null)
{
getdata.FirstName = dt.FirstName;
getdata.LastName = dt.LastName;
getdata.CompanyName = dt.CompanyName;
getdata.CompanyAddress = dt.CompanyAddress;
}
else
{
objSupplier.FirstName = dt.FirstName;
objSupplier.LastName = dt.LastName;
objSupplier.CompanyName = dt.CompanyName;
objSupplier.CompanyAddress = dt.CompanyAddress;
objSupplier.MemberId = dt.MemberId;
db.Suppliers.Add(objSupplier);
}
db.SaveChanges();
var chkname = db.Suppliers.Where(m => m.MemberId == id).FirstOrDefault();
if (chkname != null)
{
Session["name"] = chkname.FirstName;
}
else
{
Session["name"] = null;
}
ViewBag.text = "data inserted";
return(View(dt));
}
public ActionResult EditProfile(DataModel dt)
{
var id = Convert.ToInt32(Session["MemberId"]);
Clinic_automation_systemEntities db = new Clinic_automation_systemEntities();
Patient objPatient = new Patient();
var getdata = db.Patients.Where(m => m.MemberId == id).FirstOrDefault();
if (getdata != null)
{
getdata.FirstName = dt.FirstName;
getdata.LastName = dt.LastName;
getdata.DateOfBirth = dt.DOB;
getdata.Address = dt.Address;
getdata.Gender = dt.Gender;
}
else
{
objPatient.FirstName = dt.FirstName;
objPatient.LastName = dt.LastName;
objPatient.Gender = dt.Gender;
objPatient.DateOfBirth = dt.DOB;
objPatient.Address = dt.Address;
objPatient.MemberId = Convert.ToInt32(Session["MemberId"]);
db.Patients.Add(objPatient);
}
db.SaveChanges();
ViewBag.text = "Data inserted successfully.";
var chkname = db.Patients.Where(m => m.MemberId == id).FirstOrDefault();
if (chkname != null)
{
Session["name"] = chkname.FirstName;
}
else
{
Session["name"] = null;
}
return(View(dt));
}
public ActionResult AddDrugDetails(DrugModel dt)
{
Clinic_automation_systemEntities db = new Clinic_automation_systemEntities();
Drug objdrug = new Drug();
if (ModelState.IsValid)
{
objdrug.DrugName = dt.DrugName;
objdrug.UsedFor = dt.UsedFor;
objdrug.SideEffects = dt.SideEffects;
objdrug.ManufactureDate = dt.ManufactureDate;
objdrug.ExpiryDate = dt.ExpiryDate;
objdrug.TotalQuantityAvailable = dt.TotalQuantity;
db.Drugs.Add(objdrug);
db.SaveChanges();
ViewBag.text = "Added Successfully";
}
return(View());
}
public ActionResult ChangePwd(PwdModel dt)
{
var id = Convert.ToInt32(Session["MemberId"]);
Clinic_automation_systemEntities db = new Clinic_automation_systemEntities();
var getdata = db.MemberLogins.Where(m => m.MemberId == id).FirstOrDefault();
if (ModelState.IsValid)
{
if (getdata.Password == dt.OldPassword)
{
getdata.Password = dt.NewPassword;
db.SaveChanges();
ViewBag.text = "Password Changed Successfully";
}
else
{
ViewBag.text = "You entered a wrong current password";
}
}
return(View());
}
public ActionResult EditDrug(DrugModel dm)
{
Clinic_automation_systemEntities db = new Clinic_automation_systemEntities();
var getdata = db.Drugs.Where(m => m.DrugId == dm.DrugId).FirstOrDefault();
if (ModelState.IsValid)
{
getdata.DrugName = dm.DrugName;
getdata.UsedFor = dm.UsedFor;
getdata.SideEffects = dm.SideEffects;
getdata.ManufactureDate = dm.ManufactureDate;
getdata.ExpiryDate = dm.ExpiryDate;
getdata.IsDeleted = dm.IsDeleted;
getdata.TotalQuantityAvailable = dm.TotalQuantity;
db.SaveChanges();
return(RedirectToAction("ViewEditDrugs", "Admin"));
}
else
{
ViewBag.text = "no";
}
return(View());
}
public ActionResult Message(DataModel dt)
{
Clinic_automation_systemEntities db = new Clinic_automation_systemEntities();
var id = Convert.ToInt32(Session["MemberId"]);
var getfromemail = db.MemberLogins.Where(m => m.MemberId == id).FirstOrDefault();
var docid = db.Doctors.Where(m => m.DoctorId == dt.DoctorId).FirstOrDefault();
var gettoemail = db.MemberLogins.Where(m => m.MemberId == docid.MemberId).FirstOrDefault();
Inbox obj = new Inbox();
obj.FromEmailId = getfromemail.Email;
obj.ToEmailId = gettoemail.Email;
obj.Subject = dt.Subject;
obj.MessageDetail = dt.MessageDetails;
obj.MessageDate = DateTime.Now;
obj.ReplyId = 0;
obj.IsRead = false;
db.Inboxes.Add(obj);
db.SaveChanges();
ViewBag.text = "Message Sent";
return(View());
}