public void btnAddRoom_Click(object sender, EventArgs e)
{
AvailabilityHandler availabilityHandler = new AvailabilityHandler();
RoomHandler roomHandler = new RoomHandler();
string picturePath = @"\RoomPictures\";
//check if room exists
if (roomHandler.ValidateRoomNo(txtRoomNo.Text) == false)
{
Room room = new Room();
room.RoomNo = txtRoomNo.Text;
room.Description = txtDescription.Text;
room.TypeID = Convert.ToInt32(dlTypeID.SelectedValue);
if (cbWifi.Checked)
room.WifiStatus = "Yes";
else
room.WifiStatus = "No";
if (cbAircon.Checked)
room.AirconStatus = "Yes";
else
room.AirconStatus = "No";
if (cbRoomservice.Checked)
room.RoomserviceStatus = "Yes";
else
room.RoomserviceStatus = "No";
if (cbTelevision.Checked)
room.TelevisionStatus = "Yes";
else
room.TelevisionStatus = "No";
//check if picture is selected
if (fileUploadControl.HasFile)
{
try
{
//only accept .png and .jpg image files
if (fileUploadControl.PostedFile.ContentType == "image/jpeg" || fileUploadControl.PostedFile.ContentType == "image/png")
{
//check file is within maximum size limit
if (fileUploadControl.PostedFile.ContentLength < 3072000)
{
//get file name from the upload control
string filename = Path.GetFileName(fileUploadControl.FileName);
//get the extension name of the file
string extension = filename.Substring(filename.LastIndexOf("."));
//remove the extension from the file name
filename = filename.Substring(0, filename.LastIndexOf("."));
//append room number to the end of the file name
filename += "_" + room.RoomNo;
//combine path, file name and extension. phew
picturePath += filename + extension;
//all checks successfull, upload image and run SQL command
fileUploadControl.SaveAs(Server.MapPath(@"~" + picturePath));
room.Picture = picturePath;
int lastRoomID = 0;
DateTime currentYear = DateTime.Now;
lastRoomID = roomHandler.GetLastRoomID();
if (roomHandler.AddNewRoom(room) == false)
{
//populate availability table
availabilityHandler.AddAvailabilityRecord(lastRoomID, currentYear.Year);
availabilityHandler.AddAvailabilityRecord(lastRoomID, (currentYear.Year + 1));
//alert of success
lblProgress.CssClass = "label label-success";
lblProgress.Text = "Room added successfully";
//delay redirect to alert user of page change
lblRedirect.Text = "Redirecting to room list in 5 seconds.";
Response.Write("<script type=\"text/javascript\">setTimeout(function () { window.location.href = \"RoomList.aspx\"; }, 5000);</script>");
}
}
else
lblProgress.Text = "The picture has to be less than 3 megabytes!";
}
else
lblProgress.Text = "Only JPEG or PNG files are accepted!";
}
catch (Exception)
{
lblProgress.Text = "The picture failed to upload";
}
}
//no picture is selected
else
{
room.Picture = "";
//run SQL insert
if (roomHandler.AddNewRoom(room) == false)
{
//populate availability table
int lastRoomID = 0;
DateTime currentYear = DateTime.Now;
lastRoomID = roomHandler.GetLastRoomID();
availabilityHandler.AddAvailabilityRecord(lastRoomID, currentYear.Year);
availabilityHandler.AddAvailabilityRecord(lastRoomID, (currentYear.Year + 1));
//alert of success
lblProgress.CssClass = "label label-success";
lblProgress.Text = "Room added successfully";
//delay redirect to alert user of page change
lblRedirect.Text = "Redirecting to room list in 5 seconds.";
Response.Write("<script type=\"text/javascript\">setTimeout(function () { window.location.href = \"RoomList.aspx\"; }, 5000);</script>");
}
}
}
else
lblProgress.Text = "This room number already exists!";
}
public void btnSave_Click(object sender, EventArgs e)
{
string picturePath = @"\RoomPictures\";
int roomID = Convert.ToInt32(Session["EditRoom"]);
RoomHandler roomHandler = new RoomHandler();
//check if room exists or if the user changed room number
if (roomHandler.ValidateRoomNo(txtRoomNo.Text) == false || originalRoomNo == txtRoomNo.Text.Trim())
{
Room room = new Room();
room.RoomID = roomID;
room.RoomNo = txtRoomNo.Text;
room.Description = txtDescription.Text;
room.TypeID = Convert.ToInt32(dlRoomType.SelectedValue);
if (cbWifi.Checked)
room.WifiStatus = "Yes";
else
room.WifiStatus = "No";
if (cbAircon.Checked)
room.AirconStatus = "Yes";
else
room.AirconStatus = "No";
if (cbRoomservice.Checked)
room.RoomserviceStatus = "Yes";
else
room.RoomserviceStatus = "No";
if (cbTelevision.Checked)
room.TelevisionStatus = "Yes";
else
room.TelevisionStatus = "No";
room.Status = dlStatus.SelectedValue;
if (rdoKeepPic.Checked)
{
//keep picture
room.Picture = picName;
roomHandler.UpdateRoom(room);
lblProgress.CssClass = "label label-success";
lblProgress.Text = "Room edited successfully";
//delay redirect to alert user of page change
lblRedirect.Text = "Redirecting to room list in 5 seconds.";
Response.Write("<script type=\"text/javascript\">setTimeout(function () { window.location.href = \"RoomList.aspx\"; }, 5000);</script>");
}
else if (rdoUploadPic.Checked)
{
//upload picture
if (fileUploadControl.HasFile)
{
try
{
//only accept .png and .jpg image files
if (fileUploadControl.PostedFile.ContentType == "image/jpeg" || fileUploadControl.PostedFile.ContentType == "image/png")
{
//get file name from the upload control
string filename = Path.GetFileName(fileUploadControl.FileName);
//get the extension name of the file
string extension = filename.Substring(filename.LastIndexOf("."));
//remove the extension from the file name
filename = filename.Substring(0, filename.LastIndexOf("."));
//append room number to the end of the file name
filename += "_" + room.RoomNo;
//combine path, file name and extension. phew
picturePath += filename + extension;
//all checks successfull, upload image and run SQL command
fileUploadControl.SaveAs(Server.MapPath(@"~" + picturePath));
room.Picture = picturePath;
if (roomHandler.UpdateRoom(room) == false)
{
//alert of success and redirect
lblProgress.CssClass = "label label-success";
lblProgress.Text = "Room edited successfully";
//delay redirect to alert user of page change
lblRedirect.Text = "Redirecting to room list in 5 seconds.";
Response.Write("<script type=\"text/javascript\">setTimeout(function () { window.location.href = \"RoomList.aspx\"; }, 5000);</script>");
}
}
else
lblProgress.Text = "Only JPEG or PNG files are accepted!";
}
catch (Exception)
{
lblProgress.Text = "The picture failed to upload";
}
}
//no picture is selected
else
{
lblProgress.CssClass = "label label-warning";
lblProgress.Text = "You selected to upload a new picture but failed to select one to upload<br />Use the browse button to choose a picture";
}
}
else if (rdoRemovePic.Checked)
{
//remove picture
room.Picture = "";
roomHandler.UpdateRoom(room);
lblProgress.CssClass = "label label-success";
lblProgress.Text = "Room edited successfully";
//delay redirect to alert user of page change
lblRedirect.Text = "Redirecting to room list in 5 seconds.";
Response.Write("<script type=\"text/javascript\">setTimeout(function () { window.location.href = \"RoomList.aspx\"; }, 5000);</script>");
}
}
else
lblProgress.Text = "This room number already exists!";
}