//Doctor Report
public string DoctorReferral(DateTime FromDate, DateTime ToDate, string ProviderName)
{
//DanpheHTTPResponse<List<DoctorReferralReport>> responseData = new DanpheHTTPResponse<List<DoctorReferralReport>>();
DanpheHTTPResponse <DataTable> responseData = new DanpheHTTPResponse <DataTable>();
try
{
ReportingDbContext reportingDbContext = new ReportingDbContext(connString);
// DoctorReport doctorReport = reportingDbContext.DoctorReport(FromDate, ToDate, ProviderName);
DataTable doctorreport = reportingDbContext.DoctorReferral(FromDate, ToDate, ProviderName);
responseData.Status = "OK";
responseData.Results = doctorreport;
}
catch (Exception ex)
{
//Insert exception details into database table.
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
//return null;
}
// GET: /<controller>/
//used in doctor's module.
public string DoctorSummary(DateTime FromDate, DateTime ToDate, int ProviderId)
{
DanpheHTTPResponse <DataTable> responseData = new DanpheHTTPResponse <DataTable>();
try
{
if (FromDate < ((DateTime)System.Data.SqlTypes.SqlDateTime.MinValue) && ToDate < ((DateTime)System.Data.SqlTypes.SqlDateTime.MinValue))
{
FromDate = System.DateTime.Today;
ToDate = DateTime.Now;
}
else if (FromDate > ((DateTime)System.Data.SqlTypes.SqlDateTime.MinValue) && ToDate > ((DateTime)System.Data.SqlTypes.SqlDateTime.MaxValue))
{
ToDate = DateTime.Now;
}
ReportingDbContext reportingDbContext = new ReportingDbContext(connString);
DataTable doctorrSummary = reportingDbContext.DoctorSummary(FromDate, ToDate, ProviderId);
responseData.Status = "OK";
responseData.Results = doctorrSummary;
}
catch (Exception ex)
{
//Insert exception details into database table.
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string Post()
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
try
{
VisitDbContext dbContext = new VisitDbContext(base.connString);
string str = this.ReadPostData();
string reqType = this.ReadQueryStringData("reqType");
if (reqType == "concludeVisit")
{
var visitid = DanpheJSONConvert.DeserializeObject <int>(str);
var visit = dbContext.Visits.Where(v => v.PatientVisitId == visitid).Select(p => p).FirstOrDefault();
visit.ConcludeDate = System.DateTime.Now;
dbContext.Visits.Attach(visit);
dbContext.Entry(visit).Property(a => a.ConcludeDate).IsModified = true;
dbContext.SaveChanges();
responseData.Status = "OK";
}
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = "Error " + ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string Put(string reqType, int settlementId)
{
RbacUser currentUser = HttpContext.Session.Get <RbacUser>("currentuser");
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
responseData.Status = "OK";//by default status would be OK, hence assigning at the top
try
{
if (reqType == "updateSettlementPrintCount")
{
BillingDbContext bilDbContext = new BillingDbContext(connString);
int settlmntId = settlementId;
var currSettlment = bilDbContext.BillSettlements.Where(s => s.SettlementId == settlmntId).FirstOrDefault();
if (currSettlment != null)
{
int?printCount = currSettlment.PrintCount.HasValue ? currSettlment.PrintCount : 0;
printCount += 1;
bilDbContext.BillSettlements.Attach(currSettlment);
currSettlment.PrintCount = printCount;
currSettlment.PrintedOn = System.DateTime.Now; //Yubraj: 13th August'19
currSettlment.PrintedBy = currentUser.EmployeeId;
bilDbContext.Entry(currSettlment).Property(b => b.PrintCount).IsModified = true;
bilDbContext.SaveChanges();
responseData.Results = new { SettlementId = settlementId, PrintCount = printCount };
}
}
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string Put()
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
CoreDbContext coreDbContext = new CoreDbContext(base.connString);
try
{
string reqType = this.ReadQueryStringData("reqType");
string str = this.ReadPostData();
if (reqType == "bill-tax")
{
ParameterModel parameter = coreDbContext.Parameters.Where(par => par.ParameterGroupName == "BILL" && par.ParameterName == "TaxInfo").FirstOrDefault();
parameter.ParameterValue = str;
coreDbContext.Entry(parameter).Property(a => a.ParameterValue).IsModified = true;
coreDbContext.SaveChanges();
responseData.Status = "OK";
}
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
[HttpPost]// POST api/values
public string Post()
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
int CreatedBy = ToInt(this.ReadQueryStringData("CreatedBy"));
responseData.Status = "OK";//by default status would be OK, hence assigning at the top
string ipDataString = this.ReadPostData();
string reqType = this.ReadQueryStringData("reqType");
try
{
BillingDbContext billingDbContext = new BillingDbContext(connString);
if (reqType == "")
{
}
else
{
responseData.Status = "failed";
responseData.ErrorMessage = "Invalid request type.";
}
//responseData.Results = null;
}
catch (Exception ex)
{
responseData.Status = "failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string Put()
{
RbacUser currentUser = HttpContext.Session.Get <RbacUser>("currentuser");
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
responseData.Status = "OK";
try
{
BillingDbContext billingDbContext = new BillingDbContext(connString);
string reqType = this.ReadQueryStringData("reqType");
int depositId = ToInt(this.ReadQueryStringData("depositId"));
if (reqType == "updateDepositPrintCount")
{
BillingDeposit deposit = billingDbContext.BillingDeposits
.Where(a => a.DepositId == depositId)
.FirstOrDefault <BillingDeposit>();
if (deposit != null)
{
deposit.PrintCount = deposit.PrintCount == null || deposit.PrintCount == 0 ? 1 : deposit.PrintCount + 1;
deposit.PrintedOn = System.DateTime.Now; //Yubraj: 13th August'19
deposit.PrintedBy = currentUser.EmployeeId;
billingDbContext.Entry(deposit).Property(a => a.PrintCount).IsModified = true;
}
billingDbContext.SaveChanges();
responseData.Status = "OK";
}
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string Get(string reqType, string templateCode, string renderMode)
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
try
{
CoreDbContext coreDbContext = new CoreDbContext(connString);
if (reqType == "getSurveyTemplate")
{
Template currTemplate = coreDbContext.Templates.Where(t => t.Code == templateCode)
.Include("Qnairs.ChildQuestions.Options").FirstOrDefault();
//order the questionnaires by their display sequence.
if (currTemplate != null && currTemplate.Qnairs != null)
{
//if value of displayseq are same, order by qnair id in that case.
currTemplate.Qnairs = currTemplate.Qnairs.OrderBy(q => q.DisplaySeq).ThenBy(q => q.QnairId).ToList();
}
ConfigureTemplate(currTemplate, renderMode);
responseData.Results = currTemplate;
}
responseData.Status = "OK";
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string Put()
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
SchedulingDbContext schDbContext = new SchedulingDbContext(connString);
string reqType = this.ReadQueryStringData("reqType");
string str = this.ReadPostData();
try
{
#region Update Shifts (Manage Shifts)
if (reqType == "UpdateShift")
{
ShiftsMasterModel shiftData = DanpheJSONConvert.DeserializeObject <ShiftsMasterModel>(str);
shiftData.ModifiedOn = System.DateTime.Now;
schDbContext.ShiftsMaster.Attach(shiftData);
schDbContext.Entry(shiftData).State = EntityState.Modified;
schDbContext.Entry(shiftData).Property(x => x.CreatedOn).IsModified = false;
schDbContext.Entry(shiftData).Property(x => x.CreatedBy).IsModified = false;
schDbContext.SaveChanges();
responseData.Status = "OK";
responseData.Results = shiftData;
}
#endregion
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string getNephrologyPatients()
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
BillingDbContext billingDbContext = new BillingDbContext(connString);
responseData.Results = "OK";
try
{
var nephPats = (from pat in billingDbContext.Patient
join bti in billingDbContext.BillingTransactionItems on pat.PatientId equals bti.PatientId
join msd in billingDbContext.ServiceDepartment on bti.ServiceDepartmentId equals msd.ServiceDepartmentId
where msd.IntegrationName == "Nephrology"
select new
{
pat.PatientId,
pat.PatientCode,
pat.Gender,
pat.Age,
pat.DateOfBirth,
pat.Address,
pat.PhoneNumber,
bti.ProviderName,
ShortName = pat.FirstName + " " + (string.IsNullOrEmpty(pat.MiddleName) ? "" : pat.MiddleName + " ") + pat.LastName,
}).OrderByDescending(patient => patient.PatientId).ToList();
responseData.Results = nephPats;
responseData.Status = "OK";
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string Get(string paramGroup, string paramName)
{
DanpheHTTPResponse <List <ParameterModel> > responseData = new DanpheHTTPResponse <List <ParameterModel> >();
try
{
if (!string.IsNullOrEmpty(paramGroup) && !string.IsNullOrEmpty(paramName))
{
}
else
{
CoreDbContext coreDbContext = new CoreDbContext(connString);
responseData.Results = coreDbContext.Parameters.ToList();
}
responseData.Status = "OK";
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string DischargedPatientBillBreakup(int VisitId, int PatientId)
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
try
{
AdmissionDbContext admissionDbContext = new AdmissionDbContext(connString);
ReportingDbContext reportingDbContext = new ReportingDbContext(connString);
var result = (from addm in admissionDbContext.Admissions
where addm.PatientVisitId == VisitId
join visit in admissionDbContext.Visits
on addm.PatientVisitId equals visit.PatientVisitId
join pat in admissionDbContext.Patients
on addm.PatientId equals pat.PatientId
from addmInfo in admissionDbContext.PatientBedInfos
join ward in admissionDbContext.Wards
on addmInfo.WardId equals ward.WardId
join bed in admissionDbContext.Beds
on addmInfo.BedId equals bed.BedId
where addmInfo.PatientVisitId == VisitId
select new
{
Patient = new
{
IPNumber = visit.VisitCode,
PatName = pat.FirstName + " " + (string.IsNullOrEmpty(pat.MiddleName) ? "" : pat.MiddleName + " ") + pat.LastName,
Address = pat.Address,
Age = pat.Age,
Gender = pat.Gender,
PatientCode = pat.PatientCode,
InvoiceDateTime = System.DateTime.Now,
AdmissionDate = addm.AdmissionDate,
DischargeDate = addm.DischargeDate,
AdmittedDoctor = from emp in admissionDbContext.Employees
where emp.EmployeeId == addm.AdmittingDoctorId
select emp.FirstName + " " + (string.IsNullOrEmpty(emp.MiddleName) ? "" : emp.MiddleName + " ") + emp.LastName,
Ward = ward.WardName + " " + ward.WardLocation,
BedNo = bed.BedNumber
}
}).FirstOrDefault();
DataTable dischargeBill = reportingDbContext.BillDischargeBreakup(VisitId, PatientId);
var resultData = new
{
Patient = result,
ReportData = dischargeBill
};
responseData.Status = "OK";
responseData.Results = resultData;
}
catch (Exception ex)
{
//Insert exception details into database table.
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string Get(string reqType, string inputValue)
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
try
{
if (reqType == "lookups")
{
CoreDbContext dbcontext = new CoreDbContext(connString);
List <LookupsModel> allLookups = dbcontext.LookUps.ToList();
List <LookupsModel> retList = new List <LookupsModel>();
if (!string.IsNullOrEmpty(inputValue))
{
retList = allLookups.Where(a => a.ModuleName.ToLower() == inputValue.ToLower()).ToList();
}
else
{
retList = allLookups;
}
responseData.Results = retList;
}
else if (reqType == "appSettings-limited")
{
//Return only limited properties to client.
//DO NOT return SECURE INFORMATION LIKE: CONNECTIONSTRINGS, FILELOCATIONS, etc..
MyConfiguration retValue = new MyConfiguration();
retValue.ApplicationVersionNum = this._appSettings.ApplicationVersionNum;
retValue.highlightAbnormalLabResult = this._appSettings.highlightAbnormalLabResult;
retValue.CacheExpirationMinutes = this._appSettings.CacheExpirationMinutes;
responseData.Results = retValue;
}
//if (reqType == "engToNepDate")
//{
// NepaliDate ndate = new NepaliDate(connString);
// string retNepDate = ndate.NepaliLongDate(DateTime.Parse(value));
// responseData.Results = retNepDate;
//}
//else if (reqType == "nepToEngDate")
//{
// NepaliDate ndate = new NepaliDate(connString);
// string retEngDate = ndate.NeptoEnglishDate(value).ToString("yyyy-MM-dd");
// responseData.Results = retEngDate;
//}
responseData.Status = "OK";
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string GetLaboratoryServices(DateTime FromDate, DateTime ToDate)
{
LaboratoryServices labServices = new LaboratoryServices();
// DanpheHTTPResponse<DynamicReport> responseData1 = new DanpheHTTPResponse<DynamicReport>();
DanpheHTTPResponse <LaboratoryServices> responseData = new DanpheHTTPResponse <LaboratoryServices>();
try
{
GovernmentReportDbContext govreportingDbContext = new GovernmentReportDbContext(connString);
LaboratoryServices HaematologyResult = govreportingDbContext.GetHaematology(FromDate, ToDate);
labServices.HaematologyModel0 = HaematologyResult.HaematologyModel0;
labServices.HaematologyModel1 = HaematologyResult.HaematologyModel1;
LaboratoryServices ImmunologyResult = govreportingDbContext.GetImmunology(FromDate, ToDate);
labServices.ImmunologyModel0 = ImmunologyResult.ImmunologyModel0;
labServices.ImmunologyModel1 = ImmunologyResult.ImmunologyModel1;
LaboratoryServices BiochemistryResult = govreportingDbContext.GetBiochemistry(FromDate, ToDate);
labServices.BiochemistryModel0 = BiochemistryResult.BiochemistryModel0;
labServices.BiochemistryModel1 = BiochemistryResult.BiochemistryModel1;
LaboratoryServices BacteriologyResult = govreportingDbContext.GetBacteriology(FromDate, ToDate);
labServices.BacteriologyModel0 = BacteriologyResult.BacteriologyModel0;
LaboratoryServices CytologyResult = govreportingDbContext.GetCytology(FromDate, ToDate);
labServices.CytologyModel0 = CytologyResult.CytologyModel0;
LaboratoryServices VirologyResult = govreportingDbContext.GetVirology(FromDate, ToDate);
labServices.VirologyModel0 = VirologyResult.VirologyModel0;
LaboratoryServices ImmunohistochemistryResult = govreportingDbContext.GetImmunohistochemistry(FromDate, ToDate);
labServices.ImmunohistochemistryModel0 = ImmunohistochemistryResult.ImmunohistochemistryModel0;
LaboratoryServices HistologyResult = govreportingDbContext.GetHistology(FromDate, ToDate);
labServices.HistologyModel0 = HistologyResult.HistologyModel0;
LaboratoryServices ParasitologyResult = govreportingDbContext.GetParasitology(FromDate, ToDate);
labServices.ParasitologyModel0 = ParasitologyResult.ParasitologyModel0;
LaboratoryServices CardiacenzymesResult = govreportingDbContext.GetCardiacenzymes(FromDate, ToDate);
labServices.CardiacenzymesModel0 = CardiacenzymesResult.CardiacenzymesModel0;
LaboratoryServices HormonesendocrinologyResult = govreportingDbContext.GetHormonesendocrinology(FromDate, ToDate);
labServices.HormonesendocrinologyModel0 = HormonesendocrinologyResult.HormonesendocrinologyModel0;
responseData.Status = "OK";
responseData.Results = labServices;
}
catch (Exception ex)
{
//Insert exception details into database table.
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string Get(string reqType)
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
AccountingDbContext accountingDBContext = new AccountingDbContext(connString);
InventoryDbContext invDbContext = new InventoryDbContext(connString);
try
{
if (reqType == "inventory")
{
var invItems = (from goodsReceipt in invDbContext.GoodsReceipts
join vendor in invDbContext.Vendors on goodsReceipt.VendorId equals vendor.VendorId
select new
{
goodsReceipt.GoodsReceiptID,
goodsReceipt.GoodsReceiptDate,
goodsReceipt.TotalAmount,
vendor.VendorName,
goodsReceipt.Remarks,
IsSelected = true,
GoodsReceiptItems = (from goodsReceiptItem in invDbContext.GoodsReceiptItems
join invItem in invDbContext.Items on goodsReceiptItem.ItemId equals invItem.ItemId
where goodsReceiptItem.GoodsReceiptId == goodsReceipt.GoodsReceiptID
select new
{
goodsReceiptItem.GoodsReceiptItemId,
goodsReceiptItem.BatchNO,
goodsReceiptItem.ExpiryDate,
goodsReceiptItem.ReceivedQuantity,
goodsReceiptItem.FreeQuantity,
goodsReceiptItem.RejectedQuantity,
goodsReceiptItem.ItemRate,
goodsReceiptItem.VATAmount,
goodsReceiptItem.TotalAmount,
goodsReceiptItem.ItemId,
invItem.ItemName
}).ToList()
}).ToList();
responseData.Status = "OK";
responseData.Results = invItems;
}
}
catch (Exception ex)
{
string str = ex.InnerException.Message.ToString();
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string Put()
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
try
{
//RbacUser currentUser = HttpContext.Session.Get<RbacUser>("currentuser");
string reqType = this.ReadQueryStringData("reqType");
string ipStr = this.ReadPostData();
CoreDbContext coreDbContext = new CoreDbContext(connString);
if (reqType == "updateQnairs")
{
//this is used to 1. Rename Questionnaire, 2. Change Display Sequence.
List <Questionnaire> qnrListFromclient = DanpheJSONConvert.
DeserializeObject <List <Questionnaire> >(ipStr);
if (qnrListFromclient != null && qnrListFromclient.Count > 0)
{
foreach (Questionnaire qnr in qnrListFromclient)
{
qnr.ChildQuestions = null; //needed since otherwise it goes on to add existing ChildQuestion again.
//coreDbContext.Entry(qnrFromClient).Property(q => q.Text).IsModified = true;
coreDbContext.Entry(qnr).State = EntityState.Modified;
}
coreDbContext.SaveChanges();
}
responseData.Results = qnrListFromclient;
}
else if (reqType == "updateQtn")
{
Question qtnVM = DanpheJSONConvert.
DeserializeObject <Question>(ipStr);
if (qtnVM != null)
{
//use GraphDiff's updategraph method to save/delete question and option (hierarchy)
coreDbContext.UpdateGraph(qtnVM,
map => map.OwnedCollection(a => a.Options));
coreDbContext.SaveChanges();
responseData.Results = qtnVM;
}
}
responseData.Status = "OK";
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public ActionResult UploadFile(string sessionid, int senderid)
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
try
{
int[] responseidlist = { };
var file = Request.Form.Files[0];
if (file.Length > 0)
{
/////Converting Files to Byte there for we require MemoryStream object
using (var ms = new MemoryStream())
{
string fileName = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"');
////this is the Extention of Current File(.PNG, .JPEG, .JPG)
string fileExtention = Path.GetExtension(file.FileName);
////Copy Each file to MemoryStream
file.CopyTo(ms);
////Convert File to Byte[]
var fileBytes = ms.ToArray();
var tempModel = new SessionDocumentsModel();
tempModel.SessionId = sessionid;
tempModel.UploadedBy = senderid;
tempModel.FileName = fileName;
tempModel.UploadedOn = DateTime.Now.ToString();
tempModel.FileByteArray = fileBytes;
tempModel.FileExtension = fileExtention;
dbContext.SessionDocument.Add(tempModel);
dbContext.SaveChanges();
responseidlist.Append(tempModel.SessionDocumentId);
}
}
var res = (from d in dbContext.SessionDocument
orderby d.SessionDocumentId descending
select new
{
d.SessionDocumentId,
d.FileName
}).FirstOrDefault();
responseData.Results = res;
responseData.Status = "OK";
//return Json("Upload Successful.");
}
catch (System.Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = "Upload Failed" + ex.Message;
//return Json("Upload Failed: " + ex.Message);
}
return(Json(DanpheJSONConvert.SerializeObject(responseData, true)));
}
public string Put()
{
MasterDbContext masterDbContext = new MasterDbContext(connString);
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
try
{
string reqType = this.ReadQueryStringData("reqType");
int empId = ToInt(this.ReadQueryStringData("empId"));
var files = Request.Form.Files;
string ImagePath = null;
string ImageName = null;
if (files.Count != 0)
{
//
DanpheHTTPResponse <object> uploadResponse = FileUploader.Upload(files, "UserProfile\\");
if (uploadResponse.Status == "OK")
{
ImagePath = uploadResponse.Results.ToString();
ImageName = files[0].FileName;
EmployeeModel dbemp = masterDbContext.Employees.Where(a => a.EmployeeId == empId)
.FirstOrDefault <EmployeeModel>();
dbemp.ImageFullPath = ImagePath;
dbemp.ImageName = ImageName;
masterDbContext.Entry(dbemp).State = EntityState.Modified;
responseData.Status = "OK";
masterDbContext.SaveChanges();
responseData.Results = ImageName;
}
else
{
throw new Exception("Upload Failed");
}
}
else
{
responseData.ErrorMessage = "Upload Failed";
responseData.Status = "Failed";
}
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string Put()
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
string inputSting = new StreamReader(Request.Body).ReadToEnd();
try
{
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string Post()
{
DanpheHTTPResponse <ParameterModel> responseData = new DanpheHTTPResponse <ParameterModel>();
try
{
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string Get()
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
responseData.Status = "OK";//by default status would be OK, hence assigning at the top
try
{
responseData.Results = null;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string Post()
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
try
{
//RbacUser currentUser = HttpContext.Session.Get<RbacUser>("currentuser");
string reqType = this.ReadQueryStringData("reqType");
string ipStr = this.ReadPostData();
CoreDbContext coreDbContext = new CoreDbContext(connString);
if (reqType == "addQuestion")
{
Question qtnVM = DanpheJSONConvert.
DeserializeObject <Question>(ipStr);
if (qtnVM != null)
{
coreDbContext.Questions.Add(qtnVM);
coreDbContext.SaveChanges();
responseData.Results = qtnVM;
}
}
else if (reqType == "addQnair")
{
Questionnaire qnrVM = DanpheJSONConvert.
DeserializeObject <Questionnaire>(ipStr);
if (qnrVM != null)
{
Questionnaire qnr = qnrVM;
coreDbContext.Questionnaires.Add(qnr);
coreDbContext.SaveChanges();
//we get qnairId once it is saved to database.
qnrVM.QnairId = qnr.QnairId;
}
responseData.Results = qnrVM;
}
responseData.Status = "OK";
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string Get(int patientId, int patientVisitId)
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
try
{
responseData.Status = "OK";
responseData.Results = "Not implemented";
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string BILLDsbCntrUsrCollection(DateTime fromDate, DateTime toDate, int?counterId)
{
DanpheHTTPResponse <DynamicReport> responseData = new DanpheHTTPResponse <DynamicReport>();
try
{
ReportingDbContext reportingDbContext = new ReportingDbContext(connString);
DynamicReport cntrDayData = reportingDbContext.BIL_Daily_CounterNUsersCollection(fromDate, toDate);
responseData.Status = "OK";
responseData.Results = cntrDayData;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string GetSummaryReport(DateTime FromDate, DateTime ToDate)
{
DanpheHTTPResponse <DynamicReport> responseData = new DanpheHTTPResponse <DynamicReport>();
try
{
GovernmentReportDbContext govReportDbContext = new GovernmentReportDbContext(connString);
DynamicReport govReportSummary = govReportDbContext.GovReportSummary(FromDate, ToDate);
responseData.Status = "OK";
responseData.Results = govReportSummary;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
//Income segregation report
public string IncomeSegregation(DateTime FromDate, DateTime ToDate)
{
DanpheHTTPResponse <DynamicReport> responseData = new DanpheHTTPResponse <DynamicReport>();
try
{
ReportingDbContext reportingDbContext = new ReportingDbContext(connString);
DynamicReport incomeSegregation = reportingDbContext.BIL_Daily_IncomeSegregation(FromDate, ToDate);
responseData.Status = "OK";
responseData.Results = incomeSegregation;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string PatientAgeRangeNGenderWise()
{
DanpheHTTPResponse <DynamicReport> responseData = new DanpheHTTPResponse <DynamicReport>();
try
{
ReportingDbContext reportingDbContext = new ReportingDbContext(connString);
DynamicReport patCounts = reportingDbContext.Patient_AgeRangeNGenderWiseCount();
responseData.Status = "OK";
responseData.Results = patCounts;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
//public string PatientZoneMap()
//{
// DanpheHTTPResponse<DynamicReport> responseData = new DanpheHTTPResponse<DynamicReport>();
// try
// {
// ReportingDbContext reportingDbContext = new ReportingDbContext(connString);
// DynamicReport patZoneMap = reportingDbContext.Home_PatientZoneMap();
// responseData.Status = "OK";
// responseData.Results = patZoneMap;
// }
// catch (Exception ex)
// {
// responseData.Status = "Failed";
// responseData.ErrorMessage = ex.Message;
// }
// return DanpheJSONConvert.SerializeObject(responseData);
//}
public string DepartmentAppointmentsTotal()
{
DanpheHTTPResponse <DynamicReport> responseData = new DanpheHTTPResponse <DynamicReport>();
try
{
ReportingDbContext reportingDbContext = new ReportingDbContext(connString);
DynamicReport deptAppts = reportingDbContext.Home_DeptWise_TotalAppointmentCount();
responseData.Status = "OK";
responseData.Results = deptAppts;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string HomeDashboardStats()
{
DanpheHTTPResponse <DynamicReport> responseData = new DanpheHTTPResponse <DynamicReport>();
try
{
ReportingDbContext reportingDbContext = new ReportingDbContext(connString);
DynamicReport dsbStats = reportingDbContext.Home_DashboardStatistics();
responseData.Status = "OK";
responseData.Results = dsbStats;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string MonthlyBillingTrend()
{
DanpheHTTPResponse <DynamicReport> responseData = new DanpheHTTPResponse <DynamicReport>();
try
{
ReportingDbContext reportingDbContext = new ReportingDbContext(connString);
DynamicReport dailyRevenue = reportingDbContext.BIL_Monthly_BillingTrend();
responseData.Status = "OK";
responseData.Results = dailyRevenue;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
