public HttpResponseMessage delete(DeleteRequestModel req) { if (req != null) { requested_mark req_mark = db.requested_mark.Find(req.id); if (req_mark == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, "Not Found"); } else { db.requested_mark.Remove(req_mark); db.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { message = "Request deleted", req_list = db.requested_mark.Where(x => x.user_id == req.user_id && x.payment_status == "unpaid").ToList() }); } } else { response = Request.CreateResponse(HttpStatusCode.BadRequest, "Bad Request empty parameter"); } return(response); }
public ActionResult GenerateMarksheet(int?id = null) { if (!Request.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } else { string user_id = User.Identity.GetUserId(); if (id == null) { ViewBag.ErrorMsg = "Invalid Request"; return(View("Error")); } else { hslc result = db.hslcs.Find(id); if (result != null) { requested_mark req_mark = db.requested_mark.Where(x => x.payment_status == "paid" && x.user_id == user_id && x.exam_result_id == result.id).FirstOrDefault(); if (req_mark == null) { ViewBag.ErrorMsg = "Please complete your payment."; return(View("Error")); } else { decimal?year = result.exm_year; if (year != null && year >= 2016) { //generate_2016_model(result); generate_marksheet(result); } else if (year >= 2010 && year <= 2015) { generate_2010_to_2015_model(result); } else if (year >= 2004 && year <= 2009) { generate_2004_to_2009_model(result); } else { ViewBag.ErrorMsg = "Under development." + year; return(View("Error")); } } } else { ViewBag.ErrorMsg = "Requested record does not exist in our database."; return(View("Error")); } } } return(RedirectToAction("GenerateInvoice")); }
public HttpResponseMessage Post(RequestModel req) { if (!ModelState.IsValid) { response = Request.CreateResponse(HttpStatusCode.BadRequest, "Bad Request: Improper Data Passed"); } else { hslc exam_result = db.hslcs.Where(x => x.roll == req.roll && x.exm_year.ToString() == req.exam_year && x.dob == req.dob).FirstOrDefault(); if (exam_result != null) { //int exam_res_id = db.Database.SqlQuery<int>("select id from students where roll_no='" + req.roll_no + "' and year='" + req.year + "' and dob='" + req.dob + "'").FirstOrDefault(); if (db.requested_mark.Any(m => m.exam_result_id == exam_result.id && m.user_id == req.user_id)) { response = Request.CreateResponse(HttpStatusCode.Conflict, "Duplicate request found! You have already requested the same. Please check in the request history."); } else { requested_mark requested_mark = new requested_mark(); requested_mark.request_date = DateTime.Now; requested_mark.payment_status = "unpaid"; requested_mark.exam_result_id = exam_result.id; requested_mark.user_id = req.user_id; requested_mark.id = generateRandomString(26); requested_mark.txn_id = null; db.requested_mark.Add(requested_mark); db.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { message = "Marksheet has been requested, please click proceed button for payment.", req_list = db.RequestHistories.Where(x => x.user_id == req.user_id && x.payment_status == "unpaid").ToList() }); } } else { response = Request.CreateResponse(HttpStatusCode.NotFound, "No record found for the input specification."); } } return(response); }