public ActionResult Create(FormCollection collection) { try { ITaxonRepository taxon = new TaxonRepository(); IGenericRepository generics = new GenericRepository(); IReviewRepository reviews = new ReviewRepository(); // TODO: Add insert logic here TblReview r = new TblReview(); int kingdom = 0; int reviewtype = 0; kingdom = collection["addkingdom"].Equals("animal") ? generics.getExternalRef(UpdateUtils.ANIMALS, UpdateUtils.TYPE_KINGDOM) : generics.getExternalRef(UpdateUtils.PLANTS, UpdateUtils.TYPE_KINGDOM); //reviewtype = collection["reviewtype"].Equals("normal") ? // generics.getExternalRef(UpdateUtils.REVIEW_NORMAL, UpdateUtils.TYPE_REVIEW) : // generics.getExternalRef(UpdateUtils.REVIEW_ADHOC, UpdateUtils.TYPE_REVIEW); r.CountryID = int.Parse(collection["countries"]); r.AddedBy = 2; r.AddedByName= Membership.GetUser().ToString(); r.DateAdded = DateTime.Now; r.PhaseID = int.Parse(collection["addphase"]); int speciesId = int.Parse(collection["species"]); r.TaxonID = speciesId; r.TaxonLevel = generics.getExternalRef(UpdateUtils.SPECIES, UpdateUtils.TYPE_TAXONLEVEL); r.KingdomID = kingdom; // r.CommitteeID = int.Parse(collection["committee"]); r.CommitteeID = 1; r.ReviewDate = DateTime.Now; r.ReviewType = 1; int ID= taxon.SaveReview(r); ReviewStatus rs = new ReviewStatus(); rs.Status = generics.getExternalRef(UpdateUtils.SELECTION, UpdateUtils.REVIEWSTATUS); rs.DateAdded = DateTime.Now; rs.ReviewID = ID; reviews.saveReviewStatus(rs); // return RedirectToAction("List","AddReview"); return RedirectToAction("Details", "ProcessReview", new {id = ID}); } catch { //Do nothing - caught below } return RedirectToAction("AddReview", "AddReview"); }
public void testGetExternalRef() { IGenericRepository gen = new GenericRepository(); int i = gen.getExternalRef(UpdateUtils.RECOMMENDATIONS,UpdateUtils.REVIEWSTATUS); Assert.AreEqual(i, 10); }
public ActionResult CreateDecision(FormCollection collection) { try { // TODO: Add insert logic here IGenericRepository generics = new GenericRepository(); string decisionnotes = collection["decision"].ToString(); int decMeetingId = int.Parse(collection["DecMeetings"].ToString()); int decisionType = generics.getExternalRef(collection["decisiontypes"].ToString(),UpdateUtils.TYPE_DECISION); int tradeTerms = generics.getExternalRef(collection["tradeterms"].ToString(),UpdateUtils.TYPE_TRADETERMS); int PActionID = int.Parse(collection["SourceID"].ToString()); IDecisionsRepository decisions = new DecisionsRepository(); IGenericRepository generic = new GenericRepository(); Decision dec = new Decision(); dec.AddedDate = DateTime.Now; dec.DecisionType = decisionType; dec.ParagraphActionID = PActionID; dec.Notes = decisionnotes; dec.TradeTerms = tradeTerms; dec.SuspensionCommitteeID = decMeetingId; if (collection["suspensiondate"] != null && collection["suspensiondate"].Length > 0) { dec.SuspensionDate = DateTime.Parse(collection["suspensiondate"].ToString()); } if (collection["lifteddate"] != null && collection["lifteddate"].Length > 0) { DateTime liftedDate = DateTime.Parse(collection["lifteddate"].ToString()); dec.SuspensionDate = liftedDate; } if (collection["LiftedMeetings"] != null && collection["LiftedMeetings"].Length > 0) { int liftedCommitteeId = int.Parse(collection["LiftedMeetings"].ToString()); dec.LigftingCommitteeID = liftedCommitteeId; } int i = decisions.SaveDecision(dec); ViewData["MeetingsA"] = ViewData["DecMeetings"] = ViewData["LiftedMeetings"] = new SelectList(generic.getAllMeetingsSelect(), "ID", "Description"); //ViewData["DecCommittees"] = ViewData["LiftedCommittees"]= new SelectList(generic.getAllCommitteesSelect(), "ID", "Description"); IList<Decision> decs = decisions.GetAllDecisionsPerParagraph(PActionID); ViewData["decisiondetails"] = UpdateUtils.GetDecisionDetails(decs); ViewData["decisions"] = decs; //ViewData["decisions"] = decisions.GetAllDecisionsPerParagraph(PActionID); ViewData["ReviewID"] = int.Parse(collection["ReviewID"]); ViewData["PALibID"] = int.Parse(collection["PALibID"]); ViewData["PActionID"] = PActionID; ViewData["decisiontypes"] = new SelectList(generic.GetAllDecisionTypes(), "Description", "Description"); ViewData["tradeterms"] = new SelectList(generic.GetAllTradeTerms(), "Description", "Description"); ViewData["editmode"] = false; return PartialView("Decisions"); //return RedirectToAction("Index"); } catch { return RedirectToAction("Search", "SearchReview"); } }
private void saveSpeciesForReview() { ITaxonRepository Taxon = new TaxonRepository(); IGenericRepository gen = new GenericRepository(); IReviewRepository rr = new ReviewRepository(); if (TempData["CurrentData"] != null) { DataTable dt = (DataTable)TempData["CurrentData"]; int rowcount = dt.Rows.Count; ITaxonRepository taxon = new TaxonRepository(); for (int i = 0; i < rowcount; i++) { DataRow dr = dt.Rows[i]; TblReview r = new TblReview(); r.PhaseID = int.Parse(dr[1].ToString()); r.KingdomID = taxon.getTaxonLevelID(dr[7].ToString()); r.TaxonLevel = taxon.getTaxonLevelID(dr[2].ToString()); r.TaxonID = int.Parse(dr[4].ToString()); r.DateAdded = DateTime.Now; r.CountryID = int.Parse(dr[6].ToString()); int ID = taxon.SaveReview(r); ReviewStatus rs = new ReviewStatus(); rs.Status = gen.getExternalRef(UpdateUtils.SELECTION, UpdateUtils.REVIEWSTATUS); rs.DateAdded = DateTime.Now; rs.ReviewID = ID; rr.saveReviewStatus(rs); } } }
public ActionResult EditReview(int id, FormCollection collection) { try { // TODO: Add update logic here IReviewRepository reviews = new ReviewRepository(); ITaxonRepository taxons = new TaxonRepository(); TblReview review = reviews.getSingleReviewEdit(id); IGenericRepository generics = new GenericRepository(); int kingdom = 0; int reviewtype = 0; kingdom = collection["kingdom"].Equals("animal") ? generics.getExternalRef(UpdateUtils.ANIMALS, UpdateUtils.TYPE_KINGDOM) : generics.getExternalRef(UpdateUtils.PLANTS, UpdateUtils.TYPE_KINGDOM); //reviewtype = collection["reviewtype"].Equals("normal") ? // generics.getExternalRef(UpdateUtils.REVIEW_NORMAL, UpdateUtils.TYPE_REVIEW) : // generics.getExternalRef(UpdateUtils.REVIEW_ADHOC, UpdateUtils.TYPE_REVIEW); review.CountryID = int.Parse(collection["countries"]); review.AddedBy = 2; review.DateAdded = DateTime.Now; review.PhaseID = int.Parse(collection["addphase"]); review.TaxonID = int.Parse(collection["species"]); ; review.TaxonLevel = generics.getExternalRef(UpdateUtils.SPECIES, UpdateUtils.TYPE_TAXONLEVEL); review.KingdomID = kingdom; //review.CommitteeID = int.Parse(collection["committee"]); review.CommitteeID = 1; //r.ReviewDate = DateTime.Now; //r.ReviewType = reviewtype; int ID = taxons.SaveReview(review); //ReviewStatus rs = new ReviewStatus(); //rs.Status = generics.getExternalRef(UpdateUtils.SELECTION, UpdateUtils.REVIEWSTATUS); //rs.DateAdded = DateTime.Now; //rs.ReviewID = ID; //reviews.saveReviewStatus(rs); return RedirectToAction("List"); } catch { return View(); } }
public ActionResult EditReview(int id) { IReviewRepository reviews = new ReviewRepository(); IGenericRepository generics = new GenericRepository(); ITaxonRepository taxons = new TaxonRepository(); TblReview review = reviews.getSingleReviewEdit(id); ViewData["addphase"] = new SelectList(generics.getAllPhase(), "ID", "PhaseDesc",review.PhaseID); ViewData["committee"] = new SelectList(generics.getAllCommittees(), "ID", "Description", review.CommitteeID); int animal = generics.getExternalRef(UpdateUtils.ANIMALS, UpdateUtils.TYPE_KINGDOM); int kingdom = (int) review.KingdomID; IList<AGeneralTaxon> lists_countries, lists_genus, lists_species = null; int SpeciesID = review.TaxonID.GetValueOrDefault(); Taxons genus = taxons.getTaxonbySpecies(SpeciesID, (int) review.KingdomID); if (review.KingdomID == animal) { lists_countries = taxons.getCountries(SpeciesID, UpdateUtils.SPECIES, UpdateUtils.ANIMALS); lists_genus = taxons.getAGenus(); lists_species= taxons.getASpeciesbyGenus(genus.genrecid); } else { lists_countries = taxons.getCountries(SpeciesID, UpdateUtils.SPECIES, UpdateUtils.PLANTS); lists_genus = taxons.getPGenus(); lists_species= taxons.getPSpeciesbyGenus(genus.genrecid); } ViewData["animal"] = animal; ViewData["kingdom"] = kingdom; ViewData["countries"] = new SelectList(lists_countries, "RecID", "TaxonName", review.CountryID); ViewData["genus"] = new SelectList(lists_genus, "RecID", "TaxonName", genus.genrecid); ViewData["species"] = new SelectList(lists_species, "RecID", "TaxonName", SpeciesID); return View(); }