protected void btnSubmit_Click(object sender, EventArgs e) { Item newItem = new Item(); newItem.CategoryName = CategoryDB.getCategorybyName("Services"); newItem.Deposit = Convert.ToDecimal(tbxRefundableDeposit.Text); newItem.Location = LocationDB.getLocationbyID(ddlMRTLocation.SelectedValue); newItem.PricePerDay = Convert.ToDecimal(tbxPricePerDay); newItem.PricePerWeek = Convert.ToDecimal(tbxPricePerWeek); newItem.PricePerMonth = Convert.ToDecimal(tbxPricePerMonth); newItem.Renter = MemberDB.getMemberbyEmail(Session["user"].ToString()); newItem.Description = tbxDescription.InnerText; newItem.PostedDate = DateTime.Now; newItem.ItemID = Utility.convertIdentitytoPK("ITM", ItemDB.addItem(newItem)); List <string> tags = Utility.findHashTags(tbxDescription.InnerText); if (tags.Count > 0) { foreach (string t in tags) { if (!TagDB.isTagPresent(t)) { TagDB.addTag(t); } ItemTagDB.addItemTag(newItem, t); } } }
// method to read the column values in the database (through the referenced reader) and assign it to the correct properties of the referenced Item object // allows for easier editing of column names if needed, used only for methods with select statments regarding Item private static void readAItem(ref Item i, ref SqlDataReader reader) { i.ItemID = reader["itemID"].ToString(); i.Name = reader["name"].ToString(); i.Description = reader["description"].ToString(); i.PostedDate = Convert.ToDateTime(reader["postedDate"]); i.Deposit = Convert.ToDecimal(reader["deposit"]); i.CategoryName = CategoryDB.getCategorybyName(reader["categoryName"].ToString()); i.Location = LocationDB.getLocationbyID(reader["locationName"].ToString()); //This sectin will set the default value of 0 whenever null is found in the database if (reader["pricePerDay"] != DBNull.Value) { i.PricePerDay = Convert.ToDecimal(reader["pricePerDay"]); } else { i.PricePerDay = 0; } if (reader["pricePerWeek"] != DBNull.Value) { i.PricePerWeek = Convert.ToDecimal(reader["pricePerWeek"]); } else { i.PricePerWeek = 0; } if (reader["pricePerMonth"] != DBNull.Value) { i.PricePerMonth = Convert.ToDecimal(reader["pricePerMonth"]); } else { i.PricePerMonth = 0; } // This section for collecting images if (reader["img1"] != DBNull.Value) { i.Img1 = reader["img1"].ToString(); } else { i.Img1 = "NotAvailable.jpg"; } if (reader["img2"] != DBNull.Value) { i.Img2 = reader["img2"].ToString(); } else { i.Img2 = "NotAvailable.jpg"; } if (reader["img3"] != DBNull.Value) { i.Img3 = reader["img3"].ToString(); } else { i.Img3 = "NotAvailable.jpg"; } if (reader["img4"] != DBNull.Value) { i.Img4 = reader["img4"].ToString(); } else { i.Img4 = "NotAvailable.jpg"; } //This section for getting the renter of an item i.Renter = MemberDB.getMemberbyID(reader["renterID"].ToString()); }