public bool updateOrganizationMainPage(int orgID, string orgName, string description, string meetTime, string meetDay, string meetbuilding, string meetRoom, string cxCode, int categoryID,
bool requirementsMet, string requirementsMetDate, string registarApprovalDate, int statusID, List <AdvisorList> newAdvisorList, string meetFrequency,
string OAcct, string ProjCode)
{
try
{
dataContext.sp_UpdateOrganizationMainPage(orgID, orgName, description, meetTime, meetDay, meetbuilding, meetRoom,
cxCode, categoryID, requirementsMet, requirementsMetDate, registarApprovalDate, statusID, meetFrequency,
OAcct, ProjCode);
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
List <AdvisorList> oldAdvisorList = new List <AdvisorList>();
var advis = dataContext.sp_GetAdvisorList();
foreach (var x in advis)
{
AdvisorList advisor = new AdvisorList();
advisor.AdvisorID = x.Advisor_ID;
advisor.LastName = x.LastName;
advisor.FirstName = x.FirstName;
advisor.Name = x.FirstName + " " + x.LastName;
oldAdvisorList.Add(advisor);
}
for (int i = 0; i < oldAdvisorList.Count; ++i)
{
for (int j = 0; j < newAdvisorList.Count; ++j)
{
if (oldAdvisorList[i].AdvisorID == newAdvisorList[j].AdvisorID)
{
oldAdvisorList[i].FirstName = "Please Delete";
}
}
}
for (int i = 0; i < oldAdvisorList.Count; ++i)
{
if (oldAdvisorList[i].FirstName != "Please Delete")
{
dataContext.sp_UpdateOrgAdvisorRow(oldAdvisorList[i].AdvisorID, orgID);
}
}
for (int i = 0; i < newAdvisorList.Count; ++i)
{
dataContext.sp_NewOrgAdvisorRow(orgID, newAdvisorList[i].AdvisorID);
}
return(true);
}
public IList getAdvisorList()
{
List <AdvisorList> advisors = new List <AdvisorList>();
var advis = dataContext.sp_GetAdvisorList();
foreach (var x in advis)
{
AdvisorList advisor = new AdvisorList();
advisor.AdvisorID = x.Advisor_ID;
advisor.LastName = x.LastName;
advisor.FirstName = x.FirstName;
advisor.Name = x.LastName + ", " + x.FirstName;
advisors.Add(advisor);
}
return(advisors);
}
public AdvisorList getAdvisorByAdvID(int advID)
{
AdvisorList advisor = new AdvisorList();
var adv = dataContext.sp_GetAdvisorByAdvID(advID).First();
advisor.AdvisorID = adv.Advisor_ID;
advisor.LastName = adv.LastName;
advisor.FirstName = adv.FirstName;
advisor.Name = adv.FirstName + " " + adv.LastName;
if (adv.offCampus == true)
{
advisor.Type = "Community";
}
else
{
advisor.Type = "Carroll";
}
return(advisor);
}
public List <AdvisorList> getAdvisorsForOrg(int orgID)
{
List <AdvisorList> advisors = new List <AdvisorList>();
var advis = dataContext.sp_GetAdvisorListForOrgID(orgID);
foreach (var x in advis)
{
AdvisorList advisor = new AdvisorList();
advisor.AdvisorID = x.Advisor_ID;
advisor.LastName = x.LastName;
advisor.FirstName = x.FirstName;
advisor.Name = x.FirstName + " " + x.LastName;
if (x.offCampus == true)
{
advisor.Type = "Community";
}
else
{
advisor.Type = "Carroll";
}
advisors.Add(advisor);
}
return(advisors);
}
