protected void submitPropRoom(object sender, EventArgs e)
{
Session["privateBathroom"] = rbPrivateBr.SelectedValue;
Session["privateEntrance"] = rbPrivateEntr.SelectedValue;
Session["Storage"] = rbStorage.SelectedValue;
Session["Furnished"] = rbFurnished.SelectedValue;
Session["Smoker"] = rbSmoke.SelectedValue;
Session["Kitchen"] = rbKitchen.SelectedValue;
privateBath = Session["privateBathroom"].ToString();
privateEnt = Session["privateEntrance"].ToString();
storage = Session["Storage"].ToString();
furnish = Session["Furnished"].ToString();
smoker = Session["Smoker"].ToString();
kitchen = Session["Kitchen"].ToString();
sc.Open();
//find hostid
SqlCommand insert = new SqlCommand("SELECT PropertyID FROM [dbo].[Property] WHERE HostID = @HostID", sc);
insert.Parameters.AddWithValue("@HostID", Convert.ToInt32(Session["hostID"]));
insert.Connection = sc;
int propertyID = Convert.ToInt32(insert.ExecuteScalar());
insert.ExecuteNonQuery();
//find accountid
SqlCommand getAccountID = new SqlCommand("SELECT AccountID FROM [dbo].[Login] WHERE HostID = @HostID", sc);
getAccountID.Parameters.AddWithValue("@HostID", Convert.ToInt32(Session["hostID"]));
getAccountID.Connection = sc;
int accountID = Convert.ToInt32(getAccountID.ExecuteScalar());
getAccountID.ExecuteNonQuery();
Session["accountID"] = accountID;
sc.Close();
string monthlyPrice = (Convert.ToDouble(monthlyPriceTextbox.Text)).ToString();
String sqFoot = DropDownListSize.SelectedValue;
String avail = DropDownListAvailability.SelectedValue;
String display = displayTextbox.Text;
String roomDescription = bioTextbox.Text;
//insert property room into property room description
int roomID;
Session["RoomID"] = null;
string image1 = "";
string image2 = "";
string image3 = "";
PropertyRoom newRoom = new PropertyRoom(propertyID, monthlyPrice, sqFoot, avail, display, roomDescription, image1, image2, image3);
System.Data.SqlClient.SqlCommand insertBadgeProperty = new System.Data.SqlClient.SqlCommand();
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["RDSConnectionString"].ConnectionString))
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = "INSERT INTO [dbo].[PropertyRoom] ([PropertyID],[TenantID],[MonthlyPrice],[SquareFootage],[Availability],[BriefDescription],[RoomDescription],[LastUpdatedBy],[LastUpdated],[Image1],[Image2],[Image3]) VALUES (@propid,@tenantid,@price,@sqft,@avail,@desc,@roomdescrip,@lub,@lu, @image1, @image2, @image3)";
command.Parameters.AddWithValue("@propid", newRoom.propertyID);
command.Parameters.AddWithValue("@tenantid", DBNull.Value);
command.Parameters.AddWithValue("@price", monthlyPriceTextbox.Text);
command.Parameters.AddWithValue("@sqft", newRoom.squareFootage);
command.Parameters.AddWithValue("@avail", newRoom.availability);
command.Parameters.AddWithValue("@desc", newRoom.briefDescription);
command.Parameters.AddWithValue("@roomdescrip", newRoom.roomDescription);
command.Parameters.AddWithValue("@lub", "Kessler");
command.Parameters.AddWithValue("@lu", DateTime.Now);
command.Parameters.AddWithValue("@image1", 0);
command.Parameters.AddWithValue("@image2", 0);
command.Parameters.AddWithValue("@image3", 0);
connection.Open();
int recordsAffected = command.ExecuteNonQuery();
connection.Close();
try
{
connection.Open();
SqlCommand room = new SqlCommand("SELECT MAX(RoomID) FROM [dbo].[PropertyRoom]", connection);
room.Connection = connection;
roomID = Convert.ToInt32(room.ExecuteScalar());
Session["RoomID"] = roomID;
room.ExecuteNonQuery();
BadgeProperty newBadgeProperty = new BadgeProperty(roomID, privateEnt, kitchen, privateBath, furnish, storage, smoker);
//insert badge
insertBadgeProperty.CommandText = "INSERT INTO [dbo].[BadgeProperty] (RoomID, PrivateEntrance, Kitchen, PrivateBathroom, Furnished, ClosetSpace, NonSmoker) VALUES (@roomID, @privateEnt, @kitchen, @privateBath, @furnish, @storage, @smoker);";
insertBadgeProperty.Parameters.AddWithValue("@roomID", newBadgeProperty.RoomID);
insertBadgeProperty.Parameters.AddWithValue("@privateEnt", newBadgeProperty.privateEntrance);
insertBadgeProperty.Parameters.AddWithValue("@kitchen", newBadgeProperty.kitchen);
insertBadgeProperty.Parameters.AddWithValue("@privateBath", newBadgeProperty.privateBathroom);
insertBadgeProperty.Parameters.AddWithValue("@furnish", newBadgeProperty.furnished);
insertBadgeProperty.Parameters.AddWithValue("@storage", newBadgeProperty.closetSpace);
insertBadgeProperty.Parameters.AddWithValue("@smoker", newBadgeProperty.nonSmoker);
insertBadgeProperty.Connection = connection;
insertBadgeProperty.ExecuteNonQuery();
}
catch (Exception t)
{
string f = t.ToString();
}
finally
{
connection.Close();
}
}
}
//validates photo and upload photos
if (FileUploadControl.HasFile)
{
HttpPostedFile postedFile = FileUploadControl.PostedFile;
string fileName = Path.GetFileName(postedFile.FileName);
string fileExtension = Path.GetExtension(fileName);
int fileSize = postedFile.ContentLength;
if (fileExtension.ToLower() == ".jpg" || fileExtension.ToLower() == ".bmp" ||
fileExtension.ToLower() == ".gif" || fileExtension.ToLower() == ".png")
{
sc.Open();
Stream stream = postedFile.InputStream;
BinaryReader br = new BinaryReader(stream);
byte[] bytes = br.ReadBytes((int)stream.Length);
SqlCommand cmd = new SqlCommand("UPDATE [dbo].[PropertyRoom] SET Image1 = @imgdata WHERE RoomID = @RoomID", sc);
cmd.Parameters.AddWithValue("@RoomID", Session["RoomID"]);
cmd.Parameters.AddWithValue("@imgdata", bytes);
cmd.ExecuteNonQuery();
sc.Close();
StatusLabel.Text = "Image Uploaded successfully";
}
else
{
StatusLabel.Text = "Only Images (.jpg, .png, .gif and .bmp) can be uploaded!";
return;
}
}
else
{
StatusLabel.Text = "Please select an image to upload";
return;
}
if (FileUpload2.HasFile)
{
HttpPostedFile postedFile = FileUpload2.PostedFile;
string fileName = Path.GetFileName(postedFile.FileName);
string fileExtension = Path.GetExtension(fileName);
int fileSize = postedFile.ContentLength;
if (fileExtension.ToLower() == ".jpg" || fileExtension.ToLower() == ".bmp" ||
fileExtension.ToLower() == ".gif" || fileExtension.ToLower() == ".png")
{
sc.Open();
Stream stream = postedFile.InputStream;
BinaryReader br = new BinaryReader(stream);
byte[] bytes = br.ReadBytes((int)stream.Length);
SqlCommand cmd = new SqlCommand("UPDATE [dbo].[PropertyRoom] SET Image2 = @imgdata WHERE RoomID = @RoomID", sc);
cmd.Parameters.AddWithValue("@RoomID", Session["RoomID"]);
cmd.Parameters.AddWithValue("@imgdata", bytes);
cmd.ExecuteNonQuery();
sc.Close();
StatusLabel.Text = "Image Uploaded successfully";
}
else
{
StatusLabel.Text = "Only Images (.jpg, .png, .gif and .bmp) can be uploaded!";
return;
}
}
if (FileUpload3.HasFile)
{
HttpPostedFile postedFile = FileUpload3.PostedFile;
string fileName = Path.GetFileName(postedFile.FileName);
string fileExtension = Path.GetExtension(fileName);
int fileSize = postedFile.ContentLength;
if (fileExtension.ToLower() == ".jpg" || fileExtension.ToLower() == ".bmp" ||
fileExtension.ToLower() == ".gif" || fileExtension.ToLower() == ".png")
{
sc.Open();
Stream stream = postedFile.InputStream;
BinaryReader br = new BinaryReader(stream);
byte[] bytes = br.ReadBytes((int)stream.Length);
SqlCommand cmd = new SqlCommand("UPDATE [dbo].[PropertyRoom] SET Image3 = @imgdata WHERE RoomID = @RoomID", sc);
cmd.Parameters.AddWithValue("@RoomID", Session["RoomID"]);
cmd.Parameters.AddWithValue("@imgdata", bytes);
cmd.ExecuteNonQuery();
sc.Close();
StatusLabel.Text = "Image Uploaded successfully";
}
else
{
StatusLabel.Text = "Only Images (.jpg, .png, .gif and .bmp) can be uploaded!";
return;
}
}
Response.Redirect("CreateAccountSafetyHomeowner.aspx");
}
get => (Badge)GetValue(BadgeProperty); set => SetValue(BadgeProperty, value);
set => SetValue(BadgeProperty, value);
public bool CheckProperty(BadgeProperty property)
{
switch (property)
{
case BadgeProperty.Running: return CardIdleActive;
case BadgeProperty.HasTrial: return HasTrial;
case BadgeProperty.Enqueued: return IsInQueue;
case BadgeProperty.Blacklisted: return IsBlacklisted;
default: throw new ArgumentException();
}
}
