protected void Page_Load(object sender, EventArgs e)
{
// Check user authorised!
string UserEmail = "";
string UserID = "";
// Read System Cookie for User Email / ID
HttpCookie myTestCookie = new HttpCookie("UKFilmLocationAdmin");
myTestCookie = Request.Cookies["UKFilmLocationAdmin"];
// Read the cookie information and display it.
if (myTestCookie != null)
{
// User details collected
UserEmail = myTestCookie.Value;
}
else
{
// No user cookie redirect to login
Response.Redirect("/");
}
// Continue normal programming
string thisOp = Request.QueryString["Op"];
// Get Messages
// Check details against DB
DBConnection = new MySqlConnection(objUKFilmLocation.DBConnect);
DBCommand = DBConnection.CreateCommand();
UK_Film_Location_Class.UserDetails objUser = new UK_Film_Location_Class.UserDetails();
objUser.getUserFromEmail(UserEmail);
UserID = objUser.UserID;
// Get Tasks
int myCount = 0;
switch (thisOp)
{
case "AllTasks":
TableHeaderLiteral.Text = "<tr><th>User</th><th>Task</th><th width=\"150\">Date Created</th><th width=\"180\"></th></tr>";
DBConnection.Open();
DBCommand.CommandText = "select Tasks.*, userdetails.firstname from Tasks left join Userdetails on userdetails.UserID = Tasks.AssignedUserID where IsComplete = 0 order by DateAdded asc;";
DBResult = DBCommand.ExecuteReader();
Messages.Text = "";
myCount = 0;
while (DBResult.Read())
{
string isAction = "";
if (!string.IsNullOrEmpty(DBResult["TaskAction"].ToString()))
{
isAction = "<a href=\"/" + UK_Film_Location_Class.UKFilmLocation.getTaskFromAction(DBResult["TaskAction"].ToString(), DBResult["TaskAttributes"].ToString()) + "\" class=\"btn-default btn\">Do</a> ";
}
Messages.Text += "<tr><td scope=\"row\">" + DBResult["FirstName"].ToString() + "</td><td>" + DBResult["Task"].ToString() + "</td><td>" + DBResult["DateAdded"].ToString() + "</td><td align=\"right\">" + isAction + "<a href=\"javascript:if (confirm('Are you sure you want to sign off this task?')) {document.location.href='/completetask.aspx?TaskID=" + DBResult["RecordID"].ToString() + "';}\" class=\"btn-default btn\">Complete</a></td></tr>";
myCount++;
}
DBResult.Close();
DBConnection.Close();
StatsLiteral.Text += "Outstanding Tasks : " + myCount + "<br>";
break;
case "LocationTasks":
DBConnection.Open();
DBCommand.CommandText = "select * from Locations where Approved = 0 and Removed = 0 order by RecordID desc;";
DBResult = DBCommand.ExecuteReader();
Messages.Text = "";
myCount = 0;
while (DBResult.Read())
{
string thisAction = "";
TableHeaderLiteral.Text = "<tr><th>Task</th><th width=\"50\"></th></tr>";
thisAction += "This property needs to be approved!<br>";
if (string.IsNullOrEmpty(DBResult["LocationID"].ToString()))
{
thisAction += "This property needs an ID!<br>";
}
string thisPath = "";
thisPath = Server.MapPath("~/Locations/") + "/" + DBResult["LocationID"].ToString() + "/" + DBResult["LocationID"].ToString() + "_1-64x64.jpg";
if (!File.Exists(thisPath))
{
thisAction += "This property needs an image!";
}
if (!string.IsNullOrEmpty(thisAction))
{
Messages.Text += "<tr><td scope=\"row\"><a href=\"/LocationDetails.aspx?RecordID=" + DBResult["RecordID"].ToString() + "\">Location : " + DBResult["LocationID"].ToString() + " - " + DBResult["Title"].ToString() + "<br>" + thisAction + "</a></td><td><a href=\"/LocationDetails.aspx?RecordID=" + DBResult["RecordID"].ToString() + "\" class=\"btn-default btn\">Do</a></td></tr>";
}
myCount++;
}
DBResult.Close();
DBConnection.Close();
StatsLiteral.Text += "Locations needing approval : " + myCount + "<br>";
// Check Images
DBConnection.Open();
DBCommand.CommandText = "select Locations.RecordID, Locations.LocationID, Locations.Title, (select count(*) from LocationImages where locationimages.LocationID = locations.LocationID ) as NumRecs from Locations where Approved = 1 order by RecordID asc;";
DBResult = DBCommand.ExecuteReader();
myCount = 0;
while (DBResult.Read())
{
string thisAction = "";
if (DBResult["NumRecs"].ToString() == "0")
{
thisAction = "Location : " + DBResult["LocationID"].ToString() + " - " + DBResult["Title"].ToString() + "<br>This location needs an image!";
}
if (!string.IsNullOrEmpty(thisAction))
{
Messages.Text += "<tr><th scope=\"row\"><a href=\"/LocationDetails.aspx?RecordID=" + DBResult["RecordID"].ToString() + "\">" + thisAction + "</a></td><td><a href=\"/LocationDetails.aspx?RecordID=" + DBResult["RecordID"].ToString() + "\" class=\"btn-default btn\">Do</a></td></tr>";
myCount++;
}
}
DBResult.Close();
DBConnection.Close();
StatsLiteral.Text += "Locations needing images : " + myCount + "<br>";
break;
case "KitchenTasks":
// Check Images
DBConnection.Open();
DBCommand.CommandText = "SELECT distinct(Locations.LocationID), locations.Title, locations.RecordID, (select COUNT(LocationImages.LocationID) from LocationImages where LocationImages.LocationID = Locations.LocationID and LocationImages.Target = 'Kitchen') AS ImageCount, Locations.Approved FROM Locations LEFT JOIN LocationImages on Locations.LocationID = LocationImages.LocationID where Locations.Approved = 1 and (not Locations.kitchentype = '' and not Locations.kitchentype is null) having ImageCount = 0;";
DBResult = DBCommand.ExecuteReader();
myCount = 0;
while (DBResult.Read())
{
string thisAction = "";
if (DBResult["ImageCount"].ToString() == "0")
{
thisAction = "Location : " + DBResult["LocationID"].ToString() + " - " + DBResult["Title"].ToString() + "<br>This location needs an image!";
}
if (!string.IsNullOrEmpty(thisAction))
{
Messages.Text += "<tr><th scope=\"row\"><a href=\"/LocationDetails.aspx?RecordID=" + DBResult["RecordID"].ToString() + "\">" + thisAction + "</a></td><td><a href=\"/LocationDetails.aspx?RecordID=" + DBResult["RecordID"].ToString() + "\" class=\"btn-default btn\">Do</a></td></tr>";
myCount++;
}
}
DBResult.Close();
DBConnection.Close();
StatsLiteral.Text += "Kitchen locations needing images : " + myCount + "<br>";
break;
case "WarehouseTasks":
// Check Images
DBConnection.Open();
DBCommand.CommandText = "SELECT distinct(Locations.LocationID), locations.Title, locations.RecordID, (select COUNT(LocationImages.LocationID) from LocationImages where LocationImages.LocationID = Locations.LocationID and LocationImages.Target = 'Warehouse') AS ImageCount, Locations.Approved FROM Locations LEFT JOIN LocationImages on Locations.LocationID = LocationImages.LocationID where Locations.Approved = 1 and Locations.TypeID like '%2162%' having ImageCount = 0;";
DBResult = DBCommand.ExecuteReader();
myCount = 0;
while (DBResult.Read())
{
string thisAction = "";
if (DBResult["ImageCount"].ToString() == "0")
{
thisAction = "Location : " + DBResult["LocationID"].ToString() + " - " + DBResult["Title"].ToString() + "<br>This location needs an image selected!";
}
if (!string.IsNullOrEmpty(thisAction))
{
Messages.Text += "<tr><th scope=\"row\"><a href=\"/LocationDetails.aspx?RecordID=" + DBResult["RecordID"].ToString() + "\">" + thisAction + "</a></td><td><a href=\"/LocationDetails.aspx?RecordID=" + DBResult["RecordID"].ToString() + "\" class=\"btn-default btn\">Do</a></td></tr>";
myCount++;
}
}
DBResult.Close();
DBConnection.Close();
StatsLiteral.Text += "Warehouse locations needing images selecting : " + myCount + "<br>";
break;
case "AddressTasks":
// Check Images
DBConnection.Open();
DBCommand.CommandText = "SELECT distinct(Locations.LocationID), locations.Title, locations.RecordID FROM Locations where Removed = 0 and (Locations.Address = '' or Locations.Address is null or Locations.Postcode = '' or Locations.Postcode is null);";
DBResult = DBCommand.ExecuteReader();
myCount = 0;
while (DBResult.Read())
{
string thisAction = "";
thisAction = "Location : " + DBResult["LocationID"].ToString() + " - " + DBResult["Title"].ToString() + "<br>This location needs address details checked!";
if (!string.IsNullOrEmpty(thisAction))
{
Messages.Text += "<tr><th scope=\"row\"><a href=\"/LocationDetails.aspx?RecordID=" + DBResult["RecordID"].ToString() + "\">" + thisAction + "</a></td><td><a href=\"/LocationDetails.aspx?RecordID=" + DBResult["RecordID"].ToString() + "\" class=\"btn-default btn\">Do</a></td></tr>";
myCount++;
}
}
DBResult.Close();
DBConnection.Close();
StatsLiteral.Text += "Locations needing address details : " + myCount + "<br>";
break;
case "MissingEmail":
// Check Images
DBConnection.Open();
DBCommand.CommandText = "SELECT ContactID, Name, Email, Tel, Mobile, RecordID FROM Contacts where email is null or email = '';";
DBResult = DBCommand.ExecuteReader();
myCount = 0;
while (DBResult.Read())
{
string thisAction = "";
thisAction = DBResult["Name"].ToString() + "<br>Tel : " + DBResult["Tel"].ToString() + "<br>Mobile : " + DBResult["Mobile"].ToString() + "<br>This contact needs details checked!";
if (!string.IsNullOrEmpty(thisAction))
{
Messages.Text += "<tr><th scope=\"row\"><a href=\"/ContactDetails.aspx?ContactID=" + DBResult["ContactID"].ToString() + "\">" + thisAction + "</a></td><td><a href=\"/ContactDetails.aspx?ContactID=" + DBResult["ContactID"].ToString() + "\" class=\"btn-default btn\">Do</a></td></tr>";
myCount++;
}
}
DBResult.Close();
DBConnection.Close();
StatsLiteral.Text += "Locations needing address details : " + myCount + "<br>";
break;
default:
TableHeaderLiteral.Text = "<tr><th colspan=\"2\">Task</th><th width=\"150\">Date Created</th><th width=\"180\"></th></tr>";
DBConnection.Open();
if (objUser.isAgent) DBCommand.CommandText = "select * from Tasks where (AssignedUserID = '" + UserID + "') and IsComplete = 0 order by DateAdded asc;";
else DBCommand.CommandText = "select * from Tasks where (AssignedUserID = '" + UserID + "' or AssignedUserID = '0') and IsComplete = 0 order by DateAdded asc;";
DBResult = DBCommand.ExecuteReader();
Messages.Text = "";
myCount = 0;
while (DBResult.Read())
{
string isAction = "";
if (!string.IsNullOrEmpty(DBResult["TaskAction"].ToString()))
{
isAction = "<a href=\"/" + UK_Film_Location_Class.UKFilmLocation.getTaskFromAction(DBResult["TaskAction"].ToString(), DBResult["TaskAttributes"].ToString()) + "\" class=\"btn-default btn\">Do</a> ";
}
UK_Film_Location_Class.Tasks objTask = new UK_Film_Location_Class.Tasks();
objTask.getTask(Convert.ToInt32(DBResult["RecordID"].ToString()));
Messages.Text += "<tr><td scope=\"row\" width=\"36\">" + UK_Film_Location_Class.Tasks.getTaskPriorityIcon(Convert.ToInt32(DBResult["Priority"].ToString()), 32) + "</td><td>" + objTask.Text + "</td><td>" + DBResult["DateAdded"].ToString() + "</td><td>" + isAction + "<a href=\"javascript:if (confirm('Are you sure you want to sign off this task?')) {document.location.href='/completetask.aspx?TaskID=" + DBResult["RecordID"].ToString() + "';}\" class=\"btn-default btn\">Complete</a></td></tr>";
myCount++;
}
DBResult.Close();
DBConnection.Close();
StatsLiteral.Text += "Outstanding Tasks : " + myCount + "<br>";
break;
}
DBConnection.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
// Get UserID
string UserID = "";
string UserEmail = "";
HttpCookie myTestCookie = new HttpCookie("UKFilmLocationAdmin");
myTestCookie = Request.Cookies["UKFilmLocationAdmin"];
// Read the cookie information and display it.
if (myTestCookie != null)
{
// User details collected
UserEmail = myTestCookie.Value;
}
else
{
// No user cookie redirect to login
Response.Redirect("/");
}
UserID = UK_Film_Location_Class.UKFilmLocation.getUserFromEmail(myTestCookie.Value);
GlobalData.Text = "<script>UserID = '" + UserID + "';</script>";
DBConnection = new MySqlConnection(objUKFilmLocation.DBConnect);
DBCommand = DBConnection.CreateCommand();
ImmediateTasksLiteral.Text = "";
DBConnection.Open();
DBCommand.CommandText = "SELECT RecordID from tasks where DateComplete is null and (TaskAction = 'CHECK NEW LOCATION' or TaskAction = 'RECCE REQUEST' or TaskAction = 'CHECK NEW IMAGES' or TaskAction = 'NEW LOCATION' or TaskAction = 'APPROVE IMAGES') order by recordid desc limit 0, 5;";
DBResult = DBCommand.ExecuteReader();
while (DBResult.Read())
{
UK_Film_Location_Class.Tasks objTask = new UK_Film_Location_Class.Tasks();
objTask.getTask(Convert.ToInt32(DBResult["RecordID"].ToString()));
ImmediateTasksLiteral.Text += "<a href=\"" + UK_Film_Location_Class.Tasks.getTaskActionLink(objTask.TaskAction, objTask.TaskAttributes) + "\">";
ImmediateTasksLiteral.Text += "<div class=\"online-top\">";
ImmediateTasksLiteral.Text += "<div class=\"top-at\" style=\"margin-top: 5px;\">";
// Change icon if possible
string thisIcon = "";
// thisIcon = UK_Film_Location_Class.Tasks.getTaskAlternativeIcon(objTask.TaskAction, objTask.TaskAttributes, 64);
if (string.IsNullOrEmpty(thisIcon)) ImmediateTasksLiteral.Text += UK_Film_Location_Class.Tasks.getTaskPriorityIcon(Convert.ToInt32(objTask.RecordID), 64);
ImmediateTasksLiteral.Text += thisIcon + "</div>";
ImmediateTasksLiteral.Text += "<div class=\"top-on\">";
ImmediateTasksLiteral.Text += "<div class=\"top-on1\">";
ImmediateTasksLiteral.Text += "<p>"+ objTask.Task +"</p>";
ImmediateTasksLiteral.Text += "<span>" + UK_Film_Location_Class.Tasks.getTaskDetails(objTask.TaskAction, objTask.TaskAttributes) + "</span>";
ImmediateTasksLiteral.Text += "</div>";
ImmediateTasksLiteral.Text += "<span style=\"display: block; clear: both;\"><a href=\"javascript:if (confirm('Are you sure you want to sign off this task?')) {document.location.href='/completetask.aspx?Op=/Dashboard.aspx&TaskID=" + objTask.RecordID + "';}\" class=\"btn-default btn\">Done!</a></span>";
ImmediateTasksLiteral.Text += "<label class=\"round\"></label>";
ImmediateTasksLiteral.Text += "<div class=\"clearfix\"></div>";
ImmediateTasksLiteral.Text += "</div>";
ImmediateTasksLiteral.Text += "<div class=\"clearfix\"></div>";
ImmediateTasksLiteral.Text += "</div>";
ImmediateTasksLiteral.Text += "</a>";
}
DBResult.Close();
DBConnection.Close();
DBConnection.Dispose();
}
