public ActionResult AddModify(int id = 0)
{
using (HISDBEntities dc = new HISDBEntities())
{
List <RoomType> room = (from u in dc.RoomTypes
select new { u })
.OrderBy(b => b.u.RoomTypeID).AsEnumerable()
.Select(x => new RoomType {
RoomTypeID = x.u.RoomTypeID, RoomType1 = x.u.RoomType1
}).ToList();
ViewBag.RoomTypeList = new SelectList(room, "RoomTypeID", "RoomType1");
}
if (id == 0)
{
return(View(new Room()));
}
else
{
using (HISDBEntities db = new HISDBEntities())
{
return(View(db.Rooms.Where(x => x.RoomNo == id).FirstOrDefault <Room>()));
}
}
}
public ActionResult EditPO(List <PurchaseOrder> items)
{
using (HISDBEntities db = new HISDBEntities())
{
if (items != null && items.Count() > 0)
{
foreach (PurchaseOrder po in items)
{
if (po.OrderID == 0)
{
db.PurchaseOrders.Add(po);
}
else
{
db.Entry(po).State = EntityState.Modified;
}
db.SaveChanges();
}
DeletePurchaseOrderItems(items);
return(Json(new { success = true, message = string.Format("PO# - {0} adjusted Successfully", items[0].PONumber) }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = "Error occured" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult GetUsers()
{
using (HISDBEntities hs = new HISDBEntities())
{
var users = (from u in hs.Users
join ut in hs.UserTypes on u.UserTypeID equals ut.UserTypeID
join spl in hs.Specializations on u.SpecializationID equals spl.SpecializationID
select new { u, ut, spl }).AsEnumerable()
.Select(x => new User
{
UserID = x.u.UserID,
NameDisplay = x.u.GetFullName(),
DOBDisplay = x.u.GetDOBFormat(),
GenderDisplay = x.u.GetGender(),
Email = x.u.Email,
Phone = x.u.Phone,
MaritalStatusDisplay = x.u.GetMaritalStatus(),
Qualification = x.u.Qualification,
UserTypeName = x.ut.UserTypeName,
DoctorTypeDisplay = x.spl.DoctorType,
StatusDisplay = x.u.GetUserStatus()
}).ToList();
//var users = (from u in hs.VUsers
// select u).ToList();
return(Json(new { data = users }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetConsultationFeeList()
{
using (HISDBEntities hs = new HISDBEntities())
{
var consultationFees = (from cf in hs.ConsultationFees
join ct in hs.ConsultationTypes on cf.ConsultTypeID equals ct.ConsultTypeID
join u in hs.Users on cf.DoctorID equals u.UserID
select new
{
cf, ct, u
}).AsEnumerable()
.Select(x => new ConsultationFee {
ConsultationID = x.cf.ConsultationID,
DoctorID = x.cf.DoctorID,
ConsultTypeID = x.cf.ConsultTypeID,
Fee = x.cf.Fee,
DoctorName = HtmlHelpers.HtmlHelpers.GetFullName(x.u.FirstName, x.u.MiddleName, x.u.LastName),
ConsultationTypeName = x.ct.ConsultType,
ValidDays = x.cf.ValidDays
})
.ToList();
return(Json(new { data = consultationFees }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Login(FormCollection form)
{
string Username = form["username"].ToString();
string Password = form["password"].ToString();
using (HISDBEntities he = new HISDBEntities())
{
var user = he.Users.Where(a => a.UserName.Equals(Username) && a.Password.Equals(Password)).FirstOrDefault();
if (user != null)
{
Session["UserID"] = user.UserID;
Session["UserName"] = user.UserName;
int cid = Convert.ToInt16(user.UserID);
return(RedirectToAction("../Home/Index"));
}
else
{
ModelState.AddModelError("LoginVal", "The password provided is incorrect.");
// return RedirectToAction("../User/Index");
}
}
// If we got this far, something failed, redisplay form
return(View("Index"));
}
public ActionResult AddModify(MedicineMaster mm)
{
using (HISDBEntities db = new HISDBEntities())
{
if (mm.MMID == 0)
{
//AddSupplierCategories(mm);
db.MedicineMasters.Add(mm);
MedicineInventory mi = new MedicineInventory();
mi.MedicineID = mm.MMID;
mi.AvailableQty = 0;
db.MedicineInventories.Add(mi);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
//AddSupplierCategories(mm);
var mi = db.MedicineInventories.Where(m => m.MedicineID == mm.MMID).FirstOrDefault();
if (mi != null)
{
mi.PricePerItem = mm.ItemPrice;
mi.AvailableQty = mm.AvailableQuantity;
}
db.Entry(mi).State = EntityState.Modified;
db.Entry(mm).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult AddModify(Bed b)
{
using (HISDBEntities db = new HISDBEntities())
{
if (b.BedNo == 0)
{
db.Beds.Add(b);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
try
{
db.Entry(b).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
}
}
public ActionResult AddModify(int id = 0)
{
using (HISDBEntities dc = new HISDBEntities())
{
List <BedType> beds = (from u in dc.BedTypes
select new { u })
.OrderBy(b => b.u.BedTypeID).AsEnumerable()
.Select(x => new BedType {
BedTypeID = x.u.BedTypeID, BedType1 = x.u.BedType1
}).ToList();
ViewBag.BedTypeList = new SelectList(beds, "BedTypeID", "BedType1");
}
List <Room> Rooms = GetRoomIds();
if (id == 0)
{
ViewBag.Rooms = new SelectList(Rooms, "RoomNo", "RoomName");
return(View(new Bed()));
}
else
{
using (HISDBEntities db = new HISDBEntities())
{
var bed = db.Beds.Where(x => x.BedNo == id).FirstOrDefault <Bed>();
ViewBag.Rooms = new SelectList(Rooms, "RoomNo", "RoomName", bed.RoomNo);
return(View(bed));
}
}
}
//Get contact by ID
public ConsultationFee GetConsultationFee(int consulationID)
{
ConsultationFee consultationFee = null;
using (HISDBEntities dc = new HISDBEntities())
{
var v = (from cf in dc.ConsultationFees
join ct in dc.ConsultationTypes on cf.ConsultTypeID equals ct.ConsultTypeID
join u in dc.Users on cf.DoctorID equals u.UserID
where cf.ConsultationID.Equals(consulationID)
select new
{
cf,
u,
ct.ConsultType,
}).FirstOrDefault();
if (v != null)
{
consultationFee = v.cf;
consultationFee.DoctorName = HtmlHelpers.HtmlHelpers.GetFullName(v.u.FirstName, v.u.MiddleName, v.u.LastName);
consultationFee.ConsultationTypeName = v.ConsultType;
}
return(consultationFee);
}
}
private void UpdateMedicineInventory(List <PurchaseOrder> poItems)
{
using (HISDBEntities hs = new HISDBEntities())
{
foreach (PurchaseOrder po in poItems)
{
var minventory = hs.MedicineInventories.Where(mi => mi.MedicineID == po.MedicineID).ToList();
if (minventory != null && minventory.Count() > 0)
{
var m = minventory[0];
m.AvailableQty = m.AvailableQty + po.OrderedQty;
m.PricePerItem = po.PricePerItem;
hs.Entry(m).State = EntityState.Modified;
}
else
{
MedicineInventory newM = new MedicineInventory();
newM.MedicineID = po.MedicineID;
newM.AvailableQty = po.OrderedQty;
hs.MedicineInventories.Add(newM);
}
}
hs.SaveChanges();
}
}
public JsonResult GetShippedMedicines()
{
using (HISDBEntities hs = new HISDBEntities())
{
var shippedMedicines = (from po in hs.PurchaseOrders
join mm in hs.MedicineMasters on po.MedicineID equals mm.MMID
select new
{
po,
mm.MedicineName,
mm.MedDose
}).AsEnumerable().
Select(x => new PurchaseOrder
{
OrderID = x.po.OrderID,
PONumber = x.po.PONumber,
MedicineWithDose = HtmlHelpers.HtmlHelpers.GetMedicineWithDose(x.MedicineName, x.MedDose),
OrderedQty = x.po.OrderedQty,
OrderDateDisplay = HtmlHelpers.HtmlHelpers.DateFormat(x.po.OrderedDate),
ExpiryDateDisplay = HtmlHelpers.HtmlHelpers.DateFormat(x.po.ExpiryDate),
ApprovedStatus = x.po.ApprovedStatus,
PricePerItem = x.po.PricePerItem,
PricePerSheet = x.po.PricePerSheet,
BatchNo = x.po.BatchNo,
LotNo = x.po.LotNo,
MfgDateDisplay = HtmlHelpers.HtmlHelpers.DateFormat(x.po.MfgDate),
HospitalPrice = x.po.HospitalPrice
}).ToList();
return(Json(new { data = shippedMedicines }, JsonRequestBehavior.AllowGet));
}
}
// GET: Revenuerpt
public JsonResult GetReportdata(string doctors, DateTime stdt, DateTime enddt)
{
using (HISDBEntities hs = new HISDBEntities())
{
var data = hs.RevenueReport(doctors, stdt, enddt).ToList();
return(Json(new { data = data }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetScans()
{
using (HISDBEntities hs = new HISDBEntities())
{
var scans = HtmlHelpers.HtmlHelpers.GetScans();
return(Json(new { data = scans }, JsonRequestBehavior.AllowGet));
}
}
// GET: Revenuerpt
public JsonResult GetReportdata()
{
using (HISDBEntities hs = new HISDBEntities())
{
var data = hs.InventoryReport().ToList();
return(Json(new { data = data }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (HISDBEntities db = new HISDBEntities())
{
Permission bg = db.Permissions.Where(x => x.Permission_Id == id).FirstOrDefault <Permission>();
db.Permissions.Remove(bg);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetPermissions()
{
using (HISDBEntities hs = new HISDBEntities())
{
var per = (from bg in hs.Permissions
select new { bg.Permission_Id, bg.PermissionDescription, bg.PermissionStatus }).ToList();
return(Json(new { permissiondata = per }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetUserTypes()
{
using (HISDBEntities hs = new HISDBEntities())
{
var userTypes = (from ut in hs.UserTypes
select new { ut.UserTypeID, ut.UserTypeName }).ToList();
return(Json(new { data = userTypes }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetIntakes()
{
using (HISDBEntities hs = new HISDBEntities())
{
var intakes = (from ifs in hs.IntakeFrequencies
select new { ifs.FrequencyID, ifs.Frequency }).ToList();
return(Json(new { data = intakes }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetPharmaKits()
{
using (HISDBEntities hs = new HISDBEntities())
{
var pKits = (from pk in hs.PharmaKits
select new { pk.PKitID, pk.PKitName, pk.PKitCost }).ToList();
return(Json(new { data = pKits }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (HISDBEntities db = new HISDBEntities())
{
BrandSubCategory scat = db.BrandSubCategories.Where(x => x.SubCategoryID == id).FirstOrDefault <BrandSubCategory>();
db.BrandSubCategories.Remove(scat);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetConsultTypes()
{
using (HISDBEntities hs = new HISDBEntities())
{
var consultTypes = (from ct in hs.ConsultationTypes
select new { ct.ConsultTypeID, ct.ConsultType }).ToList();
return(Json(new { data = consultTypes }, JsonRequestBehavior.AllowGet));
}
}
private int AddSubCategories(string subCategory)
{
using (HISDBEntities db = new HISDBEntities())
{
System.Data.Entity.Core.Objects.ObjectParameter subcatOut = new System.Data.Entity.Core.Objects.ObjectParameter("SubCategoryID", typeof(Int32));
db.AddSubCategory(subCategory, subcatOut);
return(Convert.ToInt32(subcatOut.Value));
}
}
public JsonResult GetPurpose()
{
using (HISDBEntities hs = new HISDBEntities())
{
var purpose = (from p in hs.Purposes
select new { p.PurposeID, p.PurposeName }).ToList();
return(Json(new { data = purpose }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetBloodGroups()
{
using (HISDBEntities hs = new HISDBEntities())
{
var bloodGroups = (from bg in hs.BloodGroups
select new { bg.GroupID, bg.GroupName }).ToList();
return(Json(new { data = bloodGroups }, JsonRequestBehavior.AllowGet));
}
}
private int AddSuppliers(string supplierName)
{
using (HISDBEntities db = new HISDBEntities())
{
System.Data.Entity.Core.Objects.ObjectParameter supplierOut = new System.Data.Entity.Core.Objects.ObjectParameter("SupplierID", typeof(Int32));
db.AddSupplier(supplierName, supplierOut);
return(Convert.ToInt32(supplierOut.Value));
}
}
public ActionResult Delete(int id)
{
using (HISDBEntities db = new HISDBEntities())
{
Supplier splr = db.Suppliers.Where(x => x.SupplierID == id).FirstOrDefault <Supplier>();
db.Suppliers.Remove(splr);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (HISDBEntities db = new HISDBEntities())
{
BloodGroup bg = db.BloodGroups.Where(x => x.GroupID == id).FirstOrDefault <BloodGroup>();
db.BloodGroups.Remove(bg);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetInsuranceProvider()
{
using (HISDBEntities hs = new HISDBEntities())
{
var insProviders = (from ip in hs.InsuranceProviders
select new { ip.ProviderID, ip.ProviderName, ip.Company }).ToList();
return(Json(new { data = insProviders }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (HISDBEntities db = new HISDBEntities())
{
Purpose prpse = db.Purposes.Where(x => x.PurposeID == id).FirstOrDefault <Purpose>();
db.Purposes.Remove(prpse);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Getroomtypes()
{
using (HISDBEntities hs = new HISDBEntities())
{
var roomtype = (from bg in hs.RoomTypes
select new { bg.RoomTypeID, bg.RoomType1 }).ToList();
return(Json(new { data = roomtype }, JsonRequestBehavior.AllowGet));
}
}
