/// <inheritdoc /> public IList <MessageReportModel> GetEcommerceMessages(MessageSearchModel searchData) { IList <MessageReportModel> reports = new List <MessageReportModel>(); using (var sqlConnection = new SqlConnection(Constants.ConnectorDatabase)) { try { Query query = new Query("InboundQueue as MQE") .Select("MQE.Id", "MQE.ErpId", "MQE.EcommerceId", "MQE.CreatedTime", "MQE.UpdatedTime", "MQE.StatusId", "MQE.SyncCounter", "MQE.EntityId", "MQE.ErrorMessage", "IE.EntityName", "MSL.StatusName", "MQE.EcommerceMessageId", "MQE.StatusId") .Join("EntityMaster as IE", "MQE.EntityId", "IE.EntityId") .Join("StatusMaster as MSL", "MQE.StatusId", "MSL.StatusId"); PrepareRequestParameters(query, searchData); SqlResult sqlResult = new SqlServerCompiler().Compile(query); using (var command = new SqlCommand(sqlResult.Sql, sqlConnection)) { foreach (KeyValuePair <string, object> binding in sqlResult.Bindings) { command.Parameters.AddWithValue(binding.Key, binding.Value); } sqlConnection.Open(); using (SqlDataReader dataReader = command.ExecuteReader()) { int i = 1; while (dataReader.Read()) { var record = new MessageReportModel { Index = i++, MessageId = dataReader.GetInt64(0), ErpId = dataReader.IsDBNull(1) ? string.Empty : dataReader.GetString(1), EcommerceId = dataReader.GetString(2), CreatedDate = dataReader.GetDateTime(3), ModifiedDate = dataReader.GetDateTime(4), SyncCounter = dataReader.GetByte(6), EntityId = dataReader.GetByte(7), ErrorMessage = dataReader.IsDBNull(8) ? "" : dataReader.GetString(8), EntityName = dataReader.GetString(9), MessageStatus = dataReader.GetString(10), CloudMessageId = dataReader.GetInt64(11), StatusId = dataReader.GetByte(12), }; record.IsCheckBoxEnabled = record.StatusId == (int)MessageStatus.RequestProcessed || record.StatusId == (int)MessageStatus.Error; record.ShowActionLink = !string.IsNullOrEmpty(record.ErrorMessage); reports.Add(record); } } } } catch (Exception exception) { Logger.LogMessage(exception.Message, LogMessages.GetEcommerceMessages, LogType.Error, exception); throw; } return(reports); } }
public ActionResult MessageReport(string PatientId, DateTime FromDate, DateTime ToDate) { var totalwithin = 0; var totaloutside = 0; IEncounterReport encrepo = new EncounterReportModel(); IEnumerable <EncounterReport> encrepos = encrepo.GetAll().Where(e => e.PatientId == PatientId).AsEnumerable(); IPatientMDRepository _patients = new PatientMDRepository(); IEnumerable <PatientMD> patient = _patients.GetByUserId(PatientId); var pat = patient.FirstOrDefault(); foreach (var er in encrepos) { DateTime date = er.Encounterdate; if (FromDate <= date && date <= ToDate) { totalwithin++; } else { totaloutside++; } } var numwithin = 0; var numoutside = 0; IMessageReport msgrepo = new MessageReportModel(); IEnumerable <MessageReport> msgrepos = msgrepo.GetAll().Where(e => e.SentTo == PatientId).AsEnumerable(); foreach (var mr in msgrepos) { DateTime dt = mr.Messagedate; if (FromDate <= dt && dt <= ToDate) { numwithin++; } else { numoutside++; } } var json = new MessageReportViewModel { PatientName = pat.PatientName, DOB = pat.DateOfBirth, TotalOutside = totaloutside, TotalWithin = totalwithin, Gender = pat.Sex, NumWithin = numwithin, NumOutside = numoutside }; return(Json(json)); }
// POST api/WallPost public HttpResponseMessage PostPost(Post post) { var session = HttpContext.Current.Session; if (session["UserId"] != null) { userId = session["UserId"].ToString(); } post.PostedBy = userId; post.PostedDate = DateTime.UtcNow; var user = db.UserProfiles.FirstOrDefault(x => x.UserName == post.PostReceivedBy); ModelState.Remove("post.PostReceivedBy"); ModelState.Remove("post.PostedBy"); ModelState.Remove("post.PostedDate"); post.PostReceivedBy = user.UserId; if (ModelState.IsValid) { db.Posts.Add(post); db.SaveChanges(); var phy = db.UserProfiles.FirstOrDefault(p => p.UserId == post.PostedBy); var roles = Roles.GetRolesForUser(phy.UserName); if (roles.Contains("Physician")) { IMessageReport msgrep = new MessageReportModel(); MessageReport msg = new MessageReport(); msg.SentBy = post.PostedBy; msg.SentTo = post.PostReceivedBy; var newmsg = msgrep.AddMessageReport(msg); } var usr = db.UserProfiles.FirstOrDefault(x => x.UserId == post.PostedBy); var ret = new { Message = post.Message, PostedBy = post.PostedBy, PostedByName = usr.UserName, PostReceivedBy = post.PostReceivedBy, PostedByAvatar = imgFolder + (String.IsNullOrEmpty(usr.AvatarExt) ? defaultAvatar : post.PostedBy + "." + post.UserProfile.AvatarExt), PostedDate = post.PostedDate, PostId = post.PostId }; HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, ret); response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = post.PostId })); return(response); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } }