protected void btnGo_Click(object sender, EventArgs e) { var data = client.GetAllComplaints(); data = data.Where(x => x.status != "Resolved").ToArray(); List <Complaints> allComplaints = new List <Complaints>(); foreach (var d in data) { Complaints c = new Complaints() { title_id = d.title_id, customer_id = d.customer_id, title = d.title, category = d.category, body = d.body, status = d.status }; allComplaints.Add(c); } if (!string.IsNullOrEmpty(tbTitle.Text.Trim())) { allComplaints = searchByTitle(allComplaints); } allComplaints = searchByCategory(allComplaints); DisplayComplaints.DataSource = allComplaints; DisplayComplaints.DataBind(); }
public Complaints Update(Complaints cust) { Complaints _complatins = null; using (var sqlConnection = new SqlConnection(Constant.DatabaseConnection)) { sqlConnection.Open(); _complatins = sqlConnection.Get <Complaints>(cust.CUSTOMER_NUMBER); _complatins.RECORD_STATUS = 1; _complatins.UPDATE_DATE = DateTime.Now; _complatins.UPDATE_USER = cust.UPDATE_USER; _complatins.CONTENT_HEADER = cust.CONTENT_HEADER; _complatins.CONTENT_TEXT = cust.CONTENT_TEXT; _complatins.PHOTO = cust.PHOTO; _complatins.CUSTOMER_NUMBER = cust.CUSTOMER_NUMBER; _complatins.EMAIL = cust.EMAIL; _complatins.PHONE_NUMBER = cust.PHONE_NUMBER; _complatins.CONFIRM = cust.CONFIRM; sqlConnection.Update <Complaints>(_complatins); var result = sqlConnection.Get <Complaints>(cust.CUSTOMER_NUMBER); } return(_complatins); }
public Complaints GetComplaintById(int Id) { Complaints complaints = null; ConnectionSettings settings = new ConnectionSettings(new Uri("http://localhost:9200")); settings.DefaultIndex("complaintstore"); ElasticClient esClient = new ElasticClient(settings); var response = esClient.Search <Complaints>(s => s.Query( q => q.Term(fld => fld.Id, Id))); if (response != null) { var comp = response.Hits.FirstOrDefault(); complaints = new Complaints { Id = comp.Source.Id, ComplaintDescription = comp.Source.ComplaintDescription, ComplaintBy = comp.Source.ComplaintBy, ComplaintDate = comp.Source.ComplaintDate, IsResolved = comp.Source.IsResolved }; } return(complaints); }
public IActionResult ReportArticle(ArticleViewModel model) { int?sId = HttpContext.Session.GetInt32("ID"); if (sId == null) { return(RedirectToAction("Login", "Account")); } else { Complaints report = new Complaints(); report = db.Complaints.Where(x => x.UserID == sId && x.ArticleID == model.article.ID).FirstOrDefault(); if (report != null) { ViewBag.Status = "danger"; ViewBag.Warning = "You have already report this article.We will respond to you as soon as possible."; return(View(model)); } report = new Complaints(); report.Subject = model.complaints.Subject; report.Text = model.complaints.Text; report.UserID = sId; report.ArticleID = model.article.ID; report.Checked = false; db.Complaints.Add(report); db.SaveChanges(); ViewBag.Status = "success"; ViewBag.Warning = "Your report sent successfully.We will responsd as soon as possible."; } return(View(model)); }
public IEnumerable <Complaints> GetComplaints() { Complaints complaints = null; ConnectionSettings settings = new ConnectionSettings(new Uri("http://localhost:9200")); settings.DefaultIndex("complaintstore"); ElasticClient esClient = new ElasticClient(settings); var response = esClient.Search <Complaints>(s => s.Query(q => q.MatchAll())); var complaint1 = response.Hits.ToList(); List <Complaints> empList = new List <Complaints>(); foreach (var item in complaint1) { complaints = new Complaints { Id = item.Source.Id, ComplaintDescription = item.Source.ComplaintDescription, ComplaintBy = item.Source.ComplaintBy, ComplaintDate = item.Source.ComplaintDate, IsResolved = item.Source.IsResolved }; empList.Add(complaints); } return(empList); }
public ActionResult ReportBlog(BlogsViewModel model) { int?id = Convert.ToInt32(Session["ID"]); if (id == null) { return(RedirectToAction("Login", "Account")); } else { Complaints report = new Complaints(); report.Subject = model.Report.Subject; report.Text = model.Report.Text; report.UsersID = id; report.BlogsID = model.blog.ID; db.Complaints.Add(report); db.SaveChanges(); ViewBag.Status = "success"; ViewBag.Warning = "Your report sent successfully.We will respond as soon as possible."; } return(View(model)); }
public IActionResult Privacy(Complaints complaints) { complaints.Id = db.Complaintses.Count() + 1; db.Complaintses.Add(complaints); db.SaveChanges(); return(View()); }
public long Insert(Complaints cust) { using (var sqlConnection = new SqlConnection(Constant.DatabaseConnection)) { sqlConnection.Open(); var _complatins = new Complaints() { GUID = Guid.NewGuid().ToString(), RECORD_STATUS = 1, INSERT_DATE = DateTime.Now, INSERT_USER = cust.INSERT_USER, UPDATE_DATE = DateTime.Now, UPDATE_USER = cust.UPDATE_USER, CUSTOMER_NUMBER = cust.CUSTOMER_NUMBER, RESERVATION_ID = cust.RESERVATION_ID, CONTENT_HEADER = cust.CONTENT_HEADER, CONTENT_TEXT = cust.CONTENT_TEXT, EMAIL = cust.EMAIL, PHONE_NUMBER = cust.PHONE_NUMBER, PHOTO = cust.PHOTO, CONFIRM = cust.CONFIRM }; var complaintGuid = sqlConnection.Insert <Complaints>(_complatins); sqlConnection.Close(); return(complaintGuid); } }
private Complaints GetComplaintsById(long id, Model.Token token, SYS_USER u) { int t = 0; IEnumerable <Complaints> data = null; Complaints result = null; try { if (token.UserTypes.Contains("customer")) { data = QueryForCreator(null, u.USERNAME, 1, int.MaxValue, out t); } else if (token.UserTypes.Contains("installer")) { data = _repository.QueryComplaintsForInstaller(id, u.USERNAME, u.LICNO, 1, 1, out t); } if (t > 0) { result = _repository.AllIncluding(x => x.ComplaintsProcessing, x => x.CustomerReviews).FirstOrDefault(x => x.Key == id); } } catch (Exception exc) { throw; } return(result); }
public async Task <ActionResult <Complaints> > SaveComplaint(Complaints complaints) { _context.Complaints.Add(complaints); await _context.SaveChangesAsync(); return(CreatedAtAction("GetComplaintsList", new { id = complaints.ComplaintId }, complaints)); }
public IActionResult UpdatedComplaints(int id, string status, string code) { SessionCheck(); int status_id = obj_hrpdbcontext.Status.Where(data => data.name == status).FirstOrDefault().id; Complaints complaint = obj_hrpdbcontext.Complaints.Where(x => x.id == id).FirstOrDefault(); complaint.status_id = status_id; obj_hrpdbcontext.Complaints.Update(complaint); ComplaintHandle complaintHandle = new ComplaintHandle(); complaintHandle.complaint_id = id; complaintHandle.officer_id = sin; complaintHandle.last_update = DateTime.Now.ToString("MM/dd/yyyy hh:mm tt"); int is_exit = obj_hrpdbcontext.Complaint_Handlers.Count(x => x.complaint_id == id); if (is_exit > 0) { obj_hrpdbcontext.Complaint_Handlers.Update(complaintHandle); } else { obj_hrpdbcontext.Complaint_Handlers.Add(complaintHandle); } obj_hrpdbcontext.SaveChanges(); return(RedirectToAction("ViewComplaints")); }
public IActionResult UpdateComplaint(long Id) { bool IsAdmin = _unitOfWork.Complaints.GetAll().Where(a => a.Id == Id).Select(a => a.IsAdmin).FirstOrDefault(); Complaints comp = _unitOfWork.Complaints.GetAll().Where(a => a.Id == Id).FirstOrDefault(); string uNameId = comp.UserNameId; ComplaintsVM complaintsVM; complaintsVM = new ComplaintsVM() { complaints = _unitOfWork.Complaints.GetAll().Where(a => a.Id == Id).FirstOrDefault(), OrdersList = _unitOfWork.Order.GetAll().Where(a => a.Id == comp.OrderId). Select(i => new SelectListItem { Text = i.CustName + "- Id: " + i.Id, Value = i.Id.ToString() }), StoresList = _unitOfWork.UserStoreName.GetAll().Where(a => a.IsAdminStore). Select(i => new SelectListItem { Text = i.StoreName, Value = i.Id.ToString() }) }; ViewBag.IsAdmin = IsAdmin; if (complaintsVM.complaints.OrderId == 0) { complaintsVM.GeneralNotOrderRelated = true; } else { complaintsVM.GeneralNotOrderRelated = false; } return(View(complaintsVM)); }
public async Task <IActionResult> PutComplaint(long id, Complaints complaints) { if (id != complaints.ComplaintId) { return(BadRequest()); } _context.Entry(complaints).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ComplaintExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public IActionResult CreateComplaint(Complaints complaints) { complaints.Id = db.Complaintses.Count() + 1; db.Complaintses.Add(complaints); db.SaveChanges(); return(View("Start")); }
public virtual ActionResult Update(Complaints entity) { entity.LastUpdatedTime = DateTime.Now; OperationResult or = ComplaintsService.Update(entity); return(this.JsonFormat(or)); }
// Constructor to make the adminform connect to the server // Sees if the server sends "updated", if so: updates public AdminForm(ServerConnection server, int houseNumber, UserInfo user) { InitializeComponent(); Task.Run(() => { udpClient.Client.Bind(new IPEndPoint(0, server.GetAvailableUdpPort())); int attempts = 0; string message = ""; while (true) { Thread.Sleep(200); int count = udpClient.Client.Available; byte[] msg = new byte[count]; if (msg.Length == 0 && attempts < 100) { continue; } else if (attempts >= 100) { } else if (msg.Length == 0) { continue; } if (attempts < 100) { udpClient.Client.Receive(msg); message = Encoding.Default.GetString(msg, 0, msg.Length); } if (message.Contains("Updated") || attempts >= 100) { _user.StudentsInfo = server.GetUsersInfo(_user.HouseNumber); _mandatoryRules = server.GetMandatoryRules(_user.HouseNumber); _houseRules = server.GetHouseRules(_user.HouseNumber); _complaints = server.GetComplaints(_user.HouseNumber); _messages = server.GetMessages(_user.HouseNumber); } ; attempts = 0; } }); _houseNumber = houseNumber; _server = server; _mandatoryRules = server.GetMandatoryRules(houseNumber); _houseRules = server.GetHouseRules(houseNumber); _complaints = server.GetComplaints(houseNumber); _messages = server.GetMessages(houseNumber); _user = user; UpdateTick(false); }
public Complaints AddNewComplaint(Complaints complaint) { complaint.CreateTime = DateTime.Now; complaint.UpdateTime = DateTime.Now; _repository.Add(complaint); _repository.Save(); return(complaint); }
public ActionResult DeleteConfirmed(int id) { Complaints complaints = db.Complaints.Find(id); db.Complaints.Remove(complaints); db.SaveChanges(); return(RedirectToAction("Index")); }
public IActionResult WithDrewComplaintPenalty(int id) { SessionCheck(); Complaints comp = new Complaints(); comp.id = id; return(View(comp)); }
internal static int saveComplaint(Complaints modelComplaint, string Name) { var result = Convert.ToInt16(SqlHelper.ExecuteScalar(_myConnection, CommandType.StoredProcedure, "spATL_ADM_GenPunchlist_Ins", new SqlParameter("@PRJID", modelComplaint.PRJID), new SqlParameter("@Notes", modelComplaint.JobNotes), new SqlParameter("@UserName", Name))); return(result); }
public bool UpdateComplaints(Complaints complaints) { Wait(25); string json = JsonConvert.SerializeObject(complaints, Formatting.Indented); string message = GetResponce(PackageType.UPDATE_COMPLAINTS, PackageType.RECEIVED, json); return(true); }
public bool allowComplaint(string orderId) { Complaints complaints = _unitOfWork.Complaints.GetAll().Where(a => a.OrderId == Convert.ToInt64(orderId)).FirstOrDefault(); if (complaints == null) { return(true); } return(false); }
public static ComplaintsDto ToComplaintsDto(this Complaints c) { return(new ComplaintsDto { Area = c.Area, Attachment = c.Attachment, Attachment2 = c.Attachment2, Attachment3 = c.Attachment3, ComplaintsType = c.StrComplaintsType, ContactNumber = c.ContactNumber, CreateTime = c.CreateTime, Creator = c.Creator, CurrentProcessor = c.CurrentProcessor, Description = c.Description, Email = c.Email, Id = c.Key, IsDelete = c.IsDelete, ReceiveTime = c.ReceiveTime, Recipient = c.Recipient, SysSn = c.SysSn, Title = c.Title, UpdateTime = c.UpdateTime, OnsiteHandler = c.OnsiteHandler, ProcessingPriority = c.ProcessingPriority ?? 0, Status = c.StrStatus }); }
public void UpdateComplaint(int Id, Complaints complaint) { var updateComplaint = new UpdateComplaintCommand(complaint.Id, complaint.ComplaintDescription, complaint.ComplaintDate, complaint.IsResolved, complaint.ComplaintBy); _bus.SendCommand(updateComplaint); }
public void InsertComplaint(Complaints complaint) { var createNewComplaint = new CreateNewComplaintCommand(complaint.Id, complaint.ComplaintDescription, complaint.ComplaintDate, complaint.IsResolved, complaint.ComplaintBy); _bus.SendCommand(createNewComplaint); }
public ActionResult Edit([Bind(Include = "ID,Title,Detail")] Complaints complaints) { if (ModelState.IsValid) { db.Entry(complaints).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(complaints)); }
private async Task LoadComplaints() { var results = await complaintsDataStore.GetItemsAsync(); Complaints.Clear(); foreach (var c in results) { Complaints.Add(c); } }
public ComplaintPage() { InitializeComponent(); objCmplaints = new ComplaintsTypeList(); ComplaintTypes = objCmplaints.GetComplaintTypes(); Complaints = new Complaints(); ComplaintsList = new ObservableCollection <Complaints>(); // bind all public properties of the current class // to the Page Elements BindingContext = this; }
public IActionResult WithDrewComplaint(int id, string cname, string ccnum, string exp, string cvv) { SessionCheck(); int status_id = obj_hrpdbcontext.Status.Where(data => data.name == "Withdraw").FirstOrDefault().id; Complaints complaint = obj_hrpdbcontext.Complaints.Where(data => data.id == id).FirstOrDefault(); complaint.status_id = status_id; obj_hrpdbcontext.Complaints.Update(complaint); obj_hrpdbcontext.SaveChanges(); return(RedirectToAction("ViewComplaints")); }
private void PostComplaint() { NewComplaint.Creator = User; NewComplaint.Timestamp = DateTime.Now; //Complaints.Add(NewComplaint); Complaints.Insert(0, NewComplaint); complaintsDataStore.AddItemAsync(newComplaint); NewComplaint = new Complaint(); }