public bool createOrgCategory(string categoryName, string description, string addDate, string endDate, bool greekOrg)
{
dataContext.sp_NewOrgCategory(categoryName, description, addDate, endDate, greekOrg);
try
{
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool createMemberType(string memberName, string description, string addDate, string endDate, bool boardMember)
{
dataContext.sp_NewMemberType(memberName, description, addDate, endDate, boardMember);
try
{
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool createAdvisor(string lastName, string firstName, string emailID, string phoneNO, bool offCampus, string advisorTitle, string professionalTitle)
{
dataContext.sp_NewAdvisor(lastName, firstName, emailID, phoneNO, offCampus, advisorTitle, professionalTitle);
try
{
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool createUser(string lastName, string firstName, string password, string userID, bool isActive, int roleID, string phone, string email)
{
try
{
dataContext.sp_NewUser(lastName, firstName, password, userID, isActive, roleID, phone, email);
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool createRequiredEvent(string reqName, string reqDescription, string addDate)
{
dataContext.sp_NewRequiredEvent(reqName, reqDescription, addDate);
try
{
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool createEvent(int orgID, string date, string time, string location, string description, string orgworkedwith, string contactPhone, string contactEmail, string attendence,
string hoursVolunteered, string dollarsSpent, string title, bool eventType, bool onOffCampus, string vanRental, string busRental, string contactName,
string driver1, string driver2, string CommentText, string CommentDate, string userName, string dollarSpentByPartner, int room_reserved, int event_marketing,
int event_catering, int signup_form, int activity_waiver, int cu_night)
{
try
{
bool roomreserved = false, marketing = false, catering = false, signupform = false, activitywaiver = false, cunight = false;
if (room_reserved == 1)
{
roomreserved = true;
}
if (event_marketing == 1)
{
marketing = true;
}
if (event_catering == 1)
{
catering = true;
}
if (signup_form == 1)
{
signupform = true;
}
if (activity_waiver == 1)
{
activitywaiver = true;
}
if (cu_night == 1)
{
cunight = true;
}
dataContext.sp_NewOrgEvent(orgID, date, time, location, description, orgworkedwith, contactPhone, contactEmail, attendence,
hoursVolunteered, dollarsSpent, dollarSpentByPartner, title, eventType, onOffCampus, vanRental, busRental, contactName,
driver1, driver2, CommentText, CommentDate, userName, roomreserved, marketing, catering, signupform, activitywaiver, cunight);
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool createServiceProject(int orgID, string CP, string CPCName, string CPCPhone, string CPCEmail, string noOfVolunteers, string hoursVolunteered,
string description, bool onGoing, string location, string startDate, string endDate, string timeFrom, string timeTo,
string CommentText, string CommentDate, string userName, string meetDay, string meetFrequency, string title, string funds,
int planned_vols, decimal planned_hrs, string planned_funds)
{
try
{
dataContext.sp_NewServiceProject(orgID, CP, CPCName, CPCPhone, CPCEmail, noOfVolunteers, hoursVolunteered, description, onGoing, location, startDate,
endDate, timeFrom, timeTo, CommentText, CommentDate, userName, meetDay, meetFrequency, title, funds,
planned_vols, planned_hrs, planned_funds);
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool updateStudent(int stuID, bool certDriver, bool apprDriver, bool greekGPA)
{
dataContext.sp_UpdateStudent(stuID, certDriver, apprDriver, greekGPA);
try
{
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool createIncident(string date, string dateReported, string time, string location, string incident, string result, string notes, string followUp, int orgID, string reportedBy, List <MemberList> memberList, string commentText, string commentDate, string userName, List <NonMemberList> nonMemberList)
{
int?incidentID = 0;
//bool incidentInserted = true;
try
{
dataContext.sp_NewIncident(date, dateReported, time, location, incident, result, notes, followUp, orgID, reportedBy, commentText, commentDate, ref incidentID, userName);
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
for (int i = 0; i < memberList.Count; ++i)
{
try
{
dataContext.sp_NewPeopleInvoluved(Convert.ToInt32(memberList[i].Student_ID), incidentID);
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
}
for (int i = 0; i < nonMemberList.Count; ++i)
{
try
{
dataContext.sp_NewNonMembersInvoluved(nonMemberList[i].ID, nonMemberList[i].Name, incidentID);
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
}
return(true);
}
public bool CreateOrganization(string orgName, string orgDecscription, string orgMeetTime, string orgMeetDate, string orgMeetBuilding, string orgMeetRoom,
string dateProposed, string dateaccepted, string dateDenied, string proposalNotes, string dateSubmitted, string dateAccepted, string constitutionNotes,
string dateRegApproval, string cxCode, int catID, bool reqmet, string regMetDate, string commentText, int statusID, string commentDate, string statusStartDate,
string statusEndDate, string userName, string meetFrequency, string OAcct, string ProjCode)
{
try
{
dataContext.sp_NewOrganization(orgName, orgDecscription, orgMeetTime, orgMeetDate,
orgMeetBuilding, orgMeetRoom, dateProposed, dateaccepted,
dateDenied, proposalNotes, dateSubmitted, dateAccepted,
constitutionNotes, dateRegApproval, cxCode, catID, reqmet,
regMetDate, commentText, statusID, commentDate, statusStartDate,
statusEndDate, userName, meetFrequency, OAcct, ProjCode);
dataContext.SubmitChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public void UpdateOrgAdvisor(int organizationID, int advisorID, DateTime startDate, DateTime endDate, string proffesionalTitle, string advisorTitle)
{
dataContext.sp_NewOrgAdvisor(organizationID, advisorID, startDate, endDate, proffesionalTitle, advisorTitle);
dataContext.SubmitChanges();
}