public int SaveComplaint(complaintItem complaint) { asynSaveImage = new SaveImageBytes(ImageController.SavePicture); try { context = new SocialCopsEntities(); // Add Log logger.LogMethod("ENTER","SaveComplaint","Userid/" + complaint.userId.ToString()+ "/ started SaveComplaint", null); // New Complaint Complaint temp = new Complaint(); temp = complaintItem.convertComplaint(complaint); //Add a new Complaint context.Complaints.Add(temp); context.SaveChanges(); //Image Upload Async byte[] image = complaint.ImageByte; if (image.Length > 0) { IAsyncResult result = asynSaveImage.BeginInvoke(image, temp.complaintId.ToString(), new AsyncCallback(FinishImageUpload), asynSaveImage); } // Exit Log logger.LogMethod("EXIT", "SaveComplaint", "Userid/" + complaint.userId.ToString() + "/ finished SaveComplaint", null); return temp.complaintId; } catch (Exception ex) { logger.LogMethod("ERROR", "SaveComplaint", "Userid/" + complaint.userId.ToString() + "/ " + ex.ToString(), null); error.Result = false; error.ErrorMessage = "unforeseen error occured. Please try later."; error.ErrorDetails = ex.ToString(); throw new FaultException<Bug>(error, ex.ToString()); } }
public void DeleteComplaint(int id) { //unitOfWork.StartTransaction(); ComplaintRepository repo = new ComplaintRepository(unitOfWork); ComplaintModel complaintModel = new ComplaintModel(); Complaint complaint = new Complaint(); complaint = repo.GetAll().Where(x => x.ComplaintId == id).SingleOrDefault(); repo.Delete(x => x.ComplaintId == complaint.ComplaintId); //unitOfWork.Commit(); }
public ComplaintModel GetComplaintByComplaintId(int complaintId) { //unitOfWork.StartTransaction(); ComplaintRepository repo = new ComplaintRepository(unitOfWork); ComplaintModel complaintModel = new ComplaintModel(); Complaint complaint = new Complaint(); complaint = repo.GetAll().Where(x => x.ComplaintId == complaintId).FirstOrDefault(); //unitOfWork.Commit(); AutoMapper.Mapper.Map(complaint, complaintModel); return complaintModel; }
public ComplaintModel GetComplaintDetailByComplaintId(int compliantId) { //unitOfWork.StartTransaction(); ComplaintRepository repo = new ComplaintRepository(unitOfWork); ComplaintModel complaintModelList = new ComplaintModel(); Complaint complaintlist = new Complaint(); var complaints = (from data in db.Complaint join e in db.Employee on data.EmployeeId equals e.EmployeeId join cl in db.Client on data.ClientId equals cl.ClientId join ul in db.UserLocation on cl.ClientId equals ul.UserId join u in db.Users on cl.ClientId equals u.Id join sp in db.ServiceProvider on data.ServiceProviderId equals sp.ServiceProviderId join j in db.Job on data.JobId equals j.JobId select new { ComplainId = data.ComplaintId, Description = data.Description, ServiceProviderId = data.ServiceProviderId, EmployeeName = e.FirstName, ClientName = cl.FirstName, ClientAddress = ul.Address, ClientPhoneNumber = u.PhoneNumber, ServiceProviderName = sp.CompanyName, Status = data.Status, jobDescription = j.Description, JobAddress = j.JobAddress }).Where(x => x.ComplainId == compliantId).FirstOrDefault(); ComplaintModel model = new ComplaintModel(); model.ComplaintId = complaints.ComplainId; model.Description = complaints.Description; model.EmployeeName = complaints.EmployeeName; model.ClientName = complaints.ClientName; model.ServiceProviderName = complaints.ServiceProviderName; model.Status = complaints.Status; model.JobDescription = complaints.jobDescription; model.JobAddress = complaints.JobAddress; model.ClientAddress = complaints.ClientAddress; model.ClientPhoneNumber = complaints.ClientPhoneNumber; //unitOfWork.Commit(); return model; }
public ComplaintModel UpdateComplaint(ComplaintModel model) { //unitOfWork.StartTransaction(); ComplaintRepository repo = new ComplaintRepository(unitOfWork); ComplaintModel complaintModel = new ComplaintModel(); Complaint complaint = new Complaint(); complaint = repo.GetAll().Where(x => x.ComplaintId == model.ComplaintId).FirstOrDefault(); AutoMapper.Mapper.Map(model, complaint); repo.Update(complaint); //unitOfWork.Commit(); return complaintModel; }
public ComplaintList(Complaint e) { Id = e.Id; DateReceived = e.DateReceived; DateComplaintClosed = e.DateComplaintClosed; }
public async Task <List <Complaint> > FetchUserComplaint(int raisedBy) { List <Complaint> complaints = new List <Complaint>(); using (SqlConnection connection = new SqlConnection(this._connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand("FETCH_USER_COMPLAINT", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@raisedBy", SqlDbType.Int).Value = raisedBy; try { using (SqlDataReader reader = await command.ExecuteReaderAsync()) { while (reader.Read()) { var complaint = new Complaint { CID = Convert.ToInt32(reader["cid"].ToString()), TID = Convert.ToInt32(reader["tid"].ToString()), CPriority = Convert.ToInt32(reader["cpriority"].ToString()), UserContactNumber = reader["user_contact"].ToString(), UserComment = reader["user_comment"].ToString(), CStatus = Convert.ToInt32(reader["cstatus"].ToString()), ResolverComment = reader["resolver_comment"].ToString(), AssignedToName = reader["user_name"].ToString(), }; switch (Convert.ToInt32(reader["cpriority"].ToString())) { case 1: complaint.CPriorityText = "Low"; break; case 2: complaint.CPriorityText = "Medium"; break; case 3: complaint.CPriorityText = "High"; break; } switch (Convert.ToInt32(reader["cstatus"].ToString())) { case 1: complaint.CStatusText = "Acknowledged"; break; case 2: complaint.CStatusText = "Assigned"; break; case 3: complaint.CStatusText = "Work In Progress"; break; case 4: complaint.CStatusText = "Resolved"; break; } complaints.Add(complaint); } } return(complaints); } catch (Exception ex) { return(null); } } } }
public void ComplaintDisputePendingTrial(Complaint complaint) { }
public void ComplaintConfirmed(Complaint complaint) { }
public ComplaintsComponent(Complaint complaint) { InitializeComponent(); Refresh(complaint); }
public void ComplaintCreated(Complaint complaint) { }
protected void btnAddcomplaintsubmit_Click(object sender, EventArgs e) { if (btnAddcomplaintsubmit.Text == "Reset") { lblCompstatus.Text = ""; btnAddcomplaintsubmit.Text = "Submit"; } else { try { Complaint newComp = new Complaint(); newComp.CompTypeID = Convert.ToInt32(drpComplaintcategory.SelectedItem.Value); newComp.Assignedto = GetAvailableEmployee(newComp.CompTypeID); //newComp.Assignedto = 4; newComp.SeverityID = 2; newComp.FlatNumber = txtAddcompFlat.Text; newComp.CurrentStatus = 1; newComp.Descrption = txtComplaintdescription.Text; if (muser.currentResident.UserType == "Admin") { newComp.ResidentID = muser.currentResident.ResID; } else { newComp.ResidentID = muser.currentResident.ResID; } bool result = newComp.AddNewComplaint(); if (result == true) { drpComplaintcategory.SelectedIndex = 0; txtComplaintdescription.Text = ""; //Added by Aarshi on 11-Sept-2017 for bug fix drpAddcomAssign.Items.Clear(); drpAddcomAssign.Items.Insert(0, new ListItem("Select", "NA")); txtAddcompFlat.Text = string.Empty; txtComplaintername.Text = string.Empty; LoadComplaintsDataList(); ClientScript.RegisterStartupScript(GetType(), "SetFocusScript", "<Script>self.close();</Script>"); //code to close window ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('Complaint Submitted Sucessfully')", true); //FillComplaintData(); } else { lblCompstatus.ForeColor = System.Drawing.Color.Red; lblCompstatus.Text = " Add complaint failed try later. "; lblEmptyDataText.Visible = true; lblEmptyDataText.Text = "Add complaint failed try later"; } } catch (Exception ex) { } finally { } } }
public void CompleteOrderDelivery( Employee driver, int orderId, int bottlesReturnCount, int rating, int driverComplaintReasonId, string otherDriverComplaintReasonComment, string driverComment, DateTime recievedTime) { var vodovozOrder = _orderRepository.GetOrder(_unitOfWork, orderId); var routeList = _routeListRepository.GetActualRouteListByOrder(_unitOfWork, vodovozOrder); var routeListAddress = routeList.Addresses.Where(x => x.Order.Id == orderId).SingleOrDefault(); if (vodovozOrder is null) { var error = $"Заказ не найден: { orderId }"; _logger.LogWarning(error); throw new ArgumentOutOfRangeException(nameof(orderId), error); } if (routeList is null) { var error = $"МЛ для заказа: { orderId } не найден"; _logger.LogWarning(error); throw new ArgumentOutOfRangeException(nameof(orderId), error); } if (routeListAddress is null) { var error = $"адрес МЛ для заказа: { orderId } не найден"; _logger.LogWarning(error); throw new ArgumentOutOfRangeException(nameof(orderId), error); } if (routeList.Driver.Id != driver.Id) { _logger.LogWarning($"Водитель {driver.Id} попытался завершить заказ {orderId} водителя {routeList.Driver.Id}"); throw new InvalidOperationException("Нельзя завершить заказ другого водителя"); } if (routeList.Status != RouteListStatus.EnRoute) { var error = $"Нельзя завершить заказ: { orderId }, МЛ не в пути"; _logger.LogWarning(error); throw new ArgumentOutOfRangeException(nameof(orderId), error); } if (routeListAddress.Status != RouteListItemStatus.EnRoute) { var error = $"Нельзя завершить заказ: { orderId }, адрес МЛ не в пути"; _logger.LogWarning(error); throw new ArgumentOutOfRangeException(nameof(orderId), error); } routeListAddress.DriverBottlesReturned = bottlesReturnCount; routeList.ChangeAddressStatus(_unitOfWork, routeListAddress.Id, RouteListItemStatus.Completed); if (rating < _maxClosingRating) { var complaintReason = _complaintsRepository.GetDriverComplaintReasonById(_unitOfWork, driverComplaintReasonId); var complaintSource = _complaintsRepository.GetComplaintSourceById(_unitOfWork, _webApiParametersProvider.ComplaintSourceId); var reason = complaintReason?.Name ?? otherDriverComplaintReasonComment; var complaint = new Complaint { ComplaintSource = complaintSource, ComplaintType = ComplaintType.Driver, Order = vodovozOrder, DriverRating = rating, DeliveryPoint = vodovozOrder.DeliveryPoint, CreationDate = recievedTime, ChangedDate = recievedTime, CreatedBy = driver, ChangedBy = driver, ComplaintText = $"Заказ номер { orderId }\n" + $"По причине { reason }" }; _unitOfWork.Save(complaint); } if (bottlesReturnCount != vodovozOrder.BottlesReturn) { if (!string.IsNullOrWhiteSpace(driverComment)) { vodovozOrder.DriverMobileAppComment = driverComment; vodovozOrder.DriverMobileAppCommentTime = recievedTime; } vodovozOrder.DriverCallType = DriverCallType.CommentFromMobileApp; _unitOfWork.Save(vodovozOrder); } _unitOfWork.Save(routeListAddress); _unitOfWork.Save(routeList); _unitOfWork.Commit(); }
public override void GetById(ObjectId id) { Collection = Connection.GetCollection(collectionName); var filter = Builders <BsonDocument> .Filter.Eq("_id", id); var document = Collection.Find(filter).First(); _id = id; Description = document.GetValue("Description").AsString; Doctor = new Doctor(); Doctor.GetById(document.GetValue("Doctor").AsInt32, sqlConnection); Article = new Article(); Article.GetById(document.GetValue("Article").AsBsonDocument.GetValue("$id").AsObjectId, Connection); foreach (BsonDocument doc in document.GetValue("Tags").AsBsonArray) { Tag tag = new Tag(); tag.GetById(doc.GetValue("$id").AsObjectId, Connection); Tags.Add(tag); } foreach (BsonDocument doc in document.GetValue("MedicineObjects").AsBsonArray) { switch (doc.GetValue("Table").AsString) { case "Complaint": Complaint complaint = new Complaint(); complaint.GetById(doc.GetValue("Id").AsInt32, sqlConnection); MedicineObjects.Add(complaint); break; case "Diagnosis": Diagnosis diagnosis = new Diagnosis(); diagnosis.GetById(doc.GetValue("Id").AsInt32, sqlConnection); MedicineObjects.Add(diagnosis); break; case "Doctor": Doctor doctor = new Doctor(); doctor.GetById(doc.GetValue("Id").AsInt32, sqlConnection); MedicineObjects.Add(doctor); break; case "Medicament": Medicament medicament = new Medicament(); medicament.GetById(doc.GetValue("Id").AsInt32, sqlConnection); MedicineObjects.Add(medicament); break; case "Patient": Patient patient = new Patient(); patient.GetById(doc.GetValue("Id").AsInt32, sqlConnection); MedicineObjects.Add(patient); break; case "Problem": Problem problem = new Problem(); problem.GetById(doc.GetValue("Id").AsInt32, sqlConnection); MedicineObjects.Add(problem); break; case "Symptom": Symptom symptom = new Symptom(); symptom.GetById(doc.GetValue("Id").AsInt32, sqlConnection); MedicineObjects.Add(symptom); break; } } foreach (BsonDocument doc in document.GetValue("Changes").AsBsonArray) { Change change = new Change() { ChangeTime = doc.GetValue("ChangeTime").ToUniversalTime(), Content = doc.GetValue("Content").AsString }; Changes.Add(change); } }
// GET api/complaintapi/5 public String Get(int id) { Complaint Complaint = _db.Complaints.Find(id); return(Json.Encode(Complaint)); }
public async Task <IActionResult> Create(CreateComplaintViewModel model) { var currentUser = await GetCurrentUserAsync(); if (currentUser == null) { throw new Exception("Current user not found"); } string msg = null; if (!ModelState.IsValid) { msg = $"The Complaint was not created. Please fix the errors shown below."; ViewData["AlertMessage"] = new AlertViewModel(msg, AlertStatus.Error, "Error"); // Populate the select lists before returning the model model.SelectLists = await _dal.GetCommonSelectListsAsync(model.CurrentOfficeId); model.DisableCurrentOwnerSelect = !(model.CurrentOfficeId == currentUser.OfficeId || User.IsInRole(CtsRole.DivisionManager.ToString())); return(View(model)); } if ((!User.IsInRole(CtsRole.DivisionManager.ToString()) && model.CurrentOfficeId != currentUser.OfficeId) || model.CurrentOwnerId == CTS.SelectUserMasterText) { model.CurrentOwnerId = null; } var complaint = new Complaint(model) { Status = ComplaintStatus.New, DateEntered = DateTime.Now, EnteredBy = currentUser, DateCurrentOwnerAssigned = (model.CurrentOwnerId != null) ? (DateTime?)DateTime.Now : null, DateCurrentOwnerAccepted = (model.CurrentOwnerId != null && model.CurrentOwnerId == currentUser.Id) ? (DateTime?)DateTime.Now : null, }; // Save main complaint details try { _context.Add(complaint); await _context.SaveChangesAsync(); } catch (Exception ex) { ex.Data.Add("Action", "Saving Complaint"); ex.Data.Add("ViewModel", model); await _errorLogger.LogErrorAsync(ex, (User == null)? "Unknown" : User.Identity.Name, MethodBase.GetCurrentMethod().Name); msg = "There was an error saving the complaint. Please try again or contact support."; ViewData["AlertMessage"] = new AlertViewModel(msg, AlertStatus.Error, "Error"); // Populate the select lists before returning the model model.SelectLists = await _dal.GetCommonSelectListsAsync(model.CurrentOfficeId); model.DisableCurrentOwnerSelect = !(model.CurrentOfficeId == currentUser.OfficeId || User.IsInRole(CtsRole.DivisionManager.ToString())); return(View(model)); } // The complaint was successfully saved. Now start tracking any subsequent errors. var saveStatus = AlertStatus.Success; // Save initial complaint transitions bool transitionSaveError = false; Guid transitionId = Guid.Empty; try { transitionId = await AddComplaintTransition(new ComplaintTransition() { ComplaintId = complaint.Id, TransferredByUserId = currentUser.Id, TransferredToOfficeId = model.CurrentOfficeId, TransitionType = TransitionType.New, }); if (model.CurrentOwnerId != null) { complaint.CurrentAssignmentTransitionId = await AddComplaintTransition(new ComplaintTransition() { ComplaintId = complaint.Id, TransferredByUserId = currentUser.Id, TransferredToUserId = model.CurrentOwnerId, TransferredToOfficeId = model.CurrentOfficeId, DateAccepted = (currentUser.Id == model.CurrentOwnerId) ? (DateTime?)DateTime.Now : null, TransitionType = TransitionType.Assigned, }); if (model.CurrentOwnerId == currentUser.Id) { complaint.Status = ComplaintStatus.UnderInvestigation; } _context.Update(complaint); await _context.SaveChangesAsync(); } } catch (Exception ex) { ex.Data.Add("Action", "Saving Transitions"); ex.Data.Add("Complaint ID", complaint.Id); ex.Data.Add("ViewModel", model); ex.Data.Add("Complaint Model", complaint); ex.Data.Add("Transition ID", transitionId); await _errorLogger.LogErrorAsync(ex, (User == null)? "Unknown" : User.Identity.Name, MethodBase.GetCurrentMethod().Name); saveStatus = AlertStatus.Warning; transitionSaveError = true; } // Email appropriate recipients bool emailError = false; try { var complaintUrl = Url.Action("Details", "Complaints", new { id = complaint.Id }, protocol: HttpContext.Request.Scheme); if (complaint.CurrentOwnerId == null) { // Email Master of current Office var currentOffice = await _context.LookupOffices.FindAsync(complaint.CurrentOfficeId); var officeMaster = await _userManager.FindByIdAsync(currentOffice.MasterUserId); var masterEmail = await _userManager.GetEmailAsync(officeMaster); await _emailSender.SendEmailAsync( masterEmail, string.Format(EmailTemplates.ComplaintOpenedToMaster.Subject, complaint.Id), string.Format(EmailTemplates.ComplaintOpenedToMaster.PlainBody, complaint.Id, complaintUrl, currentOffice.Name), string.Format(EmailTemplates.ComplaintOpenedToMaster.HtmlBody, complaint.Id, complaintUrl, currentOffice.Name), !officeMaster.Active || !officeMaster.EmailConfirmed, replyTo : currentUser.Email); } else { // Email new owner var currentOwner = await _userManager.FindByIdAsync(complaint.CurrentOwnerId); var currentOwnerEmail = await _userManager.GetEmailAsync(currentOwner); bool isValidUser = currentOwner.Active && currentOwner.EmailConfirmed; await _emailSender.SendEmailAsync( currentOwnerEmail, string.Format(EmailTemplates.ComplaintAssigned.Subject, complaint.Id), string.Format(EmailTemplates.ComplaintAssigned.PlainBody, complaint.Id, complaintUrl), string.Format(EmailTemplates.ComplaintAssigned.HtmlBody, complaint.Id, complaintUrl), !isValidUser, replyTo : currentUser.Email); } } catch (Exception ex) { ex.Data.Add("Action", "Emailing recipients"); ex.Data.Add("Complaint ID", complaint.Id); ex.Data.Add("ViewModel", model); ex.Data.Add("Complaint Model", complaint); await _errorLogger.LogErrorAsync(ex, (User == null)? "Unknown" : User.Identity.Name, MethodBase.GetCurrentMethod().Name); saveStatus = AlertStatus.Warning; emailError = true; } // Save attachments bool attachmentsError = false; int fileCount = 0; string attachmentErrorMessage = null; if (model.Attachments != null && model.Attachments.Count > 0) { switch (_fileService.ValidateUploadedFiles(model.Attachments)) { case FilesValidationResult.TooMany: saveStatus = AlertStatus.Warning; attachmentsError = true; attachmentErrorMessage = "No more than 10 files can be uploaded at a time. "; break; case FilesValidationResult.WrongType: saveStatus = AlertStatus.Warning; attachmentsError = true; attachmentErrorMessage = "An invalid file type was selected. (Supported file types are images, documents, and spreadsheets.) "; break; case FilesValidationResult.Valid: var savedFileList = new List <Attachment>(); try { foreach (var file in model.Attachments) { var attachment = await _fileService.SaveAttachmentAsync(file); if (attachment != null) { attachment.ComplaintId = complaint.Id; attachment.UploadedById = currentUser.Id; _context.Add(attachment); savedFileList.Add(attachment); fileCount++; } } await _context.SaveChangesAsync(); } catch (Exception ex) { ex.Data.Add("Action", "Saving Attachments"); ex.Data.Add("Complaint ID", complaint.Id); ex.Data.Add("ViewModel", model); ex.Data.Add("Complaint Model", complaint); await _errorLogger.LogErrorAsync(ex, (User == null)? "Unknown" : User.Identity.Name, MethodBase.GetCurrentMethod().Name); foreach (var attachment in savedFileList) { await _fileService.TryDeleteFileAsync(attachment.FilePath); if (attachment.IsImage) { await _fileService.TryDeleteFileAsync(attachment.ThumbnailPath); } } fileCount = 0; saveStatus = AlertStatus.Warning; attachmentsError = true; attachmentErrorMessage = "An unknown database error occurred. "; } break; } } // Compile response message if (fileCount == 0) { msg = "The Complaint has been created. "; } else if (fileCount == 1) { msg = "The Complaint has been created and one file was attached. "; } else if (fileCount > 1) { msg = $"The Complaint has been created and {fileCount} files were attached. "; } if (saveStatus != AlertStatus.Success) { if (transitionSaveError) { msg += "There were errors saving some of the complaint details. Please contact support. "; } if (emailError) { msg += "There was an error emailing the recipients. Please contact support. "; } if (attachmentsError) { msg += "There was a problem saving the attachments: " + attachmentErrorMessage + "No files were saved. "; } TempData.SaveAlertForSession(msg, AlertStatus.Warning, "Warning"); } TempData.SaveAlertForSession(msg, saveStatus, saveStatus.GetDisplayName()); return(RedirectToAction("Details", new { id = complaint.Id })); }
public async Task <bool> UpdateComplaint(Complaint complaint) { return(await this._rechargeApiDAL.UpdateComplaint(complaint)); }
public string AddComplaint(Complaint complaint) { return(complaint.Id); }
public async Task <ActionResult> New(NewImprovementViewModel model) { if (ModelState.IsValid && (model.ComplaintSource == "order" || model.ComplaintSource == "direct" || model.ComplaintSource == "invoice")) { var complaintsDAL = new ROLWeb.Models.Improvements.ImproventsDAL(); var rentalsDAL = new ROLWeb.Models.Rentals.RentalsDAL(); Customer custId = new Customer(); StringBuilder sb = new StringBuilder(); List <Attachment> attachments = new List <Attachment>(); byte[] file = null; if (model.file != null) { var inputFile = new MemoryStream(); await model.file.InputStream.CopyToAsync(inputFile); inputFile.Seek(0, 0); attachments.Add(new Attachment(inputFile, model.file.FileName)); inputFile.Seek(0, 0); file = inputFile.ToArray(); } if (model.ComplaintSource == "order") { var orderDetails = rentalsDAL.GetRentalOrderDetails(this.ActiveCustomer, model.ReferenceId); if (orderDetails == null) { return(View("FormSubmitted", new FormSubmittedViewModel { Title = Resources.Error, Message = Resources.DataProvidedNotValid })); } custId.DatabaseName = this.ActiveCustomer.DatabaseName; custId.CompanyId = this.ActiveCustomer.CompanyId; custId.CustomerId = this.ActiveCustomer.CustomerId; custId.Name = orderDetails.AccountName; //Register complaint var complaint = new Complaint { UserId = User.Identity.GetUserId(), DatabaseName = custId.DatabaseName, CompanyId = custId.CompanyId, CustomerId = custId.CustomerId, Description = model.Description ?? "", SuggestedSolution = model.SuggestedSolution ?? "", ComplaintSource = "order", ReferenceId = orderDetails.InventTransId, StatusId = "10", Answer = "", Attachment = file }; complaint.ComplaintId = await complaintsDAL.InsertComplaint(complaint); sb.AppendFormat("<h2>MyRiwal {0}</h2>", Resources.NewImprovementForm); sb.AppendLine("<table>"); sb.AppendFormat("<tr><td>{0}:</td><td>{1:dd-MM-yyyy HH:mm}</td></tr>\n", Resources.DateTime, DateTime.Now); sb.AppendFormat("<tr><td>MyRiwal {0}:</td><td>{1}</td></tr>\n", Resources.UserName, ((System.Security.Claims.ClaimsIdentity)User.Identity).FindFirst("FullName").Value); sb.AppendFormat("<tr><td></td><td></td></tr>\n"); sb.AppendFormat("<tr><td>{0}:</td><td></td></tr>\n", Resources.FormDetails); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.CompanyNumber, this.ActiveCustomer.CompanyId); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.CustomerNumber, orderDetails.CustAccount); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.CustomerName, orderDetails.AccountName); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.ImprovementNumber, complaint.ComplaintKey); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.RentalOrder, orderDetails.SalesId); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.MachineSerialNumber, orderDetails.ObjectId); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.FleetNumber, orderDetails.AssetId); sb.AppendLine("</table>"); sb.AppendLine("<br /><br />"); sb.AppendFormat("{0}: <br />", Resources.ImprovementDescription); sb.AppendLine(model.Description); sb.AppendLine("<br /><br />"); sb.AppendFormat("{0}: <br />", Resources.SuggestedSolution); sb.AppendLine(model.SuggestedSolution); } // end source="order" else if (model.ComplaintSource == "invoice") { var invoice = (await db.GetInvoiceDetails(this.ActiveCustomer, model.ReferenceId)); if (invoice == null) { return(View("FormSubmitted", new FormSubmittedViewModel { Title = Resources.Error, Message = Resources.DataProvidedNotValid })); } custId.DatabaseName = this.ActiveCustomer.DatabaseName; custId.CompanyId = this.ActiveCustomer.CompanyId; custId.CustomerId = invoice.InvoiceAccount; custId.Name = invoice.AccountName; //Register complaint var complaint = new Complaint { UserId = User.Identity.GetUserId(), DatabaseName = custId.DatabaseName, CompanyId = custId.CompanyId, CustomerId = custId.CustomerId, Description = model.Description ?? "", SuggestedSolution = model.SuggestedSolution ?? "", ComplaintSource = "invoice", ReferenceId = invoice.InvoiceId, StatusId = "10", Answer = "", Attachment = file }; complaint.ComplaintId = await complaintsDAL.InsertComplaint(complaint); sb.AppendFormat("<h2>MyRiwal {0}</h2>", Resources.NewImprovementForm); sb.AppendLine("<table>"); sb.AppendFormat("<tr><td>{0}:</td><td>{1:dd-MM-yyyy HH:mm}</td></tr>\n", Resources.DateTime, DateTime.Now); sb.AppendFormat("<tr><td>MyRiwal {0}:</td><td>{1}</td></tr>\n", Resources.UserName, ((System.Security.Claims.ClaimsIdentity)User.Identity).FindFirst("FullName").Value); sb.AppendFormat("<tr><td></td><td></td></tr>\n"); sb.AppendFormat("<tr><td>{0}:</td><td></td></tr>\n", Resources.FormDetails); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.CompanyNumber, this.ActiveCustomer.CompanyId); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.CustomerNumber, invoice.InvoiceAccount); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.CustomerName, invoice.AccountName); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.ImprovementNumber, complaint.ComplaintKey); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.InvoiceNumber, invoice.InvoiceId); sb.AppendLine("</table>"); sb.AppendLine("<br /><br />"); sb.AppendFormat("{0}: <br />", Resources.ImprovementDescription); sb.AppendLine(model.Description); sb.AppendLine("<br /><br />"); sb.AppendFormat("{0}: <br />", Resources.SuggestedSolution); sb.AppendLine(model.SuggestedSolution); } // end source="invoice" else if (model.ComplaintSource == "direct") { custId.DatabaseName = this.ActiveCustomer.DatabaseName; custId.CompanyId = this.ActiveCustomer.CompanyId; custId.CustomerId = this.ActiveCustomer.CustomerId; custId.Name = this.ActiveCustomer.Name; //Register complaint var complaint = new Complaint { UserId = User.Identity.GetUserId(), DatabaseName = custId.DatabaseName, CompanyId = custId.CompanyId, CustomerId = custId.CustomerId, Description = model.Description ?? "", SuggestedSolution = model.SuggestedSolution ?? "", ComplaintSource = "direct", ReferenceId = "", StatusId = "10", Answer = "", Attachment = file }; complaint.ComplaintId = await complaintsDAL.InsertComplaint(complaint); sb.AppendFormat("<h2>MyRiwal {0}</h2>", Resources.NewImprovementForm); sb.AppendLine("<table>"); sb.AppendFormat("<tr><td>{0}:</td><td>{1:dd-MM-yyyy HH:mm}</td></tr>\n", Resources.DateTime, DateTime.Now); sb.AppendFormat("<tr><td>MyRiwal {0}:</td><td>{1}</td></tr>\n", Resources.UserName, ((System.Security.Claims.ClaimsIdentity)User.Identity).FindFirst("FullName").Value); sb.AppendFormat("<tr><td></td><td></td></tr>\n"); sb.AppendFormat("<tr><td>{0}:</td><td></td></tr>\n", Resources.FormDetails); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.CompanyNumber, this.ActiveCustomer.CompanyId); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.CustomerNumber, custId.CustomerId); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.CustomerName, custId.Name); sb.AppendFormat("<tr><td>{0}:</td><td>{1}</td></tr>\n", Resources.ImprovementNumber, complaint.ComplaintKey); sb.AppendLine("</table>"); sb.AppendLine("<br /><br />"); sb.AppendFormat("{0}: <br />", Resources.ImprovementDescription); sb.AppendLine(model.Description); sb.AppendLine("<br /><br />"); sb.AppendFormat("{0}: <br />", Resources.SuggestedSolution); sb.AppendLine(model.SuggestedSolution); } // end source="direct" string userEmail = ((System.Security.Claims.ClaimsIdentity)User.Identity).FindFirst("Email").Value; string onRentEmail = await rentalsDAL.GetOnRentEmailAddress(custId); if (MailClient.SendEmail(custId, Resources.NewImprovementForm, sb.ToString(), null, userEmail, onRentEmail, null, attachments)) { return(View("FormSubmitted", new FormSubmittedViewModel { Title = Resources.FormSubmitted, Message = Resources.RequestSubmitted })); } return(View("FormSubmitted", new FormSubmittedViewModel { Title = Resources.Error, Message = Resources.RequestNotSent })); } // modelstate.isvalid return(View("FormSubmitted", new FormSubmittedViewModel { Title = Resources.Error, Message = Resources.DataProvidedNotValid })); }
public ComplaintViewModel() { complaint = new Complaint(); DataService = new ComplaintService(); AcceptCommand = new RelayCommand(AcceptExecute); }
private IQueryOver <Complaint> GetComplaintQuery(IUnitOfWork uow) { ComplaintJournalNode resultAlias = null; Complaint complaintAlias = null; Employee authorAlias = null; Counterparty counterpartyAlias = null; DeliveryPoint deliveryPointAlias = null; ComplaintGuiltyItem complaintGuiltyItemAlias = null; Employee guiltyEmployeeAlias = null; Subdivision guiltySubdivisionAlias = null; Fine fineAlias = null; Order orderAlias = null; ComplaintDiscussion discussionAlias = null; Subdivision subdivisionAlias = null; ComplaintKind complaintKindAlias = null; Subdivision superspecialAlias = null; ComplaintObject complaintObjectAlias = null; var authorProjection = Projections.SqlFunction( new SQLFunctionTemplate(NHibernateUtil.String, "GET_PERSON_NAME_WITH_INITIALS(?1, ?2, ?3)"), NHibernateUtil.String, Projections.Property(() => authorAlias.LastName), Projections.Property(() => authorAlias.Name), Projections.Property(() => authorAlias.Patronymic) ); var workInSubdivisionsSubQuery = QueryOver.Of <Subdivision>(() => subdivisionAlias) .Where(() => subdivisionAlias.Id == discussionAlias.Subdivision.Id) .Where(() => discussionAlias.Status == ComplaintStatuses.InProcess) .Select(Projections.Conditional( Restrictions.IsNotNull(Projections.Property(() => subdivisionAlias.ShortName)), Projections.Property(() => subdivisionAlias.ShortName), Projections.Constant("?") ) ); var subdivisionsSubqueryProjection = Projections.SqlFunction( new SQLFunctionTemplate(NHibernateUtil.String, "GROUP_CONCAT(DISTINCT ?1 SEPARATOR ?2)"), NHibernateUtil.String, Projections.SubQuery(workInSubdivisionsSubQuery), Projections.Constant(", ")); string okkSubdivision = uow.GetById <Subdivision>(_subdivisionParametersProvider.GetOkkId()).ShortName ?? "?"; var workInSubdivisionsProjection = Projections.SqlFunction( new SQLFunctionTemplate(NHibernateUtil.String, "CONCAT_WS(',', ?1, IF(?2 = 'Checking',?3, ''))"), NHibernateUtil.String, subdivisionsSubqueryProjection, Projections.Property(() => complaintAlias.Status), Projections.Constant(okkSubdivision) ); var plannedCompletionDateProjection = Projections.SqlFunction( new SQLFunctionTemplate(NHibernateUtil.String, "GROUP_CONCAT(DISTINCT DATE_FORMAT(?1, \"%d.%m.%Y\") SEPARATOR ?2)"), NHibernateUtil.String, Projections.Property(() => discussionAlias.PlannedCompletionDate), Projections.Constant("\n")); var lastPlannedCompletionDateProjection = Projections.SqlFunction( new SQLFunctionTemplate(NHibernateUtil.DateTime, "MAX(DISTINCT ?1)"), NHibernateUtil.DateTime, Projections.Property(() => discussionAlias.PlannedCompletionDate)); var counterpartyWithAddressProjection = Projections.SqlFunction( new SQLFunctionTemplate(NHibernateUtil.String, "CONCAT_WS('\n', ?1, COMPILE_ADDRESS(?2))"), NHibernateUtil.String, Projections.Property(() => counterpartyAlias.Name), Projections.Property(() => deliveryPointAlias.Id)); var guiltyEmployeeProjection = Projections.SqlFunction( new SQLFunctionTemplate(NHibernateUtil.String, "GET_PERSON_NAME_WITH_INITIALS(?1, ?2, ?3)"), NHibernateUtil.String, Projections.Property(() => guiltyEmployeeAlias.LastName), Projections.Property(() => guiltyEmployeeAlias.Name), Projections.Property(() => guiltyEmployeeAlias.Patronymic) ); var guiltiesProjection = Projections.SqlFunction( new SQLFunctionTemplate(NHibernateUtil.String, "GROUP_CONCAT(DISTINCT " + "CASE ?1 " + $"WHEN '{nameof(ComplaintGuiltyTypes.Client)}' THEN 'Клиент' " + $"WHEN '{nameof(ComplaintGuiltyTypes.Depreciation )}' THEN 'Износ' " + $"WHEN '{nameof(ComplaintGuiltyTypes.None)}' THEN 'Нет' " + $"WHEN '{nameof(ComplaintGuiltyTypes.Employee)}' THEN CONCAT('(',?5,')', ?2)" + $"WHEN '{nameof(ComplaintGuiltyTypes.Subdivision)}' THEN ?3 " + $"WHEN '{nameof(ComplaintGuiltyTypes.Supplier)}' THEN 'Поставщик' " + "ELSE '' " + "END" + " SEPARATOR ?4)"), NHibernateUtil.String, Projections.Property(() => complaintGuiltyItemAlias.GuiltyType), guiltyEmployeeProjection, Projections.Property(() => guiltySubdivisionAlias.ShortName), Projections.Constant("\n"), Projections.Property(() => superspecialAlias.ShortName)); var finesProjection = Projections.SqlFunction( new SQLFunctionTemplate(NHibernateUtil.String, "GROUP_CONCAT(DISTINCT CONCAT(ROUND(?1, 2), ' р.') SEPARATOR ?2)"), NHibernateUtil.String, Projections.Property(() => fineAlias.TotalMoney), Projections.Constant("\n")); var query = uow.Session.QueryOver(() => complaintAlias) .Left.JoinAlias(() => complaintAlias.CreatedBy, () => authorAlias) .Left.JoinAlias(() => complaintAlias.Counterparty, () => counterpartyAlias) .Left.JoinAlias(() => complaintAlias.Order, () => orderAlias) .Left.JoinAlias(() => complaintAlias.DeliveryPoint, () => deliveryPointAlias) .Left.JoinAlias(() => complaintAlias.Guilties, () => complaintGuiltyItemAlias) .Left.JoinAlias(() => complaintAlias.ComplaintKind, () => complaintKindAlias) .Left.JoinAlias(() => complaintAlias.Fines, () => fineAlias) .Left.JoinAlias(() => complaintAlias.ComplaintDiscussions, () => discussionAlias) .Left.JoinAlias(() => discussionAlias.Subdivision, () => subdivisionAlias) .Left.JoinAlias(() => complaintGuiltyItemAlias.Employee, () => guiltyEmployeeAlias) .Left.JoinAlias(() => guiltyEmployeeAlias.Subdivision, () => superspecialAlias) .Left.JoinAlias(() => complaintGuiltyItemAlias.Subdivision, () => guiltySubdivisionAlias) .Left.JoinAlias(() => complaintKindAlias.ComplaintObject, () => complaintObjectAlias); #region Filter if (FilterViewModel != null) { if (FilterViewModel.IsForRetail != null) { query.Where(() => counterpartyAlias.IsForRetail == FilterViewModel.IsForRetail); } FilterViewModel.EndDate = FilterViewModel.EndDate.Date.AddHours(23).AddMinutes(59); if (FilterViewModel.StartDate.HasValue) { FilterViewModel.StartDate = FilterViewModel.StartDate.Value.Date; } QueryOver <ComplaintDiscussion, ComplaintDiscussion> dicussionQuery = null; if (FilterViewModel.Subdivision != null) { dicussionQuery = QueryOver.Of(() => discussionAlias) .Select(Projections.Property <ComplaintDiscussion>(p => p.Id)) .Where(() => discussionAlias.Subdivision.Id == FilterViewModel.Subdivision.Id) .And(() => discussionAlias.Complaint.Id == complaintAlias.Id); } if (FilterViewModel.StartDate.HasValue) { switch (FilterViewModel.FilterDateType) { case DateFilterType.PlannedCompletionDate: if (dicussionQuery == null) { query = query.Where(() => complaintAlias.PlannedCompletionDate <= FilterViewModel.EndDate) .And(() => FilterViewModel.StartDate == null || complaintAlias.PlannedCompletionDate >= FilterViewModel.StartDate.Value); } else { dicussionQuery = dicussionQuery .And(() => FilterViewModel.StartDate == null || discussionAlias.PlannedCompletionDate >= FilterViewModel.StartDate.Value) .And(() => discussionAlias.PlannedCompletionDate <= FilterViewModel.EndDate); } break; case DateFilterType.ActualCompletionDate: query = query.Where(() => complaintAlias.ActualCompletionDate <= FilterViewModel.EndDate) .And(() => FilterViewModel.StartDate == null || complaintAlias.ActualCompletionDate >= FilterViewModel.StartDate.Value); break; case DateFilterType.CreationDate: query = query.Where(() => complaintAlias.CreationDate <= FilterViewModel.EndDate) .And(() => FilterViewModel.StartDate == null || complaintAlias.CreationDate >= FilterViewModel.StartDate.Value); break; default: throw new ArgumentOutOfRangeException(); } } if (dicussionQuery != null) { query.WithSubquery.WhereExists(dicussionQuery); } if (FilterViewModel.ComplaintType != null) { query = query.Where(() => complaintAlias.ComplaintType == FilterViewModel.ComplaintType); } if (FilterViewModel.ComplaintStatus != null) { query = query.Where(() => complaintAlias.Status == FilterViewModel.ComplaintStatus); } if (FilterViewModel.Employee != null) { query = query.Where(() => complaintAlias.CreatedBy.Id == FilterViewModel.Employee.Id); } if (FilterViewModel.Counterparty != null) { query = query.Where(() => complaintAlias.Counterparty.Id == FilterViewModel.Counterparty.Id); } if (FilterViewModel.CurrentUserSubdivision != null && FilterViewModel.ComplaintDiscussionStatus != null) { query = query.Where(() => discussionAlias.Subdivision.Id == FilterViewModel.CurrentUserSubdivision.Id) .And(() => discussionAlias.Status == FilterViewModel.ComplaintDiscussionStatus); } if (FilterViewModel.GuiltyItemVM?.Entity?.GuiltyType != null) { var subquery = QueryOver.Of <ComplaintGuiltyItem>() .Where(g => g.GuiltyType == FilterViewModel.GuiltyItemVM.Entity.GuiltyType.Value); switch (FilterViewModel.GuiltyItemVM.Entity.GuiltyType) { case ComplaintGuiltyTypes.None: case ComplaintGuiltyTypes.Client: case ComplaintGuiltyTypes.Depreciation: case ComplaintGuiltyTypes.Supplier: break; case ComplaintGuiltyTypes.Employee: if (FilterViewModel.GuiltyItemVM.Entity.Employee != null) { subquery.Where(g => g.Employee.Id == FilterViewModel.GuiltyItemVM.Entity.Employee.Id); } break; case ComplaintGuiltyTypes.Subdivision: if (FilterViewModel.GuiltyItemVM.Entity.Subdivision != null) { subquery.Where(g => g.Subdivision.Id == FilterViewModel.GuiltyItemVM.Entity.Subdivision.Id); } break; default: break; } query.WithSubquery.WhereProperty(x => x.Id).In(subquery.Select(x => x.Complaint)); } if (FilterViewModel.ComplaintKind != null) { query.Where(() => complaintAlias.ComplaintKind.Id == FilterViewModel.ComplaintKind.Id); } if (FilterViewModel.ComplaintObject != null) { query.Where(() => complaintObjectAlias.Id == FilterViewModel.ComplaintObject.Id); } } #endregion Filter query.Where( GetSearchCriterion( () => complaintAlias.Id, () => complaintAlias.ComplaintText, () => complaintAlias.ResultText, () => counterpartyAlias.Name, () => deliveryPointAlias.CompiledAddress ) ); query.SelectList(list => list .SelectGroup(() => complaintAlias.Id).WithAlias(() => resultAlias.Id) .Select(() => complaintAlias.CreationDate).WithAlias(() => resultAlias.Date) .Select(() => complaintAlias.ComplaintType).WithAlias(() => resultAlias.Type) .Select(() => complaintAlias.Status).WithAlias(() => resultAlias.Status) .Select(workInSubdivisionsProjection).WithAlias(() => resultAlias.WorkInSubdivision) .Select(plannedCompletionDateProjection).WithAlias(() => resultAlias.PlannedCompletionDate) .Select(lastPlannedCompletionDateProjection).WithAlias(() => resultAlias.LastPlannedCompletionDate) .Select(counterpartyWithAddressProjection).WithAlias(() => resultAlias.ClientNameWithAddress) .Select(guiltiesProjection).WithAlias(() => resultAlias.Guilties) .Select(authorProjection).WithAlias(() => resultAlias.Author) .Select(finesProjection).WithAlias(() => resultAlias.Fines) .Select(() => complaintAlias.ComplaintText).WithAlias(() => resultAlias.ComplaintText) .Select(() => complaintKindAlias.Name).WithAlias(() => resultAlias.ComplaintKindString) .Select(() => complaintKindAlias.IsArchive).WithAlias(() => resultAlias.ComplaintKindIsArchive) .Select(() => complaintAlias.ResultText).WithAlias(() => resultAlias.ResultText) .Select(() => complaintAlias.ActualCompletionDate).WithAlias(() => resultAlias.ActualCompletionDate) .Select(() => complaintObjectAlias.Name).WithAlias(() => resultAlias.ComplaintObjectString) ); query.TransformUsing(Transformers.AliasToBean <ComplaintJournalNode>()) .OrderBy(n => n.Id) .Desc(); return(query); }
public Complaint UpdateComplaintStarStatus(int id, bool star) { using (var connection = SqlConnectionManager.GetConnection()) using (var command = new NpgsqlCommand()) { command.Connection = connection; command.CommandText = "select * from updateComplaintStarStatus(@id, @star)"; command.Parameters.AddWithValue("@id", id); command.Parameters.Add("@star", NpgsqlDbType.Bit).Value = star; var reader = command.ExecuteReader(); if (reader.Read()) { var c = new Complaint() { Id = int.Parse(reader["c_id"].ToString()), Title = reader["title"].ToString(), Student = new Student() { Id = int.Parse(reader["student_id"].ToString()) }, ComplaintCategory = new ComplaintCategory() { Id = int.Parse(reader["complaint_category_id"].ToString()), Name = reader["complaint_category_name"].ToString(), Code = reader["complaint_category_code"].ToString() }, DateTime = DateTime.Parse(reader["datetime"].ToString()), Description = reader["description"].ToString(), Starred = ((BitArray)reader["c_starred"]).Get(0), Feedback = reader["feedback"].ToString() }; var status = int.Parse(reader["status"].ToString()); switch (status) { case 0: c.ComplaintStatus = ComplaintStatus.Pending; break; case 1: c.ComplaintStatus = ComplaintStatus.Scheduled; break; default: c.ComplaintStatus = ComplaintStatus.Resolved; break; } var appDate = reader["appointment_date_pref"].ToString(); if (!string.IsNullOrEmpty(appDate) || !string.IsNullOrWhiteSpace(appDate)) { appDate = appDate.Substring(0, 10); c.AppointmentDatePreference = DateTime.ParseExact(appDate, "dd-MM-yyyy", CultureInfo.InvariantCulture); } else { c.AppointmentDatePreference = null; } var appFromTime = reader["appointment_from_time_pref"].ToString(); var appToTime = reader["appointment_to_time_pref"].ToString(); if (!string.IsNullOrEmpty(appFromTime) || !string.IsNullOrWhiteSpace(appFromTime)) { appFromTime = $"1970-01-01T{appFromTime}"; c.AppointmentFromTimePreference = DateTime.Parse(appFromTime); } else { c.AppointmentFromTimePreference = null; } if (!string.IsNullOrEmpty(appToTime) || !string.IsNullOrWhiteSpace(appToTime)) { appToTime = $"1970-01-01T{appToTime}"; c.AppointmentToTimePreference = DateTime.Parse(appToTime); } else { c.AppointmentToTimePreference = null; } return(c); } return(null); } }
private async Task AddComplaint() { this.Activity.RunOnUiThread(() => progressBar.Visibility = ViewStates.Visible); List <string> photos = new List <string>(); foreach (Bitmap b in images) { photos.Add(ImageToBase64String(b)); } Complaint complaint = new Complaint() { furnitureId = furniture.id, description = problemDesc.Text, photo = photos, senderName = GlobalVars.login, madeBy = furniture.madeBy }; if (complaint.Correct() && photoDefault != photoPreview.Drawable) { FireBaseConnector connector = new FireBaseConnector(); var res = connector.dataInsert(complaint); if (res == 0) { if (photos.Count != 0) { Android.Support.V7.App.AlertDialog.Builder alertDialog = new Android.Support.V7.App.AlertDialog.Builder(this.Activity); alertDialog.SetTitle(GetString(Resource.String.dataError)); alertDialog.SetIcon(Resource.Drawable.ic4c_192x192); alertDialog.SetMessage(GetString(Resource.String.addCorrect)); alertDialog.SetNeutralButton(GetString(Resource.String.OKbutton), delegate { alertDialog.Dispose(); }); alertDialog.Show(); } else { Android.Support.V7.App.AlertDialog.Builder alertDialog = new Android.Support.V7.App.AlertDialog.Builder(this.Activity); alertDialog.SetTitle(GetString(Resource.String.photoError)); alertDialog.SetIcon(Resource.Drawable.ic4c_192x192); alertDialog.SetMessage(GetString(Resource.String.photoErrorMsg)); alertDialog.SetNeutralButton(GetString(Resource.String.OKbutton), delegate { alertDialog.Dispose(); }); alertDialog.Show(); } } if (res == -1) { Android.Support.V7.App.AlertDialog.Builder alertDialog = new Android.Support.V7.App.AlertDialog.Builder(this.Activity); alertDialog.SetTitle(GetString(Resource.String.noInternetConnection)); alertDialog.SetIcon(Resource.Drawable.ic5c_192x192); alertDialog.SetMessage(GetString(Resource.String.checkConnection)); alertDialog.SetNeutralButton(GetString(Resource.String.OKbutton), delegate { alertDialog.Dispose(); }); alertDialog.Show(); } if (res == 1) { Android.Support.V7.App.AlertDialog.Builder alertDialog = new Android.Support.V7.App.AlertDialog.Builder(this.Activity); alertDialog.SetTitle(GetString(Resource.String.complaintCorrect)); alertDialog.SetIcon(Resource.Drawable.ok2a_192x192); alertDialog.SetMessage(GetString(Resource.String.complaintMessage)); alertDialog.SetNeutralButton(GetString(Resource.String.OKbutton), delegate { alertDialog.Dispose(); this.OnComplaintCreated(); this.Dismiss(); }); alertDialog.Show(); } } else { Android.Support.V7.App.AlertDialog.Builder alertDialog = new Android.Support.V7.App.AlertDialog.Builder(this.Activity); alertDialog.SetTitle(GetString(Resource.String.dataError)); alertDialog.SetIcon(Resource.Drawable.ic4c_192x192); alertDialog.SetMessage(GetString(Resource.String.addCorrect)); alertDialog.SetNeutralButton(GetString(Resource.String.OKbutton), delegate { alertDialog.Dispose(); }); alertDialog.Show(); } this.Activity.RunOnUiThread(() => btn2Complaint.Enabled = true); this.Activity.RunOnUiThread(() => progressBar.Visibility = ViewStates.Invisible); }
public Complaint CreateComplaint(Complaint complaint) { using (var connection = SqlConnectionManager.GetConnection()) using (var command = new NpgsqlCommand()) { command.Connection = connection; command.CommandText = "select * from createComplaint(@title, @studentId, @complaintCategoryId, @datetime, @description, @datePref, @fromTimePref, @toTimePref, @pictures)"; command.Parameters.AddWithValue("@title", complaint.Title); command.Parameters.AddWithValue("@studentId", complaint.Student.Id); command.Parameters.AddWithValue("@complaintCategoryId", complaint.ComplaintCategory.Id); command.Parameters.AddWithValue("@description", complaint.Description); command.Parameters.Add("@datetime", NpgsqlDbType.TimestampTz).Value = complaint.DateTime; command.Parameters.Add("@datePref", NpgsqlDbType.Date).Value = complaint.AppointmentDatePreference; command.Parameters.Add("@pictures", NpgsqlDbType.Array | NpgsqlDbType.Text).Value = complaint.Pictures; if (complaint.AppointmentFromTimePreference != null) { var fromTimeString = complaint.AppointmentFromTimePreference.Value.ToString("HH:mm:ss", CultureInfo.InvariantCulture); var fromTime = TimeSpan.Parse(fromTimeString); command.Parameters.Add("@fromTimePref", NpgsqlDbType.Time).Value = fromTime; } else { command.Parameters.Add("@fromTimePref", NpgsqlDbType.Time).Value = null; } if (complaint.AppointmentToTimePreference != null) { var toTimeString = complaint.AppointmentToTimePreference.Value.ToString("HH:mm:ss", CultureInfo.InvariantCulture); var toTime = TimeSpan.Parse(toTimeString); command.Parameters.Add("@toTimePref", NpgsqlDbType.Time).Value = toTime; } else { command.Parameters.Add("@toTimePref", NpgsqlDbType.Time).Value = null; } var reader = command.ExecuteReader(); if (reader.Read()) { var c = new Complaint() { Id = int.Parse(reader["c_id"].ToString()), Title = reader["c_title"].ToString(), Student = new Student() { Id = int.Parse(reader["c_student_id"].ToString()) }, ComplaintCategory = new ComplaintCategory() { Id = int.Parse(reader["c_complaint_category_id"].ToString()), Name = reader["c_complaint_category_name"].ToString(), Code = reader["c_complaint_category_code"].ToString() }, DateTime = DateTime.Parse(reader["c_datetime"].ToString()), Description = reader["c_description"].ToString(), Starred = ((BitArray)reader["c_starred"]).Get(0), Feedback = reader["c_feedback"].ToString() }; var status = int.Parse(reader["c_status"].ToString()); switch (status) { case 0: c.ComplaintStatus = ComplaintStatus.Pending; break; case 1: c.ComplaintStatus = ComplaintStatus.Scheduled; break; default: c.ComplaintStatus = ComplaintStatus.Resolved; break; } var appDate = reader["c_appointment_date_pref"].ToString(); if (!string.IsNullOrEmpty(appDate) || !string.IsNullOrWhiteSpace(appDate)) { appDate = appDate.Substring(0, 10); c.AppointmentDatePreference = DateTime.ParseExact(appDate, "dd-MM-yyyy", CultureInfo.InvariantCulture); } else { c.AppointmentDatePreference = null; } var appFromTime = reader["c_appointment_from_time_pref"].ToString(); var appToTime = reader["c_appointment_to_time_pref"].ToString(); if (!string.IsNullOrEmpty(appFromTime) || !string.IsNullOrWhiteSpace(appFromTime)) { appFromTime = $"1970-01-01T{appFromTime}"; c.AppointmentFromTimePreference = DateTime.Parse(appFromTime); } else { c.AppointmentFromTimePreference = null; } if (!string.IsNullOrEmpty(appToTime) || !string.IsNullOrWhiteSpace(appToTime)) { appToTime = $"1970-01-01T{appToTime}"; c.AppointmentToTimePreference = DateTime.Parse(appToTime); } else { c.AppointmentToTimePreference = null; } return(c); } return(null); } }
public void ComplaintDisputed(Complaint complaint) { }
public List <Complaint> GetComplaintsByCaretaker(int cid, int len) { using (var connection = SqlConnectionManager.GetConnection()) using (var command = new NpgsqlCommand()) { var complaints = new List <Complaint>(); command.Connection = connection; command.CommandText = "select * from getComplaintsByCaretaker(@cid, @len)"; command.Parameters.AddWithValue("@cid", cid); command.Parameters.AddWithValue("@len", len); var reader = command.ExecuteReader(); while (reader.Read()) { var c = new Complaint() { Id = int.Parse(reader["id"].ToString()), Title = reader["title"].ToString(), Student = new Student() { Id = int.Parse(reader["student_id"].ToString()), Name = reader["student_name"].ToString(), Rollno = reader["student_rollno"].ToString(), PersonalContact = reader["student_personal_contact"].ToString(), ParentContact = reader["student_parent_contact"].ToString(), Email = reader["student_email"].ToString(), Gender = ((BitArray)reader["student_gender"]).Get(0) ? 'M' : 'F', Hostel = new Hostel() { Id = int.Parse(reader["hostel_id"].ToString()), RoomNumber = reader["room_no"].ToString() } }, ComplaintCategory = new ComplaintCategory() { Id = int.Parse(reader["complaint_category_id"].ToString()), Name = reader["complaint_category_name"].ToString(), Code = reader["complaint_category_code"].ToString() }, DateTime = DateTime.Parse(reader["datetime"].ToString()), Description = reader["description"].ToString(), Starred = ((BitArray)reader["starred"]).Get(0), Feedback = reader["feedback"].ToString() }; var status = int.Parse(reader["status"].ToString()); switch (status) { case 0: c.ComplaintStatus = ComplaintStatus.Pending; break; case 1: c.ComplaintStatus = ComplaintStatus.Scheduled; break; default: c.ComplaintStatus = ComplaintStatus.Resolved; break; } var appDate = reader["appointment_date_pref"].ToString(); if (!string.IsNullOrEmpty(appDate) || !string.IsNullOrWhiteSpace(appDate)) { appDate = appDate.Substring(0, 10); c.AppointmentDatePreference = DateTime.ParseExact(appDate, "dd-MM-yyyy", CultureInfo.InvariantCulture); } else { c.AppointmentDatePreference = null; } var appFromTime = reader["appointment_from_time_pref"].ToString(); var appToTime = reader["appointment_to_time_pref"].ToString(); if (!string.IsNullOrEmpty(appFromTime) || !string.IsNullOrWhiteSpace(appFromTime)) { appFromTime = $"1970-01-01T{appFromTime}"; c.AppointmentFromTimePreference = DateTime.Parse(appFromTime); } else { c.AppointmentFromTimePreference = null; } if (!string.IsNullOrEmpty(appToTime) || !string.IsNullOrWhiteSpace(appToTime)) { appToTime = $"1970-01-01T{appToTime}"; c.AppointmentToTimePreference = DateTime.Parse(appToTime); } else { c.AppointmentToTimePreference = null; } c.Pictures = GetComplaintPictures(c.Id); complaints.Add(c); } return(complaints); } }
public void ComplaintTerminatedAsDisputeAccepted(Complaint complaint) { }
public ActionResult <Complaint> CreateComplaint([FromBody] Complaint complaint) { var dao = new ComplaintsDao(); return(dao.CreateComplaint(complaint)); }
public async Task <Response <Member> > DeleteMember(int communityID, int userID) { //Remove Alerts List <Alert> Alerts = new List <Alert>(); Alerts = db.Alerts.Where(x => x.communityID == communityID && x.userID == userID).ToList(); if (Alerts.Count != 0) { foreach (var item in Alerts) { Alert Alert = await db.Alerts.FindAsync(item.id); db.Alerts.Remove(Alert); } await db.SaveChangesAsync(); } List <Chat> ChatsTo = new List <Chat>(); List <Chat> ChatsFrom = new List <Chat>(); ChatsTo = db.Chats.Where(x => x.communityID == communityID && x.to == userID).ToList(); ChatsFrom = db.Chats.Where(x => x.communityID == communityID && x.from == userID).ToList(); if (ChatsTo.Count != 0) { foreach (var item in ChatsTo) { Chat chat = await db.Chats.FindAsync(item.chatMessageID); db.Chats.Remove(chat); } await db.SaveChangesAsync(); } if (ChatsFrom.Count != 0) { foreach (var item in ChatsFrom) { Chat chat = await db.Chats.FindAsync(item.chatMessageID); db.Chats.Remove(chat); } await db.SaveChangesAsync(); } List <Complaint> Complaints = new List <Complaint>(); Complaints = db.Complaints.Where(x => x.communityID == communityID && x.userID == userID).ToList(); if (Complaints.Count != 0) { foreach (var item in Complaints) { Complaint Complaint = await db.Complaints.FindAsync(item.complaintID); db.Complaints.Remove(Complaint); } await db.SaveChangesAsync(); } Response <Member> responceMember = new Response <Member>(); Member member = new Member(); member = await(from l in db.Members where l.communityID == communityID && l.userId == userID select l).FirstOrDefaultAsync(); if (member == null) { responceMember.status = "Failed: Incorrect CommunityID or UserID"; responceMember.model = null; return(responceMember); } db.Members.Remove(member); await db.SaveChangesAsync(); responceMember.status = "Success"; responceMember.model = member; return(responceMember); }
public async Task <List <Complaint> > FetchUserComplaintAdmin() { List <Complaint> complaints = new List <Complaint>(); using (SqlConnection connection = new SqlConnection(this._connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand("FETCH_USER_COMPLAINT_ADMIN", connection)) { command.CommandType = CommandType.StoredProcedure; try { using (SqlDataReader reader = await command.ExecuteReaderAsync()) { while (reader.Read()) { var complaint = new Complaint { CID = Convert.ToInt32(reader["cid"].ToString()), RaisedBy = Convert.ToInt32(reader["raisedby"].ToString()), RaisedByText = reader["raisedBy"].ToString(), TID = Convert.ToInt32(reader["tid"].ToString()), CPriority = Convert.ToInt32(reader["cpriority"].ToString()), UserContactNumber = reader["user_contact"].ToString(), UserComment = reader["user_comment"].ToString(), CStatus = Convert.ToInt32(reader["cstatus"].ToString()), ResolverComment = reader["resolver_comment"].ToString(), AssignedToName = reader["user_name"].ToString(), }; var transaction = new RechargeTransaction { TransactionMessage = reader["errorMessage"].ToString(), TransactionAmount = Convert.ToDecimal(reader["rechargeAmount"].ToString()), TransactionDate = Convert.ToDateTime(reader["transactionDate"].ToString()).Date, TransactionMode = reader["rechargeMode"].ToString(), TransactionStatus = reader["transactionStatus"].ToString() }; complaint.Transaction = transaction; switch (Convert.ToInt32(reader["cpriority"].ToString())) { case 1: complaint.CPriorityText = "Low"; break; case 2: complaint.CPriorityText = "Medium"; break; case 3: complaint.CPriorityText = "High"; break; } switch (Convert.ToInt32(reader["cstatus"].ToString())) { case 1: complaint.CStatusText = "Acknowledged"; break; case 2: complaint.CStatusText = "Assigned"; break; case 3: complaint.CStatusText = "Work In Progress"; break; case 4: complaint.CStatusText = "Resolved"; break; } complaints.Add(complaint); } } return(complaints); } catch (Exception ex) { return(null); } } } }
public async Task <string> AcceptAlertAsync(int id) { var notification = await _context.Notifications .Include(n => n.NotificationType) .FirstOrDefaultAsync(n => n.Id == id); var notificationType = notification.NotificationType.Type; switch (notificationType) { case "TierChange": var tempTable = await _context.ChangeClientsTierTemp .Include(cc => cc.Client) .ThenInclude(c => c.ProgramTier) .Include(cc => cc.ProgramTier) .FirstOrDefaultAsync(cc => cc.Id == notification.TempTableId); if (tempTable == null) { return("Client tier not changed because the change has already been confirmed or denied"); } var client = tempTable.Client; var programTier = tempTable.ProgramTier; client.ProgramTier = programTier; _context.Clients.Update(client); _context.ChangeClientsTierTemp.Remove(tempTable); await _context.SaveChangesAsync(); return("Client tier changed successfully"); case "Complaint": var tempTableComplaint = await _context.ComplaintTemps .FirstOrDefaultAsync(cm => cm.Id == notification.TempTableId); if (tempTableComplaint == null) { return("Complaint not changed because the change has already been confirmed or denied"); } var complaint = new Complaint { Subject = tempTableComplaint.Subject, Description = tempTableComplaint.Description, MilesProgramNumber = tempTableComplaint.MilesProgramNumber, ComplaintDate = tempTableComplaint.ComplaintDate }; _context.Complaints.Add(complaint); _context.ComplaintTemps.Remove(tempTableComplaint); await _context.SaveChangesAsync(); return("Complaint filed successfully"); case "SeatAvailability": //TODO Pending break; case "PartnerReference": var tempPartner = await _context.AddPartnersTemp .FirstOrDefaultAsync(pt => pt.Id == notification.TempTableId); if (tempPartner == null) { return("Partner was not created because its creation has already been confirmed or denied."); } var newPartner = new Partner { Name = tempPartner.Name, Description = tempPartner.Description }; _context.Partners.Add(newPartner); _context.AddPartnersTemp.Remove(tempPartner); await _context.SaveChangesAsync(); return("Partner added successfully."); case "AdInsertion": //TODO Pending break; } return("An unknown error occurred"); }
public static complaintItem convertComplaint(Complaint temp) { complaintItem complaint = new complaintItem(); complaint.complaintId = temp.complaintId; complaint.userId = temp.userId; complaint.title = temp.title; complaint.details = temp.details; complaint.numLikes = (int)temp.numLikes; complaint.numComments = (int)temp.numComments; complaint.picture = temp.picture; complaint.complaintDate = (DateTime)temp.complaintDate; complaint.location = temp.location; complaint.latitude = (float)temp.latitude; complaint.longitude = (float)temp.longitude; complaint.category = temp.category; complaint.complaintStatus = temp.complaintStatus; complaint.date = temp.date; complaint.isAnonymous = temp.isAnonymous; complaint.city = temp.city; complaint.state = temp.state; complaint.country = temp.country; complaint.pincode = temp.pincode; complaint.thumbImage1 = temp.thumbImage1; complaint.thumbImage2 = temp.thumbImage2; return complaint; }
public ComplaintModel InsertComplaint(ComplaintModel model) { //unitOfWork.StartTransaction(); ComplaintRepository repo = new ComplaintRepository(unitOfWork); Complaint complaint = new Complaint(); AutoMapper.Mapper.Map(model, complaint); repo.Insert(complaint); AutoMapper.Mapper.Map(complaint,model); //unitOfWork.Commit(); return model; }
public ComplaintController() { complaint = new Complaint(); }
public ActionResult NewComplaint(NewComplaint model) { try { ViewBag.ComplaintType = _complaintType.GetAll(); //ViewBag.SolutionType = _slnType.GetAll(); //ViewBag.SolutionStatus = _slnStatus.GetAll(); var user = _user.GetUser(User.Identity.Name); ViewBag.Complaints = _vComplaint.FilterComplaint(DateTime.Now.Date, DateTime.Now.Date, 0, 0, 0, user.UserId); if (model.Details != "" && model.ComplaintTypeId > 0) { if (model.Title.Trim().Contains(" ")) { ViewBag.Msg = _help.getMsg(AlertType.danger.ToString(), "Empty space is not allowed in Title, you can replace empty space with character like - or _"); return(View(model)); } //if (!string.IsNullOrEmpty(model.ComplaintOwnerEmail)) //{ // if (!_help.IsValidEmail(model.ComplaintOwnerEmail)) // { // ViewBag.Msg = _help.getMsg(AlertType.danger.ToString(), "Invalid email address!"); // return View(model); // } //} //if (!_help.IsValidPhone(model.MobileNo)) //{ // ViewBag.Msg = _help.getMsg(AlertType.danger.ToString(), "Invalid phone number!"); // return View(model); //} var compType = _complaintType.GetRecordById(model.ComplaintTypeId); model.Title = compType.Name.Replace(" ", "_") + "_" + model.Title + "_" + model.MobileNo; var cmp = _complaint.GetComplaintByTitle(model.Title); if (cmp == null) { var soln = _slnStatus.GetRecordById(1); if (soln.Name.ToUpper() == "RESOLVED FULLY") { model.StatusId = 4; } else { if (soln.Name.ToUpper() == "REQUIRED TECHNICAL SKILL") { model.StatusId = 3; } else { model.StatusId = 2; } } Complaint nc = new Complaint(); nc.Code = model.Code; nc.ComplaintOwnerEmail = null; nc.ComplaintOwnerName = null; nc.ComplaintTypeId = model.ComplaintTypeId; nc.Date = DateTime.Now; nc.Details = model.Details; nc.Location = null; nc.MobileNo = "08066666666"; nc.RegisteredBy = user.UserId; nc.SolutionStatusId = 1; nc.StatusId = model.StatusId; nc.Title = model.Title; using (var cmd = new TransactionScope()) { try { _complaint.Create(nc); //ComplaintActivity ca = new ComplaintActivity(); //ca.ComplaintId = nc.ComplaintId; //ca.Date = DateTime.Now; //ca.RecordedBy = -1; //ca.SolutionDetails = "No Solution Yet"; //ca.SolutionStatusId = 1; ////ca.SolutionTypeId = model.SolutionTypeId; //_complaintActivity.Create(ca); cmd.Complete(); ViewBag.Msg = _help.getMsg(AlertType.success.ToString(), "Complaint added successful!"); return(View(new NewComplaint())); } catch (Exception er) { cmd.Dispose(); ViewBag.Msg = _help.getMsg(AlertType.danger.ToString(), er.Message); return(View(model)); } } } else { ViewBag.Msg = _help.getMsg(AlertType.danger.ToString(), "Complaint title already exist!"); return(View(model)); } } else { ViewBag.Msg = _help.getMsg(AlertType.danger.ToString(), "All fields with * are required!"); return(View(model)); } } catch (Exception ex) { ViewBag.Msg = _help.getMsg(AlertType.danger.ToString(), ex.Message); return(View(model)); } }
static void Main(string[] args) { Console.Write("Имя пользователя SQL Server: "); string sqlUser = Console.ReadLine(); Console.Write("Пароль SQL Server: "); string sqlPassword = Console.ReadLine(); Console.Write("Имя пользователя MongoDB: "); string mongoUser = Console.ReadLine(); Console.Write("Пароль MongoDB: "); string mongoPassword = Console.ReadLine(); try { MongoConnection mongoConnection = new MongoConnection("ds229008.mlab.com", "29008", mongoUser, mongoPassword); mongoConnection.Connect(); SqlConnection sqlConnection = new SqlConnection("ELISEY", /*"1433",*/ sqlUser, sqlPassword); sqlConnection.Connect(); Console.Clear(); #region Заполнение БД Doctor doctor = new Doctor("Иванова", "Людмила", "Ивановна", sqlConnection); doctor.Save(sqlConnection); doctor.SignUp("doctor", "hello", "hello"); doctor.SignIn("doctor", "hello", sqlConnection); Patient patient = new Patient("Карапузов", "Иван", "Андреевич"); patient.Save(sqlConnection); Problem problem = new Problem("Не могу больше держаться", new DateTime(2018, 4, 17), patient, doctor, sqlConnection); problem.Save(); Console.WriteLine(problem); Complaint complaint1 = new Complaint("Мне больно", problem, sqlConnection); complaint1.Save(); Complaint complaint2 = new Complaint("Очень", problem, sqlConnection); complaint2.Save(); Diagnosis diagnosis = new Diagnosis("Простуда", problem, doctor, sqlConnection); diagnosis.Save(); Console.WriteLine(diagnosis); Archetype pulse = new Archetype("Пульс"); pulse.Save(sqlConnection); Archetype pressure = new Archetype("Давление"); pressure.Save(sqlConnection); Console.WriteLine(pressure); Symptom symptom1 = new Symptom(diagnosis, pulse, "60", sqlConnection); symptom1.Save(); Symptom symptom2 = new Symptom(diagnosis, pressure, "120/80", sqlConnection); symptom2.Save(); Console.WriteLine(symptom1); Console.WriteLine(symptom2); Medicament medicament = new Medicament("Мезим"); medicament.Save(sqlConnection); Medicament medicament2 = new Medicament("Терафлю"); medicament2.Save(sqlConnection); Medicament medicament3 = new Medicament("Нурофен"); medicament3.Save(sqlConnection); Prescription prescription = new Prescription(medicament, diagnosis, sqlConnection); prescription.Save(); Prescription prescription2 = new Prescription(medicament2, diagnosis, sqlConnection); prescription2.Save(); Prescription prescription3 = new Prescription(medicament3, diagnosis, sqlConnection); prescription3.Save(); Console.WriteLine(prescription3); Article article1 = new Article("Повышенная вязкость крови – один из факторов развития кардиоваскулярных осложнений у больных с истинной полицитемией", "https://research-journal.org/medical/povyshennaya-vyazkost-krovi-odin-iz-faktorov-razvitiya-kardiovaskulyarnyx-oslozhnenij-u-bolnyx-s-istinnoj-policitemiej/", "Разнообразие клинических проявлений и высокий процент развития осложнений, отличающихся по характеру и тяжести, у больных эритремией продолжает создавать трудности как в лечении, так и в повышении качества жизни больных [6, С. 32]. Изменение реологических свойств и повышение вязкости крови, по результатам наших исследований, оказывают большее влияние на сердечно-сосудистую систему с развитием целого ряда синдромов и симптомов – гипертоническая болезнь, ишемическая болезнь сердца, симптоматическая артериальная гипертензия в 53,4% случаев. Возрастной пик заболеваемости, приходящий на пациентов среднего и пожилого возраста, делает их более уязвимыми в отношении развития тромботических осложнений. В рамках нашего исследования истинной полицитемии более подвержены мужчины от 40 до 70 лет.", mongoConnection); Article article2 = new Article("Центральная гемодинамика, тиреоидный статус и дисфункции эндотелия у больных артериальной гипертонией в условиях высокогорья", "https://research-journal.org/medical/centralnaya-gemodinamika-tireoidnyj-status-i-disfunkcii-endoteliya-u-bolnyx-arterialnoj-gipertoniej-v-usloviyax-vysokogorya/", "Установлено, что снижение продукции NO с одновременным снижением концентрации тиреоидных гормонов вызывают нарушения интракардиальной гемодинамики, изменения структурно-функционального состояния ЛЖ и утяжеляют течение артериальной гипертонии.", mongoConnection); Article article3 = new Article("Сочетанные изменения экспрессии генов cstb и acap3 при симптоматической эпилепсии и болезни паркинсона", "https://research-journal.org/medical/sochetannye-izmeneniya-ekspressii-genov-cstb-i-acap3-pri-simptomaticheskoj-epilepsii-i-bolezni-parkinsona/", "Кроме того, у женщин наблюдалось снижение уровня мРНК гена CSTB при эпилепсии(примерно в 3 раза) и при болезни Паркинсона(примерно в 2.5 раза).Полученные данные указывают на возможное участие исследованных генов в патогенезе симптоматической эпилепсии и болезни Паркинсона.", mongoConnection); Tag tag1 = new Tag("Карапузов", mongoConnection); Tag tag2 = new Tag("Эритремия", mongoConnection); Tag tag3 = new Tag("Гипертония", mongoConnection); Tag tag4 = new Tag("Карапузовдержись", mongoConnection); article1.Save(); article2.Save(); article3.Save(); tag1.Save(); tag2.Save(); tag3.Save(); tag4.Save(); Association association1 = new Association("Ассоциация с наибольшим количеством тегов", mongoConnection, sqlConnection); association1.Tags.AddRange(new Tag[] { tag1, tag2, tag3 }); association1.Article = article1; association1.MedicineObjects.AddRange(new IEhrObject[] { patient, problem, medicament2, medicament3 }); association1.Save(); Association association2 = new Association("Ассоциация про Карапузова", mongoConnection, sqlConnection); association2.Tags.AddRange(new Tag[] { tag1, tag3 }); association2.Article = article2; association2.MedicineObjects.AddRange(new IEhrObject[] { patient, medicament }); association2.Save(); Association association3 = new Association("Ассоциация с наименьшим количеством тегов", mongoConnection, sqlConnection); association3.Tags.AddRange(new Tag[] { tag1, tag4 }); association3.Article = article3; association3.MedicineObjects.AddRange(new IEhrObject[] { medicament, medicament3 }); association3.Save(); #endregion #region Поиск по тегам Tag findTag1 = new Tag(); Tag findTag2 = new Tag(); Tag findTag3 = new Tag(); Tag findTag4 = new Tag(); Tag findTag5 = new Tag(); try { Console.Write("Введите тег: "); findTag1.GetByContent(Console.ReadLine(), mongoConnection); //"Карапузов" } catch (Exception ex) { Console.WriteLine(ex.Message); } try { Console.Write("Введите тег: "); findTag2.GetByContent(Console.ReadLine(), mongoConnection); //"Эритремия" } catch (Exception ex) { Console.WriteLine(ex.Message); } try { Console.Write("Введите тег: "); findTag3.GetByContent(Console.ReadLine(), mongoConnection); //"Гипертония" } catch (Exception ex) { Console.WriteLine(ex.Message); } try { Console.Write("Введите тег: "); findTag4.GetByContent(Console.ReadLine(), mongoConnection); //"Грипп" } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.WriteLine(); Stopwatch stopwatch = new Stopwatch(); stopwatch.Start(); List <KeyValuePair <int, Association> > associations = Association.GetAssociationListByTag(new Tag[] { findTag1, findTag2, findTag3, findTag4 }, sqlConnection, mongoConnection); stopwatch.Stop(); foreach (KeyValuePair <int, Association> association in associations) { Console.WriteLine(association.Value); Console.WriteLine("Число совпадений: " + association.Key); Console.WriteLine(); } Console.WriteLine("Затрачено времени: " + stopwatch.Elapsed); #endregion } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.ReadKey(); }
public void AddComplaint(Complaint complaint) { _dbContext.Complaints.Add(complaint); _dbContext.SaveChanges(); }
public static Complaint convertComplaint(complaintItem item) { Complaint temp = new Complaint(); temp.userId = item.userId; temp.title = item.title; temp.details = item.details; temp.numLikes = (int)item.numLikes; temp.numComments = (int)item.numComments; temp.picture = item.picture; temp.complaintDate = (DateTime)item.complaintDate; temp.location = item.location; temp.latitude = (float)item.latitude; temp.longitude = (float)item.longitude; temp.category = item.category; temp.complaintStatus = item.complaintStatus; temp.date = item.date; temp.isAnonymous = item.isAnonymous; temp.city = item.city; temp.state = item.state; temp.country = item.country; temp.pincode = item.pincode; return temp; }