//
// POST: /MemberTypeSetup/Delete/5
public ActionResult AutocompleteMemberType(string s)
{
EHMSEntities ent = new EHMSEntities();
List <string> MemberType = new List <string>();
var units = ent.SetupMemberTypes.Where(x => x.MemberTypeName.Contains(s) && x.Status == "A").ToList();
foreach (var item in units)
{
MemberType.Add(item.MemberTypeName);
}
return(Json(MemberType, JsonRequestBehavior.AllowGet));
}
public SetupMemberDependentModel GetRelationWithId(int id)
{
SetupMemberDependentModel obj = new SetupMemberDependentModel();
using (EHMSEntities ent = new EHMSEntities())
{
obj = AutoMapper.Mapper.Map <SetupMemberDependent, SetupMemberDependentModel>(ent.SetupMemberDependents.Where(x => x.SetupMemberDetailID == id).FirstOrDefault());
}
return(obj);
}
public int Delete(int id)
{
int i = 0;
using (EHMSEntities ent = new EHMSEntities())
{
var objToDelete = ent.DesignationWiseSalarySetups.Where(x => x.ID == id).FirstOrDefault();
ent.DesignationWiseSalarySetups.Remove(objToDelete);
i = ent.SaveChanges();
}
return(i);
}
public int Delete(int id)
{
int i = 0;
using (EHMSEntities ent = new EHMSEntities())
{
var objToDelete = ent.ItemBlockSetups.Where(x => x.ItemBlockSetupID == id).FirstOrDefault();
ent.ItemBlockSetups.Remove(objToDelete);
i = ent.SaveChanges();
}
return(i);
}
public void Details(int id)
{
using (EHMSEntities ent = new EHMSEntities())
{
var config = new MapperConfiguration(cfg => {
cfg.CreateMap <SetupHospitalDetail, SetUpHospitalDetailModel>();
});
//AutoMapper.Mapper.CreateMap<SetupHospitalDetails, SetUpHospitalDetailModel>();
var Details = ent.SetupHospitalDetails.Where(x => x.DetailsId == id).FirstOrDefault();
SetUpHospitalDetailModel det = AutoMapper.Mapper.Map <SetupHospitalDetail, SetUpHospitalDetailModel>(Details);
}
}
public int Update(DoctorFeeSetupModel model)
{
int i = 0;
using (EHMSEntities ent = new EHMSEntities())
{
var objtoeditDoctorFeeSetup = ent.SetupDoctorFees.Where(x => x.DoctorFeeID == model.DoctorFeeID).FirstOrDefault();
AutoMapper.Mapper.Map(model, objtoeditDoctorFeeSetup);
i = ent.SaveChanges();
}
return(i);
}
public IpdSearchResults GetNurseDailyReport(int IpdResistration)
{
IpdSearchResults model = new IpdSearchResults();
using (EHMSEntities ent = new EHMSEntities())
{
var IpdMRCommonTest = ent.IpdMRCommonTests.Where(m => m.IpdRegistrationID == IpdResistration).ToList();
foreach (var item in IpdMRCommonTest)
{
var ViewIpdMrCommonTest = new IpdMRCommonTestModel();
{
ViewIpdMrCommonTest.CommonTestName = item.CommonTestName;
ViewIpdMrCommonTest.Details = item.Details;
ViewIpdMrCommonTest.IpdMRcCommonTesDate = (DateTime)item.IpdMRcCommonTesDate;
}
model.IpdMRCommontestList.Add(ViewIpdMrCommonTest);
}
var IpdMRMainTest = ent.IpdMrMainTests.Where(m => m.IpdRegistrationMasterID == IpdResistration).ToList();
foreach (var items in IpdMRMainTest)
{
var ViewMainTest = new IpdMrMainTestModel();
{
ViewMainTest.SectionId = items.SectionID;
ViewMainTest.TestID = items.TestID;
ViewMainTest.ShortDescription = items.ShortDescription;
ViewMainTest.LongDescription = items.LongDescription;
}
model.IpdMrMainTestList.Add(ViewMainTest);
}
var IpdMRMedecinTestRepor = ent.IpdMrMedicineRecords.Where(m => m.IpdRegisterationID == IpdResistration).ToList();
foreach (var itemss in IpdMRMedecinTestRepor)
{
var ViewMedicineRecord = new IpdMedicalRecord();
{
ViewMedicineRecord.MedicineName = itemss.MedicineName;
ViewMedicineRecord.Doses = itemss.Doses;
ViewMedicineRecord.DosesTotalDays = itemss.DosesTotalDays;
ViewMedicineRecord.DosesTimes = itemss.DosesTimes;
}
model.IpdMedecalRecordList.Add(ViewMedicineRecord);
}
return(model);
}
}
public List <DietTypeSetupViewModel> GetDietTypeList()
{
using (EHMSEntities ent = new EHMSEntities())
{
List <DietTypeSetupViewModel> List = ent.DietTypeSetups.Select(x => new DietTypeSetupViewModel()
{
DietTypeSetupId = x.DietTypeSetupId,
TypeName = x.TypeName
}).ToList();
return(List);
}
}
public int Delete(int IpdRoomId)
{
using (EHMSEntities ent = new EHMSEntities())
{
var objToDelete = ent.SetupHospitalFeeDiscounts.Where(x => x.FeeDiscountId == IpdRoomId).FirstOrDefault();
// var objtodelete = ent.StudentRecords.Where(x => x.StudentRecordId == StudentRecordId).FirstOrDefault();
ent.SetupHospitalFeeDiscounts.Remove(objToDelete);
ent.SaveChanges();
}
return(1);
}
public void Delete(int id)
{
using (EHMSEntities ent = new EHMSEntities())
{
var data1 = ent.GL_AccSubGroups.Where(x => x.ParentID == id).FirstOrDefault();
if (data1 == null)
{
var data = ent.GL_AccSubGroups.Where(x => x.AccSubGruupID == id).FirstOrDefault();
ent.GL_AccSubGroups.Remove(data);
ent.SaveChanges();
}
}
}
public ActionResult Change(int id, int DepartmentID, int OpdEmerNo)
{
EHMSEntities ent = new EHMSEntities();
IpdRegistrationMasterModel model = new IpdRegistrationMasterModel();
model.OpdNoEmergencyNo = OpdEmerNo;
model.DepartmentID = DepartmentID;
model.passvalues = 1;
int ipdno = ent.IpdRegistrationMasters.Where(x => x.OpdNoEmergencyNo == OpdEmerNo && x.Status == true).SingleOrDefault().IpdRegistrationID;
model.ipdPatientDiagnosisDetailList = new List <IpdPatientDiagnosisDetailsModel>(AutoMapper.Mapper.Map <IEnumerable <IpdPatientDiagnosisDetail>, IEnumerable <IpdPatientDiagnosisDetailsModel> >(ent.IpdPatientDiagnosisDetails.Where(x => x.IpdRegistrationID == ipdno)));
return(View(model));
}
public int Delete(int id)
{
int i = 0;
using (EHMSEntities ent = new EHMSEntities())
{
var objToEdit = ent.SetupOtherTests.Where(x => x.SetupOtherTestId == id).FirstOrDefault();
objToEdit.Status = false;
ent.Entry(objToEdit).State = System.Data.EntityState.Modified;
i = ent.SaveChanges();
}
return(i);
}
public int Delete(int deleteid)
{
using (EHMSEntities ent = new EHMSEntities())
{
var objToDelete = ent.SetupEmployeeTypes.Where(x => x.SetupEmployeeTypeID == deleteid).FirstOrDefault();
ent.SetupEmployeeTypes.Remove(objToDelete);
int i = ent.SaveChanges();
return(i);
}
}
public int Update(DepositMasterModel model)
{
int i = 0;
EHMSEntities ent = new EHMSEntities();
var objToEdit = ent.PatientDepositMasters.Where(x => x.PatientDepositMasterId == model.PatientDepositMasterId).FirstOrDefault();
AutoMapper.Mapper.Map(model, objToEdit);
objToEdit.Status = true;
ent.Entry(objToEdit).State = System.Data.EntityState.Modified;
i = ent.SaveChanges();
return(i);
}
public ActionResult Edit(int id)
{
ItemBlockRecordsModel model = new ItemBlockRecordsModel();
using (EHMSEntities ent = new EHMSEntities())
{
var obj = ent.ItemBlockRecords.Where(x => x.ItemBlcokRecID == id).SingleOrDefault();
AutoMapper.Mapper.Map(obj, model);
model.ItemBlockSetupID = obj.ItemBlockSetup.BlockId;
}
return(View(model));
}
public ActionResult StockReport()
{
EHMSEntities ent = new EHMSEntities();
StockItemMasterModel model = new StockItemMasterModel();
model.StockItemMasterList = Session["report"] as List <StockItemMasterModel>;
if (Session["report"] == null)
{
model.StockItemMasterList = new List <StockItemMasterModel>(AutoMapper.Mapper.Map <IEnumerable <StockItemMaster>, IEnumerable <StockItemMasterModel> >(ent.StockItemMasters).Where(x => x.Status == true));
}
Session["report"] = null;
return(View(model.StockItemMasterList));
}
public List <SetupOtherTestModel> GetlistByDepartmentName(int?DeptId)
{
EHMSEntities ent = new EHMSEntities();
if (DeptId != 0)
{
return(new List <SetupOtherTestModel>(AutoMapper.Mapper.Map <IEnumerable <SetupOtherTest>, IEnumerable <SetupOtherTestModel> >(ent.SetupOtherTests).Where(x => x.Status == true && x.TestTypeID == DeptId)));
}
else
{
return(new List <SetupOtherTestModel>(AutoMapper.Mapper.Map <IEnumerable <SetupOtherTest>, IEnumerable <SetupOtherTestModel> >(ent.SetupOtherTests).Where(x => x.Status == true)));
}
}
public void Update(MemberTypeModel model)
{
using (EHMSEntities ent = new EHMSEntities())
{
var objtoedit = ent.SetupMemberTypes.Where(x => x.MemberTypeID == model.MemberTypeID).FirstOrDefault();
AutoMapper.Mapper.Map(model, objtoedit);
objtoedit.Status = "A";
//objtoedit.ValidUpto = Convert.ToDateTime(model.date);
objtoedit.ValidUpto = DateTime.Now;
ent.Entry(objtoedit).State = System.Data.EntityState.Modified;
ent.SaveChanges();
}
}
public int Insert(SetupEmergencyInvestigationMasterModel model)
{
int i = 0;
using (EHMSEntities ent = new EHMSEntities())
{
var objToSave = AutoMapper.Mapper.Map <SetupEmergencyInvestigationMasterModel, EmergencyInvestigationMaster>(model);
objToSave.Status = "Y";
ent.EmergencyInvestigationMasters.Add(objToSave);
i = ent.SaveChanges();
}
return(i);
}
public void Insert(MemberTypeDiscountModel model)
{
using (EHMSEntities ent = new EHMSEntities())
{
var objToSave = AutoMapper.Mapper.Map <MemberTypeDiscountModel, SetupMemberDiscount>(model);
objToSave.Status = "A";
objToSave.CreatedDate = DateTime.Now;
objToSave.CreatedBy = 1;
ent.SetupMemberDiscounts.Add(objToSave);
ent.SaveChanges();
}
}
public int Insert(SetupBlockModel model)
{
int i = 0;
using (EHMSEntities ent = new EHMSEntities())
{
var objToSave = AutoMapper.Mapper.Map <SetupBlockModel, SetupBlock>(model);
objToSave.Status = "Y";
ent.SetupBlocks.Add(objToSave);
i = ent.SaveChanges();
}
return(i);
}
public void Update(MemberTypeDiscountModel model)
{
using (EHMSEntities ent = new EHMSEntities())
{
var objtoedit = ent.SetupMemberDiscounts.Where(x => x.MemberDiscountID == model.MemberDiscountID).FirstOrDefault();
model.CreatedDate = objtoedit.CreatedDate;
model.CreatedBy = objtoedit.CreatedBy;
AutoMapper.Mapper.Map(model, objtoedit);
objtoedit.Status = "A";
ent.Entry(objtoedit).State = System.Data.EntityState.Modified;
ent.SaveChanges();
}
}
public void Update(SurgeryChargeModel model)
{
EHMSEntities ent = new EHMSEntities();
var obj = ent.SurgeryCharges.Where(x => x.SurgeryChargeId == model.SurgeryChargeId).SingleOrDefault();
AutoMapper.Mapper.Map(model, obj);
obj.Status = true;
decimal PayabelPerTax = Convert.ToDecimal((model.PayableGrandTotal / 100) * Convert.ToDecimal(5));
obj.PayableTaxTotal = PayabelPerTax;
ent.Entry(obj).State = System.Data.EntityState.Modified;
ent.SaveChanges();
}
private void RemoveFromBloodManagementMaster(int BloodDonateId)
{
using (EHMSEntities ent = new EHMSEntities())
{
var objToStockDelete = ent.BloodStockManagements.Where(y => y.SourceFrom == BloodDonateId).FirstOrDefault();
ent.BloodStockManagements.Remove(objToStockDelete);
ent.SaveChanges();
//RemoveAllFunctions(StudentRecordId);
}
//throw new NotImplementedException();
}
public int Insert(SetUpHospitalFeeDiscountModel model)
{
using (EHMSEntities ent = new EHMSEntities())
{
var objToSave = AutoMapper.Mapper.Map <SetUpHospitalFeeDiscountModel, SetupHospitalFeeDiscount>(model);
objToSave.CreatedBy = "1";
objToSave.CreatedDate = DateTime.Now;
objToSave.Status = true;
ent.SetupHospitalFeeDiscounts.Add(objToSave);
ent.SaveChanges();
}
return(1);
}
private void updateBloodStockMasterTable(BloodStockManagementMasterModel modelBloodMaster)
{
using (EHMSEntities ent = new EHMSEntities())
{
BloodStockManagementMaster e = (from e1 in ent.BloodStockManagementMasters
where e1.BloodType == modelBloodMaster.BloodType
select e1).First();
e.QuantityUnit = e.QuantityUnit + modelBloodMaster.QuantityUnit;
e.QuantityML = e.QuantityML + modelBloodMaster.QuantityML;
ent.SaveChanges();
}
}
public int Update(SetUpIpdWardModel model)
{
using (EHMSEntities ent = new EHMSEntities())
{
var objToEdit = ent.SetupIpdWards.Where(x => x.IpdWardId == model.IpdWardId).FirstOrDefault();
AutoMapper.Mapper.Map(model, objToEdit);
ent.Entry(objToEdit).State = System.Data.EntityState.Modified;
ent.SaveChanges();
}
return(1);
}
public ActionResult AutocomplereOpdMaster(string s)
{
EHMSEntities ent = new EHMSEntities();
List <string> items = new List <string>();
var units = ent.OpdMasters.Where(x => (x.FirstName + " " + (x.MiddleName + " " ?? string.Empty) + x.LastName).Contains(s) && x.Status == true).ToList();
foreach (var item in units)
{
items.Add(item.FirstName + " " + (item.MiddleName + " " ?? string.Empty) + item.LastName);
}
//return Json(new { Text = items, value = items }, JsonRequestBehavior.AllowGet);
return(Json(items, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(int id, int newValue)
{
EHMSEntities ent = new EHMSEntities();
var obj = ent.StockReturnIns.Where(x => x.ReturnInId == id).SingleOrDefault();
var objitem = ent.StockItemMasters.Where(x => x.StockItemEntryId == obj.ItemId).SingleOrDefault();
objitem.Quantity = objitem.Quantity - obj.ReturnInQty + newValue;
obj.ReturnInQty = newValue;
ent.Entry(obj).State = System.Data.EntityState.Modified;
ent.Entry(objitem).State = System.Data.EntityState.Modified;
ent.SaveChanges();
return(Json("Successfully Saved!!", JsonRequestBehavior.AllowGet));
}
public int Update(SetupAgentModel model)
{
int i = 0;
EHMSEntities ent = new EHMSEntities();
var objToEdit = ent.SetupAgents.Where(x => x.AgentId == model.AgentId).FirstOrDefault();
AutoMapper.Mapper.Map(model, objToEdit);
// ent.Entry(objToEdit).State = System.Data.EntityState.Modified;
ent.Entry(objToEdit).State = System.Data.EntityState.Modified;
i = ent.SaveChanges();
return(i);
}
