protected void btnDelete_Click(object sender, EventArgs e)
{
space_category_id = Convert.ToInt32(Request.QueryString["spaceCategoryID"]);
qSoc_SpaceCategory category = new qSoc_SpaceCategory(space_category_id);
category.Available = "No";
category.MarkAsDelete = 1;
category.Update();
Response.Redirect("group-types-list.aspx");
}
protected void btnSave_OnClick(object sender, System.EventArgs e)
{
Page.Validate("form");
if (Page.IsValid)
{
int user_id = Convert.ToInt32(Context.Items["UserID"]);
if (!String.IsNullOrEmpty(Request.QueryString["spaceCategoryID"]))
{
space_category_id = Convert.ToInt32(Request.QueryString["spaceCategoryID"]);
qSoc_SpaceCategory category = new qSoc_SpaceCategory(space_category_id);
category.CatgoryName = txtSpaceCategory.Text;
category.CategoryDescription = txtDescription.Text;
category.Available = rblAvailable.SelectedValue;
category.LastModified = DateTime.Now;
category.LastModifiedBy = user_id;
category.Update();
}
else
{
qSoc_SpaceCategory category = new qSoc_SpaceCategory();
category.ScopeID = 1;
category.Created = DateTime.Now;
category.CreatedBy = user_id;
category.LastModified = DateTime.Now;
category.LastModifiedBy = user_id;
category.Available = "Yes";
category.MarkAsDelete = 0;
category.CatgoryName = txtSpaceCategory.Text;
category.CategoryDescription = txtDescription.Text;
category.Available = rblAvailable.SelectedValue;
category.Insert();
space_category_id = category.SpaceCategoryID;
}
// redirect to page to add keyword + keywords
if (!String.IsNullOrEmpty(Request.QueryString["spaceCategoryID"]))
{
//lblMessage.Text = "*** Record Successfully Updated ***";
//lblMessageBottom.Text = "*** Record Successfully Updated ***";
Response.Redirect("group-types-list.aspx");
}
else
{
Response.Redirect(Request.Url.ToString() + "?mode=add-successful&spaceCategoryID=" + space_category_id);
//Response.Redirect("keywords-list.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(Request.QueryString["categoryID"]))
{
string cat_id = Request.QueryString["categoryID"];
siteSpaces.SelectCommand = "SELECT * FROM qSoc_Spaces_View WHERE SpaceType <> 'family' AND MarkAsDelete = 0 AND SpaceCategoryID = " + cat_id + " ORDER BY SpaceShortName ASC";
qSoc_SpaceCategory cat = new qSoc_SpaceCategory(Convert.ToInt32(cat_id));
lblTitle.Text = cat.CatgoryName + " Groups";
}
else
{
siteSpaces.SelectCommand = "SELECT * FROM qSoc_Spaces_View WHERE SpaceType <> 'family' AND MarkAsDelete = 0 ORDER BY SpaceShortName ASC";
lblTitle.Text = "All Groups";
}
if (!Page.IsPostBack)
{
startDate = null;
endDate = null;
var cats = qSoc_SpaceCategory.GetSpaceCategories();
string cat_options_html = string.Empty;
cat_options_html += "<li><a href=\"spaces-list.aspx\">All Groups</a></li>";
if (cats != null)
{
foreach (var c in cats)
{
cat_options_html += "<li><a href=\"spaces-list.aspx?categoryID=" + c.SpaceCategoryID + "\">" + c.CatgoryName + "</a></li>";
}
}
litGroupTypeOptions.Text = cat_options_html;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!String.IsNullOrEmpty(Request.QueryString["spaceCategoryID"]))
{
space_category_id = Convert.ToInt32(Request.QueryString["spaceCategoryID"]);
qSoc_SpaceCategory category = new qSoc_SpaceCategory(space_category_id);
lblTitle.Text = "Edit Group Type (ID: " + category.SpaceCategoryID + ")";
txtSpaceCategory.Text = category.CatgoryName;
txtDescription.Text = category.CategoryDescription;
rblAvailable.SelectedValue = category.Available;
}
else
{
lblTitle.Text = "New group type";
rblAvailable.SelectedValue = "Yes";
plhTools.Visible = false;
}
if (Convert.ToString(Request.QueryString["mode"]) == "add-successful")
{
lblMessage.Text = "*** Record Successfully Added ***";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
group_request_id = Convert.ToInt32(Request.QueryString["groupRequestID"]);
if (!String.IsNullOrEmpty(Convert.ToString(group_request_id)))
{
qOrg_GroupRequests request = new qOrg_GroupRequests(group_request_id);
populateSchools();
lblTitle.Text = "Edit Group Request (ID: " + request.GroupRequestID + ")";
lblRequestTimestamp.Text = Convert.ToString(request.Created);
string advisor_info = string.Empty;
advisor_info = "<span class=\"NormalBoldDarkGray\">Name:</span> " + request.AdvisorFirstName + " " + request.AdvisorLastName;
advisor_info += "<br><br><span class=\"NormalBoldDarkGray\">Position:</span> " + request.AdvisorPosition;
advisor_info += "<br><br><span class=\"NormalBoldDarkGray\">Other Position:</span> " + request.AdvisorPositionOther;
advisor_info += "<br><br><span class=\"NormalBoldDarkGray\">Email:</span> " + request.AdvisorEmail;
advisor_info += "<br><br><span class=\"NormalBoldDarkGray\">Phone:</span> " + request.AdvisorPhone;
litAdvisorInfo.Text = advisor_info;
string group_info = string.Empty;
group_info = "<span class=\"NormalBoldDarkGray\">Name:</span> " + request.GroupShortName;
qSoc_SpaceCategory category = new qSoc_SpaceCategory(Convert.ToInt32(request.SpaceCategoryID));
group_info += "<br><br><span class=\"NormalBoldDarkGray\">Type:</span> " + category.CatgoryName;
group_info += "<br><br><span class=\"NormalBoldDarkGray\">Other Type:</span> " + request.CategoryOther;
group_info += "<br><br><span class=\"NormalBoldDarkGray\">Description:</span> " + request.GroupDescriptionOther;
group_info += "<br><br><span class=\"NormalBoldDarkGray\">Why Join:</span> " + request.WhyJoin;
group_info += "<br><br><span class=\"NormalBoldDarkGray\">How Many Members:</span> " + request.NumNumbers;
group_info += "<br><br><span class=\"NormalBoldDarkGray\">When Founded:</span> " + request.WhenFounded;
litGroupInfo.Text = group_info;
string school_info = string.Empty;
school_info += "<br><br><span class=\"NormalBoldDarkGray\">School:</span> " + request.OtherSchool;
if (!String.IsNullOrEmpty(Convert.ToString(request.SchoolDistrictID)))
{
int school_district_id = request.SchoolDistrictID;
qOrg_SchoolDistrict district = new qOrg_SchoolDistrict(school_district_id);
school_info += "<br><br><span class=\"NormalBoldDarkGray\">District:</span> " + district.DistrictName;
}
else
{
school_info += "<br><br><span class=\"NormalBoldDarkGray\">District:</span> none";
}
school_info += "<br><br><span class=\"NormalBoldDarkGray\">Type:</span> " + request.SchoolType;
school_info += "<br><br><span class=\"NormalBoldDarkGray\">Address:</span><blockquote><span class=\"Normal\"> " + request.OtherSchoolAddress1 + ", " + request.OtherSchoolAddress2 + "<br>" + request.OtherSchoolCity + ", " + request.OtherSchoolStateProvince + " " + request.OtherSchoolPostalCode + "</span></blockquote>";
school_info += "<br><br><span class=\"NormalBoldDarkGray\">Phone:</span> " + request.OtherSchoolPhone;
litSchoolInfo.Text = school_info;
string principal_info = string.Empty;
principal_info = "<span class=\"NormalBoldDarkGray\">Name:</span> " + request.PrincipalFirstName + " " + request.PrincipalLastName;
principal_info += "<br><br><span class=\"NormalBoldDarkGray\">Position:</span> " + request.PrincipalRole;
principal_info += "<br><br><span class=\"NormalBoldDarkGray\">Email:</span> " + request.PrincipalEmail;
principal_info += "<br><br><span class=\"NormalBoldDarkGray\">Phone:</span> " + request.PrincipalPhone;
litPrincipalInfo.Text = principal_info;
txtAdvisorEmail.Text = request.AdvisorEmail;
txtGroupName.Text = request.GroupShortName;
txtPrincipalEmail.Text = request.PrincipalEmail;
txtAdvisorNotes.Text = request.AdvisorNotes;
txtGroupNotes.Text = request.GroupNotes;
txtSchoolNotes.Text = request.SchoolNotes;
txtPrincipalNotes.Text = request.PrincipalNotes;
ddlStatus.SelectedValue = request.Status;
if (!String.IsNullOrEmpty(Convert.ToString(request.SchoolID)))
if (request.SchoolID > 0)
ddlSchools.SelectedValue = Convert.ToString(request.SchoolID);
else
{
btnApproveRequest.Enabled = false;
lblApprovalInfo.Text = "<br><br><strong>*** WARNING: This request does NOT have a school associated with it yet. A school must be selected from the pull down in the School Info section below. ***</strong>";
}
else
{
btnApproveRequest.Enabled = false;
lblApprovalInfo.Text = "<br><br><strong>*** WARNING: This request does NOT have a school associated with it yet. A school must be selected from the pull down in the School Info section below. ***</strong>";
}
if (!String.IsNullOrEmpty(request.ApprovedBy))
{
btnApproveRequest.Visible = true;
lblApprovalInfo.Text = "Approved by " + request.ApprovedBy + " and email last sent at " + request.WhenApproved;
}
else
btnApproveRequest.Visible = true;
if (request.Status == "Completed")
lblPrincipalApprval.Text = "Request APPROVED by " + request.PrincipalInitials + " at " + request.PrincipalWhenApproved;
else if (request.Status == "Rejected-Principal")
lblPrincipalApprval.Text = "Request DENIED by " + request.PrincipalInitials + " at " + request.PrincipalWhenApproved;
}
else
{
lblTitle.Text = "A Problem Has Occurred: Please go back and try again";
}
}
}
