private static List <CourtDecision> getDecisions()
{
if (courtDecisions == null)
{
//Load Data from Source File and stor it in sourceData
DataTable sourceData = new DataAccess.CsvHelper.CsvReader(AppDomain.CurrentDomain.BaseDirectory + @"\Data\CourtData.csv")
{
cSeperator = '|', cDelimiter = '"', HasHeaderRow = false
}.ReadIntoDataTable();
//Initialize CitationList
courtDecisions = new List <CourtDecision>();
//Load Citations to List
foreach (DataRow row in sourceData.Rows)
{
CourtDecision dec = new CourtDecision();
dec.id = row[0].ToString();
dec.file_number = row[1].ToString();
dec.date = row[2].ToString();
dec.court = new Court();
dec.court.level_of_appeal = row[3].ToString();
courtDecisions.Add(dec);
}
}
return(courtDecisions);
}
public ActionResult DeleteConfirmed(int id)
{
CourtDecision courtdecision = db.CourtDecisions.Find(id);
db.CourtDecisions.Remove(courtdecision);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private CourtDecision CreateCourtDecision()
{
var courtdecision = new CourtDecision();
courtdecision.Is382BApplied = true;
courtdecision.PrisonerId = PrisonerId;
courtdecision.AdmissionId = AdmissionId;
return(courtdecision);
}
//
// GET: /CourtDecision/Details/5
public ActionResult Details(int id = 0)
{
CourtDecision courtdecision = db.CourtDecisions.Find(id);
if (courtdecision == null)
{
return(HttpNotFound());
}
return(View(courtdecision));
}
public static CourtDecision getCourtDecision(string DecisionId)
{
try
{
return(getDecisions().Where(d => d.id == DecisionId).First());
}
catch (Exception ex)
{
return(new CourtDecision()
{
id = DecisionId, file_number = "12 U 123/45", date = "2016-01-01", court = new Court()
{
id = "0", level_of_appeal = ""
}
});
}
CourtDecision result = new CourtDecision();
JsonValue decision = getApiCall("cases/" + DecisionId);
if (decision == null)
{
result.id = "error";
result.slug = "error - api request to openlegaldata failed";
return(result);
}
result.id = decision["id"].ToString();
result.slug = decision["slug"].ToString();
result.file_number = decision["file_number"];
result.date = decision["date"];
result.create_date = decision["created_date"];
result.update_date = decision["updated_date"];
result.type = decision["type"];
result.court = new Court();
result.court.id = decision["court"]["id"].ToString();
result.court.name = decision["court"]["name"].ToString();
result.court.slug = decision["court"]["slug"];
result.court.city = decision["court"]["city"] != null ? decision["court"]["city"].ToString() : "";
result.court.state = decision["court"]["state"].ToString();
result.court.jurisdiction = decision["court"]["jurisdiction"];
result.court.level_of_appeal = decision["court"]["level_of_appeal"];
return(result);
}
private static void UpdateDecisions()
{
using (StreamReader reader = new StreamReader(AppDomain.CurrentDomain.BaseDirectory + @"Data\cases.json", Encoding.UTF8))
{
string query = reader.ReadLine();
int i = 0;
while (!reader.EndOfStream)
{
if (i % 500 == 0)
{
System.Diagnostics.Debug.WriteLine(DateTime.Now.ToLongTimeString() + " " + i + " rows checked");
}
JsonValue v = JsonValue.Parse(reader.ReadLine());
CourtDecision dec = new CourtDecision(v);
dec.UpdateToDatabase(con);
i++;
}
}
}
//
// GET: /CourtDecision/Create
public ActionResult Create()
{
var admission = GetLatestAdmission(); //db.Admissions.OrderByDescending(o => o.AdmissionId).FirstOrDefault(o => o.PrisonerId == courtdecision.PrisonerId);
CourtDecision courtdecision = CreateCourtDecision();
courtdecision.DateOfUnderTrialStart = admission.DateOfAdmission;
if (admission.DateOfReleaseWithFullSentence != null)
{
ViewBag.DateOfReleaseWithFullSentence = admission.DateOfReleaseWithFullSentence.Value.ToString("dd-MMM-yyy");
}
else
{
ViewBag.DateOfReleaseWithFullSentence = "";
}
PopulateDropDowns(courtdecision);
return(View(courtdecision));
}
private void PopulateDropDowns(CourtDecision courtdecision)
{
IQueryable <FIR> firList = null;
IQueryable <CourtHearing> courtHearingList = null;
if (courtdecision.AdmissionId > 0)
{
firList = db.FIRs.Where(o => o.AdmissionId == courtdecision.AdmissionId);
courtHearingList = db.CourtHearings.Where(o => o.AdmissionId == courtdecision.AdmissionId);
}
else
{
firList = db.FIRs.Where(o => o.Admission.PrisonerId == courtdecision.PrisonerId);
courtHearingList = db.CourtHearings.Where(o => o.Admission.PrisonerId == courtdecision.PrisonerId);
}
if (courtHearingList != null)
{
var list = new List <NameValuePair>();
foreach (var c in courtHearingList)
{
var nameValuePair = new NameValuePair {
Value = c.CourtHearingId, Name = string.Format("{0} - {1:dd-MMM-yyyy} - {2}", c.FIR.FIRNumber, c.DateOfHearing, c.Court.Name)
};
if (c.JudgeType != null)
{
nameValuePair.Name += string.Format(" - {0}", c.JudgeType.Name);
}
list.Add(nameValuePair);
}
ViewBag.FIRId = new SelectList(firList, "FIRId", "FIRNumber", courtdecision.FIRId);
ViewBag.CourtHearingId = new SelectList(list, "Value", "Name", courtdecision.CourtHearingId);
}
ViewBag.DecisionStatus = new SelectList(Enum.GetValues(typeof(DecisionStatus)), courtdecision.DecisionStatus);
ViewBag.CourtDecisionType = new SelectList(Enum.GetValues(typeof(CourtDecisionType)), courtdecision.CourtDecisionType);
}
public ActionResult Edit(CourtDecision courtdecision, DateTime?DateOfReleaseWithFullSentence)
{
if (ModelState.IsValid)
{
var admission = db.Admissions.Include(o => o.Prisoner).OrderByDescending(o => o.AdmissionId).FirstOrDefault(o => o.PrisonerId == courtdecision.PrisonerId);
admission.DateOfReleaseWithFullSentence = DateOfReleaseWithFullSentence;
if (courtdecision.DecisionStatus == DecisionStatus.Sentenced)
{
admission.Prisoner.Category = PrisonerCategory.Convicted;
}
db.Entry(courtdecision).State = EntityState.Modified;
db.SaveChanges();
CalculateSentence();
return(RedirectToAction("Details", new { id = courtdecision.CourtDecisionId, PrisonerId = PrisonerId }));
}
PopulateDropDowns(courtdecision);
return(View(courtdecision));
}
//
// GET: /CourtDecision/Edit/5
public ActionResult Edit(int id = 0)
{
CourtDecision courtdecision = db.CourtDecisions.Find(id);
if (courtdecision == null)
{
return(HttpNotFound());
}
var admission = db.Admissions.OrderByDescending(o => o.AdmissionId).FirstOrDefault(o => o.PrisonerId == courtdecision.PrisonerId);
if (admission.DateOfReleaseWithFullSentence != null)
{
ViewBag.DateOfReleaseWithFullSentence = admission.DateOfReleaseWithFullSentence.Value.ToString("dd-MMM-yyyy");
}
else
{
ViewBag.DateOfReleaseWithFullSentence = "";
}
PopulateDropDowns(courtdecision);
return(View(courtdecision));
}
