protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.FillDropDown();
}
else
{
this.ChangeRecord();
this.DisplayRecord();
}
this.DisplayRecord();
///<summary>
///This is the code for displaying images. It is also used to navigate to the POI_Images.aspx
///</summary>
string poiID = Request.QueryString["qrypoiID"];
DA_POI poiDAObject = new DA_POI();
DataRow dataRowObject = poiDAObject.GetPOI(poiID);
string imageFilename1 = Convert.ToString(dataRowObject["POI_Image1"]);
string imageFilename2 = Convert.ToString(dataRowObject["POI_Image2"]);
string imageFilename3 = Convert.ToString(dataRowObject["POI_Image3"]);
//Image 1 Info
if (imageFilename1 == "")
imageFilename1 = "no-image.jpg";
Trace.Warn("imageFilename1 = " + imageFilename1);
//Display Image 1 info
string image1WithPath = "~/Images/" + imageFilename1;
imgImage1.ImageUrl = image1WithPath;
imgImage1.ToolTip = imageFilename1;
imgImage1.AlternateText = "Image file not found!";
//Image 2 Info
if (imageFilename2 == "")
imageFilename2 = "no-image.jpg";
//Display Image 2 info
imgImage2.ImageUrl = "~/Images/" + imageFilename2;
imgImage2.ToolTip = imageFilename2;
imgImage2.AlternateText = "Image file not found!";
hypImage2.NavigateUrl = "POI_Images.aspx?qrypoiID=" + poiID;
hypImage2.Text = "Edit Images";
//Image 3 Info
if (imageFilename3 == "")
imageFilename3 = "no-image.jpg";
Trace.Warn("imageFilename3 = " + imageFilename3);
//Display Image 1 info
imgImage3.ImageUrl = "~/Images/" + imageFilename3;
imgImage3.ToolTip = imageFilename3;
imgImage3.AlternateText = "Image file not found!";
}
/// <summary>
/// name: delBTN_Click
/// description: This method is from button click, it generates the modul Popup to verify deletion of a POI
/// </summary>
protected void delBTN_Click(object sender, ImageClickEventArgs e)
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
DA_POI inventoryDAObject = new DA_POI();
DataRow dataRowObject = inventoryDAObject.GetPOI(gvrow.Cells[0].Text);
string ID = Convert.ToString(dataRowObject["POI_ID"]);
string title = Convert.ToString(dataRowObject["POI_Title"]);
lblID.Text = ID;
lblTitle.Text = title;
this.ModalPopupExtender1.Show();
}
/// <summary>
/// name: delBTN_Click
/// description: This method is from button click, it generates the modul Popup to verify deletion of a POI
/// </summary>
protected void delBTN_Click(object sender, ImageClickEventArgs e)
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
DA_POI inventoryDAObject = new DA_POI();
DataRow dataRowObject = inventoryDAObject.GetPOI(gvrow.Cells[0].Text);
string ID = Convert.ToString(dataRowObject["POI_ID"]);
string title = Convert.ToString(dataRowObject["POI_Title"]);
lblID.Text = ID;
lblTitle.Text = title;
this.ModalPopupExtender1.Show();
}
protected void Page_Load(object sender, EventArgs e)
{
///<summary>
///This is the code for displaying images
///</summary>
///
string poiID = Request.QueryString["qrypoiID"];
DA_POI poiDAObject = new DA_POI();
DataRow dataRowObject = poiDAObject.GetPOI(poiID);
string imageFilename1 = Convert.ToString(dataRowObject["POI_Image1"]);
string imageFilename2 = Convert.ToString(dataRowObject["POI_Image2"]);
string imageFilename3 = Convert.ToString(dataRowObject["POI_Image3"]);
string imageFilename4 = Convert.ToString(dataRowObject["POI_Image4"]);
string imageFilename5 = Convert.ToString(dataRowObject["POI_Image5"]);
string imageFilename6 = Convert.ToString(dataRowObject["POI_Image6"]);
//Image 1 Info
if (imageFilename1 == "")
{
imgImage1.Visible = false;
lblNoImage1.Visible = true;
}
else
{
lbDeleteImage1.Visible = true;
imagesExist++;
}
Trace.Warn("imageFilename1 = " + imageFilename1);
//Display Image 1 info
string image1WithPath = "~/Images/" + imageFilename1;
imgImage1.ImageUrl = image1WithPath;
imgImage1.ToolTip = imageFilename1;
imgImage1.AlternateText = "Image file not found!";
//Image 2 Info
if (imageFilename2 == "")
{
imgImage2.Visible = false;
lblNoImage2.Visible = true;
}
else
{
lbDeleteImage2.Visible = true;
imagesExist++;
}
Trace.Warn("imageFilename2 = " + imageFilename2);
//Display Image 2 info
imgImage2.ImageUrl = "~/Images/" + imageFilename2;
imgImage2.ToolTip = imageFilename2;
imgImage2.AlternateText = "Image file not found!";
//Image 3 Info
if (imageFilename3 == "")
{
imgImage3.Visible = false;
lblNoImage3.Visible = true;
}
else
{
lbDeleteImage3.Visible = true;
imagesExist++;
}
Trace.Warn("imageFilename3 = " + imageFilename3);
//Display Image 1 info
imgImage3.ImageUrl = "~/Images/" + imageFilename3;
imgImage3.ToolTip = imageFilename3;
imgImage3.AlternateText = "Image file not found!";
//Image 4 Info
if (imageFilename4 == "")
{
imgImage4.Visible = false;
lblNoImage4.Visible = true;
}
else
{
lbDeleteImage4.Visible = true;
imagesExist++;
}
Trace.Warn("imageFilename4 = " + imageFilename4);
//Display Image 4 info
imgImage4.ImageUrl = "~/Images/" + imageFilename4;
imgImage4.ToolTip = imageFilename2;
imgImage4.AlternateText = "Image file not found!";
//Image 5 Info
if (imageFilename5 == "")
{
imgImage5.Visible = false;
lblNoImage5.Visible = true;
}
else
{
lbDeleteImage5.Visible = true;
imagesExist++;
}
Trace.Warn("imageFilename5 = " + imageFilename5);
//Display Image 5 info
imgImage5.ImageUrl = "~/Images/" + imageFilename5;
imgImage5.ToolTip = imageFilename5;
imgImage5.AlternateText = "Image file not found!";
//Image 6 Info
if (imageFilename6 == "")
{
imgImage6.Visible = false;
lblNoImage6.Visible = true;
}
else
{
lbDeleteImage6.Visible = true;
imagesExist++;
}
Trace.Warn("imageFilename6 = " + imageFilename6);
//Display Image 6 info
imgImage6.ImageUrl = "~/Images/" + imageFilename6;
imgImage6.ToolTip = imageFilename6;
imgImage6.AlternateText = "Image file not found!";
Trace.Warn("imagesExist = " + imagesExist);
if (imagesExist == 6)
{
pnlUploadImage.Visible = false;
}
else if (imagesExist < 6)
{
pnlUploadImage.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
///<summary>
///This is the code for displaying images
///</summary>
///
string poiID = Request.QueryString["qrypoiID"];
DA_POI poiDAObject = new DA_POI();
DataRow dataRowObject = poiDAObject.GetPOI(poiID);
string imageFilename1 = Convert.ToString(dataRowObject["POI_Image1"]);
string imageFilename2 = Convert.ToString(dataRowObject["POI_Image2"]);
string imageFilename3 = Convert.ToString(dataRowObject["POI_Image3"]);
string imageFilename4 = Convert.ToString(dataRowObject["POI_Image4"]);
string imageFilename5 = Convert.ToString(dataRowObject["POI_Image5"]);
string imageFilename6 = Convert.ToString(dataRowObject["POI_Image6"]);
//Image 1 Info
if (imageFilename1 == "")
{
imgImage1.Visible = false;
lblNoImage1.Visible = true;
}
else
{
lbDeleteImage1.Visible = true;
imagesExist++;
}
Trace.Warn("imageFilename1 = " + imageFilename1);
//Display Image 1 info
string image1WithPath = "~/Images/" + imageFilename1;
imgImage1.ImageUrl = image1WithPath;
imgImage1.ToolTip = imageFilename1;
imgImage1.AlternateText = "Image file not found!";
//Image 2 Info
if (imageFilename2 == "")
{
imgImage2.Visible = false;
lblNoImage2.Visible = true;
}
else
{
lbDeleteImage2.Visible = true;
imagesExist++;
}
Trace.Warn("imageFilename2 = " + imageFilename2);
//Display Image 2 info
imgImage2.ImageUrl = "~/Images/" + imageFilename2;
imgImage2.ToolTip = imageFilename2;
imgImage2.AlternateText = "Image file not found!";
//Image 3 Info
if (imageFilename3 == "")
{
imgImage3.Visible = false;
lblNoImage3.Visible = true;
}
else
{
lbDeleteImage3.Visible = true;
imagesExist++;
}
Trace.Warn("imageFilename3 = " + imageFilename3);
//Display Image 1 info
imgImage3.ImageUrl = "~/Images/" + imageFilename3;
imgImage3.ToolTip = imageFilename3;
imgImage3.AlternateText = "Image file not found!";
//Image 4 Info
if (imageFilename4 == "")
{
imgImage4.Visible = false;
lblNoImage4.Visible = true;
}
else
{
lbDeleteImage4.Visible = true;
imagesExist++;
}
Trace.Warn("imageFilename4 = " + imageFilename4);
//Display Image 4 info
imgImage4.ImageUrl = "~/Images/" + imageFilename4;
imgImage4.ToolTip = imageFilename2;
imgImage4.AlternateText = "Image file not found!";
//Image 5 Info
if (imageFilename5 == "")
{
imgImage5.Visible = false;
lblNoImage5.Visible = true;
}
else
{
lbDeleteImage5.Visible = true;
imagesExist++;
}
Trace.Warn("imageFilename5 = " + imageFilename5);
//Display Image 5 info
imgImage5.ImageUrl = "~/Images/" + imageFilename5;
imgImage5.ToolTip = imageFilename5;
imgImage5.AlternateText = "Image file not found!";
//Image 6 Info
if (imageFilename6 == "")
{
imgImage6.Visible = false;
lblNoImage6.Visible = true;
}
else
{
lbDeleteImage6.Visible = true;
imagesExist++;
}
Trace.Warn("imageFilename6 = " + imageFilename6);
//Display Image 6 info
imgImage6.ImageUrl = "~/Images/" + imageFilename6;
imgImage6.ToolTip = imageFilename6;
imgImage6.AlternateText = "Image file not found!";
Trace.Warn("imagesExist = " + imagesExist);
if (imagesExist == 6)
{
pnlUploadImage.Visible = false;
}
else if (imagesExist < 6)
{
pnlUploadImage.Visible = true;
}
}
/// <summary>
/// name: DisplayRecord
/// description: method to display data when modifying a POI
/// </summary>
private void DisplayRecord()
{
string locationID = (Request.QueryString["qrypoiID"]);
DA_POI inventoryObject = new DA_POI();
DataRow dataRowObject = inventoryObject.GetPOI(locationID);
//Assign the field values of the DataRow object to variables
string ID = Convert.ToString(dataRowObject["POI_ID"]);
decimal latitude = Convert.ToDecimal(dataRowObject["POI_Latitude"]);
decimal longitude = Convert.ToDecimal(dataRowObject["POI_Longitude"]);
string title = Convert.ToString(dataRowObject["POI_Title"]);
string description = Convert.ToString(dataRowObject["POI_Description"]);
string address1 = Convert.ToString(dataRowObject["POI_Address1"]);
string address2 = Convert.ToString(dataRowObject["POI_Address2"]);
string city = Convert.ToString(dataRowObject["POI_City"]);
string state = Convert.ToString(dataRowObject["POI_State"]);
string ZipCode = Convert.ToString(dataRowObject["POI_ZipCode"]);
string contactName = Convert.ToString(dataRowObject["POI_ContactName"]);
string phone = Convert.ToString(dataRowObject["POI_Phone"]);
string url = Convert.ToString(dataRowObject["POI_URL"]);
string category = Convert.ToString(dataRowObject["POI_Category"]);
bool isActive = Convert.ToBoolean(dataRowObject["IsActive"]);
bool petFriendly = Convert.ToBoolean(dataRowObject["Pet_Friendly"]);
string image1Desc = Convert.ToString(dataRowObject["Image1Desc"]);
string image2Desc = Convert.ToString(dataRowObject["Image2Desc"]);
string image3Desc = Convert.ToString(dataRowObject["Image3Desc"]);
lblID.Text = ID.ToString();
txtLongitude.Text = longitude.ToString();
txtLatitude.Text = latitude.ToString();
txtTitle.Text = title;
txtDescription.Text = description;
txtAddress1.Text = address1;
txtAddress2.Text = address2;
txtCity.Text = city;
txtState.Text = state;
txtZipCode.Text = ZipCode;
txtContactName.Text = contactName;
txtPhone.Text = phone;
txtURL.Text = url;
ddlCategory.SelectedValue = category.ToString();
txtImage1Desc.Text = image1Desc;
txtImage2Desc.Text = image2Desc;
txtImage3Desc.Text = image3Desc;
if (isActive == true)
{
chkIsActive.Checked = true;
}
else
{
chkIsActive.Checked = false;
}
if (petFriendly == true)
{
chkPetFriendly.Checked = true;
}
else
{
chkPetFriendly.Checked = false;
}
}
/// <summary>
/// name: DisplayRecord
/// description: method to display data when modifying a POI
/// </summary>
private void DisplayRecord()
{
string locationID = (Request.QueryString["qrypoiID"]);
DA_POI inventoryObject = new DA_POI();
DataRow dataRowObject = inventoryObject.GetPOI(locationID);
//Assign the field values of the DataRow object to variables
string ID = Convert.ToString(dataRowObject["POI_ID"]);
decimal latitude = Convert.ToDecimal(dataRowObject["POI_Latitude"]);
decimal longitude = Convert.ToDecimal(dataRowObject["POI_Longitude"]);
string title = Convert.ToString(dataRowObject["POI_Title"]);
string description = Convert.ToString(dataRowObject["POI_Description"]);
string address1 = Convert.ToString(dataRowObject["POI_Address1"]);
string address2 = Convert.ToString(dataRowObject["POI_Address2"]);
string city = Convert.ToString(dataRowObject["POI_City"]);
string state = Convert.ToString(dataRowObject["POI_State"]);
string ZipCode = Convert.ToString(dataRowObject["POI_ZipCode"]);
string contactName = Convert.ToString(dataRowObject["POI_ContactName"]);
string phone = Convert.ToString(dataRowObject["POI_Phone"]);
string url = Convert.ToString(dataRowObject["POI_URL"]);
string category = Convert.ToString(dataRowObject["POI_Category"]);
bool isActive = Convert.ToBoolean(dataRowObject["IsActive"]);
bool petFriendly = Convert.ToBoolean(dataRowObject["Pet_Friendly"]);
lblID.Text = ID.ToString();
txtLongitude.Text = longitude.ToString();
txtLatitude.Text = latitude.ToString();
txtTitle.Text = title;
txtDescription.Text = description;
txtAddress1.Text = address1;
txtAddress2.Text = address2;
txtCity.Text = city;
txtState.Text = state;
txtZipCode.Text = ZipCode;
txtContactName.Text = contactName;
txtPhone.Text = phone;
txtURL.Text = url;
ddlCategory.SelectedValue = category.ToString();
if (isActive == true)
{
chkIsActive.Checked = true;
}
else
{
chkIsActive.Checked = false;
}
if (petFriendly == true)
{
chkPetFriendly.Checked = true;
}
else
{
chkPetFriendly.Checked = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.FillDropDown();
}
else
{
this.ChangeRecord();
this.DisplayRecord();
}
this.DisplayRecord();
///<summary>
///This is the code for displaying images. It is also used to navigate to the POI_Images.aspx
///</summary>
string poiID = Request.QueryString["qrypoiID"];
DA_POI poiDAObject = new DA_POI();
DataRow dataRowObject = poiDAObject.GetPOI(poiID);
string imageFilename1 = Convert.ToString(dataRowObject["POI_Image1"]);
string imageFilename2 = Convert.ToString(dataRowObject["POI_Image2"]);
string imageFilename3 = Convert.ToString(dataRowObject["POI_Image3"]);
string imageFilename4 = Convert.ToString(dataRowObject["POI_Image4"]);
string imageFilename5 = Convert.ToString(dataRowObject["POI_Image5"]);
string imageFilename6 = Convert.ToString(dataRowObject["POI_Image6"]);
//Image 1 Info
if (imageFilename1 == "")
{
imageFilename1 = "no-image.jpg";
}
Trace.Warn("imageFilename1 = " + imageFilename1);
//Display Image 1 info
string image1WithPath = "~/Images/" + imageFilename1;
imgImage1.ImageUrl = image1WithPath;
imgImage1.ToolTip = imageFilename1;
imgImage1.AlternateText = "Image file not found!";
//Image 2 Info
if (imageFilename2 == "")
{
imageFilename2 = "no-image.jpg";
}
//Display Image 2 info
imgImage2.ImageUrl = "~/Images/" + imageFilename2;
imgImage2.ToolTip = imageFilename2;
imgImage2.AlternateText = "Image file not found!";
hypImage2.NavigateUrl = "POI_Images.aspx?qrypoiID=" + poiID;
hypImage2.Text = "Edit Images";
//Image 3 Info
if (imageFilename3 == "")
{
imageFilename3 = "no-image.jpg";
}
Trace.Warn("imageFilename3 = " + imageFilename3);
//Display Image 3info
imgImage3.ImageUrl = "~/Images/" + imageFilename3;
imgImage3.ToolTip = imageFilename3;
imgImage3.AlternateText = "Image file not found!";
//Image 4 Info
if (imageFilename4 == "")
{
imageFilename4 = "no-image.jpg";
}
//Display Image 4 info
imgImage4.ImageUrl = "~/Images/" + imageFilename4;
imgImage4.ToolTip = imageFilename4;
imgImage4.AlternateText = "Image file not found!";
//Image 5 Info
if (imageFilename5 == "")
{
imageFilename5 = "no-image.jpg";
}
//Display Image 5 info
imgImage5.ImageUrl = "~/Images/" + imageFilename5;
imgImage5.ToolTip = imageFilename5;
imgImage5.AlternateText = "Image file not found!";
//Image 6 Info
if (imageFilename6 == "")
{
imageFilename6 = "no-image.jpg";
}
//Display Image 6 info
imgImage6.ImageUrl = "~/Images/" + imageFilename6;
imgImage6.ToolTip = imageFilename6;
imgImage6.AlternateText = "Image file not found!";
}
/// <summary>
/// name: DisplayRecord
/// description: method to display data when modifying a POI
/// </summary>
private void DisplayRecord()
{
string locationID = (Request.QueryString["qrypoiID"]);
DA_POI inventoryObject = new DA_POI();
DataRow dataRowObject = inventoryObject.GetPOI(locationID);
//Assign the field values of the DataRow object to variables
string ID = Convert.ToString(dataRowObject["POI_ID"]);
decimal latitude = Convert.ToDecimal(dataRowObject["POI_Latitude"]);
decimal longitude = Convert.ToDecimal(dataRowObject["POI_Longitude"]);
string title = Convert.ToString(dataRowObject["POI_Title"]);
string url = Convert.ToString(dataRowObject["POI_URL"]);
string description = Convert.ToString(dataRowObject["POI_Description"]);
string category = Convert.ToString(dataRowObject["POI_Category"]);
bool isActive = Convert.ToBoolean(dataRowObject["IsActive"]);
lblID.Text = ID.ToString();
txtLatitude.Text = latitude.ToString();
txtLongitude.Text = longitude.ToString();
txtTitle.Text = title;
txtDescription.Text = description;
txtURL.Text = url;
ddlCategory.SelectedValue = category.ToString();
if (isActive == true)
{
chkIsActive.Checked = true;
}
else
{
chkIsActive.Checked = false;
}
}
