// GET: /SearchReview/GetCountries
public ActionResult GetCountriesSearch(bool ajax, string speciesID, string kingdom)
{
IGenericRepository gen = new GenericRepository();
ITaxonRepository taxon = new TaxonRepository();
IList<AGeneralTaxon> lists = null;
int _speciesID = int.Parse((speciesID));
if (kingdom.Equals("animals") || kingdom.Equals("animal"))
{
lists = taxon.getCountriesSearch(_speciesID, UpdateUtils.SPECIES, UpdateUtils.ANIMALS);
}
else if (kingdom.Equals("plants") || kingdom.Equals("plant"))
{
lists = taxon.getCountriesSearch(_speciesID, UpdateUtils.SPECIES, UpdateUtils.PLANTS);
}
else if (kingdom.Equals("all"))
{
lists = taxon.getCountriesSearch(_speciesID, UpdateUtils.SPECIES, UpdateUtils.ALL_KINGDOM);
}
// return Json(taxons.getCountries(3, UpdateUtils.PHYLUM, UpdateUtils.ANIMALS).ToList());
return Json(lists);
}
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 ActionResult AddReview()
{
IGenericRepository gen = new GenericRepository();
ITaxonRepository taxons = new TaxonRepository();
IList<AGeneralTaxon> initList = new[] { new AGeneralTaxon { RecId = 1, TaxonName = "- Please Select -" } };
ViewData["addphase"] = new SelectList(gen.getAllPhase(), "ID", "PhaseDesc");
ViewData["committee"] = new SelectList(gen.getAllCommittees(),"ID","Description");
//ViewData["genus"] = new SelectList(taxons.getAGenus(),"RecID","TaxonName");
//ViewData["species"] = new SelectList(taxons.getASpecies(), "RecID", "TaxonName");
ViewData["countries"] = ViewData["genus"] = ViewData["species"] = new SelectList(initList, "RecID", "TaxonName");
// ViewData["countries"] = new SelectList(taxons.)
return View();
}
public ActionResult CreateRecommendation(FormCollection collection)
{
try
{
// TODO: Add insert logic here
string recommendation = collection["recommendation"].ToString();
int committee_id = int.Parse(collection["Committees"].ToString());
DateTime recdeadlinedate = DateTime.Parse(collection["recdeadlinedate"].ToString());
DateTime recdate = DateTime.Parse(collection["recdate"].ToString());
int PActionID = int.Parse(collection["SourceID"].ToString());
IRecommendationsRepository recs = new RecommendationsRepository();
IGenericRepository generic = new GenericRepository();
Recommendation r = new Recommendation();
r.AddedDate = DateTime.Now;
r.CommitteeID = committee_id;
r.DeadlineDate = recdeadlinedate;
r.RecDate = recdate;
r.RecommendationX = recommendation;
r.ParagraphActionID = PActionID;
int i= recs.SaveRec(r);
ViewData["Committees"] = new SelectList(generic.getAllCommitteesSelect(), "ID", "Description");
ViewData["recommendations"] = recs.getAllRecommendationsByParagraph(PActionID);
ViewData["PActionID"] = PActionID;
return PartialView("Recommendations");
//return RedirectToAction("Index");
}
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();
}
public void IndexTest3()
{
// ITaxonRepository Taxon = new TaxonRepository();
IGenericRepository gen = new GenericRepository();
IList<Phase> am = gen.getAllPhase();
Assert.AreEqual(am[0].PhaseDesc, "hello");
}
public void TestDescriptionGeneral()
{
IGenericRepository gens = new GenericRepository();
string test = gens.GetDescriptionByType(1, UpdateUtils.TYPE_DECISION);
// int j = recs.getAllRecommendationsByParagraph(12).Count;
Assert.AreEqual(test, "hello");
}
public void testAllCommittees()
{
IGenericRepository generic = new GenericRepository();
IMeetingLibRepository mlib = new MeetingLibRepository();
// IList<TblMeetingLib> coms = generic.getAllMeetings();
//IList<SelectItems> items = generic.getAllCommitteesSelect();
IList<SelectItems> items = generic.getAllMeetingsSelect();
IList<MeetingLib> itemsm = mlib.getAllMeetingLibs();
SelectList sl = new SelectList(itemsm, "MeetingLibID", "MeetingLibDesc");
Assert.AreEqual(sl.First().Text,"hello");
}
//
// GET: /Report/
public ActionResult Index()
{
ITaxonRepository taxons = new TaxonRepository();
IGenericRepository generics = new GenericRepository();
ViewData["countries"] = new SelectList(taxons.getReportCountries(), "ID", "Description");
ViewData["paragraphs"] = new SelectList(taxons.getReportParagraphActions(), "ID", "Description");
ViewData["phases"] = new SelectList(generics.getAllPhase(), "ID", "PhaseDesc");
ViewData["concerns"] = new SelectList(generics.getAllLevelofConcerns(), "ID", "Description");
ViewData["species"] = new SelectList(taxons.getASpeciesSearch(), "RecID", "TaxonName");
IList<UsersParagraphLink> users = generics.getAllUsersBySource();
int usercount = users.Count;
for (int j = 0; j < usercount; j++) {
users[j].UserID = Membership.GetUser(new Guid(users[j].UserID)).UserName;
}
ViewData["actors"] =
new SelectList(users, "UserID", "UserID");
return View();
}
public static IList<DecisionDetails> GetDecisionDetails(IList<Decision> decisions)
{
IList<DecisionDetails> decDetails = new List<DecisionDetails>();
// IList<DecisionDetails> decDetails;
IGenericRepository gens = new GenericRepository();
Decision decision;
int decCount = decisions.Count;
for (int i = 0; i < decCount;i++ ) {
decision = decisions[i];
DecisionDetails decDetail = new DecisionDetails();
decDetail.DecisionId = decision.Id;
decDetail.DecisionType =
gens.GetDescriptionByType(decision.DecisionType, UpdateUtils.TYPE_DECISION);
decDetail.TradeTerms =
gens.GetDescriptionByType(decision.TradeTerms, UpdateUtils.TYPE_TRADETERMS);
decDetail.DecisionDate = DateTime.Parse(decision.SuspensionDate.ToString());
if (decision.SuspensionLiftDate != null)
decDetail.LiftingDate = DateTime.Parse(decision.SuspensionLiftDate.ToString());
decDetails.Insert(i,decDetail);
}
return decDetails;
}
//function to save users for a paragraph
public static void InsertUsersPerParagraph(FormCollection collection, int SourceID, int SourceType)
{
IGenericRepository generics = new GenericRepository();
string selectedusers = collection["users"];
string[] allusers = selectedusers.Split(',');
int count = allusers.Length;
if (count > 0)
generics.DeleteUser(null, SourceID, SourceType);
for (int i = 0; i < count; i++)
{
UsersParagraphLink user = new UsersParagraphLink();
user.DateAdded = DateTime.Now;
user.UserID = Membership.GetUser(allusers[i]).ProviderUserKey.ToString();
user.SourceID = SourceID;
user.SourceType = SourceType;
generics.SaveUser(user);
}
}
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);
}
}
}
//
// GET: /AddReview/
public ActionResult ReviewIndex()
{
ITaxonRepository Taxon = new TaxonRepository();
IGenericRepository gen = new GenericRepository();
ViewData["Phase"] = gen.getAllPhase();
ViewData["Kingdom"] = Taxon.getKingdom();
return View();
}
// GET: /AddReview/GetGenus
public ActionResult GetGenus(bool ajax, string value)
{
IGenericRepository gen = new GenericRepository();
ITaxonRepository taxon = new TaxonRepository();
IList<AGeneralTaxon> lists = null;
if (value.Equals("animal"))
{
lists = taxon.getAGenus();
}
else if (value.Equals("plant"))
{
lists = taxon.getPGenus();
}
// return Json(taxons.getCountries(3, UpdateUtils.PHYLUM, UpdateUtils.ANIMALS).ToList());
return Json(lists);
}
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 SaveCompleted(FormCollection collection)
{
try
{
IGenericRepository generics = new GenericRepository();
IReviewRepository reviews = new ReviewRepository();
int PActionID = int.Parse(collection["SourceID"].ToString());
string completed = collection["ckCompleted"];
DateTime dateCompleted = DateTime.Now;
ParagraphAction PAction = reviews.getParagraphActionbyID(PActionID);
int ReviewID = int.Parse(PAction.ReviewID.ToString());
if (collection["selectedactorsedit"] != null)
{
collection["users"] = collection["selectedactorsedit"];
UpdateUtils.InsertUsersPerParagraph(collection, PActionID, UpdateUtils.PARAGRAPH_SOURCE);
}
// string selected = collection["selectedactorsedit"].ToString();
// string[] listselected = selected.Split(',');
// int count = listselected.Length;
// for (int j = 0; j < count; j++)
// {
// string key = Membership.GetUser(listselected[j]).ProviderUserKey.ToString();
// }
if (completed != null)
{
PAction.Completed = true;
if (collection["edit_date_completed"] != null && collection["edit_date_completed"].Length > 0)
{
dateCompleted = DateTime.Parse(collection["edit_date_completed"]);
}
PAction.CompletedDate = dateCompleted;
}
else
{
PAction.Completed = false;
PAction.DateModified = DateTime.Now;
}
//Save the rest of the data
var deadlineDate = collection["Deadline"] == null ? ((DateTime)PAction.DateStarted).AddDays(30) : DateTime.Parse(collection["Deadline"].ToString());
var startedDate = DateTime.Parse(collection["DateStarted"]);
PAction.DeadlineDate = deadlineDate;
PAction.DateStarted = startedDate;
if (collection["concerns"] != null)
{
string concern = collection["concerns"];
switch (concern) {
case UpdateUtils.URGENT_CONCERN:
PAction.ConcernID = UpdateUtils.URGENT_CONCERN_ID;
break;
case UpdateUtils.POSSIBLE_CONCERN:
PAction.ConcernID = UpdateUtils.POSSIBLE_CONCERN_ID;
break;
case UpdateUtils.LEAST_CONCERN:
PAction.ConcernID = UpdateUtils.LEAST_CONCERN_ID;
break;
case UpdateUtils.NOT_CLASSIFIED:
PAction.ConcernID = UpdateUtils.NOT_CLASSIFIED_ID;
break;
}
ParagraphAction topPA = generics.getParagraphActionPerReview(PAction.ReviewID.Value);
if (topPA.Id == PAction.Id)
{
TblReview review = reviews.getSingleReviewEdit(PAction.ReviewID);
review.ConcernID = PAction.ConcernID;
DB.Save(review);
generics.resetCurrentConcernForReview(PAction.ReviewID.Value);
PAction.CurrentConcern = true;
}
}
PAction.MeetingID = Int32.Parse(collection["Meetings"]);
PAction.DateModified = DateTime.Now;
int i= reviews.SavePA(PAction);
return RedirectToAction("Details","ProcessReview", new {ID=ReviewID});
}
catch
{
//return View();
return null;
}
}
public static int InsertParagraphActionForm(FormCollection collection)
{
IReviewRepository reviews = new ReviewRepository();
IGenericRepository generics = new GenericRepository();
ParagraphAction pa = new ParagraphAction();
int palibid = int.Parse(collection["PALibID"]);
int reviewid = int.Parse(collection["ReviewID"]);
pa.PALibID = palibid;
pa.DateStarted = DateTime.Parse(collection["pda_started_date"].ToString());
pa.DeadlineDate = DateTime.Parse(collection["pda_deadline_date"].ToString());
pa.MeetingID = int.Parse(collection["meetings"]);
pa.ReviewID = reviewid;
//string concern = collection["concerns"].ToString();)
if (collection["concerns"] != null)
{
string concern = collection["concerns"].ToString();
switch(concern)
{
case UpdateUtils.URGENT_CONCERN:
pa.ConcernID = UpdateUtils.URGENT_CONCERN_ID;
break;
case UpdateUtils.POSSIBLE_CONCERN:
pa.ConcernID = UpdateUtils.POSSIBLE_CONCERN_ID;
break;
case UpdateUtils.LEAST_CONCERN:
pa.ConcernID = UpdateUtils.LEAST_CONCERN_ID;
break;
case UpdateUtils.NOT_CLASSIFIED:
pa.ConcernID = UpdateUtils.NOT_CLASSIFIED_ID;
break;
}
TblReview review = reviews.getSingleReviewEdit(reviewid);
review.ConcernID = pa.ConcernID;
DB.Save(review);
generics.resetCurrentConcernForReview(reviewid);
pa.CurrentConcern = true;
}
else
{
pa.ConcernID = UpdateUtils.NOT_CLASSIFIED_ID;
pa.CurrentConcern = true;
}
string completed = collection["completed"];
if ((completed!=null) && (completed.Equals("on")))
{
DateTime dateCompleted = DateTime.Now;
if (collection["pda_completed_date"] != null && collection["pda_completed_date"].Length > 0) {
dateCompleted = DateTime.Parse(collection["pda_completed_date"]);
pa.CompletedDate = dateCompleted;
}
else {
pa.CompletedDate = dateCompleted;
}
pa.Completed = true;
}
pa.DateAdded = DateTime.Now;
return reviews.SavePA(pa);
}
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");
}
}
public void DeleteUsers(string[] users, int SourceID, int SourceType)
{
IGenericRepository generics = new GenericRepository();
int count = users.Length;
for (int i=0;i<count;i++)
{
generics.DeleteUser(users[i],SourceID,SourceType);
}
}
public ActionResult DeleteDecision(FormCollection collection)
{
//ICommentsRepository comments = new CommentsRepository();
IDecisionsRepository decisions = new DecisionsRepository();
IGenericRepository generics = new GenericRepository();
int ID = int.Parse(collection["ID"]);
int ReviewID_ = int.Parse(collection["ReviewID"]);
int PALibID_ = int.Parse(collection["PALibID"]);
int SourceID = int.Parse(collection["SourceID"]);
int SourceType = int.Parse(collection["SourceType"]);
decisions.DeleteDecision(ID);
//SourceID is the ParagraphActionID actually
IList<Decision> decs = decisions.GetAllDecisionsPerParagraph(SourceID);
ViewData["decisiondetails"] = UpdateUtils.GetDecisionDetails(decs);
ViewData["decisions"] = decs;
//ViewData["Comments"] = comments.getCommentsByID(SourceID, SourceType);
ViewData["ReviewID"] = ReviewID_;
ViewData["PALibID"] = PALibID_;
ViewData["PActionID"] = SourceID;
ViewData["MeetingsA"] =
ViewData["DecMeetings"] =
ViewData["LiftedMeetings"] = new SelectList(generics.getAllMeetingsSelect(), "ID", "Description");
ViewData["decisiontypes"] = new SelectList(generics.GetAllDecisionTypes(), "Description",
"Description");
ViewData["tradeterms"] = new SelectList(generics.GetAllTradeTerms(), "Description",
"Description");
ViewData["editmode"] = false;
return PartialView("Decisions");
//return RedirectToAction("ParagraphDetailsEdit", new { ReviewID = ReviewID_, PALibID = PALibID_ });
//return View();
}
// GET: /Report/GetSpeciesList
public ActionResult GetSpeciesList(bool ajax, string kingdom)
{
IGenericRepository gen = new GenericRepository();
ITaxonRepository taxon = new TaxonRepository();
IList<AGeneralTaxon> lists = null;
if (kingdom.Equals("animals"))
lists = taxon.getASpeciesSearch();
else {
lists = taxon.getPSpeciesSearch();
}
// return Json(taxons.getCountries(3, UpdateUtils.PHYLUM, UpdateUtils.ANIMALS).ToList());
return Json(lists);
}
//
// GET: /ProcessReview/Details/5
public ActionResult Details(int id)
{
int ReviewID = id;
IReviewRepository reviews = new ReviewRepository();
ITaxonRepository taxon = new TaxonRepository();
IGenericRepository generics = new GenericRepository();
ReviewDesc review = reviews.getSingleReview(ReviewID);
review.TaxonName = taxon.getReviewTaxonName(review.ID, review.Taxontype, review.Kingdom);
bool completed = generics.getOldDataImportedStatus(ReviewID);
ViewData["para31_completed"] = completed;
ViewData["Title"] = review.TaxonName + " [" + review.CtyShort + "]";
ViewData["Review"] = review;
//ViewData["PAction"] = reviews.getParagraphDetails(review.)
ViewData["NextPALibID"] = reviews.getNextParagraphForReview(ReviewID);
var current_reviews = reviews.getAllPALibExtra(ReviewID);
ViewData["PALibs"] = current_reviews;
ViewData["para_contributor"] = null;
foreach (var currentReview in current_reviews)
{
if ((currentReview.ReviewID > 0) && !currentReview.Completed && (!completed))
{
IList<UsersParagraphLink> users = generics.getUserBySource(currentReview.ID, UpdateUtils.PARAGRAPH_SOURCE);
int usercount = users.Count;
for (int j = 0; j < usercount; j++) {
users[j].UserID = Membership.GetUser(new Guid(users[j].UserID)).UserName;
if (User.Identity.IsAuthenticated) {
var current_user = User.Identity.Name;
if (users[j].UserID == current_user) {
ViewData["para_contributor"] = current_user;
}
}
}
}
}
return View();
}
public ActionResult GenericReport(FormCollection collection)
{
int i = 10;
IGenericRepository generics = new GenericRepository();
int country = int.Parse(collection["countries"].ToString());
int paLibId = int.Parse(collection["paragraphs"].ToString());
int concern = int.Parse(collection["concerns"].ToString());
int phase = int.Parse(collection["phases"].ToString());
string actors = collection["actors"].ToString();
int taxonid = 0;
string reportkingdom = collection["reportkingdom"];
if (collection["species"] == null)
taxonid = -1;
else
taxonid = int.Parse(collection["species"].ToString());
int kingdom = 0;
switch(reportkingdom)
{
case UpdateUtils.ALL_KINGDOM:
kingdom = 0;
break;
case UpdateUtils.ANIMALS:
kingdom = 1;
break;
case UpdateUtils.PLANTS:
kingdom = 2;
break;
}
//DataSet dataTest = SPs.SpGetReportByCountries(country).GetDataSet();
actors = actors.Equals("-1") ? actors : Membership.GetUser(actors).ProviderUserKey.ToString();
DataSet dataTest = generics.getReportData(country, phase,paLibId, concern,actors, kingdom, taxonid);
DataRowCollection colResults = dataTest.Tables[0].Rows;
int count = colResults.Count;
TempData["reportData"] = dataTest;
return RedirectToAction("CountryView");
return View();
}
public ActionResult EditDecision(FormCollection collection)
{
IDecisionsRepository decisions = new DecisionsRepository();
IGenericRepository generics = new GenericRepository();
int ID = int.Parse(collection["ID"]);
int ReviewID_ = int.Parse(collection["ReviewID"]);
int PALibID_ = int.Parse(collection["PALibID"]);
int SourceID = int.Parse(collection["SourceID"]);
int SourceType = int.Parse(collection["SourceType"]);
//decisions.DeleteDecision(ID);
Decision decision = DB.Get<Decision>(ID);
ViewData["decision"] = decision;
ViewData["editmode"] = true;
//SourceID is the ParagraphActionID actually
IList<Decision> decs = decisions.GetAllDecisionsPerParagraph(SourceID);
ViewData["decisiondetails"] = UpdateUtils.GetDecisionDetails(decs);
ViewData["decisions"] = decs;
//ViewData["Comments"] = comments.getCommentsByID(SourceID, SourceType);
ViewData["ReviewID"] = ReviewID_;
ViewData["PALibID"] = PALibID_;
ViewData["PActionID"] = SourceID;
ViewData["ID"] = ID;
ViewData["MeetingsA"] = new SelectList(generics.getAllMeetingsSelect(), "ID", "Description");
ViewData["DecMeetings"] = new SelectList(generics.getAllMeetingsSelect(), "ID", "Description", decision.SuspensionCommitteeID);
ViewData["LiftedMeetings"] = new SelectList(generics.getAllMeetingsSelect(), "ID", "Description", decision.LigftingCommitteeID);
ViewData["decisiontypes"] = new SelectList(generics.GetAllDecisionTypes(), "Description",
"Description", decision.DecisionType);
ViewData["tradeterms"] = new SelectList(generics.GetAllTradeTerms(), "Description",
"Description",decision.TradeTerms);
return PartialView("Decisions");
}
public void TestDecisionDetails()
{
IGenericRepository gens = new GenericRepository();
IDecisionsRepository decisions = new DecisionsRepository();
IList<Decision> decs = decisions.GetAllDecisionsPerParagraph(12);
IList<DecisionDetails> details = UpdateUtils.GetDecisionDetails(decs);
// int j = recs.getAllRecommendationsByParagraph(12).Count;
Assert.AreEqual(details.Count,decs.Count);
}
public ActionResult ParagraphDetails(int ReviewID, int PALibID)
{
try
{
ITaxonRepository taxon = new TaxonRepository();
IReviewRepository reviews = new ReviewRepository();
IGenericRepository generic = new GenericRepository();
IMeetingLibRepository mlib = new MeetingLibRepository();
IMembershipRepository members = new MembershipRepository();
ICommentsRepository comments = new CommentsRepository();
IDocumentsRepository docs = new DocumentsRepository();
ReviewDesc review = reviews.getSingleReview(ReviewID);
review.TaxonName = taxon.getReviewTaxonName(review.ID, review.Taxontype, review.Kingdom);
ViewData["allactorsadd"] = new SelectList(Membership.GetAllUsers());
ViewData["selectedactorsedit"]= ViewData["allactorsedit"]=ViewData["selectedactorsadd"]=ViewData["allactors2"] = ViewData["allactorsadd"];
ViewData["PATitle"] = review.TaxonName + "-" + review.Taxontype + "\\" + review.CtyShort;
ViewData["Committees"] = new SelectList(generic.getAllCommitteesSelect(), "ID", "Description");
ViewData["Meetings"] = new SelectList(mlib.getAllMeetingLibs(), "MeetingLibID", "MeetingLibDesc");
ViewData["Roles"] = new SelectList(members.getAllRoles());
ViewData["PALib"] = reviews.getSinglePALib(PALibID);
ViewData["ReviewID"] = ReviewID;
ParagraphActionDetails pad = reviews.getParagraphDetails(PALibID, ReviewID);
if (pad != null)
{
ViewData["Comments"] = comments.getCommentsByID(pad.ID, UpdateUtils.PARAGRAPH_SOURCE,UpdateUtils.ROLE_ALL);
ViewData["Documents"] = docs.getDocumentsByID(pad.ID, UpdateUtils.PARAGRAPH_SOURCE, UpdateUtils.ROLE_ALL);
IList<UsersParagraphLink> users = generic.getUserBySource(pad.ID, UpdateUtils.PARAGRAPH_SOURCE);
int usercount = users.Count;
for (int j = 0; j < usercount; j++)
{
users[j].UserID = Membership.GetUser(new Guid(users[j].UserID)).UserName;
}
ViewData["selectedactorsedit"] =
new SelectList(users, "UserID", "UserID");
}
ViewData["PADetails"] = pad;
return View();
}
catch
{
return null;
}
}
public void testGetExternalRef()
{
IGenericRepository gen = new GenericRepository();
int i = gen.getExternalRef(UpdateUtils.RECOMMENDATIONS,UpdateUtils.REVIEWSTATUS);
Assert.AreEqual(i, 10);
}
public ActionResult ParagraphDetailsAdd(int? ReviewID, int? PALibID)
{
try
{
ITaxonRepository taxon = new TaxonRepository();
IReviewRepository reviews = new ReviewRepository();
IGenericRepository generic = new GenericRepository();
IMeetingLibRepository mlib = new MeetingLibRepository();
IMembershipRepository members = new MembershipRepository();
ICommentsRepository comments = new CommentsRepository();
IDocumentsRepository docs = new DocumentsRepository();
ReviewDesc review = reviews.getSingleReview(ReviewID);
ViewData["concernlevel"] = reviews.getConcernForReview(ReviewID.Value);
review.TaxonName = taxon.getReviewTaxonName(review.ID, review.Taxontype, review.Kingdom);
List<Actor> userdetails = GetUserDetails();
ViewData["allactorsadd"] = new SelectList(userdetails,"UserName", "UserDetails");
//ViewData["selectedactorsedit"] = ViewData["allactorsedit"] = ViewData["selectedactorsadd"] = ViewData["allactors2"] = ViewData["allactorsadd"];
ViewData["PATitle"] = review.TaxonName + " [" + review.CtyShort + "]";
ViewData["committees"] = new SelectList(generic.getAllCommitteesSelect(), "ID", "Description");
ViewData["meetings1"] = new SelectList(mlib.getAllMeetingLibs(), "MeetingLibID", "MeetingLibDesc");
ViewData["meetings"] =new SelectList(generic.getAllMeetingsSelect(), "ID", "Description");
ViewData["concerns"] = new SelectList(generic.getAllLevelofConcerns(), "Description", "Description");
//ViewData["roles"] = new SelectList(members.getAllRoles());
ViewData["rolesc"] =
ViewData["rolesd"]=new SelectList(UpdateUtils.getViewersList());
ViewData["paction"] = reviews.getSinglePALib(PALibID);
ViewData["PALib"] = PALibID;
ViewData["ReviewID"] = ReviewID;
ViewData["concernlevel"] = reviews.getConcernForReview(ReviewID.Value);
return View();
}
catch
{
return null;
}
}
public void testgetAllReviews()
{
ITaxonRepository Taxon = new TaxonRepository();
IGenericRepository gen = new GenericRepository();
// ViewData["Review"] = Taxon.getAllReviews();
IList<ReviewDesc> reviews = Taxon.getAllReviews();
int count = reviews.Count;
if (count > 0)
{
for(int i=0;i<count;i++)
{
reviews[i].TaxonName = Taxon.getReviewTaxonName(reviews[i].ID, reviews[i].Taxontype, reviews[i].Kingdom);
}
}
//ReviewDesc r = reviews[0];
Assert.AreEqual( reviews[0].TaxonName, "test");
//Assert.AreEqual(count,0);
}
public ActionResult ParagraphDetailsEdit(int ReviewID, int PALibID)
{
try
{
ITaxonRepository taxon = new TaxonRepository();
IReviewRepository reviews = new ReviewRepository();
IGenericRepository generic = new GenericRepository();
IMeetingLibRepository mlib = new MeetingLibRepository();
IMembershipRepository members = new MembershipRepository();
ICommentsRepository comments = new CommentsRepository();
IDocumentsRepository docs = new DocumentsRepository();
IRecommendationsRepository recs = new RecommendationsRepository();
IDecisionsRepository decisions = new DecisionsRepository();
var review = reviews.getSingleReview(ReviewID);
review.TaxonName = taxon.getReviewTaxonName(review.ID, review.Taxontype, review.Kingdom);
List<Actor> userDetails = GetUserDetails();
ViewData["allactorsadd"] = new SelectList(userDetails,"UserName","UserDetails");
ViewData["selectedactorsedit"] =
ViewData["allactorsedit"] =
ViewData["selectedactorsadd"] = ViewData["allactors2"] = ViewData["allactorsadd"];
ViewData["PATitle"] = review.TaxonName + " [" + review.CtyShort + "]";
ViewData["MeetingsA"] = ViewData["DecMeetings"] = ViewData["LiftedMeetings"] = new SelectList(generic.getAllMeetingsSelect(), "ID", "Description");
// ViewData["Roles"] = new SelectList(members.getAllRoles());
ViewData["roles"] = new SelectList(UpdateUtils.getViewersList());
ViewData["PALib"] = reviews.getSinglePALib(PALibID);
//GETTING THE PACTIONLIB TO RETRIEVE RECOMMENDATIONS/DECISIONS VALUES
ParagraphActionLib palib = generic.getPActionLib(PALibID);
ViewData["NeedsRecommendation"] = palib.Recommendations;
ViewData["NeedsDecision"] = palib.Decisions;
ViewData["NeedsConcern"] = palib.ConcernVisible;
//END GETTING RECOMMENDATIONS/DECISIONS
ViewData["ReviewID"] = ReviewID;
ParagraphActionDetails pad = reviews.getParagraphDetails(PALibID, ReviewID);
ViewData["Meetings"] = new SelectList(generic.getAllMeetingsSelect(), "ID", "Description",
pad.MeetingID);
ViewData["DateStarted"] = pad.DateStarted.ToShortDateString();
ViewData["Deadline"] = pad.Deadline.ToShortDateString();
ViewData["concerns"] = new SelectList(generic.getAllLevelofConcerns(), "Description", "Description");
// ViewData["concernlevel"]= reviews.getConcernForReview(ReviewID);
ViewData["concernlevel"] = generic.getConcernForParagraphAction(pad.ID);
ViewData["contributor"] = null;
if (pad != null)
{
if (Request.IsAuthenticated)
{
var user = UpdateUtils.getCurrentMembershipUser();
var roles = Roles.GetRolesForUser();
if (roles.Contains(UpdateUtils.ROLE_DATA_CONTRIBUTOR))
{
ViewData["contributor"] = User.Identity.Name;
}
if (roles.Contains(UpdateUtils.ROLE_INTERMEDIATE_VIEWER))
{
ViewData["Comments"] = comments.getCommentsByID(pad.ID, UpdateUtils.PARAGRAPH_SOURCE,UpdateUtils.ROLE_INTERMEDIATE_VIEWER );
ViewData["Documents"] = docs.getDocumentsByID(pad.ID, UpdateUtils.PARAGRAPH_SOURCE, UpdateUtils.ROLE_INTERMEDIATE_VIEWER);
//ViewData["Documents"] = ViewData["Documents"] + docs.getDocumentsByID(pad.ID, UpdateUtils.PARAGRAPH_SOURCE, UpdateUtils.ROLE_PUBLIC_VIEWER);
}
if (roles.Contains(UpdateUtils.ROLE_FULL_VIEWER))
{
ViewData["Comments"] = comments.getCommentsByID(pad.ID, UpdateUtils.PARAGRAPH_SOURCE, UpdateUtils.ROLE_ALL);
ViewData["Documents"] = docs.getDocumentsByID(pad.ID, UpdateUtils.PARAGRAPH_SOURCE, UpdateUtils.ROLE_ALL);
}
}
else
{
ViewData["Comments"] = comments.getCommentsByID(pad.ID, UpdateUtils.PARAGRAPH_SOURCE, UpdateUtils.ROLE_PUBLIC_VIEWER );
ViewData["Documents"] = docs.getDocumentsByID(pad.ID, UpdateUtils.PARAGRAPH_SOURCE, UpdateUtils.ROLE_PUBLIC_VIEWER);
}
IList<UsersParagraphLink> users = generic.getUserBySource(pad.ID, UpdateUtils.PARAGRAPH_SOURCE);
int usercount = users.Count;
for (int j = 0; j < usercount; j++)
{
users[j].UserID = Membership.GetUser(new Guid(users[j].UserID)).UserName;
if (User.Identity.IsAuthenticated)
{
var current_user = User.Identity.Name;
if (users[j].UserID == current_user)
{
ViewData["contributor"] = current_user;
}
}
}
ViewData["PActionID"] = pad.ID;
ViewData["ReviewID"] = ReviewID;
ViewData["PALibID"] = PALibID;
ViewData["recommendations"] = recs.getAllRecommendationsByParagraph(pad.ID);
ViewData["editmode"] = false;
//ViewData["decisions"] = decisions.GetAllDecisionsPerParagraph(pad.ID);
IList<Decision> decs = decisions.GetAllDecisionsPerParagraph(pad.ID);
ViewData["decisiondetails"] = UpdateUtils.GetDecisionDetails(decs);
ViewData["decisions"] = decs;
ViewData["decisiontypes"] = new SelectList(generic.GetAllDecisionTypes(), "Description",
"Description");
ViewData["tradeterms"] = new SelectList(generic.GetAllTradeTerms(), "Description",
"Description");
ViewData["selectedactorsedit"] =
new SelectList(users, "UserID", "UserID");
}
ViewData["PADetails"] = pad;
return View();
}
catch (Exception e)
{
return null;
}
}
