protected void Page_Load(object sender, EventArgs e)
{
Master.HideAllFilters = true;
if (RequestVars.Get("a", 0) == 1)
{
Response.Clear();
switch (RequestVars.Get("t", 0))
{
case 1: //Remove
int propSurvReaID = RequestVars.Post("p", -1);
int userID = RequestVars.Post("u", -1);
int sendType = RequestVars.Post("s", -1);
if (propSurvReaID != -1 && userID != -1 && sendType != -1)
{
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
int rows = sql.NonQuery(
@"DELETE FROM [tblNotificationUsers] WHERE [PropertySurveyReasonID] = @PropertySurveyReasonID AND [UserID] = @UserID AND [SendType] = @SendType",
new SQLParamList().Add("@PropertySurveyReasonID", propSurvReaID)
.Add("@UserID", userID)
.Add("@SendType", sendType)
);
if (!sql.HasError)
{
if (rows != 0)
{
Response.Write(new JSONBuilder().AddInt("s", 0));
}
else
{
Response.Write(new JSONBuilder().AddInt("s", 4).AddString("msg", "No matching records found. Refresh the page to see the most up to date information."));
}
}
else
{
Response.Write(new JSONBuilder().AddInt("s", 3).AddString("msg", "There was a problem contacting the database. Please try again. (ENM105)"));
}
}
else
{
Response.Write(new JSONBuilder().AddInt("s", 2).AddString("msg", "Invalid values specified."));
}
break;
case 2: //Get user list
propSurvReaID = RequestVars.Get("p", -1);
if (propSurvReaID != -1)
{
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
DataTable dt = sql.QueryDataTable(@"
SELECT [UserID],[FirstName],[LastName]
FROM [tblCOM_Users]
WHERE [UserID] NOT IN (SELECT [UserID] FROM [tblNotificationUsers] WHERE [PropertySurveyReasonID] = @PSRID )
AND [Active] = 1
ORDER BY [FirstName], [LastName]",
new SqlParameter("@PSRID", propSurvReaID));
if (!sql.HasError)
{
JSONBuilder jb = new JSONBuilder().AddInt("s", 0);
jb.AddArray("ubh");
foreach (DataRow dr in dt.Rows)
{
jb.AddObject()
.AddInt("i", (int)dr["UserID"])
.AddString("n", dr["FirstName"].ToString() + " " + dr["LastName"].ToString())
.CloseObject();
}
jb.CloseArray();
Response.Write(jb);
}
else
{
Response.Write(new JSONBuilder().AddInt("s", 3).AddString("msg", "There was a problem contacting the database. Please try again. (ENM106)"));
}
}
else
{
Response.Write(new JSONBuilder().AddInt("s", 2).AddString("msg", "Invalid values specified."));
}
break;
default:
Response.Write(new JSONBuilder().AddInt("s", 1).AddString("msg", "Invalid type specified."));
break;
}
Response.End();
return;
}
if (!IsPostBack)
{
//Hide reason by default. Can only be shown if Property and Survey are changed.
ddlReason.Visible = false;
}
else
{
lblReasonError.Text = String.Empty;
}
}