public bool Fetch(int RID)
{
// declare reader
SqlDataReader dr;
SqlParameter[] arrParams = new SqlParameter[1];
arrParams[0] = new SqlParameter("@RID", RID);
dr = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "app_SRPReport_GetByID", arrParams);
if (dr.Read())
{
// declare return value
SRPReport result = new SRPReport();
DateTime _datetime;
int _int;
//decimal _decimal;
if (int.TryParse(dr["RID"].ToString(), out _int)) this.RID = _int;
if (int.TryParse(dr["RTID"].ToString(), out _int)) this.RTID = _int;
if (int.TryParse(dr["ProgId"].ToString(), out _int)) this.ProgId = _int;
this.ReportName = dr["ReportName"].ToString();
this.DisplayFilters = bool.Parse(dr["DisplayFilters"].ToString());
if (int.TryParse(dr["ReportFormat"].ToString(), out _int)) this.ReportFormat = _int;
if (DateTime.TryParse(dr["DOBFrom"].ToString(), out _datetime)) this.DOBFrom = _datetime;
if (DateTime.TryParse(dr["DOBTo"].ToString(), out _datetime)) this.DOBTo = _datetime;
if (int.TryParse(dr["AgeFrom"].ToString(), out _int)) this.AgeFrom = _int;
if (int.TryParse(dr["AgeTo"].ToString(), out _int)) this.AgeTo = _int;
this.SchoolGrade = dr["SchoolGrade"].ToString();
this.FirstName = dr["FirstName"].ToString();
this.LastName = dr["LastName"].ToString();
this.Gender = dr["Gender"].ToString();
this.EmailAddress = dr["EmailAddress"].ToString();
this.PhoneNumber = dr["PhoneNumber"].ToString();
this.City = dr["City"].ToString();
this.State = dr["State"].ToString();
this.ZipCode = dr["ZipCode"].ToString();
this.County = dr["County"].ToString();
if (int.TryParse(dr["PrimaryLibrary"].ToString(), out _int)) this.PrimaryLibrary = _int;
this.SchoolName = dr["SchoolName"].ToString();
this.District = dr["District"].ToString();
this.SDistrict = dr["SDistrict"].ToString();
this.Teacher = dr["Teacher"].ToString();
this.GroupTeamName = dr["GroupTeamName"].ToString();
if (int.TryParse(dr["SchoolType"].ToString(), out _int)) this.SchoolType = _int;
if (int.TryParse(dr["LiteracyLevel1"].ToString(), out _int)) this.LiteracyLevel1 = _int;
if (int.TryParse(dr["LiteracyLevel2"].ToString(), out _int)) this.LiteracyLevel2 = _int;
this.Custom1 = dr["Custom1"].ToString();
this.Custom2 = dr["Custom2"].ToString();
this.Custom3 = dr["Custom3"].ToString();
this.Custom4 = dr["Custom4"].ToString();
this.Custom5 = dr["Custom5"].ToString();
if (DateTime.TryParse(dr["RegistrationDateStart"].ToString(), out _datetime)) this.RegistrationDateStart = _datetime;
if (DateTime.TryParse(dr["RegistrationDateEnd"].ToString(), out _datetime)) this.RegistrationDateEnd = _datetime;
if (int.TryParse(dr["PointsMin"].ToString(), out _int)) this.PointsMin = _int;
if (int.TryParse(dr["PointsMax"].ToString(), out _int)) this.PointsMax = _int;
if (DateTime.TryParse(dr["PointsStart"].ToString(), out _datetime)) this.PointsStart = _datetime;
if (DateTime.TryParse(dr["PointsEnd"].ToString(), out _datetime)) this.PointsEnd = _datetime;
this.EventCode = dr["EventCode"].ToString();
if (int.TryParse(dr["EarnedBadge"].ToString(), out _int)) this.EarnedBadge = _int;
this.PhysicalPrizeEarned = dr["PhysicalPrizeEarned"].ToString();
this.PhysicalPrizeRedeemed = bool.Parse(dr["PhysicalPrizeRedeemed"].ToString());
if (DateTime.TryParse(dr["PhysicalPrizeStartDate"].ToString(), out _datetime)) this.PhysicalPrizeStartDate = _datetime;
if (DateTime.TryParse(dr["PhysicalPrizeEndDate"].ToString(), out _datetime)) this.PhysicalPrizeEndDate = _datetime;
if (int.TryParse(dr["ReviewsMin"].ToString(), out _int)) this.ReviewsMin = _int;
if (int.TryParse(dr["ReviewsMax"].ToString(), out _int)) this.ReviewsMax = _int;
this.ReviewTitle = dr["ReviewTitle"].ToString();
this.ReviewAuthor = dr["ReviewAuthor"].ToString();
if (DateTime.TryParse(dr["ReviewStartDate"].ToString(), out _datetime)) this.ReviewStartDate = _datetime;
if (DateTime.TryParse(dr["ReviewEndDate"].ToString(), out _datetime)) this.ReviewEndDate = _datetime;
this.RandomDrawingName = dr["RandomDrawingName"].ToString();
if (int.TryParse(dr["RandomDrawingNum"].ToString(), out _int)) this.RandomDrawingNum = _int;
if (DateTime.TryParse(dr["RandomDrawingStartDate"].ToString(), out _datetime)) this.RandomDrawingStartDate = _datetime;
if (DateTime.TryParse(dr["RandomDrawingEndDate"].ToString(), out _datetime)) this.RandomDrawingEndDate = _datetime;
this.HasBeenDrawn = bool.Parse(dr["HasBeenDrawn"].ToString());
this.HasRedeemend = bool.Parse(dr["HasRedeemend"].ToString());
this.PIDInc = bool.Parse(dr["PIDInc"].ToString());
this.UsernameInc = bool.Parse(dr["UsernameInc"].ToString());
this.DOBInc = bool.Parse(dr["DOBInc"].ToString());
this.AgeInc = bool.Parse(dr["AgeInc"].ToString());
this.SchoolGradeInc = bool.Parse(dr["SchoolGradeInc"].ToString());
this.FirstNameInc = bool.Parse(dr["FirstNameInc"].ToString());
this.LastNameInc = bool.Parse(dr["LastNameInc"].ToString());
this.GenderInc = bool.Parse(dr["GenderInc"].ToString());
this.EmailAddressInc = bool.Parse(dr["EmailAddressInc"].ToString());
this.PhoneNumberInc = bool.Parse(dr["PhoneNumberInc"].ToString());
this.CityInc = bool.Parse(dr["CityInc"].ToString());
this.StateInc = bool.Parse(dr["StateInc"].ToString());
this.ZipCodeInc = bool.Parse(dr["ZipCodeInc"].ToString());
this.CountyInc = bool.Parse(dr["CountyInc"].ToString());
this.PrimaryLibraryInc = bool.Parse(dr["PrimaryLibraryInc"].ToString());
this.SchoolNameInc = bool.Parse(dr["SchoolNameInc"].ToString());
this.DistrictInc = bool.Parse(dr["DistrictInc"].ToString());
this.SDistrictInc = bool.Parse(dr["SDistrictInc"].ToString());
this.TeacherInc = bool.Parse(dr["TeacherInc"].ToString());
this.GroupTeamNameInc = bool.Parse(dr["GroupTeamNameInc"].ToString());
this.SchoolTypeInc = bool.Parse(dr["SchoolTypeInc"].ToString());
this.LiteracyLevel1Inc = bool.Parse(dr["LiteracyLevel1Inc"].ToString());
this.LiteracyLevel2Inc = bool.Parse(dr["LiteracyLevel2Inc"].ToString());
this.Custom1Inc = bool.Parse(dr["Custom1Inc"].ToString());
this.Custom2Inc = bool.Parse(dr["Custom2Inc"].ToString());
this.Custom3Inc = bool.Parse(dr["Custom3Inc"].ToString());
this.Custom4Inc = bool.Parse(dr["Custom4Inc"].ToString());
this.Custom5Inc = bool.Parse(dr["Custom5Inc"].ToString());
this.RegistrationDateInc = bool.Parse(dr["RegistrationDateInc"].ToString());
this.PointsInc = bool.Parse(dr["PointsInc"].ToString());
this.EarnedBadgeInc = bool.Parse(dr["EarnedBadgeInc"].ToString());
this.PhysicalPrizeNameInc = bool.Parse(dr["PhysicalPrizeNameInc"].ToString());
this.PhysicalPrizeDateInc = bool.Parse(dr["PhysicalPrizeDateInc"].ToString());
this.NumReviewsInc = bool.Parse(dr["NumReviewsInc"].ToString());
this.ReviewAuthorInc = bool.Parse(dr["ReviewAuthorInc"].ToString());
this.ReviewTitleInc = bool.Parse(dr["ReviewTitleInc"].ToString());
this.ReviewDateInc = bool.Parse(dr["ReviewDateInc"].ToString());
this.RandomDrawingNameInc = bool.Parse(dr["RandomDrawingNameInc"].ToString());
this.RandomDrawingNumInc = bool.Parse(dr["RandomDrawingNumInc"].ToString());
this.RandomDrawingDateInc = bool.Parse(dr["RandomDrawingDateInc"].ToString());
this.HasBeenDrawnInc = bool.Parse(dr["HasBeenDrawnInc"].ToString());
this.HasRedeemendInc = bool.Parse(dr["HasRedeemendInc"].ToString());
if (DateTime.TryParse(dr["LastModDate"].ToString(), out _datetime)) this.LastModDate = _datetime;
this.LastModUser = dr["LastModUser"].ToString();
if (DateTime.TryParse(dr["AddedDate"].ToString(), out _datetime)) this.AddedDate = _datetime;
this.AddedUser = dr["AddedUser"].ToString();
if (int.TryParse(dr["TenID"].ToString(), out _int)) this.TenID = _int;
if (int.TryParse(dr["FldInt1"].ToString(), out _int)) this.FldInt1 = _int;
if (int.TryParse(dr["FldInt2"].ToString(), out _int)) this.FldInt2 = _int;
if (int.TryParse(dr["FldInt3"].ToString(), out _int)) this.FldInt3 = _int;
this.FldBit1 = bool.Parse(dr["FldBit1"].ToString());
this.FldBit2 = bool.Parse(dr["FldBit2"].ToString());
this.FldBit3 = bool.Parse(dr["FldBit3"].ToString());
this.FldText1 = dr["FldText1"].ToString();
this.FldText2 = dr["FldText2"].ToString();
this.FldText3 = dr["FldText3"].ToString();
if (int.TryParse(dr["Score1From"].ToString(), out _int)) this.Score1From = _int;
if (int.TryParse(dr["Score1To"].ToString(), out _int)) this.Score1To = _int;
if (int.TryParse(dr["Score1PctFrom"].ToString(), out _int)) this.Score1PctFrom = _int;
if (int.TryParse(dr["Score1PctTo"].ToString(), out _int)) this.Score1PctTo = _int;
if (int.TryParse(dr["Score2From"].ToString(), out _int)) this.Score2From = _int;
if (int.TryParse(dr["Score2To"].ToString(), out _int)) this.Score2To = _int;
if (int.TryParse(dr["Score2PctFrom"].ToString(), out _int)) this.Score2PctFrom = _int;
if (int.TryParse(dr["Score2PctTo"].ToString(), out _int)) this.Score2PctTo = _int;
this.Score1Inc = bool.Parse(dr["Score1Inc"].ToString());
this.Score2Inc = bool.Parse(dr["Score2Inc"].ToString());
this.Score1PctInc = bool.Parse(dr["Score1PctInc"].ToString());
this.Score2PctInc = bool.Parse(dr["Score2PctInc"].ToString());
dr.Close();
return true;
}
dr.Close();
return false;
}
public static int Delete(SRPReport o)
{
int iReturn = -1; //assume the worst
SqlParameter[] arrParams = new SqlParameter[1];
arrParams[0] = new SqlParameter("@RID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RID, o.RID.GetTypeCode()));
try
{
iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SRPReport_Delete", arrParams);
}
catch (SqlException exx)
{
System.Diagnostics.Debug.Write(exx.Message);
}
return iReturn;
}
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
}
public static int Update(SRPReport o)
{
int iReturn = -1; //assume the worst
SqlParameter[] arrParams = new SqlParameter[126];
arrParams[0] = new SqlParameter("@RID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RID, o.RID.GetTypeCode()));
arrParams[1] = new SqlParameter("@RTID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RTID, o.RTID.GetTypeCode()));
arrParams[2] = new SqlParameter("@ProgId", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ProgId, o.ProgId.GetTypeCode()));
arrParams[3] = new SqlParameter("@ReportName", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ReportName, o.ReportName.GetTypeCode()));
arrParams[4] = new SqlParameter("@DisplayFilters", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DisplayFilters, o.DisplayFilters.GetTypeCode()));
arrParams[5] = new SqlParameter("@ReportFormat", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ReportFormat, o.ReportFormat.GetTypeCode()));
arrParams[6] = new SqlParameter("@DOBFrom", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DOBFrom, o.DOBFrom.GetTypeCode()));
arrParams[7] = new SqlParameter("@DOBTo", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DOBTo, o.DOBTo.GetTypeCode()));
arrParams[8] = new SqlParameter("@AgeFrom", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AgeFrom, o.AgeFrom.GetTypeCode()));
arrParams[9] = new SqlParameter("@AgeTo", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AgeTo, o.AgeTo.GetTypeCode()));
arrParams[10] = new SqlParameter("@SchoolGrade", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SchoolGrade, o.SchoolGrade.GetTypeCode()));
arrParams[11] = new SqlParameter("@FirstName", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FirstName, o.FirstName.GetTypeCode()));
arrParams[12] = new SqlParameter("@LastName", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LastName, o.LastName.GetTypeCode()));
arrParams[13] = new SqlParameter("@Gender", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Gender, o.Gender.GetTypeCode()));
arrParams[14] = new SqlParameter("@EmailAddress", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.EmailAddress, o.EmailAddress.GetTypeCode()));
arrParams[15] = new SqlParameter("@PhoneNumber", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PhoneNumber, o.PhoneNumber.GetTypeCode()));
arrParams[16] = new SqlParameter("@City", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.City, o.City.GetTypeCode()));
arrParams[17] = new SqlParameter("@State", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.State, o.State.GetTypeCode()));
arrParams[18] = new SqlParameter("@ZipCode", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ZipCode, o.ZipCode.GetTypeCode()));
arrParams[19] = new SqlParameter("@County", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.County, o.County.GetTypeCode()));
arrParams[20] = new SqlParameter("@PrimaryLibrary", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PrimaryLibrary, o.PrimaryLibrary.GetTypeCode()));
arrParams[21] = new SqlParameter("@SchoolName", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SchoolName, o.SchoolName.GetTypeCode()));
arrParams[22] = new SqlParameter("@District", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.District, o.District.GetTypeCode()));
arrParams[23] = new SqlParameter("@Teacher", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Teacher, o.Teacher.GetTypeCode()));
arrParams[24] = new SqlParameter("@GroupTeamName", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.GroupTeamName, o.GroupTeamName.GetTypeCode()));
arrParams[25] = new SqlParameter("@SchoolType", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SchoolType, o.SchoolType.GetTypeCode()));
arrParams[26] = new SqlParameter("@LiteracyLevel1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LiteracyLevel1, o.LiteracyLevel1.GetTypeCode()));
arrParams[27] = new SqlParameter("@LiteracyLevel2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LiteracyLevel2, o.LiteracyLevel2.GetTypeCode()));
arrParams[28] = new SqlParameter("@Custom1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Custom1, o.Custom1.GetTypeCode()));
arrParams[29] = new SqlParameter("@Custom2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Custom2, o.Custom2.GetTypeCode()));
arrParams[30] = new SqlParameter("@Custom3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Custom3, o.Custom3.GetTypeCode()));
arrParams[31] = new SqlParameter("@Custom4", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Custom4, o.Custom4.GetTypeCode()));
arrParams[32] = new SqlParameter("@Custom5", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Custom5, o.Custom5.GetTypeCode()));
arrParams[33] = new SqlParameter("@RegistrationDateStart", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RegistrationDateStart, o.RegistrationDateStart.GetTypeCode()));
arrParams[34] = new SqlParameter("@RegistrationDateEnd", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RegistrationDateEnd, o.RegistrationDateEnd.GetTypeCode()));
arrParams[35] = new SqlParameter("@PointsMin", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PointsMin, o.PointsMin.GetTypeCode()));
arrParams[36] = new SqlParameter("@PointsMax", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PointsMax, o.PointsMax.GetTypeCode()));
arrParams[37] = new SqlParameter("@PointsStart", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PointsStart, o.PointsStart.GetTypeCode()));
arrParams[38] = new SqlParameter("@PointsEnd", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PointsEnd, o.PointsEnd.GetTypeCode()));
arrParams[39] = new SqlParameter("@EventCode", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.EventCode, o.EventCode.GetTypeCode()));
arrParams[40] = new SqlParameter("@EarnedBadge", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.EarnedBadge, o.EarnedBadge.GetTypeCode()));
arrParams[41] = new SqlParameter("@PhysicalPrizeEarned", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PhysicalPrizeEarned, o.PhysicalPrizeEarned.GetTypeCode()));
arrParams[42] = new SqlParameter("@PhysicalPrizeRedeemed", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PhysicalPrizeRedeemed, o.PhysicalPrizeRedeemed.GetTypeCode()));
arrParams[43] = new SqlParameter("@PhysicalPrizeStartDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PhysicalPrizeStartDate, o.PhysicalPrizeStartDate.GetTypeCode()));
arrParams[44] = new SqlParameter("@PhysicalPrizeEndDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PhysicalPrizeEndDate, o.PhysicalPrizeEndDate.GetTypeCode()));
arrParams[45] = new SqlParameter("@ReviewsMin", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ReviewsMin, o.ReviewsMin.GetTypeCode()));
arrParams[46] = new SqlParameter("@ReviewsMax", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ReviewsMax, o.ReviewsMax.GetTypeCode()));
arrParams[47] = new SqlParameter("@ReviewTitle", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ReviewTitle, o.ReviewTitle.GetTypeCode()));
arrParams[48] = new SqlParameter("@ReviewAuthor", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ReviewAuthor, o.ReviewAuthor.GetTypeCode()));
arrParams[49] = new SqlParameter("@ReviewStartDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ReviewStartDate, o.ReviewStartDate.GetTypeCode()));
arrParams[50] = new SqlParameter("@ReviewEndDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ReviewEndDate, o.ReviewEndDate.GetTypeCode()));
arrParams[51] = new SqlParameter("@RandomDrawingName", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RandomDrawingName, o.RandomDrawingName.GetTypeCode()));
arrParams[52] = new SqlParameter("@RandomDrawingNum", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RandomDrawingNum, o.RandomDrawingNum.GetTypeCode()));
arrParams[53] = new SqlParameter("@RandomDrawingStartDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RandomDrawingStartDate, o.RandomDrawingStartDate.GetTypeCode()));
arrParams[54] = new SqlParameter("@RandomDrawingEndDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RandomDrawingEndDate, o.RandomDrawingEndDate.GetTypeCode()));
arrParams[55] = new SqlParameter("@HasBeenDrawn", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.HasBeenDrawn, o.HasBeenDrawn.GetTypeCode()));
arrParams[56] = new SqlParameter("@HasRedeemend", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.HasRedeemend, o.HasRedeemend.GetTypeCode()));
arrParams[57] = new SqlParameter("@PIDInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PIDInc, o.PIDInc.GetTypeCode()));
arrParams[58] = new SqlParameter("@UsernameInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.UsernameInc, o.UsernameInc.GetTypeCode()));
arrParams[59] = new SqlParameter("@DOBInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DOBInc, o.DOBInc.GetTypeCode()));
arrParams[60] = new SqlParameter("@AgeInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AgeInc, o.AgeInc.GetTypeCode()));
arrParams[61] = new SqlParameter("@SchoolGradeInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SchoolGradeInc, o.SchoolGradeInc.GetTypeCode()));
arrParams[62] = new SqlParameter("@FirstNameInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FirstNameInc, o.FirstNameInc.GetTypeCode()));
arrParams[63] = new SqlParameter("@LastNameInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LastNameInc, o.LastNameInc.GetTypeCode()));
arrParams[64] = new SqlParameter("@GenderInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.GenderInc, o.GenderInc.GetTypeCode()));
arrParams[65] = new SqlParameter("@EmailAddressInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.EmailAddressInc, o.EmailAddressInc.GetTypeCode()));
arrParams[66] = new SqlParameter("@PhoneNumberInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PhoneNumberInc, o.PhoneNumberInc.GetTypeCode()));
arrParams[67] = new SqlParameter("@CityInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.CityInc, o.CityInc.GetTypeCode()));
arrParams[68] = new SqlParameter("@StateInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.StateInc, o.StateInc.GetTypeCode()));
arrParams[69] = new SqlParameter("@ZipCodeInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ZipCodeInc, o.ZipCodeInc.GetTypeCode()));
arrParams[70] = new SqlParameter("@CountyInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.CountyInc, o.CountyInc.GetTypeCode()));
arrParams[71] = new SqlParameter("@PrimaryLibraryInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PrimaryLibraryInc, o.PrimaryLibraryInc.GetTypeCode()));
arrParams[72] = new SqlParameter("@SchoolNameInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SchoolNameInc, o.SchoolNameInc.GetTypeCode()));
arrParams[73] = new SqlParameter("@DistrictInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.DistrictInc, o.DistrictInc.GetTypeCode()));
arrParams[74] = new SqlParameter("@TeacherInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.TeacherInc, o.TeacherInc.GetTypeCode()));
arrParams[75] = new SqlParameter("@GroupTeamNameInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.GroupTeamNameInc, o.GroupTeamNameInc.GetTypeCode()));
arrParams[76] = new SqlParameter("@SchoolTypeInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SchoolTypeInc, o.SchoolTypeInc.GetTypeCode()));
arrParams[77] = new SqlParameter("@LiteracyLevel1Inc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LiteracyLevel1Inc, o.LiteracyLevel1Inc.GetTypeCode()));
arrParams[78] = new SqlParameter("@LiteracyLevel2Inc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LiteracyLevel2Inc, o.LiteracyLevel2Inc.GetTypeCode()));
arrParams[79] = new SqlParameter("@Custom1Inc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Custom1Inc, o.Custom1Inc.GetTypeCode()));
arrParams[80] = new SqlParameter("@Custom2Inc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Custom2Inc, o.Custom2Inc.GetTypeCode()));
arrParams[81] = new SqlParameter("@Custom3Inc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Custom3Inc, o.Custom3Inc.GetTypeCode()));
arrParams[82] = new SqlParameter("@Custom4Inc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Custom4Inc, o.Custom4Inc.GetTypeCode()));
arrParams[83] = new SqlParameter("@Custom5Inc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Custom5Inc, o.Custom5Inc.GetTypeCode()));
arrParams[84] = new SqlParameter("@RegistrationDateInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RegistrationDateInc, o.RegistrationDateInc.GetTypeCode()));
arrParams[85] = new SqlParameter("@PointsInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PointsInc, o.PointsInc.GetTypeCode()));
arrParams[86] = new SqlParameter("@EarnedBadgeInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.EarnedBadgeInc, o.EarnedBadgeInc.GetTypeCode()));
arrParams[87] = new SqlParameter("@PhysicalPrizeNameInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PhysicalPrizeNameInc, o.PhysicalPrizeNameInc.GetTypeCode()));
arrParams[88] = new SqlParameter("@PhysicalPrizeDateInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.PhysicalPrizeDateInc, o.PhysicalPrizeDateInc.GetTypeCode()));
arrParams[89] = new SqlParameter("@NumReviewsInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.NumReviewsInc, o.NumReviewsInc.GetTypeCode()));
arrParams[90] = new SqlParameter("@ReviewAuthorInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ReviewAuthorInc, o.ReviewAuthorInc.GetTypeCode()));
arrParams[91] = new SqlParameter("@ReviewTitleInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ReviewTitleInc, o.ReviewTitleInc.GetTypeCode()));
arrParams[92] = new SqlParameter("@ReviewDateInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.ReviewDateInc, o.ReviewDateInc.GetTypeCode()));
arrParams[93] = new SqlParameter("@RandomDrawingNameInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RandomDrawingNameInc, o.RandomDrawingNameInc.GetTypeCode()));
arrParams[94] = new SqlParameter("@RandomDrawingNumInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RandomDrawingNumInc, o.RandomDrawingNumInc.GetTypeCode()));
arrParams[95] = new SqlParameter("@RandomDrawingDateInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.RandomDrawingDateInc, o.RandomDrawingDateInc.GetTypeCode()));
arrParams[96] = new SqlParameter("@HasBeenDrawnInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.HasBeenDrawnInc, o.HasBeenDrawnInc.GetTypeCode()));
arrParams[97] = new SqlParameter("@HasRedeemendInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.HasRedeemendInc, o.HasRedeemendInc.GetTypeCode()));
arrParams[98] = new SqlParameter("@LastModDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LastModDate, o.LastModDate.GetTypeCode()));
arrParams[99] = new SqlParameter("@LastModUser", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.LastModUser, o.LastModUser.GetTypeCode()));
arrParams[100] = new SqlParameter("@AddedDate", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AddedDate, o.AddedDate.GetTypeCode()));
arrParams[101] = new SqlParameter("@AddedUser", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.AddedUser, o.AddedUser.GetTypeCode()));
arrParams[102] = new SqlParameter("@SDistrict", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SDistrict, o.SDistrict.GetTypeCode()));
arrParams[103] = new SqlParameter("@SDistrictInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.SDistrictInc, o.SDistrictInc.GetTypeCode()));
arrParams[104] = new SqlParameter("@TenID", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.TenID, o.TenID.GetTypeCode()));
arrParams[105] = new SqlParameter("@FldInt1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt1, o.FldInt1.GetTypeCode()));
arrParams[106] = new SqlParameter("@FldInt2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt2, o.FldInt2.GetTypeCode()));
arrParams[107] = new SqlParameter("@FldInt3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldInt3, o.FldInt3.GetTypeCode()));
arrParams[108] = new SqlParameter("@FldBit1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit1, o.FldBit1.GetTypeCode()));
arrParams[109] = new SqlParameter("@FldBit2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit2, o.FldBit2.GetTypeCode()));
arrParams[110] = new SqlParameter("@FldBit3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldBit3, o.FldBit3.GetTypeCode()));
arrParams[111] = new SqlParameter("@FldText1", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText1, o.FldText1.GetTypeCode()));
arrParams[112] = new SqlParameter("@FldText2", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText2, o.FldText2.GetTypeCode()));
arrParams[113] = new SqlParameter("@FldText3", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.FldText3, o.FldText3.GetTypeCode()));
arrParams[114] = new SqlParameter("@Score1From", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Score1From, o.Score1From.GetTypeCode()));
arrParams[115] = new SqlParameter("@Score1To", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Score1To, o.Score1To.GetTypeCode()));
arrParams[116] = new SqlParameter("@Score1PctFrom", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Score1PctFrom, o.Score1PctFrom.GetTypeCode()));
arrParams[117] = new SqlParameter("@Score1PctTo", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Score1PctTo, o.Score1PctTo.GetTypeCode()));
arrParams[118] = new SqlParameter("@Score2From", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Score2From, o.Score2From.GetTypeCode()));
arrParams[119] = new SqlParameter("@Score2To", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Score2To, o.Score2To.GetTypeCode()));
arrParams[120] = new SqlParameter("@Score2PctFrom", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Score2PctFrom, o.Score2PctFrom.GetTypeCode()));
arrParams[121] = new SqlParameter("@Score2PctTo", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Score2PctTo, o.Score2PctTo.GetTypeCode()));
arrParams[122] = new SqlParameter("@Score1Inc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Score1Inc, o.Score1Inc.GetTypeCode()));
arrParams[123] = new SqlParameter("@Score2Inc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Score2Inc, o.Score2Inc.GetTypeCode()));
arrParams[124] = new SqlParameter("@Score1PctInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Score1PctInc, o.Score1PctInc.GetTypeCode()));
arrParams[125] = new SqlParameter("@Score2PctInc", GRA.SRP.Core.Utilities.GlobalUtilities.DBSafeValue(o.Score2PctInc, o.Score2PctInc.GetTypeCode()));
try
{
iReturn = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "app_SRPReport_Update", arrParams);
}
catch (SqlException exx)
{
System.Diagnostics.Debug.Write(exx.Message);
}
return iReturn;
}
protected void GvRowCommand(object sender, GridViewCommandEventArgs e)
{
string editpage = "~/ControlRoom/Modules/Reports/ReportAddEdit.aspx";
if (e.CommandName.ToLower() == "addrecord")
{
Session["RID"]= string.Empty; Response.Redirect(editpage);
}
if (e.CommandName.ToLower() == "editrecord")
{
int key = Convert.ToInt32(e.CommandArgument);
Session["RID"] = key; Response.Redirect(editpage);
}
if (e.CommandName.ToLower() == "deleterecord")
{
var key = Convert.ToInt32(e.CommandArgument);
try
{
var obj = new SRPReport();
if (obj.IsValid(BusinessRulesValidationMode.DELETE))
{
SRPReport.FetchObject(key).Delete();
LoadData();
var masterPage = (IControlRoomMaster)Master;
if (masterPage != null) masterPage.PageMessage = SRPResources.DeleteOK;
}
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);
if (masterPage != null) masterPage.PageError = message;
}
}
catch (Exception ex)
{
var masterPage = (IControlRoomMaster)Master;
if (masterPage != null)
masterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message);
}
}
}