public IHttpActionResult DeleteComplaint(int ID) { db.Configuration.ProxyCreationEnabled = false; COMPLAINT Delete = new COMPLAINT(); Delete = db.COMPLAINTs.Where(zz => zz.COMPLAINTID == ID).FirstOrDefault(); if (Delete == null) { return(NotFound()); } db.COMPLAINTs.Remove(Delete); db.SaveChanges(); return(Ok(Delete)); }
public dynamic Assign(dynamic Employee) { db.Configuration.ProxyCreationEnabled = false; try { int EmployeeID = Convert.ToInt16(Employee.EMPLOYEEID); int ComplaintID = Convert.ToInt16(Employee.ComplaintID); COMPLAINT com = db.COMPLAINTs.Where(zz => zz.COMPLAINTID == ComplaintID).FirstOrDefault(); com.EMPLOYEEID = EmployeeID; db.SaveChanges(); } catch (Exception) { return(false); } return(true); }
public dynamic Assign(dynamic Employee) { db.Configuration.ProxyCreationEnabled = false; try { //int EmployeeID = Convert.ToInt16(Employee.EMPLOYEEID); int ComplaintID = Convert.ToInt16(Employee.ComplaintID); COMPLAINT com = db.COMPLAINTs.Where(zz => zz.COMPLAINTID == ComplaintID).FirstOrDefault(); // com.EMPLOYEEID = EmployeeID; com.COMPLAINTSTATUSID = 2; db.SaveChanges(); var rentid = db.COMPLAINTs.Where(cc => cc.COMPLAINTID == ComplaintID).Select(kk => kk.RENTALAGREEMENTID).FirstOrDefault(); var clntid = db.RENTAL_AGREEMENT.Where(cc => cc.RENTALAGREEMENTID == rentid).Select(kk => kk.CLIENTID); var cln = db.CLIENTs.Find(clntid); //send email MailMessage mail = new MailMessage(); SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com"); mail.From = new MailAddress("*****@*****.**"); mail.To.Add(cln.EMAIL.ToString()); mail.Subject = "Inturbidus: Complaint resolved ! "; mail.Body = "Good day " + cln.NAME + " " + cln.SURNAME + "\n\nYour complaint was recently resolved, we would appreciate your feedback.\n\nPlease navigate to the Complaints page and provide feedback on whether your complaint was resolved .\n\nThank you"; SmtpServer.Port = 587; SmtpServer.DeliveryMethod = SmtpDeliveryMethod.Network; SmtpServer.UseDefaultCredentials = false; SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "test123@123test"); SmtpServer.EnableSsl = true; SmtpServer.Send(mail); } catch (Exception) { return(false); } return(true); }
public dynamic getComplaintById(int ID) { db.Configuration.ProxyCreationEnabled = false; COMPLAINT com = new COMPLAINT(); dynamic myCom = new ExpandoObject(); try { com = db.COMPLAINTs.Find(ID); myCom.ComplaintID = com.COMPLAINTID; COMPLAINTSTATU status = db.COMPLAINTSTATUS.Where(zz => zz.COMPLAINTSTATUSID == com.COMPLAINTSTATUSID).FirstOrDefault(); myCom.ComplaintStatus = status.COMPLAINTSTATUS_NAME; myCom.Date = com.DATE; myCom.Details = com.DETAILS; myCom.Photo = com.PHOTO; myCom.RentalID = com.RENTALAGREEMENTID; string filePath = HttpContext.Current.Server.MapPath("~/Images/" + com.PHOTO); using (FileStream fileStream = new FileStream(filePath, FileMode.Open)) { using (var memoryStream = new MemoryStream()) { fileStream.CopyTo(memoryStream); Bitmap image = new Bitmap(1, 1); image.Save(memoryStream, ImageFormat.Png); byte[] byteImage = memoryStream.ToArray(); string base64String = Convert.ToBase64String(byteImage); myCom.Photo = "data:image/png;base64," + base64String; } } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error With Complaint Details")); } return(myCom); }
public HttpResponseMessage UpdateComplaint() { var httpRequest = HttpContext.Current.Request; string imageName = ""; try { ////Upload Image ////var postedFile = httpRequest.Files["Image"]; //string postedFile = complaint.Photo.tostring(); ////int len = postedFile.le ////Create custom filename //imageName = new String(Path.GetFileNameWithoutExtension(postedFile).Take(postedFile.Length).ToArray()).Replace(" ", "-") + Path.GetExtension(postedFile); //imageName = imageName + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile); //var filePath = HttpContext.Current.Server.MapPath("~/Images/" + imageName); //postedFile.SaveAs(filePath); //Upload Image var postedFile = httpRequest.Files["Image"]; if (postedFile != null) { //Create custom filename imageName = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(postedFile.FileName.Length).ToArray()).Replace(" ", "-") + Path.GetExtension(postedFile.FileName); imageName = imageName + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName); var filePath = HttpContext.Current.Server.MapPath("~/Images/" + imageName); postedFile.SaveAs(filePath); } } catch { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "No image was added")); } COMPLAINT conplaint = new COMPLAINT(); //Save to DB try { var ID = Convert.ToInt16(httpRequest["ComplaintID"]); COMPLAINT update = db.COMPLAINTs.Where(zz => zz.COMPLAINTID == ID).FirstOrDefault(); update.RENTALAGREEMENTID = Convert.ToInt16(httpRequest["RentalID"]); update.DETAILS = httpRequest["Details"]; update.DATE = DateTime.Now; if (imageName != "") { update.PHOTO = imageName; } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error With Complaint Details")); } try { db.SaveChanges(); } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e.Message)); } return(Request.CreateResponse(HttpStatusCode.Created)); }
public HttpResponseMessage AddCOmplaint() { var httpRequest = HttpContext.Current.Request; string imageName = ""; try { //Upload Image var postedFile = httpRequest.Files["Image"]; if (postedFile == null) { //imageName = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(postedFile.FileName.Length).ToArray()).Replace(" ", "-") + Path.GetExtension(postedFile.FileName); //imageName = imageName + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName); //var filePath = HttpContext.Current.Server.MapPath("~/Images/" + imageName); //postedFile.SaveAs(filePath); } else { imageName = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(postedFile.FileName.Length).ToArray()).Replace(" ", "-") + Path.GetExtension(postedFile.FileName); imageName = imageName + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName); var filePath = HttpContext.Current.Server.MapPath("~/Images/" + imageName); postedFile.SaveAs(filePath); } } catch { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "No image was added")); } COMPLAINT conplaint = new COMPLAINT(); //Save to DB try { conplaint.RENTALAGREEMENTID = Convert.ToInt16(httpRequest["RentalID"]); conplaint.DETAILS = httpRequest["Details"]; conplaint.COMPLAINTSTATUSID = 1; conplaint.DATE = DateTime.Now; conplaint.PHOTO = imageName; var admin = db.EMPLOYEEs.Where(kk => kk.EMPLOYEETYPEID == 9).FirstOrDefault(); //send email MailMessage mail = new MailMessage(); SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com"); mail.From = new MailAddress("*****@*****.**"); mail.To.Add(admin.EMAIL.ToString()); mail.Subject = "Complaint lodged ! "; mail.Body = "Good day " + admin.NAME + " " + admin.SURNAME + "\n\nThere is a new complaint that has to be reviewed and resolved,please have a look at it.\n\nThank you"; SmtpServer.Port = 587; SmtpServer.DeliveryMethod = SmtpDeliveryMethod.Network; SmtpServer.UseDefaultCredentials = false; SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "test123@123test"); SmtpServer.EnableSsl = true; SmtpServer.Send(mail); } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error With Complaint Details")); } try { db.COMPLAINTs.Add(conplaint); db.SaveChanges(); } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e.Message)); } return(Request.CreateResponse(HttpStatusCode.Created)); }