protected void DvItemCommand(object sender, DetailsViewCommandEventArgs e) { string returnURL = "~/ControlRoom/Modules/Reports/ReportList.aspx"; if (e.CommandName.ToLower() == "back") { Response.Redirect(returnURL); } if (e.CommandName.ToLower() == "refresh") { try { odsData.DataBind(); dv.DataBind(); dv.ChangeMode(DetailsViewMode.Edit); var masterPage = (IControlRoomMaster)Master; if (masterPage != null) masterPage.PageMessage = SRPResources.RefreshOK; } catch (Exception ex) { var masterPage = (IControlRoomMaster)Master; masterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message); } } #region Save report if (e.CommandName.ToLower() == "savereport") { if (lblPK.Text == "") { try { //ADD var obj = new SRPReport(); obj.RTID = FormatHelper.SafeToInt( ((DropDownList)((DetailsView)sender).FindControl("RTID")).SelectedValue); obj.ProgId = FormatHelper.SafeToInt( ((DropDownList)((DetailsView)sender).FindControl("ProgId")).SelectedValue); obj.ReportName = ((TextBox)((DetailsView)sender).FindControl("ReportName")).Text; obj.DisplayFilters = ((CheckBox)((DetailsView)sender).FindControl("DisplayFilters")).Checked; obj.ReportFormat = FormatHelper.SafeToInt( ((DropDownList)((DetailsView)sender).FindControl("ReportFormat")).SelectedValue); obj.DOBFrom = FormatHelper.SafeToDateTime(((TextBox)((DetailsView)sender).FindControl("DOBFrom")).Text); obj.DOBTo = FormatHelper.SafeToDateTime(((TextBox)((DetailsView)sender).FindControl("DOBTo")).Text); obj.AgeFrom = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("AgeFrom")).Text); obj.AgeTo = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("AgeTo")).Text); obj.SchoolGrade = ((TextBox)((DetailsView)sender).FindControl("SchoolGrade")).Text; obj.FirstName = ((TextBox)((DetailsView)sender).FindControl("FirstName")).Text; obj.LastName = ((TextBox)((DetailsView)sender).FindControl("LastName")).Text; obj.Gender = ((DropDownList)((DetailsView)sender).FindControl("Gender")).SelectedValue; obj.EmailAddress = ((TextBox)((DetailsView)sender).FindControl("EmailAddress")).Text; obj.PhoneNumber = ((TextBox)((DetailsView)sender).FindControl("PhoneNumber")).Text; obj.City = ((TextBox)((DetailsView)sender).FindControl("City")).Text; obj.State = ((TextBox)((DetailsView)sender).FindControl("State")).Text; obj.ZipCode = ((TextBox)((DetailsView)sender).FindControl("ZipCode")).Text; obj.County = ((TextBox)((DetailsView)sender).FindControl("County")).Text; obj.PrimaryLibrary = FormatHelper.SafeToInt( ((DropDownList)((DetailsView)sender).FindControl("PrimaryLibrary")).SelectedValue); obj.SchoolName = ((DropDownList)((DetailsView)sender).FindControl("SchoolName")).SelectedValue; obj.District = ((DropDownList)((DetailsView)sender).FindControl("District")).SelectedValue; obj.SDistrict = ((DropDownList)((DetailsView)sender).FindControl("SDistrict")).SelectedValue; obj.Teacher = ((TextBox)((DetailsView)sender).FindControl("Teacher")).Text; obj.GroupTeamName = ((TextBox)((DetailsView)sender).FindControl("GroupTeamName")).Text; obj.SchoolType = FormatHelper.SafeToInt( ((DropDownList)((DetailsView)sender).FindControl("SchoolType")).SelectedValue); obj.LiteracyLevel1 = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("LiteracyLevel1")).Text); obj.LiteracyLevel2 = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("LiteracyLevel2")).Text); obj.Custom1 = ((TextBox)((DetailsView)sender).FindControl("Custom1")).Text; obj.Custom2 = ((TextBox)((DetailsView)sender).FindControl("Custom2")).Text; obj.Custom3 = ((TextBox)((DetailsView)sender).FindControl("Custom3")).Text; obj.Custom4 = ((TextBox)((DetailsView)sender).FindControl("Custom4")).Text; obj.Custom5 = ((TextBox)((DetailsView)sender).FindControl("Custom5")).Text; obj.RegistrationDateStart = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("RegistrationDateStart")).Text); obj.RegistrationDateEnd = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("RegistrationDateEnd")).Text); obj.PointsMin = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("PointsMin")).Text); obj.PointsMax = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("PointsMax")).Text); obj.PointsStart = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("PointsStart")).Text); obj.PointsEnd = FormatHelper.SafeToDateTime(((TextBox)((DetailsView)sender).FindControl("PointsEnd")).Text); obj.EventCode = ((TextBox)((DetailsView)sender).FindControl("EventCode")).Text; obj.EarnedBadge = FormatHelper.SafeToInt( ((DropDownList)((DetailsView)sender).FindControl("EarnedBadge")).SelectedValue); obj.PhysicalPrizeEarned = ((TextBox)((DetailsView)sender).FindControl("PhysicalPrizeEarned")).Text; obj.PhysicalPrizeRedeemed = ((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeRedeemed")).Checked; obj.PhysicalPrizeStartDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("PhysicalPrizeStartDate")).Text); obj.PhysicalPrizeEndDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("PhysicalPrizeEndDate")).Text); obj.ReviewsMin = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("ReviewsMin")).Text); obj.ReviewsMax = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("ReviewsMax")).Text); obj.ReviewTitle = ((TextBox)((DetailsView)sender).FindControl("ReviewTitle")).Text; obj.ReviewAuthor = ((TextBox)((DetailsView)sender).FindControl("ReviewAuthor")).Text; obj.ReviewStartDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("ReviewStartDate")).Text); obj.ReviewEndDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("ReviewEndDate")).Text); obj.RandomDrawingName = ((TextBox)((DetailsView)sender).FindControl("RandomDrawingName")).Text; obj.RandomDrawingNum = FormatHelper.SafeToInt( ((TextBox)((DetailsView)sender).FindControl("RandomDrawingNum")).Text); obj.RandomDrawingStartDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("RandomDrawingStartDate")).Text); obj.RandomDrawingEndDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("RandomDrawingEndDate")).Text); obj.HasBeenDrawn = ((CheckBox)((DetailsView)sender).FindControl("HasBeenDrawn")).Checked; obj.HasRedeemend = ((CheckBox)((DetailsView)sender).FindControl("HasRedeemend")).Checked; obj.PIDInc = ((CheckBox)((DetailsView)sender).FindControl("PIDInc")).Checked; obj.UsernameInc = ((CheckBox)((DetailsView)sender).FindControl("UsernameInc")).Checked; obj.DOBInc = ((CheckBox)((DetailsView)sender).FindControl("DOBInc")).Checked; obj.AgeInc = ((CheckBox)((DetailsView)sender).FindControl("AgeInc")).Checked; obj.SchoolGradeInc = ((CheckBox)((DetailsView)sender).FindControl("SchoolGradeInc")).Checked; obj.FirstNameInc = ((CheckBox)((DetailsView)sender).FindControl("FirstNameInc")).Checked; obj.LastNameInc = ((CheckBox)((DetailsView)sender).FindControl("LastNameInc")).Checked; obj.GenderInc = ((CheckBox)((DetailsView)sender).FindControl("GenderInc")).Checked; obj.EmailAddressInc = ((CheckBox)((DetailsView)sender).FindControl("EmailAddressInc")).Checked; obj.PhoneNumberInc = ((CheckBox)((DetailsView)sender).FindControl("PhoneNumberInc")).Checked; obj.CityInc = ((CheckBox)((DetailsView)sender).FindControl("CityInc")).Checked; obj.StateInc = ((CheckBox)((DetailsView)sender).FindControl("StateInc")).Checked; obj.ZipCodeInc = ((CheckBox)((DetailsView)sender).FindControl("ZipCodeInc")).Checked; obj.CountyInc = ((CheckBox)((DetailsView)sender).FindControl("CountyInc")).Checked; obj.PrimaryLibraryInc = ((CheckBox)((DetailsView)sender).FindControl("PrimaryLibraryInc")).Checked; obj.SchoolNameInc = ((CheckBox)((DetailsView)sender).FindControl("SchoolNameInc")).Checked; obj.DistrictInc = ((CheckBox)((DetailsView)sender).FindControl("DistrictInc")).Checked; obj.TeacherInc = ((CheckBox)((DetailsView)sender).FindControl("TeacherInc")).Checked; obj.GroupTeamNameInc = ((CheckBox)((DetailsView)sender).FindControl("GroupTeamNameInc")).Checked; obj.SchoolTypeInc = ((CheckBox)((DetailsView)sender).FindControl("SchoolTypeInc")).Checked; obj.LiteracyLevel1Inc = ((CheckBox)((DetailsView)sender).FindControl("LiteracyLevel1Inc")).Checked; obj.LiteracyLevel2Inc = ((CheckBox)((DetailsView)sender).FindControl("LiteracyLevel2Inc")).Checked; obj.Custom1Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom1Inc")).Checked; obj.Custom2Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom2Inc")).Checked; obj.Custom3Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom3Inc")).Checked; obj.Custom4Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom4Inc")).Checked; obj.Custom5Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom5Inc")).Checked; obj.RegistrationDateInc = ((CheckBox)((DetailsView)sender).FindControl("RegistrationDateInc")).Checked; obj.PointsInc = ((CheckBox)((DetailsView)sender).FindControl("PointsInc")).Checked; obj.EarnedBadgeInc = ((CheckBox)((DetailsView)sender).FindControl("EarnedBadgeInc")).Checked; obj.PhysicalPrizeNameInc = ((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeNameInc")).Checked; obj.PhysicalPrizeDateInc = ((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeDateInc")).Checked; obj.NumReviewsInc = ((CheckBox)((DetailsView)sender).FindControl("NumReviewsInc")).Checked; obj.ReviewAuthorInc = ((CheckBox)((DetailsView)sender).FindControl("ReviewAuthorInc")).Checked; obj.ReviewTitleInc = ((CheckBox)((DetailsView)sender).FindControl("ReviewTitleInc")).Checked; obj.ReviewDateInc = ((CheckBox)((DetailsView)sender).FindControl("ReviewDateInc")).Checked; obj.RandomDrawingNameInc = ((CheckBox)((DetailsView)sender).FindControl("RandomDrawingNameInc")).Checked; obj.RandomDrawingNumInc = ((CheckBox)((DetailsView)sender).FindControl("RandomDrawingNumInc")).Checked; obj.RandomDrawingDateInc = ((CheckBox)((DetailsView)sender).FindControl("RandomDrawingDateInc")).Checked; obj.HasBeenDrawnInc = ((CheckBox)((DetailsView)sender).FindControl("HasBeenDrawnInc")).Checked; obj.HasRedeemendInc = ((CheckBox)((DetailsView)sender).FindControl("HasRedeemendInc")).Checked; obj.Score1From = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score1From")).Text); obj.Score1To = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score1To")).Text); obj.Score2From = FormatHelper.SafeToInt( ((TextBox)((DetailsView)sender).FindControl("Score2From")).Text); obj.Score2To = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score2To")).Text); obj.Score1PctFrom = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score1PctFrom")).Text); obj.Score1PctTo = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score1PctTo")).Text); obj.Score2PctFrom = FormatHelper.SafeToInt( ((TextBox)((DetailsView)sender).FindControl("Score2PctFrom")).Text); obj.Score2PctTo = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score2PctTo")).Text); obj.Score1Inc = ((CheckBox)((DetailsView)sender).FindControl("Score1Inc")).Checked; obj.Score2Inc = ((CheckBox)((DetailsView)sender).FindControl("Score2Inc")).Checked; obj.Score1PctInc = ((CheckBox)((DetailsView)sender).FindControl("Score1PctInc")).Checked; obj.Score2PctInc = ((CheckBox)((DetailsView)sender).FindControl("Score2PctInc")).Checked; obj.AddedDate = DateTime.Now; obj.AddedUser = ((SRPUser)Session[SessionData.UserProfile.ToString()]).Username; //"N/A"; // Get from session obj.LastModDate = obj.AddedDate; obj.LastModUser = obj.AddedUser; if (obj.IsValid(BusinessRulesValidationMode.INSERT)) { obj.Insert(); lblPK.Text = obj.RID.ToString(); odsData.DataBind(); dv.DataBind(); dv.ChangeMode(DetailsViewMode.Edit); var masterPage = (IControlRoomMaster)Master; masterPage.PageMessage = SRPResources.AddedOK; } else { var masterPage = (IControlRoomMaster)Master; string message = String.Format(SRPResources.ApplicationError1, "<ul>"); foreach (BusinessRulesValidationMessage m in obj.ErrorCodes) { message = string.Format(String.Format("{0}<li>{{0}}</li>", message), m.ErrorMessage); } message = string.Format("{0}</ul>", message); masterPage.PageError = message; } } catch (Exception ex) { var masterPage = (IControlRoomMaster)Master; masterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message); } } else { try { var obj = new SRPReport(); int pk = int.Parse(lblPK.Text); obj.Fetch(pk); obj.RTID = FormatHelper.SafeToInt(((DropDownList)((DetailsView)sender).FindControl("RTID")).SelectedValue); obj.ProgId = FormatHelper.SafeToInt(((DropDownList)((DetailsView)sender).FindControl("ProgId")).SelectedValue); obj.ReportName = ((TextBox)((DetailsView)sender).FindControl("ReportName")).Text; obj.DisplayFilters = ((CheckBox)((DetailsView)sender).FindControl("DisplayFilters")).Checked; obj.ReportFormat = FormatHelper.SafeToInt(((DropDownList)((DetailsView)sender).FindControl("ReportFormat")).SelectedValue); obj.DOBFrom = FormatHelper.SafeToDateTime(((TextBox)((DetailsView)sender).FindControl("DOBFrom")).Text); obj.DOBTo = FormatHelper.SafeToDateTime(((TextBox)((DetailsView)sender).FindControl("DOBTo")).Text); obj.AgeFrom = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("AgeFrom")).Text); obj.AgeTo = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("AgeTo")).Text); obj.SchoolGrade = ((TextBox)((DetailsView)sender).FindControl("SchoolGrade")).Text; obj.FirstName = ((TextBox)((DetailsView)sender).FindControl("FirstName")).Text; obj.LastName = ((TextBox)((DetailsView)sender).FindControl("LastName")).Text; obj.Gender = ((DropDownList)((DetailsView)sender).FindControl("Gender")).SelectedValue; obj.EmailAddress = ((TextBox)((DetailsView)sender).FindControl("EmailAddress")).Text; obj.PhoneNumber = ((TextBox)((DetailsView)sender).FindControl("PhoneNumber")).Text; obj.City = ((TextBox)((DetailsView)sender).FindControl("City")).Text; obj.State = ((TextBox)((DetailsView)sender).FindControl("State")).Text; obj.ZipCode = ((TextBox)((DetailsView)sender).FindControl("ZipCode")).Text; obj.County = ((TextBox)((DetailsView)sender).FindControl("County")).Text; obj.PrimaryLibrary = FormatHelper.SafeToInt(((DropDownList)((DetailsView)sender).FindControl("PrimaryLibrary")).SelectedValue); obj.SchoolName = ((DropDownList)((DetailsView)sender).FindControl("SchoolName")).SelectedValue; obj.District = ((DropDownList)((DetailsView)sender).FindControl("District")).SelectedValue; obj.SDistrict = ((DropDownList)((DetailsView)sender).FindControl("SDistrict")).SelectedValue; obj.Teacher = ((TextBox)((DetailsView)sender).FindControl("Teacher")).Text; obj.GroupTeamName = ((TextBox)((DetailsView)sender).FindControl("GroupTeamName")).Text; obj.SchoolType = FormatHelper.SafeToInt(((DropDownList)((DetailsView)sender).FindControl("SchoolType")).SelectedValue); obj.LiteracyLevel1 = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("LiteracyLevel1")).Text); obj.LiteracyLevel2 = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("LiteracyLevel2")).Text); obj.Custom1 = ((TextBox)((DetailsView)sender).FindControl("Custom1")).Text; obj.Custom2 = ((TextBox)((DetailsView)sender).FindControl("Custom2")).Text; obj.Custom3 = ((TextBox)((DetailsView)sender).FindControl("Custom3")).Text; obj.Custom4 = ((TextBox)((DetailsView)sender).FindControl("Custom4")).Text; obj.Custom5 = ((TextBox)((DetailsView)sender).FindControl("Custom5")).Text; obj.RegistrationDateStart = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("RegistrationDateStart")).Text); obj.RegistrationDateEnd = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("RegistrationDateEnd")).Text); obj.PointsMin = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("PointsMin")).Text); obj.PointsMax = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("PointsMax")).Text); obj.PointsStart = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("PointsStart")).Text); obj.PointsEnd = FormatHelper.SafeToDateTime(((TextBox)((DetailsView)sender).FindControl("PointsEnd")).Text); obj.EventCode = ((TextBox)((DetailsView)sender).FindControl("EventCode")).Text; obj.EarnedBadge = FormatHelper.SafeToInt(((DropDownList)((DetailsView)sender).FindControl("EarnedBadge")).SelectedValue); obj.PhysicalPrizeEarned = ((TextBox)((DetailsView)sender).FindControl("PhysicalPrizeEarned")).Text; obj.PhysicalPrizeRedeemed = ((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeRedeemed")).Checked; obj.PhysicalPrizeStartDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("PhysicalPrizeStartDate")).Text); obj.PhysicalPrizeEndDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("PhysicalPrizeEndDate")).Text); obj.ReviewsMin = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("ReviewsMin")).Text); obj.ReviewsMax = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("ReviewsMax")).Text); obj.ReviewTitle = ((TextBox)((DetailsView)sender).FindControl("ReviewTitle")).Text; obj.ReviewAuthor = ((TextBox)((DetailsView)sender).FindControl("ReviewAuthor")).Text; obj.ReviewStartDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("ReviewStartDate")).Text); obj.ReviewEndDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("ReviewEndDate")).Text); obj.RandomDrawingName = ((TextBox)((DetailsView)sender).FindControl("RandomDrawingName")).Text; obj.RandomDrawingNum = FormatHelper.SafeToInt( ((TextBox)((DetailsView)sender).FindControl("RandomDrawingNum")).Text); obj.RandomDrawingStartDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("RandomDrawingStartDate")).Text); obj.RandomDrawingEndDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("RandomDrawingEndDate")).Text); obj.HasBeenDrawn = ((CheckBox)((DetailsView)sender).FindControl("HasBeenDrawn")).Checked; obj.HasRedeemend = ((CheckBox)((DetailsView)sender).FindControl("HasRedeemend")).Checked; obj.PIDInc = ((CheckBox)((DetailsView)sender).FindControl("PIDInc")).Checked; obj.UsernameInc = ((CheckBox)((DetailsView)sender).FindControl("UsernameInc")).Checked; obj.DOBInc = ((CheckBox)((DetailsView)sender).FindControl("DOBInc")).Checked; obj.AgeInc = ((CheckBox)((DetailsView)sender).FindControl("AgeInc")).Checked; obj.SchoolGradeInc = ((CheckBox)((DetailsView)sender).FindControl("SchoolGradeInc")).Checked; obj.FirstNameInc = ((CheckBox)((DetailsView)sender).FindControl("FirstNameInc")).Checked; obj.LastNameInc = ((CheckBox)((DetailsView)sender).FindControl("LastNameInc")).Checked; obj.GenderInc = ((CheckBox)((DetailsView)sender).FindControl("GenderInc")).Checked; obj.EmailAddressInc = ((CheckBox)((DetailsView)sender).FindControl("EmailAddressInc")).Checked; obj.PhoneNumberInc = ((CheckBox)((DetailsView)sender).FindControl("PhoneNumberInc")).Checked; obj.CityInc = ((CheckBox)((DetailsView)sender).FindControl("CityInc")).Checked; obj.StateInc = ((CheckBox)((DetailsView)sender).FindControl("StateInc")).Checked; obj.ZipCodeInc = ((CheckBox)((DetailsView)sender).FindControl("ZipCodeInc")).Checked; obj.CountyInc = ((CheckBox)((DetailsView)sender).FindControl("CountyInc")).Checked; obj.PrimaryLibraryInc = ((CheckBox)((DetailsView)sender).FindControl("PrimaryLibraryInc")).Checked; obj.SchoolNameInc = ((CheckBox)((DetailsView)sender).FindControl("SchoolNameInc")).Checked; obj.DistrictInc = ((CheckBox)((DetailsView)sender).FindControl("DistrictInc")).Checked; obj.TeacherInc = ((CheckBox)((DetailsView)sender).FindControl("TeacherInc")).Checked; obj.GroupTeamNameInc = ((CheckBox)((DetailsView)sender).FindControl("GroupTeamNameInc")).Checked; obj.SchoolTypeInc = ((CheckBox)((DetailsView)sender).FindControl("SchoolTypeInc")).Checked; obj.LiteracyLevel1Inc = ((CheckBox)((DetailsView)sender).FindControl("LiteracyLevel1Inc")).Checked; obj.LiteracyLevel2Inc = ((CheckBox)((DetailsView)sender).FindControl("LiteracyLevel2Inc")).Checked; obj.Custom1Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom1Inc")).Checked; obj.Custom2Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom2Inc")).Checked; obj.Custom3Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom3Inc")).Checked; obj.Custom4Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom4Inc")).Checked; obj.Custom5Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom5Inc")).Checked; obj.RegistrationDateInc = ((CheckBox)((DetailsView)sender).FindControl("RegistrationDateInc")).Checked; obj.PointsInc = ((CheckBox)((DetailsView)sender).FindControl("PointsInc")).Checked; obj.EarnedBadgeInc = ((CheckBox)((DetailsView)sender).FindControl("EarnedBadgeInc")).Checked; obj.PhysicalPrizeNameInc = ((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeNameInc")).Checked; obj.PhysicalPrizeDateInc = ((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeDateInc")).Checked; obj.NumReviewsInc = ((CheckBox)((DetailsView)sender).FindControl("NumReviewsInc")).Checked; obj.ReviewAuthorInc = ((CheckBox)((DetailsView)sender).FindControl("ReviewAuthorInc")).Checked; obj.ReviewTitleInc = ((CheckBox)((DetailsView)sender).FindControl("ReviewTitleInc")).Checked; obj.ReviewDateInc = ((CheckBox)((DetailsView)sender).FindControl("ReviewDateInc")).Checked; obj.RandomDrawingNameInc = ((CheckBox)((DetailsView)sender).FindControl("RandomDrawingNameInc")).Checked; obj.RandomDrawingNumInc = ((CheckBox)((DetailsView)sender).FindControl("RandomDrawingNumInc")).Checked; obj.RandomDrawingDateInc = ((CheckBox)((DetailsView)sender).FindControl("RandomDrawingDateInc")).Checked; obj.HasBeenDrawnInc = ((CheckBox)((DetailsView)sender).FindControl("HasBeenDrawnInc")).Checked; obj.HasRedeemendInc = ((CheckBox)((DetailsView)sender).FindControl("HasRedeemendInc")).Checked; obj.Score1From = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score1From")).Text); obj.Score1To = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score1To")).Text); obj.Score2From = FormatHelper.SafeToInt( ((TextBox)((DetailsView)sender).FindControl("Score2From")).Text); obj.Score2To = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score2To")).Text); obj.Score1PctFrom = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score1PctFrom")).Text); obj.Score1PctTo = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score1PctTo")).Text); obj.Score2PctFrom = FormatHelper.SafeToInt( ((TextBox)((DetailsView)sender).FindControl("Score2PctFrom")).Text); obj.Score2PctTo = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score2PctTo")).Text); obj.Score1Inc = ((CheckBox)((DetailsView)sender).FindControl("Score1Inc")).Checked; obj.Score2Inc = ((CheckBox)((DetailsView)sender).FindControl("Score2Inc")).Checked; obj.Score1PctInc = ((CheckBox)((DetailsView)sender).FindControl("Score1PctInc")).Checked; obj.Score2PctInc = ((CheckBox)((DetailsView)sender).FindControl("Score2PctInc")).Checked; obj.LastModDate = DateTime.Now; obj.LastModUser = ((SRPUser)Session[SessionData.UserProfile.ToString()]).Username; //"N/A"; // Get from session if (obj.IsValid(BusinessRulesValidationMode.UPDATE)) { obj.Update(); odsData.DataBind(); dv.DataBind(); dv.ChangeMode(DetailsViewMode.Edit); var masterPage = (IControlRoomMaster)Master; masterPage.PageMessage = SRPResources.SaveOK; } else { var masterPage = (IControlRoomMaster)Master; string message = String.Format(SRPResources.ApplicationError1, "<ul>"); foreach (BusinessRulesValidationMessage m in obj.ErrorCodes) { message = string.Format(String.Format("{0}<li>{{0}}</li>", message), m.ErrorMessage); } message = string.Format("{0}</ul>", message); masterPage.PageError = message; } } catch (Exception ex) { var masterPage = (IControlRoomMaster)Master; masterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message); } } } #endregion #region save as template if (e.CommandName.ToLower() == "savetemplate") { var templateName = ((TextBox)((DetailsView)sender).FindControl("TemplateName")).Text.Trim(); if (templateName == "") { var masterPage = (IControlRoomMaster)Master; masterPage.PageError = String.Format("To create a report template from the current report format, you need to enter a Template Name."); ((TextBox)((DetailsView)sender).FindControl("TemplateName")).Focus(); return; } try { //ADD var obj = new ReportTemplate(); obj.ProgId = FormatHelper.SafeToInt( ((DropDownList)((DetailsView)sender).FindControl("ProgId")).SelectedValue); obj.ReportName = ((TextBox)((DetailsView)sender).FindControl("TemplateName")).Text; obj.DisplayFilters = ((CheckBox)((DetailsView)sender).FindControl("DisplayFilters")).Checked; obj.DOBFrom = FormatHelper.SafeToDateTime(((TextBox)((DetailsView)sender).FindControl("DOBFrom")).Text); obj.DOBTo = FormatHelper.SafeToDateTime(((TextBox)((DetailsView)sender).FindControl("DOBTo")).Text); obj.AgeFrom = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("AgeFrom")).Text); obj.AgeTo = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("AgeTo")).Text); obj.SchoolGrade = ((TextBox)((DetailsView)sender).FindControl("SchoolGrade")).Text; obj.FirstName = ((TextBox)((DetailsView)sender).FindControl("FirstName")).Text; obj.LastName = ((TextBox)((DetailsView)sender).FindControl("LastName")).Text; obj.Gender = ((DropDownList)((DetailsView)sender).FindControl("Gender")).SelectedValue; obj.EmailAddress = ((TextBox)((DetailsView)sender).FindControl("EmailAddress")).Text; obj.PhoneNumber = ((TextBox)((DetailsView)sender).FindControl("PhoneNumber")).Text; obj.City = ((TextBox)((DetailsView)sender).FindControl("City")).Text; obj.State = ((TextBox)((DetailsView)sender).FindControl("State")).Text; obj.ZipCode = ((TextBox)((DetailsView)sender).FindControl("ZipCode")).Text; obj.County = ((TextBox)((DetailsView)sender).FindControl("County")).Text; obj.PrimaryLibrary = FormatHelper.SafeToInt( ((DropDownList)((DetailsView)sender).FindControl("PrimaryLibrary")).SelectedValue); obj.SchoolName = ((DropDownList)((DetailsView)sender).FindControl("SchoolName")).SelectedValue; obj.District = ((DropDownList)((DetailsView)sender).FindControl("District")).SelectedValue; obj.SDistrict = ((DropDownList)((DetailsView)sender).FindControl("SDistrict")).SelectedValue; obj.Teacher = ((TextBox)((DetailsView)sender).FindControl("Teacher")).Text; obj.GroupTeamName = ((TextBox)((DetailsView)sender).FindControl("GroupTeamName")).Text; obj.SchoolType = FormatHelper.SafeToInt( ((DropDownList)((DetailsView)sender).FindControl("SchoolType")).SelectedValue); obj.LiteracyLevel1 = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("LiteracyLevel1")).Text); obj.LiteracyLevel2 = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("LiteracyLevel2")).Text); obj.Custom1 = ((TextBox)((DetailsView)sender).FindControl("Custom1")).Text; obj.Custom2 = ((TextBox)((DetailsView)sender).FindControl("Custom2")).Text; obj.Custom3 = ((TextBox)((DetailsView)sender).FindControl("Custom3")).Text; obj.Custom4 = ((TextBox)((DetailsView)sender).FindControl("Custom4")).Text; obj.Custom5 = ((TextBox)((DetailsView)sender).FindControl("Custom5")).Text; obj.RegistrationDateStart = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("RegistrationDateStart")).Text); obj.RegistrationDateEnd = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("RegistrationDateEnd")).Text); obj.PointsMin = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("PointsMin")).Text); obj.PointsMax = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("PointsMax")).Text); obj.PointsStart = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("PointsStart")).Text); obj.PointsEnd = FormatHelper.SafeToDateTime(((TextBox)((DetailsView)sender).FindControl("PointsEnd")).Text); obj.EventCode = ((TextBox)((DetailsView)sender).FindControl("EventCode")).Text; obj.EarnedBadge = FormatHelper.SafeToInt( ((DropDownList)((DetailsView)sender).FindControl("EarnedBadge")).SelectedValue); obj.PhysicalPrizeEarned = ((TextBox)((DetailsView)sender).FindControl("PhysicalPrizeEarned")).Text; obj.PhysicalPrizeRedeemed = ((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeRedeemed")).Checked; obj.PhysicalPrizeStartDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("PhysicalPrizeStartDate")).Text); obj.PhysicalPrizeEndDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("PhysicalPrizeEndDate")).Text); obj.ReviewsMin = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("ReviewsMin")).Text); obj.ReviewsMax = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("ReviewsMax")).Text); obj.ReviewTitle = ((TextBox)((DetailsView)sender).FindControl("ReviewTitle")).Text; obj.ReviewAuthor = ((TextBox)((DetailsView)sender).FindControl("ReviewAuthor")).Text; obj.ReviewStartDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("ReviewStartDate")).Text); obj.ReviewEndDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("ReviewEndDate")).Text); obj.RandomDrawingName = ((TextBox)((DetailsView)sender).FindControl("RandomDrawingName")).Text; obj.RandomDrawingNum = FormatHelper.SafeToInt( ((TextBox)((DetailsView)sender).FindControl("RandomDrawingNum")).Text); obj.RandomDrawingStartDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("RandomDrawingStartDate")).Text); obj.RandomDrawingEndDate = FormatHelper.SafeToDateTime( ((TextBox)((DetailsView)sender).FindControl("RandomDrawingEndDate")).Text); obj.HasBeenDrawn = ((CheckBox)((DetailsView)sender).FindControl("HasBeenDrawn")).Checked; obj.HasRedeemend = ((CheckBox)((DetailsView)sender).FindControl("HasRedeemend")).Checked; obj.Score1From = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score1From")).Text); obj.Score1To = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score1To")).Text); obj.Score2From = FormatHelper.SafeToInt( ((TextBox)((DetailsView)sender).FindControl("Score2From")).Text); obj.Score2To = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score2To")).Text); obj.Score1PctFrom = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score1PctFrom")).Text); obj.Score1PctTo = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score1PctTo")).Text); obj.Score2PctFrom = FormatHelper.SafeToInt( ((TextBox)((DetailsView)sender).FindControl("Score2PctFrom")).Text); obj.Score2PctTo = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("Score2PctTo")).Text); obj.Score1Inc = ((CheckBox)((DetailsView)sender).FindControl("Score1Inc")).Checked; obj.Score2Inc = ((CheckBox)((DetailsView)sender).FindControl("Score2Inc")).Checked; obj.Score2PctInc = ((CheckBox)((DetailsView)sender).FindControl("Score2PctInc")).Checked; obj.Score2PctInc = ((CheckBox)((DetailsView)sender).FindControl("Score2PctInc")).Checked; obj.PIDInc = ((CheckBox)((DetailsView)sender).FindControl("PIDInc")).Checked; obj.UsernameInc = ((CheckBox)((DetailsView)sender).FindControl("UsernameInc")).Checked; obj.DOBInc = ((CheckBox)((DetailsView)sender).FindControl("DOBInc")).Checked; obj.AgeInc = ((CheckBox)((DetailsView)sender).FindControl("AgeInc")).Checked; obj.SchoolGradeInc = ((CheckBox)((DetailsView)sender).FindControl("SchoolGradeInc")).Checked; obj.FirstNameInc = ((CheckBox)((DetailsView)sender).FindControl("FirstNameInc")).Checked; obj.LastNameInc = ((CheckBox)((DetailsView)sender).FindControl("LastNameInc")).Checked; obj.GenderInc = ((CheckBox)((DetailsView)sender).FindControl("GenderInc")).Checked; obj.EmailAddressInc = ((CheckBox)((DetailsView)sender).FindControl("EmailAddressInc")).Checked; obj.PhoneNumberInc = ((CheckBox)((DetailsView)sender).FindControl("PhoneNumberInc")).Checked; obj.CityInc = ((CheckBox)((DetailsView)sender).FindControl("CityInc")).Checked; obj.StateInc = ((CheckBox)((DetailsView)sender).FindControl("StateInc")).Checked; obj.ZipCodeInc = ((CheckBox)((DetailsView)sender).FindControl("ZipCodeInc")).Checked; obj.CountyInc = ((CheckBox)((DetailsView)sender).FindControl("CountyInc")).Checked; obj.PrimaryLibraryInc = ((CheckBox)((DetailsView)sender).FindControl("PrimaryLibraryInc")).Checked; obj.SchoolNameInc = ((CheckBox)((DetailsView)sender).FindControl("SchoolNameInc")).Checked; obj.DistrictInc = ((CheckBox)((DetailsView)sender).FindControl("DistrictInc")).Checked; obj.TeacherInc = ((CheckBox)((DetailsView)sender).FindControl("TeacherInc")).Checked; obj.GroupTeamNameInc = ((CheckBox)((DetailsView)sender).FindControl("GroupTeamNameInc")).Checked; obj.SchoolTypeInc = ((CheckBox)((DetailsView)sender).FindControl("SchoolTypeInc")).Checked; obj.LiteracyLevel1Inc = ((CheckBox)((DetailsView)sender).FindControl("LiteracyLevel1Inc")).Checked; obj.LiteracyLevel2Inc = ((CheckBox)((DetailsView)sender).FindControl("LiteracyLevel2Inc")).Checked; obj.Custom1Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom1Inc")).Checked; obj.Custom2Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom2Inc")).Checked; obj.Custom3Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom3Inc")).Checked; obj.Custom4Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom4Inc")).Checked; obj.Custom5Inc = ((CheckBox)((DetailsView)sender).FindControl("Custom5Inc")).Checked; obj.RegistrationDateInc = ((CheckBox)((DetailsView)sender).FindControl("RegistrationDateInc")).Checked; obj.PointsInc = ((CheckBox)((DetailsView)sender).FindControl("PointsInc")).Checked; obj.EarnedBadgeInc = ((CheckBox)((DetailsView)sender).FindControl("EarnedBadgeInc")).Checked; obj.PhysicalPrizeNameInc = ((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeNameInc")).Checked; obj.PhysicalPrizeDateInc = ((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeDateInc")).Checked; obj.NumReviewsInc = ((CheckBox)((DetailsView)sender).FindControl("NumReviewsInc")).Checked; obj.ReviewAuthorInc = ((CheckBox)((DetailsView)sender).FindControl("ReviewAuthorInc")).Checked; obj.ReviewTitleInc = ((CheckBox)((DetailsView)sender).FindControl("ReviewTitleInc")).Checked; obj.ReviewDateInc = ((CheckBox)((DetailsView)sender).FindControl("ReviewDateInc")).Checked; obj.RandomDrawingNameInc = ((CheckBox)((DetailsView)sender).FindControl("RandomDrawingNameInc")).Checked; obj.RandomDrawingNumInc = ((CheckBox)((DetailsView)sender).FindControl("RandomDrawingNumInc")).Checked; obj.RandomDrawingDateInc = ((CheckBox)((DetailsView)sender).FindControl("RandomDrawingDateInc")).Checked; obj.HasBeenDrawnInc = ((CheckBox)((DetailsView)sender).FindControl("HasBeenDrawnInc")).Checked; obj.HasRedeemendInc = ((CheckBox)((DetailsView)sender).FindControl("HasRedeemendInc")).Checked; obj.AddedDate = DateTime.Now; obj.AddedUser = ((SRPUser)Session[SessionData.UserProfile.ToString()]).Username; //"N/A"; // Get from session obj.LastModDate = obj.AddedDate; obj.LastModUser = obj.AddedUser; if (obj.IsValid(BusinessRulesValidationMode.INSERT)) { obj.Insert(); odsData.DataBind(); dv.DataBind(); dv.ChangeMode(DetailsViewMode.Edit); var masterPage = (IControlRoomMaster)Master; masterPage.PageMessage = "Report Template has been successfully created!"; } else { var masterPage = (IControlRoomMaster)Master; string message = String.Format(SRPResources.ApplicationError1, "<ul>"); foreach (BusinessRulesValidationMessage m in obj.ErrorCodes) { message = string.Format(String.Format("{0}<li>{{0}}</li>", message), m.ErrorMessage); } message = string.Format("{0}</ul>", message); masterPage.PageError = message; } } catch (Exception ex) { var masterPage = (IControlRoomMaster)Master; masterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message); } } #endregion #region load from template if (e.CommandName.ToLower() == "loadtemplate") { try { var RTID = FormatHelper.SafeToInt( ((DropDownList)((DetailsView)sender).FindControl("RTID")).SelectedValue); if (RTID == 0) return; var obj = ReportTemplate.FetchObject(RTID); var dd = ((DropDownList)((DetailsView)sender).FindControl("ProgId")); var i = dd.Items.FindByValue(obj.ProgId.ToString()); if (i != null) dd.SelectedValue = (obj.ProgId.ToString()); dd = ((DropDownList)((DetailsView)sender).FindControl("Gender")); i = dd.Items.FindByValue(obj.Gender); if (i != null) dd.SelectedValue = (obj.Gender); dd = ((DropDownList)((DetailsView)sender).FindControl("PrimaryLibrary")); i = dd.Items.FindByValue(obj.PrimaryLibrary.ToString()); if (i != null) dd.SelectedValue = (obj.PrimaryLibrary.ToString()); dd = ((DropDownList)((DetailsView)sender).FindControl("SchoolName")); i = dd.Items.FindByValue(obj.SchoolName.ToString()); if (i != null) dd.SelectedValue = (obj.SchoolName.ToString()); dd = ((DropDownList)((DetailsView)sender).FindControl("District")); i = dd.Items.FindByValue(obj.District.ToString()); if (i != null) dd.SelectedValue = (obj.District.ToString()); dd = ((DropDownList)((DetailsView)sender).FindControl("SDistrict")); i = dd.Items.FindByValue(obj.SDistrict.ToString()); if (i != null) dd.SelectedValue = (obj.SDistrict.ToString()); dd = ((DropDownList)((DetailsView)sender).FindControl("SchoolType")); i = dd.Items.FindByValue(obj.SchoolType.ToString()); if (i != null) dd.SelectedValue = (obj.SchoolType.ToString()); dd = ((DropDownList)((DetailsView)sender).FindControl("EarnedBadge")); i = dd.Items.FindByValue(obj.EarnedBadge.ToString()); if (i != null) dd.SelectedValue = (obj.EarnedBadge.ToString()); //((TextBox)((DetailsView)sender).FindControl("ReportName")).Text = obj.ReportName; ((TextBox)((DetailsView)sender).FindControl("SchoolGrade")).Text = obj.SchoolGrade; ((TextBox)((DetailsView)sender).FindControl("FirstName")).Text = obj.FirstName; ((TextBox)((DetailsView)sender).FindControl("LastName")).Text = obj.LastName; ((TextBox)((DetailsView)sender).FindControl("PhoneNumber")).Text = obj.PhoneNumber; ((TextBox)((DetailsView)sender).FindControl("City")).Text = obj.City; ((TextBox)((DetailsView)sender).FindControl("State")).Text = obj.State; ((TextBox)((DetailsView)sender).FindControl("ZipCode")).Text = obj.ZipCode; ((TextBox)((DetailsView)sender).FindControl("County")).Text = obj.County; //((TextBox)((DetailsView)sender).FindControl("SchoolName")).Text = obj.SchoolName; //((TextBox)((DetailsView)sender).FindControl("District")).Text = obj.District; ((TextBox)((DetailsView)sender).FindControl("Teacher")).Text = obj.Teacher; ((TextBox)((DetailsView)sender).FindControl("GroupTeamName")).Text = obj.GroupTeamName; ((TextBox)((DetailsView)sender).FindControl("Custom1")).Text = obj.Custom1; ((TextBox)((DetailsView)sender).FindControl("Custom2")).Text = obj.Custom2; ((TextBox)((DetailsView)sender).FindControl("Custom3")).Text = obj.Custom3; ((TextBox)((DetailsView)sender).FindControl("Custom4")).Text = obj.Custom4; ((TextBox)((DetailsView)sender).FindControl("Custom5")).Text = obj.Custom5; ((TextBox)((DetailsView)sender).FindControl("EventCode")).Text = obj.EventCode; ((TextBox)((DetailsView)sender).FindControl("PhysicalPrizeEarned")).Text = obj.PhysicalPrizeEarned; ((TextBox)((DetailsView)sender).FindControl("ReviewTitle")).Text = obj.ReviewTitle; ((TextBox)((DetailsView)sender).FindControl("ReviewAuthor")).Text = obj.ReviewAuthor; ((TextBox)((DetailsView)sender).FindControl("RandomDrawingName")).Text = obj.RandomDrawingName; ((TextBox)((DetailsView)sender).FindControl("DOBFrom")).Text = FormatHelper.ToWidgetDisplayDate(obj.DOBFrom); ((TextBox)((DetailsView)sender).FindControl("DOBTo")).Text = FormatHelper.ToWidgetDisplayDate(obj.DOBTo); ((TextBox)((DetailsView)sender).FindControl("RegistrationDateStart")).Text = FormatHelper.ToWidgetDisplayDate(obj.RegistrationDateStart); ((TextBox)((DetailsView)sender).FindControl("RegistrationDateEnd")).Text = FormatHelper.ToWidgetDisplayDate(obj.RegistrationDateEnd); ((TextBox)((DetailsView)sender).FindControl("PointsStart")).Text = FormatHelper.ToWidgetDisplayDate(obj.PointsStart); ((TextBox)((DetailsView)sender).FindControl("PointsEnd")).Text = FormatHelper.ToWidgetDisplayDate(obj.PointsEnd); ((TextBox)((DetailsView)sender).FindControl("PhysicalPrizeStartDate")).Text = FormatHelper.ToWidgetDisplayDate(obj.PhysicalPrizeStartDate); ((TextBox)((DetailsView)sender).FindControl("PhysicalPrizeEndDate")).Text = FormatHelper.ToWidgetDisplayDate(obj.PhysicalPrizeEndDate); ((TextBox)((DetailsView)sender).FindControl("ReviewStartDate")).Text = FormatHelper.ToWidgetDisplayDate(obj.ReviewStartDate); ((TextBox)((DetailsView)sender).FindControl("ReviewEndDate")).Text = FormatHelper.ToWidgetDisplayDate(obj.ReviewEndDate); ((TextBox)((DetailsView)sender).FindControl("RandomDrawingStartDate")).Text = FormatHelper.ToWidgetDisplayDate(obj.RandomDrawingStartDate); ((TextBox)((DetailsView)sender).FindControl("RandomDrawingEndDate")).Text = FormatHelper.ToWidgetDisplayDate(obj.RandomDrawingEndDate); ((TextBox)((DetailsView)sender).FindControl("AgeFrom")).Text = FormatHelper.ToWidgetDisplayInt(obj.AgeFrom); ((TextBox)((DetailsView)sender).FindControl("AgeTo")).Text = FormatHelper.ToWidgetDisplayInt(obj.AgeTo); ((TextBox)((DetailsView)sender).FindControl("LiteracyLevel1")).Text = FormatHelper.ToWidgetDisplayInt(obj.LiteracyLevel1); ((TextBox)((DetailsView)sender).FindControl("LiteracyLevel2")).Text = FormatHelper.ToWidgetDisplayInt(obj.LiteracyLevel2); ((TextBox)((DetailsView)sender).FindControl("PointsMin")).Text = FormatHelper.ToWidgetDisplayInt(obj.PointsMin); ((TextBox)((DetailsView)sender).FindControl("PointsMax")).Text = FormatHelper.ToWidgetDisplayInt(obj.PointsMax); ((TextBox)((DetailsView)sender).FindControl("ReviewsMin")).Text = FormatHelper.ToWidgetDisplayInt(obj.ReviewsMin); ((TextBox)((DetailsView)sender).FindControl("ReviewsMax")).Text = FormatHelper.ToWidgetDisplayInt(obj.ReviewsMax); ((TextBox)((DetailsView)sender).FindControl("RandomDrawingNum")).Text = FormatHelper.ToWidgetDisplayInt(obj.RandomDrawingNum); ((CheckBox)((DetailsView)sender).FindControl("DisplayFilters")).Checked = obj.DisplayFilters; ((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeRedeemed")).Checked = obj.PhysicalPrizeRedeemed; ((CheckBox)((DetailsView)sender).FindControl("HasBeenDrawn")).Checked = obj.HasBeenDrawn; ((CheckBox)((DetailsView)sender).FindControl("HasRedeemend")).Checked = obj.HasRedeemend; ((CheckBox)((DetailsView)sender).FindControl("PIDInc")).Checked = obj.PIDInc; ((CheckBox)((DetailsView)sender).FindControl("UsernameInc")).Checked = obj.UsernameInc; ((CheckBox)((DetailsView)sender).FindControl("AgeInc")).Checked = obj.AgeInc; ((CheckBox)((DetailsView)sender).FindControl("SchoolGradeInc")).Checked = obj.SchoolGradeInc; ((CheckBox)((DetailsView)sender).FindControl("FirstNameInc")).Checked = obj.FirstNameInc; ((CheckBox)((DetailsView)sender).FindControl("LastNameInc")).Checked = obj.LastNameInc; ((CheckBox)((DetailsView)sender).FindControl("GenderInc")).Checked = obj.GenderInc; ((CheckBox)((DetailsView)sender).FindControl("EmailAddressInc")).Checked = obj.EmailAddressInc; ((CheckBox)((DetailsView)sender).FindControl("PhoneNumberInc")).Checked = obj.PhoneNumberInc; ((CheckBox)((DetailsView)sender).FindControl("CityInc")).Checked = obj.CityInc; ((CheckBox)((DetailsView)sender).FindControl("StateInc")).Checked = obj.StateInc; ((CheckBox)((DetailsView)sender).FindControl("ZipCodeInc")).Checked = obj.ZipCodeInc; ((CheckBox)((DetailsView)sender).FindControl("CountyInc")).Checked = obj.CountyInc; ((CheckBox)((DetailsView)sender).FindControl("PrimaryLibraryInc")).Checked = obj.PrimaryLibraryInc; ((CheckBox)((DetailsView)sender).FindControl("SchoolNameInc")).Checked = obj.SchoolNameInc; ((CheckBox)((DetailsView)sender).FindControl("TeacherInc")).Checked = obj.TeacherInc; ((CheckBox)((DetailsView)sender).FindControl("GroupTeamNameInc")).Checked = obj.GroupTeamNameInc; ((CheckBox)((DetailsView)sender).FindControl("SchoolTypeInc")).Checked = obj.SchoolTypeInc; ((CheckBox)((DetailsView)sender).FindControl("LiteracyLevel1Inc")).Checked = obj.LiteracyLevel1Inc; ((CheckBox)((DetailsView)sender).FindControl("LiteracyLevel2Inc")).Checked = obj.LiteracyLevel2Inc; ((CheckBox)((DetailsView)sender).FindControl("Custom1Inc")).Checked = obj.Custom1Inc; ((CheckBox)((DetailsView)sender).FindControl("Custom2Inc")).Checked = obj.Custom2Inc; ((CheckBox)((DetailsView)sender).FindControl("Custom3Inc")).Checked = obj.Custom3Inc; ((CheckBox)((DetailsView)sender).FindControl("Custom4Inc")).Checked = obj.Custom4Inc; ((CheckBox)((DetailsView)sender).FindControl("Custom5Inc")).Checked = obj.Custom5Inc; ((CheckBox)((DetailsView)sender).FindControl("RegistrationDateInc")).Checked = obj.RegistrationDateInc; ((CheckBox)((DetailsView)sender).FindControl("PointsInc")).Checked = obj.PointsInc; ((CheckBox)((DetailsView)sender).FindControl("EarnedBadgeInc")).Checked = obj.EarnedBadgeInc; ((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeNameInc")).Checked = obj.PhysicalPrizeNameInc; ((CheckBox)((DetailsView)sender).FindControl("NumReviewsInc")).Checked = obj.NumReviewsInc; ((CheckBox)((DetailsView)sender).FindControl("ReviewAuthorInc")).Checked = obj.ReviewAuthorInc; ((CheckBox)((DetailsView)sender).FindControl("ReviewTitleInc")).Checked = obj.ReviewTitleInc; ((CheckBox)((DetailsView)sender).FindControl("ReviewDateInc")).Checked = obj.ReviewDateInc; ((CheckBox)((DetailsView)sender).FindControl("RandomDrawingNameInc")).Checked = obj.RandomDrawingNameInc; ((CheckBox)((DetailsView)sender).FindControl("RandomDrawingNumInc")).Checked = obj.RandomDrawingNumInc; ((CheckBox)((DetailsView)sender).FindControl("RandomDrawingDateInc")).Checked = obj.RandomDrawingDateInc; ((CheckBox)((DetailsView)sender).FindControl("HasBeenDrawnInc")).Checked = obj.HasBeenDrawnInc; ((CheckBox)((DetailsView)sender).FindControl("HasRedeemendInc")).Checked = obj.HasRedeemendInc; ((TextBox)((DetailsView)sender).FindControl("Score1From")).Text = FormatHelper.ToWidgetDisplayInt(obj.Score1From); ((TextBox)((DetailsView)sender).FindControl("Score2From")).Text = FormatHelper.ToWidgetDisplayInt(obj.Score2From); ((TextBox)((DetailsView)sender).FindControl("Score1PctFrom")).Text = FormatHelper.ToWidgetDisplayInt(obj.Score1PctFrom); ((TextBox)((DetailsView)sender).FindControl("Score2PctFrom")).Text = FormatHelper.ToWidgetDisplayInt(obj.Score2PctFrom); ((TextBox)((DetailsView)sender).FindControl("Score1To")).Text = FormatHelper.ToWidgetDisplayInt(obj.Score1To); ((TextBox)((DetailsView)sender).FindControl("Score2To")).Text = FormatHelper.ToWidgetDisplayInt(obj.Score2To); ((TextBox)((DetailsView)sender).FindControl("Score1PctTo")).Text = FormatHelper.ToWidgetDisplayInt(obj.Score1PctTo); ((TextBox)((DetailsView)sender).FindControl("Score2PctTo")).Text = FormatHelper.ToWidgetDisplayInt(obj.Score2PctTo); ((CheckBox)((DetailsView)sender).FindControl("Score1Inc")).Checked = obj.Score1Inc; ((CheckBox)((DetailsView)sender).FindControl("Score2Inc")).Checked = obj.Score2Inc; ((CheckBox)((DetailsView)sender).FindControl("Score1PctInc")).Checked = obj.Score1PctInc; ((CheckBox)((DetailsView)sender).FindControl("Score2PctInc")).Checked = obj.Score2PctInc; var masterPage = (IControlRoomMaster)Master; if (masterPage != null) masterPage.PageMessage = "Report template loaded."; } catch (Exception ex) { var masterPage = (IControlRoomMaster)Master; masterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message); } } #endregion #region RUN REPORT if (e.CommandName.ToLower() == "runreport") { try { SqlParameter[] arrParams = null; var retColumns = string.Empty; var whereClause = string.Empty; var fromClause = "Patron p "; var filterStr = string.Empty; //var tmpFilter= string.Empty; var minorSep = "~"; var majorSep = "|"; if (((CheckBox)((DetailsView)sender).FindControl("PIDInc")).Checked) retColumns = Coalesce(retColumns, "p.PID as PatronID", ","); if (((CheckBox)((DetailsView)sender).FindControl("UsernameInc")).Checked) retColumns = Coalesce(retColumns, "p.Username", ","); if (((CheckBox)((DetailsView)sender).FindControl("DOBInc")).Checked) retColumns = Coalesce(retColumns, "convert(varchar, DOB, 101) as DOB", ","); if (((CheckBox)((DetailsView)sender).FindControl("AgeInc")).Checked) retColumns = Coalesce(retColumns, "case when Age > 0 then Age else null end as Age", ","); if (((CheckBox)((DetailsView)sender).FindControl("SchoolGradeInc")).Checked) retColumns = Coalesce(retColumns, "SchoolGrade", ","); if (((CheckBox)((DetailsView)sender).FindControl("FirstNameInc")).Checked) retColumns = Coalesce(retColumns, "FirstName", ","); if (((CheckBox)((DetailsView)sender).FindControl("LastNameInc")).Checked) retColumns = Coalesce(retColumns, "LastName", ","); if (((CheckBox)((DetailsView)sender).FindControl("GenderInc")).Checked) retColumns = Coalesce(retColumns, "Gender", ","); if (((CheckBox)((DetailsView)sender).FindControl("EmailAddressInc")).Checked) retColumns = Coalesce(retColumns, "EmailAddress", ","); if (((CheckBox)((DetailsView)sender).FindControl("PhoneNumberInc")).Checked) retColumns = Coalesce(retColumns, "PhoneNumber", ","); if (((CheckBox)((DetailsView)sender).FindControl("CityInc")).Checked) retColumns = Coalesce(retColumns, "City", ","); if (((CheckBox)((DetailsView)sender).FindControl("StateInc")).Checked) retColumns = Coalesce(retColumns, "State", ","); if (((CheckBox)((DetailsView)sender).FindControl("ZipCodeInc")).Checked) retColumns = Coalesce(retColumns, "ZipCode", ","); if (((CheckBox)((DetailsView)sender).FindControl("Score1Inc")).Checked) retColumns = Coalesce(retColumns, "Score1", ","); if (((CheckBox)((DetailsView)sender).FindControl("Score2Inc")).Checked) retColumns = Coalesce(retColumns, "Score2", ","); if (((CheckBox)((DetailsView)sender).FindControl("Score1PctInc")).Checked) retColumns = Coalesce(retColumns, "Score1Pct", ","); if (((CheckBox)((DetailsView)sender).FindControl("Score2PctInc")).Checked) retColumns = Coalesce(retColumns, "Score2Pct", ","); if (((CheckBox)((DetailsView)sender).FindControl("DistrictInc")).Checked) { // CODE Translate fromClause = Coalesce(fromClause, "left outer join Code C4 on C4.CID = p.District", " "); retColumns = Coalesce(retColumns, "C4.Code as District", ","); } if (((CheckBox)((DetailsView)sender).FindControl("PrimaryLibraryInc")).Checked) { // CODE Translate fromClause = Coalesce(fromClause, "left outer join Code C1 on C1.CID = p.PrimaryLibrary", " "); retColumns = Coalesce(retColumns, "C1.Code as PrimaryLibrary", ","); } if (((CheckBox)((DetailsView)sender).FindControl("SDistrictInc")).Checked) { // CODE Translate fromClause = Coalesce(fromClause, "left outer join Code C5 on C5.CID = p.SDistrict", " "); retColumns = Coalesce(retColumns, "C5.Code as SDistrict", ","); } if (((CheckBox)((DetailsView)sender).FindControl("SchoolNameInc")).Checked) { // CODE Translate fromClause = Coalesce(fromClause, "left outer join Code C3 on C3.CID = p.SchoolName", " "); retColumns = Coalesce(retColumns, "C3.Code as SchoolName", ","); } //if (((CheckBox)((DetailsView)sender).FindControl("SchoolNameInc")).Checked) // retColumns = Coalesce(retColumns, "SchoolName", ","); //if (((CheckBox)((DetailsView)sender).FindControl("DistrictInc")).Checked) // retColumns = Coalesce(retColumns, "District", ","); if (((CheckBox)((DetailsView)sender).FindControl("TeacherInc")).Checked) retColumns = Coalesce(retColumns, "Teacher", ","); if (((CheckBox)((DetailsView)sender).FindControl("GroupTeamNameInc")).Checked) retColumns = Coalesce(retColumns, "GroupTeamName", ","); if (((CheckBox)((DetailsView)sender).FindControl("SchoolTypeInc")).Checked) { //CODE Translate1 fromClause = Coalesce(fromClause, "left outer join Code C2 on C2.CID = p.SchoolType", " "); retColumns = Coalesce(retColumns, "C2.Code as SchoolType", ","); } if (((CheckBox)((DetailsView)sender).FindControl("LiteracyLevel1Inc")).Checked) retColumns = Coalesce(retColumns, "case when LiteracyLevel1 > 0 then LiteracyLevel1 else null end as LiteracyLevel1", ","); if (((CheckBox)((DetailsView)sender).FindControl("LiteracyLevel2Inc")).Checked) retColumns = Coalesce(retColumns, "case when LiteracyLevel2 > 0 then LiteracyLevel2 else null end as LiteracyLevel2", ","); if (((CheckBox)((DetailsView)sender).FindControl("Custom1Inc")).Checked) retColumns = Coalesce(retColumns, "Custom1", ","); if (((CheckBox)((DetailsView)sender).FindControl("Custom2Inc")).Checked) retColumns = Coalesce(retColumns, "Custom2", ","); if (((CheckBox)((DetailsView)sender).FindControl("Custom3Inc")).Checked) retColumns = Coalesce(retColumns, "Custom3", ","); if (((CheckBox)((DetailsView)sender).FindControl("Custom4Inc")).Checked) retColumns = Coalesce(retColumns, "Custom4", ","); if (((CheckBox)((DetailsView)sender).FindControl("Custom5Inc")).Checked) retColumns = Coalesce(retColumns, "Custom5", ","); if (((CheckBox)((DetailsView)sender).FindControl("RegistrationDateInc")).Checked) retColumns = Coalesce(retColumns, "convert(varchar, RegistrationDate, 101) as RegistrationDate", ","); ProcessSimpleStringFilter((DetailsView)sender, "FirstName", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "LastName", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "SchoolGrade", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "EmailAddress", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "PhoneNumber", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "City", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "State", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "ZipCode", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "County", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "Teacher", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "GroupTeamName", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); //ProcessSimpleStringFilter((DetailsView)sender, "District", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); //ProcessSimpleStringFilter((DetailsView)sender, "SchoolName", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); string txt; string parmField; int _int; DateTime _dt; string filterField; //ProgID fromClause = Coalesce(fromClause, "left outer join Programs PGM on PGM.PID = p.ProgId", " "); retColumns = Coalesce(retColumns, "PGM.AdminName as Program", ","); parmField = "ProgID"; txt = ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedValue; _int = int.Parse(txt); if (_int > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + parmField, _int)); whereClause = Coalesce(whereClause, string.Format("(p.{0} = @{1})", parmField, parmField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", "Program", minorSep, ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedItem.Text), majorSep); } ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// txt = ((DropDownList)((DetailsView)sender).FindControl("Gender")).SelectedValue.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + "Gender", txt)); whereClause = Coalesce(whereClause, string.Format("({0} = @{0})", "Gender"), " AND "); //retColumns = Coalesce(retColumns, filterField, ","); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", "Gender", minorSep, ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedItem.Text), majorSep); } parmField = "PrimaryLibrary"; txt = ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedValue; _int = txt.SafeToInt(); if (_int > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + parmField, _int)); whereClause = Coalesce(whereClause, string.Format("({0} = @{1})", parmField, parmField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", parmField, minorSep, ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedItem.Text), majorSep); } parmField = "District"; txt = ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedValue; _int = txt.SafeToInt(); if (_int > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + parmField, _int)); whereClause = Coalesce(whereClause, string.Format("({0} = @{1})", parmField, parmField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", "Library District", minorSep, ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedItem.Text), majorSep); } parmField = "SDistrict"; txt = ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedValue; _int = txt.SafeToInt(); if (_int > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + parmField, _int)); whereClause = Coalesce(whereClause, string.Format("({0} = @{1})", parmField, parmField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", "School District", minorSep, ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedItem.Text), majorSep); } parmField = "SchoolName"; txt = ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedValue; _int = txt.SafeToInt(); if (_int > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + parmField, _int)); whereClause = Coalesce(whereClause, string.Format("({0} = @{1})", parmField, parmField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", "School Name", minorSep, ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedItem.Text), majorSep); } parmField = "SchoolType"; txt = ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedValue; _int = txt.SafeToInt(); if (_int > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + parmField, _int)); whereClause = Coalesce(whereClause, string.Format("({0} = @{1})", parmField, parmField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", parmField, minorSep, ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedItem.Text), majorSep); } ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// parmField = "LiteracyLevel1"; txt = ((TextBox)(((DetailsView)sender).FindControl(parmField))).Text.Trim(); _int = txt.SafeToInt(); if (_int > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + parmField, _int)); whereClause = Coalesce(whereClause, string.Format("({0} = @{1})", parmField, parmField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", parmField, minorSep, txt), majorSep); } parmField = "LiteracyLevel2"; txt = ((TextBox)(((DetailsView)sender).FindControl(parmField))).Text.Trim(); _int = txt.SafeToInt(); if (_int > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + parmField, _int)); whereClause = Coalesce(whereClause, string.Format("({0} = @{1})", parmField, parmField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", parmField, minorSep, txt), majorSep); } ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// ProcessSimpleStringFilter((DetailsView)sender, "Custom1", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "Custom2", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "Custom3", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "Custom4", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ProcessSimpleStringFilter((DetailsView)sender, "Custom5", ref whereClause, ref retColumns, ref arrParams, ref filterStr, minorSep, majorSep); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// filterField = "Score1From"; parmField = "Score1"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} >= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} >= {2}", parmField, minorSep, txt), majorSep); } filterField = "Score2From"; parmField = "Score2"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} >= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} >= {2}", parmField, minorSep, txt), majorSep); } filterField = "Score1To"; parmField = "Score1"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} <= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} <= {2}", parmField, minorSep, txt), majorSep); } filterField = "Score2To"; parmField = "Score2"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} <= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} <= {2}", parmField, minorSep, txt), majorSep); } filterField = "Score1PctFrom"; parmField = "Score1Pct"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} >= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} >= {2}", parmField, minorSep, txt), majorSep); } filterField = "Score2PctFrom"; parmField = "Score2Pct"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} >= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} >= {2}", parmField, minorSep, txt), majorSep); } filterField = "Score1PctTo"; parmField = "Score1Pct"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} <= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} <= {2}", parmField, minorSep, txt), majorSep); } filterField = "Score2PctTo"; parmField = "Score2Pct"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} <= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} <= {2}", parmField, minorSep, txt), majorSep); } ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// filterField = "AgeFrom"; parmField = "Age"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} >= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", filterField, minorSep, txt), majorSep); } filterField = "AgeTo"; parmField = "Age"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} <= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", filterField, minorSep, txt), majorSep); } filterField = "DOBFrom"; parmField = "DOB"; _dt = FormatHelper.SafeToDateTime(((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()); if (_dt != DateTime.MinValue) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _dt)); whereClause = Coalesce(whereClause, string.Format("({0} >= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", filterField, minorSep, txt), majorSep); } filterField = "DOBTo"; parmField = "DOB"; _dt = FormatHelper.SafeToDateTime(((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()); if (_dt != DateTime.MinValue) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _dt)); whereClause = Coalesce(whereClause, string.Format("({0} <= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", filterField, minorSep, txt), majorSep); } filterField = "RegistrationDateStart"; parmField = "RegistrationDate"; _dt = FormatHelper.SafeToDateTime(((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()); if (_dt != DateTime.MinValue) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _dt)); whereClause = Coalesce(whereClause, string.Format("({0} >= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", filterField, minorSep, txt), majorSep); } filterField = "RegistrationDateEnd"; parmField = "RegistrationDate"; _dt = FormatHelper.SafeToDateTime(((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()); if (_dt != DateTime.MinValue) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _dt)); whereClause = Coalesce(whereClause, string.Format("({0} <= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", filterField, minorSep, txt), majorSep); } /////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////// var needPointsDate = false; if (((CheckBox)((DetailsView)sender).FindControl("PointsInc")).Checked) { retColumns = Coalesce(retColumns, "(select SUM(convert(BIGINT, NumPoints)) from PatronPoints pp where pp.PID = p.PID AND (@PointsStart is null or pp.AwardDate >= @PointsStart) and (@PointsEnd is null or pp.AwardDate <= @PointsEnd)) as NumPoints", ","); needPointsDate = true; } filterField = "PointsMin"; parmField = "(select SUM(convert(BIGINT, NumPoints)) from PatronPoints pp where pp.PID = p.PID AND (@PointsStart is null or pp.AwardDate >= @PointsStart) and (@PointsEnd is null or pp.AwardDate <= @PointsEnd))"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} >= @{1} or @{1} is null)", parmField, filterField), " AND "); needPointsDate = true; filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", filterField, minorSep, txt), majorSep); } filterField = "PointsMax"; parmField = "(select SUM(convert(BIGINT, NumPoints)) from PatronPoints pp where pp.PID = p.PID AND (@PointsStart is null or pp.AwardDate >= @PointsStart) and (@PointsEnd is null or pp.AwardDate <= @PointsEnd))"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} <= @{1} or @{1} is null)", parmField, filterField), " AND "); needPointsDate = true; filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", filterField, minorSep, txt), majorSep); } filterField = "PointsStart"; _dt = FormatHelper.SafeToDateTime(((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()); if (_dt != DateTime.MinValue) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _dt)); filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", filterField, minorSep, ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()), majorSep); } else if (needPointsDate) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, DBNull.Value)); } filterField = "PointsEnd"; _dt = FormatHelper.SafeToDateTime(((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()); if (_dt != DateTime.MinValue) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _dt)); filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", filterField, minorSep, ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()), majorSep); } else if (needPointsDate) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, DBNull.Value)); } /////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////// filterField = "EventCode"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { retColumns = Coalesce(retColumns, "pp1.EventCode", ","); AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, txt)); whereClause = Coalesce(whereClause, string.Format("(pp1.{0} like '%' + @{1} + '%')", filterField, filterField), " AND "); fromClause = Coalesce(fromClause, "left join PatronPoints pp1 on p.PID = pp1.PID", " "); filterStr = Coalesce(filterStr, string.Format("{0}{1} like {2}", filterField, minorSep, txt), majorSep); } /////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////// var needBadges = false; if (((CheckBox)((DetailsView)sender).FindControl("EarnedBadgeInc")).Checked) { needBadges = true; retColumns = Coalesce(retColumns, "b.AdminName as BadgeName", ","); } filterField = "EarnedBadge"; txt = ((DropDownList)(((DetailsView)sender).FindControl(filterField))).SelectedValue; _int = int.Parse(txt); if (_int > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _int)); whereClause = Coalesce(whereClause, string.Format("({0} = @{1})", "pb.BadgeId", filterField), " AND "); needBadges = true; filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", filterField, minorSep, ((DropDownList)(((DetailsView)sender).FindControl(filterField))).SelectedItem.Text), majorSep); } if (needBadges) { fromClause = Coalesce(fromClause, "left join PatronBadges pb on pb.PID = p.PID left outer join Badge b on pb.BadgeID = b.BID", " "); } /////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////// var needPrize = false; if (((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeNameInc")).Checked) { needPrize = true; retColumns = Coalesce(retColumns, "pr.PrizeName", ","); retColumns = Coalesce(retColumns, "pr.RedeemedFlag", ","); } filterField = "PhysicalPrizeEarned"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { needPrize = true; AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, txt)); whereClause = Coalesce(whereClause, string.Format("({0} like '%' + @{1} + '%')", "pr.PrizeName", filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1}like {2}", "PrizeName", minorSep, txt), majorSep); filterField = "PhysicalPrizeRedeemed"; var chk = ((CheckBox)(((DetailsView)sender).FindControl(filterField))).Checked; AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, (chk ? 1 : 0))); whereClause = Coalesce(whereClause, string.Format("(pr.RedeemedFlag = @{0})", filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", "Redeemed", minorSep, (chk ? 1 : 0)), majorSep); } if (((CheckBox)((DetailsView)sender).FindControl("PhysicalPrizeDateInc")).Checked) { needPrize = true; retColumns = Coalesce(retColumns, "pr.AddedDate as PrizeAwardDate", ","); } filterField = "PhysicalPrizeStartDate"; _dt = FormatHelper.SafeToDateTime(((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()); if (_dt != DateTime.MinValue) { needPrize = true; AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _dt)); whereClause = Coalesce(whereClause, string.Format("(pr.AddedDate >= @{0} or @{0} is null)", filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", filterField, minorSep, ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()), majorSep); } filterField = "PhysicalPrizeEndDate"; _dt = FormatHelper.SafeToDateTime(((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()); if (_dt != DateTime.MinValue) { needPrize = true; AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _dt)); whereClause = Coalesce(whereClause, string.Format("(pr.AddedDate <= @{0} or @{0} is null)", filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", filterField, minorSep, ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()), majorSep); } if (needPrize) { fromClause = Coalesce(fromClause, "left join PatronPrizes pr on p.PID = pr.PID", " "); } /////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////// var needReview = false; var needReviewDates = false; if (((CheckBox)((DetailsView)sender).FindControl("NumReviewsInc")).Checked) { needReview = true; retColumns = Coalesce(retColumns, "(select Count(*) from PatronReview pr where pr.PID = p.PID AND (@ReviewStartDate is null or pr.ReviewDate >= @ReviewStartDate) and (@ReviewEndDate is null or pr.ReviewDate <= @ReviewEndDate)) as NumReviews", ","); needReviewDates = true; } filterField = "ReviewsMin"; parmField = "(select Count(*) from PatronReview pr where pr.PID = p.PID AND (@ReviewStartDate is null or pr.ReviewDate >= @ReviewStartDate) and (@ReviewEndDate is null or pr.ReviewDate <= @ReviewEndDate))"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} >= @{1} or @{1} is null)", parmField, filterField), " AND "); needReviewDates = true; filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", filterField, minorSep, txt), majorSep); } filterField = "ReviewsMax"; parmField = "(select Count(*) from PatronReview pr where pr.PID = p.PID AND (@ReviewStartDate is null or pr.ReviewDate >= @ReviewStartDate) and (@ReviewEndDate is null or pr.ReviewDate <= @ReviewEndDate))"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, int.Parse(txt))); whereClause = Coalesce(whereClause, string.Format("({0} <= @{1} or @{1} is null)", parmField, filterField), " AND "); needReviewDates = true; filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", filterField, minorSep, txt), majorSep); } if (((CheckBox)((DetailsView)sender).FindControl("ReviewTitleInc")).Checked) { needReview = true; retColumns = Coalesce(retColumns, "patr.Title", ","); } filterField = "ReviewTitle"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { needReview = true; AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, txt)); whereClause = Coalesce(whereClause, string.Format("(patr.Title like '%' + @{0} + '%')", filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} like {2}", filterField, minorSep, txt), majorSep); } if (((CheckBox)((DetailsView)sender).FindControl("ReviewAuthorInc")).Checked) { needReview = true; retColumns = Coalesce(retColumns, "patr.Author", ","); } filterField = "ReviewAuthor"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { needReview = true; AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, txt)); whereClause = Coalesce(whereClause, string.Format("(patr.Author like '%' + @{0} + '%')", filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} like {2}", filterField, minorSep, txt), majorSep); } if (((CheckBox)((DetailsView)sender).FindControl("ReviewDateInc")).Checked) { needReview = true; retColumns = Coalesce(retColumns, "convert(varchar, patr.ReviewDate, 101) as ReviewDate", ","); } filterField = "ReviewStartDate"; _dt = FormatHelper.SafeToDateTime(((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()); if (_dt != DateTime.MinValue) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _dt)); whereClause = Coalesce(whereClause, string.Format("(@{0} is null or patr.ReviewDate >= @{0})", filterField), " AND "); needReview = true; filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", filterField, minorSep, ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()), majorSep); } else if (needReviewDates) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, DBNull.Value)); needReview = true; } filterField = "ReviewEndDate"; _dt = FormatHelper.SafeToDateTime(((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()); if (_dt != DateTime.MinValue) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _dt)); whereClause = Coalesce(whereClause, string.Format("(@{0} is null or patr.ReviewDate <= @{0})", filterField), " AND "); needReview = true; filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", filterField, minorSep, ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()), majorSep); } else if (needReviewDates) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, DBNull.Value)); needReview = true; } if (needReview) { fromClause = Coalesce(fromClause, "left join PatronReview patr on patr.PID = p.PID", " "); } /////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////// var needDrawing = false; //var needDrawingDates = false; if (((CheckBox)((DetailsView)sender).FindControl("RandomDrawingNameInc")).Checked) { needDrawing = true; retColumns = Coalesce(retColumns, "pdr.PrizeName as RandomDrawingName", ","); } filterField = "RandomDrawingName"; txt = ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim(); if (txt.Length > 0) { needReview = true; AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, txt)); whereClause = Coalesce(whereClause, string.Format("(pdr.PrizeName like '%' + @{0} + '%')", filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", filterField, minorSep, txt), majorSep); } if (((CheckBox)((DetailsView)sender).FindControl("RandomDrawingNumInc")).Checked) { needDrawing = true; retColumns = Coalesce(retColumns, "pdr.PDID as RandomDrawingNum", ","); } parmField = "RandomDrawingNum"; txt = ((TextBox)(((DetailsView)sender).FindControl(parmField))).Text.Trim(); _int = txt.SafeToInt(); if (_int > 0) { AddSqlParameter(ref arrParams, new SqlParameter("@" + parmField, _int)); whereClause = Coalesce(whereClause, string.Format("({0} = @{1})", "pdr.PDID", parmField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", filterField, minorSep, txt), majorSep); } if (((CheckBox)((DetailsView)sender).FindControl("HasRedeemendInc")).Checked) { needDrawing = true; retColumns = Coalesce(retColumns, "pdw.PrizePickedUpFlag as UserRedeemedPrize", ","); filterField = "HasBeenDrawn"; var chk = ((CheckBox)(((DetailsView)sender).FindControl(filterField))).Checked; AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, (chk ? 1 : 0))); whereClause = Coalesce(whereClause, string.Format("(pdw.PrizePickedUpFlag = @{0})", filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", filterField, minorSep, (chk ? 1 : 0)), majorSep); } if (((CheckBox)((DetailsView)sender).FindControl("HasBeenDrawnInc")).Checked) { needDrawing = true; retColumns = Coalesce(retColumns, "'Yes' as UserHasBeenDrawn", ","); } if (((CheckBox)((DetailsView)sender).FindControl("RandomDrawingDateInc")).Checked) { needDrawing = true; retColumns = Coalesce(retColumns, "convert(varchar, pdr.DrawingDateTime, 101) as RandomDrawingDate", ","); } filterField = "RandomDrawingStartDate"; parmField = "pdr.DrawingDateTime"; _dt = FormatHelper.SafeToDateTime(((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()); if (_dt != DateTime.MinValue) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _dt)); whereClause = Coalesce(whereClause, string.Format("({0} >= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", filterField, minorSep, ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()), majorSep); } filterField = "RandomDrawingEndDate"; parmField = "pdr.DrawingDateTime"; _dt = FormatHelper.SafeToDateTime(((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()); if (_dt != DateTime.MinValue) { AddSqlParameter(ref arrParams, new SqlParameter("@" + filterField, _dt)); whereClause = Coalesce(whereClause, string.Format("({0} <= @{1})", parmField, filterField), " AND "); filterStr = Coalesce(filterStr, string.Format("{0}{1} = {2}", filterField, minorSep, ((TextBox)(((DetailsView)sender).FindControl(filterField))).Text.Trim()), majorSep); } if (needDrawing) { fromClause = Coalesce(fromClause, "left outer join PrizeDrawingWinners pdw on pdw.PatronId = p.PID left outer join PrizeDrawing pdr on pdw.PDID = pdr.PDID", " "); } /////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////// if (retColumns.Length == 0) { var masterPage = (IControlRoomMaster)Master; masterPage.PageError = String.Format("You must select the columns to display."); return; } AddSqlParameter(ref arrParams, new SqlParameter("@TenID", CRTenantID == null ? -1 : CRTenantID)); whereClause = Coalesce(whereClause, "(p.TenID = @TenID)", " AND "); // Should this be DISTINCT ????????? var SQL = "SELECT DISTINCT " + retColumns + " FROM " + fromClause; if (whereClause.Length > 0) SQL = SQL + " WHERE " + whereClause; //lblSQl.Text = SQL; var ds = SqlHelper.ExecuteDataset(conn, CommandType.Text, SQL, arrParams); Session["rptSql"] = ds; //gv.DataSource = ds; //gv.DataBind(); parmField = "ReportFormat"; txt = ((DropDownList)(((DetailsView)sender).FindControl(parmField))).SelectedValue; _int = int.Parse(txt); if (_int == 0) { string path = "HTMLReportResults.aspx"; Page.ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "var win = window.open('" + path + "','',''); if (win == null || typeof(win)=='undefined') {alert('Turn off your pop-up blocker!');}", true); //Response.Redirect("HTMLReportResults.aspx"); Session["rptFilter"] = filterStr.Replace(minorSep, " ").Replace(majorSep, "<br/>"); } if (_int == 2) { string excelFilename = Server.MapPath("~/Adhocreport.xlsx"); //CreateExcelFile.CreateExcelDocument(ds, excelFilename, filterStr.Replace(minorSep, " ").Replace(majorSep, "\n")); CreateExcelFile.CreateExcelDocument(ds, excelFilename); Response.ContentType = "application/vnd.ms-excel"; Response.AppendHeader("Content-Disposition", "attachment; filename=Adhocreport.xlsx"); EnableViewState = false; Response.BinaryWrite(File.ReadAllBytes(excelFilename)); File.Delete(excelFilename); Response.End(); } } catch (Exception ex) { var masterPage = (IControlRoomMaster)Master; masterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message); } } #endregion }