public string checkEndDate(string rentalID)
{
Extension itemExtension = ExtensionDB.getLastExtensionofRental(rentalID);
Rental itemRental = RentalDB.getRentalbyID(rentalID);
if (itemExtension.ExtensionID == null)
{
return(String.Format("{0:MM/dd/yy}", itemRental.StartDate) + " - " + String.Format("{0:MM/dd/yy}", itemRental.EndDate));
}
else
{
return(String.Format("{0:MM/dd/yy}", itemRental.StartDate) + " - " + String.Format("{0:MM/dd/yy}", itemExtension.NewEndDate));
}
}
public string checkEndDate(string rentalID)
{
Extension itemExtension = ExtensionDB.getLastExtensionofRental(rentalID);
if (itemExtension.ExtensionID == null)
{
Rental itemRental = RentalDB.getRentalbyID(rentalID);
return(itemRental.EndDate.ToString());
}
else
{
return(itemExtension.NewEndDate.ToString());
}
}
protected void repeaterItemInformation_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
// check if there is on going rental extenson for item selected
Extension itemExtension = ExtensionDB.getLastExtensionofItem(Request.QueryString["itemID"], "On-going");
if (itemExtension.ExtensionID == null)
{
List <Rental> itemRental = RentalDB.getRentalofItem(Request.QueryString["itemID"], "On-going");
if (itemRental.Count == 0)
{
itemStatus = "Available";
}
else
{
itemStatus = "On-going";
// itemRental[0].
}
}
else
{
itemStatus = "On-going Extended";
// itemExtension.NewEndDate
}
// To display the status of the item to the user
if (e.Item.ItemType == ListItemType.Item)
{
// allow renting if no extension, allow reserve if there is
Button btnRent = (Button)e.Item.FindControl("btnRent");
Label lblItemStatus = e.Item.FindControl("lblItemStatus") as Label;
lblItemStatus.Text = itemStatus;
if (itemStatus == "On-going" || itemStatus == "On-going Extended")
{
btnRent.Text = "Reserve Now";
}
else
{
btnRent.Text = "Rent Now";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Session["pageRedirectAfterLogin"] = Request.RawUrl;
Response.Redirect("Login.aspx");
return;
}
if (Request.QueryString["itemID"] == null)
{
Response.Redirect("Categories.aspx");
return;
}
lblDepositAmount.Text = ItemDB.getItembyID(Request.QueryString["itemID"]).Deposit.ToString();
List <Item> itemInfo = new List <Item>();
itemInfo.Add(ItemDB.getItembyID(Request.QueryString["itemID"]));
rptItemRentalInfo.DataSource = itemInfo;
rptItemRentalInfo.DataBind();
var selectedDates = new List <DateTime?>();
Extension itemExtension = ExtensionDB.getLastExtensionofItem(Request.QueryString["itemID"], "On-going");
List <Rental> itemRental = RentalDB.getRentalofItem(Request.QueryString["itemID"], "Scheduled");
List <Rental> itemRentalInfo = RentalDB.getRentalofItem(Request.QueryString["itemID"], "On-going");
if (itemExtension != null)
{
for (var date = itemRentalInfo[0].StartDate; date <= itemExtension.NewEndDate; date = date.AddDays(1))
{
selectedDates.Add(date);
}
}
foreach (Rental rental in itemRental)
{
for (var date = rental.StartDate; date <= rental.EndDate; date = date.AddDays(1))
{
selectedDates.Add(date);
}
}
for (int i = 0; i < selectedDates.Count(); i++)
{
string temp = selectedDates[i].ToString();
temp = temp.Replace(" 12:00:00 AM", "");
DateTime dt = new DateTime();
int temp2 = temp.IndexOf("/");
// Make sure that the day is single digit
if (temp2 == 1)
{
dt = DateTime.ParseExact(temp, "d/M/yyyy", CultureInfo.InvariantCulture);
}
else
{
dt = DateTime.ParseExact(temp, "dd/M/yyyy", CultureInfo.InvariantCulture);
}
disabledDate = disabledDate + "'" + dt.ToString("yyyy-MM-dd") + "'" + ", ";
}
ClientScript.RegisterStartupScript(GetType(), "datePickerInit", "var datepicker = new HotelDatepicker(document.getElementById('input-id'), { disabledDates: [ " + disabledDate + " ] });", true);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Item itemRental = ItemDB.getItembyID(Request.QueryString["itemID"]);
string inputDates = String.Format("{0}", Request.Form["input-id"]);
if (inputDates != "")
{
DateTime startDate = Convert.ToDateTime(inputDates.Substring(0, 10));
DateTime endDate = Convert.ToDateTime(inputDates.Substring(inputDates.Length - 10));
int numOfDays = Convert.ToInt32((endDate - startDate).TotalDays);
if (Session["itemExtension"].ToString() == "ExtendItem")
{
Extension lastExtension = ExtensionDB.getLastExtensionofRental(Request.QueryString["rentalID"].ToString());
if (lastExtension.ExtensionID != null)
{
if (startDate.CompareTo(lastExtension.NewEndDate.AddDays(1)) != 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Extension must start right after your rental period ends')", true);
return;
}
}
else
{
Rental currentRental = RentalDB.getRentalbyID(Request.QueryString["rentalID"].ToString());
if (startDate.CompareTo(currentRental.EndDate.AddDays(1)) != 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Extension must start right after your rental period ends')", true);
return;
}
}
}
decimal totalDayPrice = 0, totalWeekPrice = 0, totalMonthPrice = 0, amountDue = 0;
if (itemRental.PricePerMonth != 0)
{
totalMonthPrice = (numOfDays / 30) * itemRental.PricePerMonth;
if (itemRental.PricePerWeek != 0)
{
totalWeekPrice = (numOfDays % 30) / 7 * itemRental.PricePerWeek;
if (itemRental.PricePerDay != 0)
{
totalDayPrice = (numOfDays % 30) % 7 * itemRental.PricePerDay;
}
}
else
{
totalDayPrice = (numOfDays % 30) * itemRental.PricePerDay;
}
}
else
{
if (itemRental.PricePerWeek != 0)
{
totalWeekPrice = numOfDays / 7 * itemRental.PricePerWeek;
if (itemRental.PricePerDay != 0)
{
totalDayPrice = (numOfDays % 7) * itemRental.PricePerDay;
}
}
else
{
totalDayPrice = (numOfDays * itemRental.PricePerDay);
}
}
amountDue = totalDayPrice + totalWeekPrice + totalMonthPrice;
lblRentalRate.Text = amountDue.ToString();
Rental rental = new Rental();
Session["rentalPeriod"] = inputDates;
Session["rentalRate"] = lblRentalRate.Text;
try
{
rental.PickUpLocation = tbxPickUpLocation.Value;
rental.PickUpTime = Convert.ToDateTime(tbxPickUpTime.Value).TimeOfDay;
rental.ReturnLocation = tbxReturnLocation.Value;
rental.ReturnTime = Convert.ToDateTime(tbxReturnTime.Value).TimeOfDay;
rental.ReturnLocation = tbxReturnLocation.Value;
}
catch (Exception E)
{
Session["error"] = E.Message;
return;
}
if (Session["itemExtension"].ToString() == "ExtendItem")
{
rental.RentalFee = amountDue;
lblTotalAmountPayable.Text = rental.RentalFee.ToString();
Session["rental"] = rental;
Response.Redirect("Payment.aspx?itemID=" + Request.QueryString["itemID"] + "&rentalID=" + Request.QueryString["rentalID"].ToString());
}
else
{
rental.RentalFee = amountDue + itemRental.Deposit;
lblTotalAmountPayable.Text = rental.RentalFee.ToString();
Session["rental"] = rental;
Response.Redirect("Payment.aspx?itemID=" + Request.QueryString["itemID"]);
}
}
else
{
pnlMessageOutput.Visible = true;
lblOutput.Text = "Please select the dates";
}
}
protected void Page_Load(object sender, EventArgs e)
{
List <Item> itemInfo = new List <Item>();
// check if logged in
if (Session["user"] == null) // not logged in
{
Session["pageRedirectAfterLogin"] = Request.RawUrl;
Response.Redirect("Login.aspx"); // transfer to login page
return;
}
// check if user wants to extend
if (Session["itemExtension"].ToString() == "ExtendItem")
{
if (RentalDB.isRentalOfMemberPresent(Request.QueryString["rentalID"].ToString(), MemberDB.getMemberbyEmail(Session["user"].ToString()).MemberID))
{
Rental rentalInfo = RentalDB.getRentalbyID(Request.QueryString["rentalID"].ToString());
tbxPickUpLocation.Value = rentalInfo.PickUpLocation;
tbxPickUpTime.Value = rentalInfo.PickUpTime.ToString();
tbxReturnLocation.Value = rentalInfo.ReturnLocation;
tbxReturnTime.Value = rentalInfo.ReturnTime.ToString();
tbxPickUpLocation.Disabled = true;
tbxPickUpTime.Disabled = true;
tbxReturnLocation.Disabled = true;
tbxReturnTime.Disabled = true;
itemInfo.Add(ItemDB.getItembyID(RentalDB.getRentalbyID(Request.QueryString["rentalID"].ToString()).Item.ItemID));
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Inaccessible Page!')", true);
Response.Redirect("RentalHistory.aspx");
}
}
else if (Request.QueryString["itemID"] == null)
{
Response.Redirect("Categories.aspx");
return;
}
else
{
lblDepositAmount.Text = ItemDB.getItembyID(Request.QueryString["itemID"]).Deposit.ToString();
itemInfo.Add(ItemDB.getItembyID(Request.QueryString["itemID"]));
}
rptItemRentalInfo.DataSource = itemInfo;
rptItemRentalInfo.DataBind();
var selectedDates = new List <DateTime?>();
List <Rental> currentRental = RentalDB.getRentalofItem(Request.QueryString["itemID"], "On-going");
if (currentRental.Count > 0)
{
foreach (Rental rental in currentRental)
{
for (var date = rental.StartDate; date <= rental.EndDate; date = date.AddDays(1))
{
selectedDates.Add(date);
}
}
}
List <Rental> scheduledRental = RentalDB.getRentalofItem(Request.QueryString["itemID"], "Scheduled");
if (scheduledRental.Count > 0)
{
foreach (Rental rental in scheduledRental)
{
for (var date = rental.StartDate; date <= rental.EndDate; date = date.AddDays(1))
{
selectedDates.Add(date);
}
}
}
Extension itemExtension = ExtensionDB.getLastExtensionofItem(Request.QueryString["itemID"], "On-going");
if (itemExtension.ExtensionID != null)
{
for (var date = currentRental[0].StartDate; date <= itemExtension.NewEndDate; date = date.AddDays(1))
{
selectedDates.Add(date);
}
}
for (int i = 0; i < selectedDates.Count(); i++)
{
string temp = selectedDates[i].ToString();
temp = temp.Substring(0, temp.IndexOf(" "));
//temp = temp.Replace(" 12:00:00 AM", "");
DateTime dt = new DateTime();
int temp2 = temp.IndexOf("/");
// Make sure that the day is single digit
if (temp2 == 1)
{
dt = DateTime.ParseExact(temp, "d/M/yyyy", CultureInfo.InvariantCulture);
}
else
{
dt = DateTime.ParseExact(temp, "dd/M/yyyy", CultureInfo.InvariantCulture);
}
disabledDate = disabledDate + "'" + dt.ToString("yyyy-MM-dd") + "'" + ", ";
}
ClientScript.RegisterStartupScript(GetType(),
"datePickerInit", "var datepicker = new HotelDatepicker(document.getElementById('input-id'), { disabledDates: [ " + disabledDate + " ] });",
true);
}
protected void btnPay_Click(object sender, EventArgs e)
{
// submit payment
Item itemInfo = ItemDB.getItembyID(Request.QueryString["itemID"]);
Member mem = MemberDB.getMemberbyEmail(Session["user"].ToString());
Rental rentInfo = (Rental)Session["rental"];
var myCharge = new StripeChargeCreateOptions();
myCharge.Amount = Convert.ToInt32(rentInfo.RentalFee) * 100;
myCharge.Currency = "sgd";
myCharge.SourceCard = new SourceCard()
{
Number = "4242424242424242",
ExpirationYear = 2022,
ExpirationMonth = 10,
AddressCountry = "SG", // optional
AddressLine1 = mem.Address, // optional
AddressLine2 = mem.Address, // optional
AddressCity = "Singapore", // optional
AddressState = "NC", // optional
AddressZip = mem.PostalCode.ToString(), // optional
Name = mem.Name, // optional
Cvc = "1223" // optional
};
var chargeService = new StripeChargeService();
StripeCharge stripeCharge = chargeService.Create(myCharge);
PaymentPay pay = new PaymentPay();
pay.StripeRefNum = Utility.getRandomizedChar(5, 0);
string n = Session["rentalPeriod"].ToString();
string startDate = n.Substring(0, 10);
string endDate = n.Substring(n.Length - 10);
if (Session["itemExtension"].ToString() == "NotExtension")
{
rentInfo.DateCreated = DateTime.Now;
rentInfo.Deposit = itemInfo.Deposit;
rentInfo.PaymentReleaseCode = Utility.getRandomizedChar(6, 0);
rentInfo.Item = itemInfo;
rentInfo.StartDate = Convert.ToDateTime(startDate);
rentInfo.EndDate = Convert.ToDateTime(endDate);
rentInfo.Status = "Scheduled";
rentInfo.Payment = PaymentDB.getPaymentbyID(Utility.convertIdentitytoPK("PAY", PaymentDB.addPayment(pay)));
rentInfo.Rentee = mem;
rentInfo.Unit = "Day";
Response.Redirect("RentalDetails.aspx?rentalID=" + Utility.convertIdentitytoPK("RNT", RentalDB.addRental(rentInfo)));
}
else
{
Rental rent = RentalDB.getRentalbyID(Request.QueryString["rentalID"]);
Extension ext = new Extension();
ext.ExtensionRentalFee = rentInfo.RentalFee;
ext.NewEndDate = Convert.ToDateTime(endDate);
ext.NewReturnLocation = rent.ReturnLocation;
int paymentID = PaymentDB.addPayment(pay);
pay.PaymentID = Utility.convertIdentitytoPK("PAY", paymentID);
ext.NewReturnTime = rent.ReturnTime;
ext.Payment = pay;
ext.Rental = rent;
ext.Status = "Granted";
ext.Unit = "Day";
ExtensionDB.addExtension(ext);
Response.Redirect("RentalDetails.aspx?rentalID=" + Request.QueryString["rentalID"]);
}
}