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