public ActionResult delete(int id)
{
IMeetingLibRepository MeetingLibRep = new MeetingLibRepository();
MeetingLib ml = new MeetingLib();
//GET MEETING
try
{
ml = MeetingLibRep.getMeetingLibByID(id);
}
catch (Exception exception)
{
//IF THERE IS A MESS UP, RETURN ERROR TO FRONT
TempData["flash"] = "Unable to retrieve meeting: " + exception.Message;
return RedirectToAction("Index");
}
//DELETE MEETING
try
{
MeetingLibRep.Delete(ml);
TempData["flash"] = "Deleted meeting.";
return RedirectToAction("Index");
}
catch (Exception exception)
{
TempData["flash"] = "Unable to delete meeting: " + exception.Message;
return RedirectToAction("Index");
}
}
public void Delete_MeetingLib()
{
IMeetingLibRepository MeetingLibRep = new MeetingLibRepository();
MeetingLib m = MeetingLibRep.getMeetingLibByID(2);
MeetingLibRep.Delete(m);
m = MeetingLibRep.getMeetingLibByID(2);
Assert.IsTrue(m.Deleted == true);
}
public static void UpdateMeetingLib(MeetingLib m, FormCollection collection)
{
IMeetingLibRepository MeetingLibRep = new MeetingLibRepository();
m.MeetingLibDesc = collection["MeetingLibDesc"];
m.MeetingLibNumber = collection["MeetingLibNumber"];
m.MeetingLibDate = DateTime.Parse(collection["meeting_date"]);
m.DateModified = DateTime.Now;
MeetingLibRep.Save(m);
return;
}
public void Adding_MeetingLib()
{
IMeetingLibRepository MeetingLibRep = new MeetingLibRepository();
MeetingLib m = new MeetingLib();
IList<SelectItems> allItems = new List<SelectItems>();
allItems.ToPagedList(0, 10);
m.MeetingLibDesc = "Plants";
m.MeetingLibNumber = "PL01";
m.MeetingLibDate = DateTime.Parse("02/02/2009");
m.DateAdded = DateTime.Now;
m.DateModified = DateTime.Now;
int saved = MeetingLibRep.Save(m);
Assert.AreEqual(saved, 3);
}
public void MeetingLibs_Get_By_ID()
{
IMeetingLibRepository MeetingLibRep = new MeetingLibRepository();
MeetingLib m = MeetingLibRep.getMeetingLibByID(1);
Assert.AreEqual(m.MeetingLibDesc,"Animal");
}
public void Update_Meeting_Lib()
{
IMeetingLibRepository MeetingLibRep = new MeetingLibRepository();
MeetingLib m = MeetingLibRep.getMeetingLibByID(2);
FormCollection form = new FormCollection();
form["MeetingLibNumber"] = "x";
form["MeetingLibDesc"] = "xy";
form["MeetingLibDate"] = "01/01/2009";
m.MeetingLibDesc = form["MeetingLibDesc"];
m.MeetingLibNumber = form["MeetingLibNumber"];
m.MeetingLibDate = DateTime.Parse(form["MeetingLibDate"]);
MeetingLibRep.Save(m);
Assert.AreEqual(MeetingLibRep.Save(m),0);
}
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");
}
public void Modify_MeetingLib()
{
IMeetingLibRepository MeetingLibRep = new MeetingLibRepository();
MeetingLib m = MeetingLibRep.getMeetingLibByID(2);
m.MeetingLibDesc = "PLants Committee";
m.DateModified = DateTime.Now;
int saved = MeetingLibRep.Save(m);
Assert.AreEqual(saved, 1);
}
public static void UpdateMeetingLib(MeetingLib m, FormCollection collection)
{
IMeetingLibRepository MeetingLibRep = new MeetingLibRepository();
m.MeetingLibDesc = collection["MeetingLibDesc"];
m.MeetingLibNumber = collection["MeetingLibNumber"];
m.MeetingLibDate = DateTime.Parse(collection["meeting_date"]);
m.DateModified = DateTime.Now;
MeetingLibRep.Save(m);
return;
}
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;
}
}
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 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 ActionResult Edit(int id)
{
IMeetingLibRepository MeetingLibRep = new MeetingLibRepository();
MeetingLib m = MeetingLibRep.getMeetingLibByID(id);
ViewData.Model = m;
return View();
}
public ActionResult Index()
{
IMeetingLibRepository MeetingLibRep = new MeetingLibRepository();
ViewData.Model = MeetingLibRep.getAllMeetingLibs();
return View();
}
public ActionResult Edit(int id, FormCollection collection)
{
try
{
// TODO: Add update logic here
IMeetingLibRepository MeetingLibRep = new MeetingLibRepository();
MeetingLib m = MeetingLibRep.getMeetingLibByID(id);
m.MeetingLibDesc = collection["meeting_description"];
m.MeetingLibNumber = collection["meeting_number"];
m.MeetingLibDate = DateTime.Parse(collection["meeting_date"]);
m.DateModified = DateTime.Now;
MeetingLibRep.Save(m);
return RedirectToAction("Index");
}
catch (SubSonic.SqlQueryException e)
{
Console.WriteLine("{0} Exception caught.", e.Message);
IMeetingLibRepository MeetingLibRep = new MeetingLibRepository();
MeetingLib m = MeetingLibRep.getMeetingLibByID(id);
ViewData.Model = m;
return View();
}
}
