protected void SaveBtn_Click(object sender, EventArgs e)
{
bool isOK = true;
UK_Film_Location_Class.RecceDates objRecceDate = new UK_Film_Location_Class.RecceDates();
if (string.IsNullOrEmpty(RecceDate.Text))
{
isOK = false;
RecceDatePanel.CssClass = "has-error";
}
else
{
RecceDatePanel.CssClass = "";
}
if (string.IsNullOrEmpty(RecceTime.Text))
{
isOK = false;
RecceTimePanel.CssClass = "has-error";
}
else
{
RecceTimePanel.CssClass = "";
}
if (isOK)
{
if (!string.IsNullOrEmpty(Request.QueryString["RecceID"]))
{
objRecceDate.getRecceAppointment(Request.QueryString["RecceID"]);
}
objRecceDate.RecceDate = DateTime.Parse(RecceDate.Text);
objRecceDate.Time = RecceTime.Text;
objRecceDate.Purpose = ReccePurposeDropDownList.SelectedValue;
objRecceDate.Notes = RecceNotes.Text;
if (!string.IsNullOrEmpty(Request.QueryString["OpportunityID"]))
{
objRecceDate.OpportunityID = Request.QueryString["OpportunityID"];
}
// Save Record
objRecceDate.Save();
if (!string.IsNullOrEmpty(objRecceDate.OpportunityID))
{
Response.Redirect("/OpportunityDetails.aspx?OpportunityID=" + objRecceDate.OpportunityID);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
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("/");
}
if (!IsPostBack)
{
DBConnection = new MySqlConnection(objUKFilmLocation.DBConnect);
DBCommand = DBConnection.CreateCommand();
string thisOpportunityID = Request.QueryString["OpportunityID"];
string thisRecceID = Request.QueryString["RecceID"];
UK_Film_Location_Class.RecceDates objRecceDate = new UK_Film_Location_Class.RecceDates();
UK_Film_Location_Class.OpportunityDetails objOpportunity = new UK_Film_Location_Class.OpportunityDetails();
UK_Film_Location_Class.LocationDetails objLocation = new UK_Film_Location_Class.LocationDetails();
UK_Film_Location_Class.ContactDetails objLocationContact = new UK_Film_Location_Class.ContactDetails();
UK_Film_Location_Class.ContactDetails objProjectCompany = new UK_Film_Location_Class.ContactDetails();
UK_Film_Location_Class.ProjectDetails objProject = new UK_Film_Location_Class.ProjectDetails();
if (!string.IsNullOrEmpty(thisRecceID))
{
objRecceDate.getRecceAppointment(thisRecceID);
thisOpportunityID = objRecceDate.OpportunityID;
RecceDate.Text = UK_Film_Location_Class.UKFilmLocation.makeSQLShortDate(objRecceDate.RecceDate.ToShortDateString());
RecceTime.Text = objRecceDate.Time;
RecceNotes.Text = objRecceDate.Notes;
}
else
{
RecceDate.Text = UK_Film_Location_Class.UKFilmLocation.makeSQLShortDate(DateTime.Now.ToShortDateString() );
RecceTime.Text = "00:00";
}
objOpportunity.getOpportunity(thisOpportunityID);
objLocation.getLocationFromID(objOpportunity.LocationID);
objLocationContact.getContact(objLocation.ContactID);
objProjectCompany.getContact(objOpportunity.ContactID);
objProject.getProjectDetails(objOpportunity.ProjectID);
if (objRecceDate.RecordID > 0)
{
ViewReccePDFLiteral.Text = " <a target=\"_blank\" href=\"http://ukfilmlocation.com/RecceAppointment.php?RecceDateID=" + objRecceDate.RecordID + "&Recipient=" + objProjectCompany.ContactID + "\" class=\"btn-default btn\">View Recce PDF <i class=\"fa fa-file-pdf-o\" title=\"Contact Details\"></i></a>";
}
JobRefLiteral.Text = "<a href=\"/OpportunityDetails.aspx?OpportunityID=" + objOpportunity.OpportunityID + "\">J" + objProject.RecordID + " / " + objOpportunity.LocationID + " <i class=\"fa fa-external-link-square\" title=\"Opportunity Details\"></i></a>";
LocationLiteral.Text = "<p>Recce request for location <b><a href=\"/LocationDetails.aspx?LocationID=" + objLocation.LocationID + "\">" + objLocation.LocationID + " <i class=\"fa fa-external-link-square\" title=\"Location Details\"></i></a></b><br>" + objLocation.Title + "</p><br><br><p>Job Ref : <a href=\"/OpportunityDetails.aspx?OpportunityID=" + objOpportunity.OpportunityID + "\">J" + objProject.RecordID + " - " + objProject.WorkingTitle + " <i class=\"fa fa-external-link-square\" title=\"Opportunity Details\"></i></a></p><p>Location Contact : <a href=\"/ContactDetails.aspx?ContactID=" + objLocationContact.ContactID + "\">" + objLocationContact.Name + " <i class=\"fa fa-external-link-square\" title=\"Contact Details\"></i></a><br>Tel : " + objLocationContact.Tel + "<br>Mobile : " + objLocationContact.Mobile + "<br>Email : " + objLocationContact.Email + "</p><br><br><p>Project Company Contact : <a href=\"/ContactDetails.aspx?ContactID=" + objProjectCompany.ContactID + "\">" + objProjectCompany.Name + " <i class=\"fa fa-external-link-square\" title=\"Contact Details\"></i></a><br>Tel : " + objProjectCompany.Tel + "<br>Mobile : " + objProjectCompany.Mobile + "<br>Email : " + objProjectCompany.Email + "</p>";
// Populate Purpose Drop down
DBConnection.Open();
DBCommand.CommandText = "select RecordID, value from ReccePurposes;";
DBResult = DBCommand.ExecuteReader();
DataTable myData = new DataTable();
myData.Load(DBResult);
DataView myview = myData.DefaultView;
myview.Sort = "RecordID asc";
DBResult.Close();
DBConnection.Close();
ReccePurposeDropDownList.DataSource = myview;
ReccePurposeDropDownList.DataTextField = "Value";
ReccePurposeDropDownList.DataValueField = "Value";
ReccePurposeDropDownList.DataBind();
ReccePurposeDropDownList.SelectedValue = objRecceDate.Purpose;
//ListItem list = new ListItem();
//list = new ListItem();
//list.Text = "Other";
//list.Value = "";
//ReccePurposeDropDownList.Items.Add(list);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string thisID = Request.QueryString["RecceID"];
if (!string.IsNullOrEmpty(thisID))
{
string Message = "";
HttpCookie myTestCookie = new HttpCookie("UKFilmLocationAdmin");
myTestCookie = Request.Cookies["UKFilmLocationAdmin"];
UK_Film_Location_Class.UserDetails objUser = new UK_Film_Location_Class.UserDetails();
objUser.getUserFromEmail(myTestCookie.Value);
UK_Film_Location_Class.RecceDates objRecce = new UK_Film_Location_Class.RecceDates();
objRecce.getRecceAppointment(thisID);
UK_Film_Location_Class.OpportunityDetails objOpportunity = new UK_Film_Location_Class.OpportunityDetails();
objOpportunity.getOpportunity(objRecce.OpportunityID);
UK_Film_Location_Class.ContactDetails objProductionContact = new UK_Film_Location_Class.ContactDetails();
objProductionContact.getContact(objOpportunity.ContactID);
UK_Film_Location_Class.LocationDetails objLocation = new UK_Film_Location_Class.LocationDetails();
objLocation.getLocationFromID(objOpportunity.LocationID);
UK_Film_Location_Class.ContactDetails objLocationContact = new UK_Film_Location_Class.ContactDetails();
objLocationContact.getContact(objLocation.ContactID);
// Check Fields
// Update or Create Record
DBConnection = new MySqlConnection(objUKFilmLocation.DBConnect);
DBCommand = DBConnection.CreateCommand();
// Location Address
string thisAddress = "";
if (!string.IsNullOrEmpty(objLocation.Address)) thisAddress += objLocation.Address;
if (!string.IsNullOrEmpty(objLocation.Street)) thisAddress += ", " + objLocation.Street;
if (!string.IsNullOrEmpty(objLocation.Town)) thisAddress += ", " + objLocation.Town;
if (!string.IsNullOrEmpty(objLocation.County)) thisAddress += ", " + objLocation.County;
if (!string.IsNullOrEmpty(objLocation.Postcode)) thisAddress += ", " + objLocation.Postcode;
DBConnection.Open();
// Update Record
DBCommand.CommandText = "update Tasks set IsComplete = '1', DateComplete = '" + UK_Film_Location_Class.UKFilmLocation.makeSQLDate(DateTime.Now.ToString()) + "' where TaskAttributes = '" + thisID + "' and TaskAction = 'RECCE REQUEST'";
DBCommand.ExecuteNonQuery();
DBConnection.Close();
DBConnection.Open();
// Update Record
DBCommand.CommandText = "update RecceDates set EmailSent = '" + UK_Film_Location_Class.UKFilmLocation.makeSQLDate(DateTime.Now.ToString()) + "' where RecordID = '" + thisID + "'";
DBCommand.ExecuteNonQuery();
DBConnection.Close();
// Send Owner Email
Message = "<p>" + objLocationContact.Name + ", we are pleased to confirm the date(s) of the recce for " + objProductionContact.Name + " at location " + objLocation.LocationID + ". </p>";
Message += "<p>";
Message += "Below are the details of the confirmed recce booking. You can also view all your recce requests on our website, <a href=\"http://ukfilmlocation.dev/MyRecces.aspx\">click here</a>. If you have any questions please let us know, telephone 0844 669 5245.</p>";
Message += "<p>You can download a PDF version of this appointment by <a target=\"_blank\" href=\"http://" + UK_Film_Location_Class.UKFilmLocation.DefaultWebsite + "/RecceAppointment.php?RecceDateID=" + thisID + "&Recipient=" + objLocationContact.ContactID + "\">clicking here</a>.</p>";
Message += "<h2>Recce Details</h2>";
Message += "<p>Location Ref : <a href=\"http://" + UK_Film_Location_Class.UKFilmLocation.DefaultWebsite + "/Location.aspx?LocationID=" + objLocation.LocationID + "\">" + objLocation.LocationID + "</a><br>";
Message += "Address : " + thisAddress + "</p>";
Message += "<p>";
// Message += "<p>Date Of Recce : " + DateTime.Parse(RecceDateLiteral.Text).ToShortDateString() + "<br>";
// Message += "Time Of Recce : " + RecceTimeLiteral.Text + "<br>";
Message += "Contact : " + objProductionContact.Name + "<br>";
Message += "Contact Tel : " + objProductionContact.Tel + "<br>";
Message += "Contact Mobile : " + objProductionContact.Mobile + "<br>";
// Message += "Notes : " + RecceNotesTextBox.Text;
Message += "</p>";
Message += "<h2>Recce Details</h2>";
Message += "<p>";
if (!string.IsNullOrEmpty(objRecce.RecceDate.ToShortDateString())) Message += "Date Of Recce : " + objRecce.RecceDate.ToShortDateString().Replace(" 00:00:00", "") + "<br>";
if (!string.IsNullOrEmpty(objRecce.Time)) Message += "Time Of Recce : " + objRecce.Time + "<br>";
if (!string.IsNullOrEmpty(objOpportunity.TypeOfShoot)) Message += "Type Of Shoot : " + objOpportunity.TypeOfShoot + "<br>";
//if (!string.IsNullOrEmpty(AgreedRateTextBox.Text)) Message += "Agreed Agency Rate % : " + AgreedRateTextBox.Text + "<br>";
if (!string.IsNullOrEmpty(objRecce.Notes)) Message += "Notes : " + objRecce.Notes.Replace("\n", "<br>");
Message += "</p>";
Message += "<p>Agent : " + objUser.FirstName + " " + objUser.LastName + "<br>";
Message += "Agent Email : " + objUser.Email + "<br>";
Message += "Agent Tel : 0844 669 5245 / 01782 388090</p>";
Message += "<p>We appreciate your feedback, please let us know how it went.</p>";
Message += "<p><i>UKFilmLocation.com</i><br>";
Message += "Tel 0844 669 5245</p>";
UK_Film_Location_Class.UKFilmLocation.sendEmail(objLocationContact.Email, objUser.FirstName + " " + objUser.LastName, objUser.Email, "UKFilmLocation.com - Recce Confirmation for Location: " + objLocation.LocationID + " (" + UK_Film_Location_Class.LocationDetails.getTitleFromID(objLocation.LocationID) + ")", Message);
// Send Project Company Email
// Send emails
Message = "<p>" + objProductionContact.Name + ", we are pleased to confirm the date(s) of your recce at location " + objLocation.LocationID + ". We hope the location lives up to your expectations.</p><p>You can download a printable PDF for this location by <a href=\"http://" + UK_Film_Location_Class.UKFilmLocation.DefaultWebsite + "/LocationPDF.php?LocationID=" + objLocation.LocationID + "\" target=\"_blank\">clicking here</a>.</p>";
Message += "<p>";
Message += "Below are the details of the confirmed recce booking. You can also view all your recce requests on our website, <a href=\"http://ukfilmlocation.dev/MyRecces.aspx\">click here</a>. If you have any questions please let us know, telephone 0844 669 5245.</p>";
Message += "<p>You can download a PDF version of this appointment by <a target=\"_blank\" href=\"http://" + UK_Film_Location_Class.UKFilmLocation.DefaultWebsite + "/RecceAppointment.php?RecceDateID=" + thisID + "&Recipient=" + objProductionContact.ContactID + "\">clicking here</a>.</p>";
Message += "<h2>Recce Details</h2>";
Message += "<p>Location Ref : <a href=\"http://" + UK_Film_Location_Class.UKFilmLocation.DefaultWebsite + "/Location.aspx?LocationID=" + objLocation.LocationID + "\">" + objLocation.LocationID + "</a><br>";
Message += "Address : " + thisAddress + "</p>";
Message += "<p>";
// Date Of Recce : " + DateTime.Parse(RecceDateLiteral.Text).ToShortDateString() + "<br>";
// Message += "Time Of Recce : " + RecceTimeLiteral.Text + "<br>";
Message += "Owner : " + objLocationContact.Name + "<br>";
Message += "Owner Tel : " + objLocationContact.Tel + "<br>";
Message += "Owner Mobile : " + objLocationContact.Mobile + "<br>";
// Message += "Notes : " + RecceNotesTextBox.Text;
Message += "</p>";
Message += "<h2>Recce Details</h2>";
Message += "<p>";
if (!string.IsNullOrEmpty(objRecce.RecceDate.ToShortDateString())) Message += "Date Of Recce : " + objRecce.RecceDate.ToShortDateString().Replace(" 00:00:00", "") + "<br>";
if (!string.IsNullOrEmpty(objRecce.Time)) Message += "Time Of Recce : " + objRecce.Time + "<br>";
if (!string.IsNullOrEmpty(objOpportunity.TypeOfShoot)) Message += "Type Of Shoot : " + objOpportunity.TypeOfShoot + "<br>";
//if (!string.IsNullOrEmpty(AgreedRateTextBox.Text)) Message += "Agreed Agency Rate % : " + AgreedRateTextBox.Text + "<br>";
if (!string.IsNullOrEmpty(objRecce.Notes)) Message += "Notes : " + objRecce.Notes.Replace("\n", "<br>");
Message += "</p>";
Message += "<p>Agent : " + objUser.FirstName + " " + objUser.LastName + "<br>";
Message += "Agent Email : " + objUser.Email + "<br>";
Message += "Agent Tel : 0844 669 5245 / 01782 388090</p>";
Message += "<p><i>UKFilmLocation.com</i><br>";
Message += "Tel 0844 669 5245</p>";
UK_Film_Location_Class.UKFilmLocation.sendEmail(objProductionContact.Email, objUser.FirstName + " " + objUser.LastName, objUser.Email, "UKFilmLocation.com - Recce Confirmation for Location: " + objLocation.LocationID + " (" + UK_Film_Location_Class.LocationDetails.getTitleFromID(objLocation.LocationID) + ")", Message);
Response.Redirect("/OpportunityDetails.aspx?OpportunityID=" + objOpportunity.OpportunityID);
}
DBConnection.Dispose();
}