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();
}
