//active user
public void ActiveUser(int id, out string result, out bool isSuccess)
{
try
{
AllFormReview AllFormReview = new AllFormReview();
using (BoardofPardonsEntities1 dbcontext = new BoardofPardonsEntities1())
{
var user = dbcontext.Users.Where(a => a.Id == id).FirstOrDefault();
user.Status = true;
dbcontext.SaveChanges();
result = "";
isSuccess = true;
}
}
catch (Exception ex)
{
using (StreamWriter writer =
new StreamWriter(HostingEnvironment.MapPath("~/errLog.txt")))
{
writer.WriteLine("==========================");
writer.WriteLine("Date " + DateTime.Now);
writer.WriteLine("Error" + ex.Message);
}
isSuccess = false;
result = ex.Message;
}
}
// GET: PDFReport
public ActionResult ActionToPdfFile(AllFormReview ListFormStatus)
{
accountManager = new AccountManager();
//AllFormReview ListFormStatus = new AllFormReview();
ListFormStatus = accountManager.GetAllFormReview(ListFormStatus.Id, out returnMessage, out isSuccess);
return(View("ActionToPdfFile", ListFormStatus));
}
public AllFormReview GetAllFormReview(int id, out string result, out bool isSuccess)
{
try
{
AllFormReview AllFormReview = new AllFormReview();
using (BoardofPardonsEntities1 dbcontext = new BoardofPardonsEntities1())
{
AllFormReview.Id = id;
var form = dbcontext.Forms.Where(a => a.id == id).FirstOrDefault();
AllFormReview.type = form.Type;
if (form.Type == 2)
{
AllFormReview.IncarceratedStep1 = dbcontext.IncarceratedStep1.Where(a => a.FormId == id).FirstOrDefault();
AllFormReview.IncarceratedStep2 = dbcontext.IncarceratedStep2.Where(a => a.FormId == id).FirstOrDefault();
AllFormReview.IncarceratedStep3 = dbcontext.IncarceratedStep3.Where(a => a.FormId == id).FirstOrDefault();
AllFormReview.IncarceratedStep4 = dbcontext.IncarceratedStep4.Where(a => a.FormId == id).FirstOrDefault();
AllFormReview.IncarceratedStep5 = dbcontext.IncarceratedStep5.Where(a => a.FormId == id).FirstOrDefault();
AllFormReview.IncarceratedStep6 = dbcontext.IncarceratedStep6.Where(a => a.FormId == id).FirstOrDefault();
AllFormReview.IncarceratedStep7 = dbcontext.IncarceratedStep7.Where(a => a.FormId == id).FirstOrDefault();
}
else
{
AllFormReview.NonIncarceratedStep1 = dbcontext.NonIncarceratedStep1.Where(a => a.FormId == id).FirstOrDefault();
AllFormReview.NonIncarceratedStep2 = dbcontext.NonIncarceratedStep2.Where(a => a.FormId == id).FirstOrDefault();
AllFormReview.NonIncarceratedStep3 = dbcontext.NonIncarceratedStep3.Where(a => a.FormId == id).FirstOrDefault();
AllFormReview.NonIncarceratedStep4 = dbcontext.NonIncarceratedStep4.Where(a => a.FormId == id).FirstOrDefault();
AllFormReview.NonIncarceratedStep5 = dbcontext.NonIncarceratedStep5.Where(a => a.FormId == id).FirstOrDefault();
AllFormReview.NonIncarceratedStep6 = dbcontext.NonIncarceratedStep6.Where(a => a.FormId == id).FirstOrDefault();
AllFormReview.NonIncarceratedStep7 = dbcontext.NonIncarceratedStep7.Where(a => a.FormId == id).FirstOrDefault();
}
result = "";
isSuccess = true;
return(AllFormReview);
}
}
catch (Exception ex)
{
using (StreamWriter writer =
new StreamWriter(HostingEnvironment.MapPath("~/errLog.txt")))
{
writer.WriteLine("==========================");
writer.WriteLine("Date " + DateTime.Now);
writer.WriteLine("Error" + ex.Message);
}
isSuccess = false;
result = ex.Message;
return(null);
}
}
public ActionResult review(int id)
{
accountManager = new AccountManager();
AllFormReview ListFormStatus = new AllFormReview();
ListFormStatus = accountManager.GetAllFormReview(id, out returnMessage, out isSuccess);
if (isSuccess)
{
return(View(ListFormStatus));
}
else
{
return(RedirectToAction("Index"));
}
}
public ActionResult PDFView(int id)
{
accountManager = new AccountManager();
AllFormReview ListFormStatus = new AllFormReview();
//ListFormStatus = accountManager.GetAllFormReview(id, out returnMessage, out isSuccess);
ListFormStatus.Id = id;
try
{
return(new ActionAsPdf("ActionToPdfFile", ListFormStatus));
//return new RazorPDF.PdfResult(ListFormStatus, "PDFView");
}
catch (Exception ex)
{
return(null);
}
}
public void updateFormReview(string command, string comment, int id, int currentReviewr, out string result, out bool isSuccess)
{
try
{
AllFormReview AllFormReview = new AllFormReview();
using (BoardofPardonsEntities1 dbcontext = new BoardofPardonsEntities1())
{
var form = dbcontext.Forms.Where(a => a.id == id).FirstOrDefault();
if (command == "reject")
{
form.Status = 3;
}
else
{
form.Status = 4;
}
Review objReview = new Review();
objReview.Comment = comment;
objReview.FormId = id;
objReview.ReviewedAt = DateTime.Now;
objReview.ReviewerId = currentReviewr;
objReview.Status = form.Status;
dbcontext.Reviews.Add(objReview);
dbcontext.SaveChanges();
result = "";
isSuccess = true;
}
}
catch (Exception ex)
{
using (StreamWriter writer =
new StreamWriter(HostingEnvironment.MapPath("~/errLog.txt")))
{
writer.WriteLine("==========================");
writer.WriteLine("Date " + DateTime.Now);
writer.WriteLine("Error" + ex.Message);
}
isSuccess = false;
result = ex.Message;
}
}
