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