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(); } }