| public getExternalRef ( string description, string type ) : int | ||
| description | string | |
| type | string | |
| Résultat | int | |
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();
}
