protected void btnVerifyPhone_Click(object sender, EventArgs e)
{
pnlPhone.Visible = true;
btnVerifyPhone.Enabled = false;
// Your Account SID from twilio.com/console
var accountSid = "AC6df3f3bb4adeee93cdbc734e56757194";
// Your Auth Token from twilio.com/console
var authToken = "268d599703a742f5a70d22e28ad3e2ab";
TwilioClient.Init(accountSid, authToken);
if (tbxPhone.Value == "")
{
pnlMessageOutput.Visible = true;
lblOutput.Text = "Please insert phone number.";
}
else if (MemberDB.getMemberbyPhone(tbxPhone.Value).Email != null)
{
pnlMessageOutput.Visible = true;
lblOutput.Text = "Phone number exists.";
}
else
{
string otp = Utility.getRandomizedChar(5, 0);
var message = MessageResource.Create(
to: new PhoneNumber("+65" + tbxPhone.Value),
from: new PhoneNumber("+12566678209"),
body: otp + " is your RentHere OTP.");
Session["OTP"] = otp;
}
}
// method to read the column values in the database (through the referenced reader) and assign it to the correct properties of the referenced MemberMessage object
// allows for easier editing of column names if needed, used only for methods with select statments regarding MemberMessage
private static void readAMsg(ref MemberMessage msg, ref SqlDataReader reader)
{
msg.MemberInbox = MemberInboxDB.getMemberInboxID(reader["memberInboxID"].ToString());
msg.Reply = Convert.ToString(reader["reply"]);
msg.Date = Convert.ToDateTime(reader["date"]);
msg.Sender = MemberDB.getMemberbyID(reader["senderID"].ToString());
}
public ActionResult Register(RegisterViewModel mem)
{
// make sure model is valid
if (ModelState.IsValid)
{
if (MemberDB.DoesUsernameExist(mem.Username))
{
ModelState.AddModelError("DuplicateUsername", "Username is already taken");
return(View(mem));
}
// if valid add to DB
Member m = new Member()
{
Username = mem.Username,
Password = mem.Password,
Email = mem.Email,
};
MemberDB.RegisterMember(m);
SessionHelper.LogUserIn(m);
return(RedirectToAction("Index", "Home"));
}
// if invalid, return view w/ errors
return(View(mem));
}
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);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
//Validate the UI
if (string.IsNullOrEmpty(txtJoinDate.Text.Trim()))
{
MessageBox.Show("Please enter a member name.");
txtJoinDate.Focus();
return;
}
Member objMember = MemberDB.GetMember(txtNumber.Text);
try
{
bool status = MemberDB.DeleteMember(objMember);
if (status) //You can use this syntax as well..if (status ==true)
{
MessageBox.Show("Member was deleted from the database.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Member was not deleted from the database.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// gets messages regarding dispute selected
protected string retrieveMessage(string memberID, string staffID, string reply, string datePosted)
{
if (memberID != "")
{
return(" <div class='item'> \n " +
" <div class='text'> \n " +
" <div class='heading'> \n " +
" <a class='text-success' href='#'>" + MemberDB.getMemberbyID(memberID).Name + "</a> \n " +
" <span class='date'>" + Convert.ToString(datePosted) + "</span> \n " +
" </div> \n " +
reply +
" </div> \n " +
" </div> \n ");
}
else
{
return(" <div class='item'> \n " +
" <div class='text'> \n " +
" <div class='heading'> \n " +
" <a href='#'> <Strong> (Staff) " + StaffDB.getStaffbyID(staffID).Name + " </strong> </a> \n " +
" <span class='date'>" + Convert.ToString(datePosted) + "</span> \n " +
" </div> \n " +
reply +
" </div> \n " +
" </div> \n ");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["user"] == null)
{
pnlBeforeLogin.Visible = true;
}
else
{
pnlAfterLogin.Visible = true;
string[] fullName = MemberDB.getMemberbyEmail(Session["user"].ToString()).Name.Split(' ');
lblUsername.Text = " " + fullName[0];
}
ddlCategory.DataSource = CategoryDB.getAllCategory();
ddlCategory.DataBind();
ddlLocation.DataSource = LocationDB.getAllLocation();
ddlLocation.DataBind();
ddlLocation.Items.Insert(0, new ListItem("Singapore", ""));
}
}
protected void btnResolve_Click(object sender, EventArgs e)
{
Dispute dis = DisputeDB.getDisputeforRental(Request["rentid"].ToString());
if (dis.Status == "Resolved")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Your page has expired since your disputer has closed the case')", true);
rptMessages.DataBind();
setChatControls(false);
tbxMessage.Text = "";
return;
}
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "confirmMessage", "confirm('You are about to close the dispute case. As the action is irreversible, are you sure?')", true);
DisputeDB.resolveDispute(dis.DisputeID);
MessageDispute msgDis = new MessageDispute();
msgDis.Date = DateTime.Now;
msgDis.Dispute = dis;
msgDis.Member = MemberDB.getMemberbyEmail(Session["user"].ToString());
msgDis.Staff = new Staff(null, null, null, null, 0, null, new DateTime());
msgDis.Reply = "==============The Dispute has been closed================";
MessageDisputeDB.addMsgDispute(msgDis);
setChatControls(false);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (tbxMessage.Text.Length > 255)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Your message cannot exceed 255 characters!')", true);
return;
}
Dispute dis = DisputeDB.getDisputeforRental(Request["rentid"].ToString());
if (dis.Status == "Resolved")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Your page has expired since your disputer has closed the case')", true);
rptMessages.DataBind();
setChatControls(false);
tbxMessage.Text = "";
return;
}
if (tbxMessage.Text != "")
{
if (dis.DisputeID == null)
{
if (ddlReason.SelectedValue != "")
{
dis = new Dispute();
dis.Reason = ddlReason.SelectedItem.Value;
dis.Date = DateTime.Now;
dis.Rental = RentalDB.getRentalbyID(Request["rentid"].ToString());
dis.Status = "Pending";
dis.SubmittedBy = MemberDB.getMemberbyEmail(Session["user"].ToString());
DisputeDB.addDispute(dis);
ddlReason.Enabled = false;
}
else
{
return;
}
}
dis = DisputeDB.getDisputeforRental(Request["rentid"].ToString());
MessageDispute msgDis = new MessageDispute();
msgDis.Date = DateTime.Now;
msgDis.Dispute = dis;
msgDis.Member = MemberDB.getMemberbyEmail(Session["user"].ToString());
msgDis.Staff = new Staff(null, null, null, null, 0, null, new DateTime());
msgDis.Reply = tbxMessage.Text;
MessageDisputeDB.addMsgDispute(msgDis);
tbxMessage.Text = "";
rptMessages.DataSource = MessageDisputeDB.getMsgforDispute(dis.DisputeID);
rptMessages.DataBind();
}
}
// method to get all support ticket from the database
public static List <SupportTicket> getAllSupportTicket()
{
List <SupportTicket> ticketList = new List <SupportTicket>();
try
{
SqlCommand command = new SqlCommand("Select * from SupportTicket");
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
SupportTicket t = new SupportTicket();
t.TicketID = reader["ticketID"].ToString();
t.Title = reader["title"].ToString();
t.Description = reader["description"].ToString();
t.Date = Convert.ToDateTime(reader["Date"]);
t.Status = reader["status"].ToString();
t.Urgency = reader["urgency"].ToString();
t.Member = MemberDB.getMemberbyID(reader["memberID"].ToString());
ticketList.Add(t);
}
reader.Close();
}
finally
{
connection.Close();
}
return(ticketList);
}
// method to get all support tickets with answered status from the database
public static List <SupportTicket> getAnsweredSupportTicket()
{
List <SupportTicket> ticketList = new List <SupportTicket>();
try
{
SqlCommand command = new SqlCommand("Select ticketID, title, description, date, st.status, urgency, m.memberID, m.name, m.address, m.postalCode,m.password, m.email, m.phoneNumber, m.identificationNumber, m.identificationPicture, m.dateJoined , m.dateOfBirth, m.dateVerified, m.gender, m.status as MState, m.profilePic from SupportTicket st, Member m where st.status = 'Answered' and st.memberID = m.memberID");
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
SupportTicket t = new SupportTicket();
t.TicketID = reader["ticketID"].ToString();
t.Title = reader["title"].ToString();
t.Description = reader["description"].ToString();
t.Date = Convert.ToDateTime(reader["Date"]);
t.Status = reader["status"].ToString();
t.Urgency = reader["urgency"].ToString();
t.Member = MemberDB.getMemberbyID(reader["memberID"].ToString());
ticketList.Add(t);
}
reader.Close();
}
finally
{
connection.Close();
}
return(ticketList);
}
protected void Page_Load(object sender, EventArgs e)
{
// user has selected a member to be viewed. this page displays information about the member selected
// checks if user is logged in
if (Session["admin"] == null) // if user is not logged in, redirect to login page
{
Response.Redirect("Login.aspx");
return;
}
// check if member is selected
if (Request.QueryString["memberID"] == null) // if nothing is selected, redirect to MemberList page
{
Server.Transfer("~/memberList.aspx");
}
else
{
// if member is selected, display the correct information for the item selected
List <Member> memberList = new List <Member>();
memberList.Add(MemberDB.getMemberbyID(Request.QueryString["memberID"].ToString()));
rptMemberInfo.DataSource = memberList;
rptMemberInfo.DataBind();
}
// allows user to see items listed by member
List <Item> itemList = ItemDB.getAllItemofMember(MemberDB.getMemberbyID(Request.QueryString["memberID"].ToString()).MemberID);
rptItemList.DataSource = itemList;
rptItemList.DataBind();
}
// gets messages regarding supoprt ticket selected
protected string retrieveMessage(string memberID, string staffID, string reply, string datePosted)
{
if (MemberDB.getMemberbyID(memberID).Email == SupportTicketDB.getSupportTicketbyID(Request.QueryString["ticketID"].ToString()).Member.Email)
{
return(" <div class='item'> \n " +
" <div class='text'> \n " +
" <div class='heading'> \n " +
" <a class='text-success' href='#'>" + MemberDB.getMemberbyID(memberID).Name + "</a> \n " +
" <span class='date'>" + Convert.ToString(datePosted) + "</span> \n " +
" </div> \n " +
reply +
" </div> \n " +
" </div> \n ");
}
else
{
return(" <div class='item'> \n " +
" <div class='text'> \n " +
" <div class='heading'> \n " +
" <a href='#'> <Strong> (Staff) " + StaffDB.getStaffbyID(staffID).Name + " </strong> </a> \n " +
" <span class='date'>" + Convert.ToString(datePosted) + "</span> \n " +
" </div> \n " +
reply +
" </div> \n " +
" </div> \n ");
}
}
protected void lsvItemPostedList_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e)
{
DataPager1.SetPageProperties(e.StartRowIndex, e.MaximumRows, false);
lsvItemPostedList.DataSource = ItemDB.getAllItemofMember(MemberDB.getMemberbyEmail(Session["user"].ToString()).MemberID);
lsvItemPostedList.DataBind();
}
public ActionResult Register(RegisterViewModel registerUser)
{
if (ModelState.IsValid)
{
if (MemberDB.IsUsernameTaked(registerUser))
{
ModelState.AddModelError("UsernameTaken",
"Username has been already taken!");
return(View(registerUser));
}
Member m = new Member()
{
Username = registerUser.Username,
EmailAddress = registerUser.Email
};
MemberDB.AddMember(m);
SessionHelper.LogUserIn(m.Username);
// redirect to home page
return(RedirectToAction("Index", "Home"));
}
return(View(registerUser));
}
// gets sum of ratings by member from the database
public static List <MemberAnalytic> getMemberFeedbackAnalytic()
{
List <MemberAnalytic> feedList = new List <MemberAnalytic>();
try
{
SqlCommand command = new SqlCommand("SELECT feedbackTo, sum(case when rating='Positive' then 1 else 0 end) AS positiveCount, sum(case when rating = 'Neutral' then 1 else 0 end) AS neutralCount, sum(case when rating = 'Negative' then 1 else 0 end) AS negativeCount FROM Feedback F, Member M WHERE F.feedbackTo = M.memberID and M.status<>'Banned' GROUP BY feedbackTo");
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
MemberAnalytic ma = new MemberAnalytic();
ma.Member = MemberDB.getMemberbyID(reader["feedbackTo"].ToString());
ma.NoOfPositiveFeedback = Convert.ToInt32(reader["positiveCount"]);
ma.NoOfNeutralFeedback = Convert.ToInt32(reader["neutralCount"]);
ma.NoOfNegativeFeedback = Convert.ToInt32(reader["negativeCount"]);
ma.NoOfRentalAsRenter = RentalDB.getNoofRentalAsRenter(ma.Member.MemberID);
ma.NoOfRentalAsRentee = RentalDB.getNoofRentalAsRentee(ma.Member.MemberID);
feedList.Add(ma);
}
reader.Close();
}
finally
{
connection.Close();
}
return(feedList);
}
private void btnSignUp_Click(object sender, EventArgs e)
{
try
{
Member member = new Member();
member.joindate = DateTime.Now.ToString();
member.firstname = txtFName.Text;
member.lastname = txtLName.Text;
member.address = txtAddress.Text;
member.city = txtCity.Text;
member.state = txtState.Text;
member.zipcode = txtZipcode.Text;
member.phone = maskedTextBox1.Text;
member.member_status = "A";
member.login_name = txtUsername.Text;
member.password = txtPass.Text;
member.email = txtEmail.Text;
member.contact_method = "1";
member.subscription_id = "1";
member.photo = "";
MemberDB.AddMember(member);
MessageBox.Show("Welcome to Meramec OnLine Movie Kiosk " + member.login_name);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Clears form and loads list boxes with data.
/// </summary>
private void LoadBoxes()
{
Clear();
List <Member> allMembers =
MemberDB.GetAllMembers();
if (allMembers != null)
{
foreach (Member m in allMembers)
{
lstMembers.Items.Add($"{m.MemberID}, " +
$"{m.Username}, " +
$"{m.LastName}, " +
$"{m.FirstName}, " +
$"Admin: " +
$"{m.IsAdmin}");
}
}
List <Book> allBooks =
LibraryDB.GetAllBooks();
if (allBooks != null)
{
foreach (Book b in allBooks)
{
lstBooks.Items.Add($"{b.ISBN}, " +
$"{b.Title}, " +
$"{b.Author}, " +
$"{b.PubDate}, " +
$"{b.Category}");
}
}
}
public RentalSearchForm(int memberID)
{
InitializeComponent();
Global.memberID = memberID;
Member currentMember = MemberDB.GetMember(memberID);
lblName.Text = "Hello " + currentMember.firstname;
List <Movie> myMovieList = MovieDB.GetMovies();
List <PictureBox> pixBoxes = new List <PictureBox>();
pixBoxes.Add(pictureBox7);
pixBoxes.Add(pictureBox8);
pixBoxes.Add(pictureBox9);
pixBoxes.Add(pictureBox10);
imageList1.ImageSize = new Size(32, 32);
for (int i = 0; i < pixBoxes.Count; i++)
{
pixBoxes[i].Load(myMovieList[i].image);
}
//foreach (Movie movie in myMovieList)
//{
// pictureBox1.Load(movie.image);
// var newImage = Image.FromFile(@"C:\Users\pezhe\OneDrive\Documents\College Classes\C# II\In-Class Demos\Week 10\Project2Template_v2Fall2016\Project2Template\MeramecNetFlixProject\Resources\stlcc-icon-dark-blue.png");
// pictureBox1.Image = newImage;
// imageList1.Images.Add(newImage);
//}
}
// check if member logged in is giving or recieving feedback
public string isGiveorReceiveFeedback(string rentalID, string renteeID, string rentStatus)
{
if (rentStatus != "On-going")
{
Feedback feed = FeedbackDB.getFeedbackforRental(rentalID);
if (feed.FeedbackID != null)
{
if (renteeID == MemberDB.getMemberbyEmail(Session["user"].ToString()).MemberID)
{
return("Review Feedback");
}
else
{
return("Feedback Given");
}
}
else
{
if (renteeID == MemberDB.getMemberbyEmail(Session["user"].ToString()).MemberID)
{
return("Give Feedback");
}
else
{
return("No Feedback Yet");
}
}
}
else
{
return("");
}
}
private void BtnSubmit_Click(object sender, EventArgs e)
{
if (!(ValidateUI(BtnSubmit)))
{
return;
}
Member currentMember;
try
{
currentMember = MemberDB.LoginMember(txtUsername.Text, txtPassword.Text);
if (currentMember != null)
{
new RentalSearchForm(currentMember.member_number).Show();
this.Close();
}
else
{
MessageBox.Show("Login failed, username and/or password incorrect", "MeramecNetFlix", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "MeramecNetFlix", MessageBoxButtons.OK, MessageBoxIcon.Error);
throw ex;
}
}
private void btn_Browse_Click(object sender, EventArgs e)
{
dataGridView1.Rows.Clear();
foreach (Member m in MemberDB.GetMembers())
{
//put each genre object into a datagridview row object
DataGridViewRow newRow = new DataGridViewRow();
//creates cells using dataGridView1 as a template
newRow.CreateCells(dataGridView1);
newRow.Cells[0].Value = m.id;
newRow.Cells[1].Value = m.joindate;
newRow.Cells[2].Value = m.firstname;
newRow.Cells[3].Value = m.lastname;
newRow.Cells[4].Value = m.address;
newRow.Cells[5].Value = m.city;
newRow.Cells[6].Value = m.state;
newRow.Cells[7].Value = m.zipcode;
newRow.Cells[8].Value = m.phone;
newRow.Cells[9].Value = m.member_status;
newRow.Cells[10].Value = m.login_name;
newRow.Cells[11].Value = m.password;
newRow.Cells[12].Value = m.email;
newRow.Cells[13].Value = m.subscription_id;
newRow.Cells[14].Value = m.admin;
dataGridView1.Rows.Add(newRow);
}
}
protected void Page_Load(object sender, EventArgs e)
{
_memberid = ConvertUtility.ToInt32(Request.QueryString["mi"]);
_activeCode = ConvertUtility.ToString(Request.QueryString["code"]);
string notApprove = "Mã kích hoạt không hợp lệ, vui lòng kiểm tra email đăng ký để có mã kích hoạt hợp lệ.";
if (_activeCode.Length >= 150)
{
notice.InnerHtml = notApprove;
return;
}
var memberInfo = MemberDB.GetInfo(_memberid);
if (memberInfo != null)
{
if (_activeCode == memberInfo.Member_ActiveCode)
{
memberInfo.Member_Active = true;
MemberDB.Update(memberInfo);
notice.InnerHtml = "Chúc mừng bạn đã kích hoạt tài khoản thành công. Từ bây giờ bạn có thể đăng nhập và mua sắm cùng My-Deal.vn";
}
else
{
notice.InnerHtml = notApprove;
}
}
else
{
notice.InnerHtml = notApprove;
}
}
protected void btnRenterProfile_Click(object sender, EventArgs e)
{
// Redirect to renter's profile page
Item itemInfo = ItemDB.getItembyID(Request.QueryString["itemID"].ToString());
Response.Redirect("~/User.aspx?memberID=" + MemberDB.getMemberbyID(ItemDB.getItembyID(Request.QueryString["itemID"].ToString()).Renter.MemberID).MemberID);
}
protected void btnSend_Click(object sender, EventArgs e)
{
if (tbxMessage.Text.Length > 255)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Your message cannot exceed 255 characters!')", true);
return;
}
if (tbxMessage.Text != "")
{
MemberMessage msgDis = new MemberMessage();
msgDis.Date = DateTime.Now;
msgDis.Reply = tbxMessage.Text;
msgDis.Sender = MemberDB.getMemberbyEmail(Session["user"].ToString());
msgDis.MemberInbox = MemberInboxDB.getMemberInboxID(Request.QueryString["memberInboxID"].ToString());
//msgDis.Receiver = MemberDB.getMemberbyID(MemberDB.getMemberbyID("MEM000000001").MemberID);
//msgDis.Item = ItemDB.getItembyID("ITM000000003");
MemberMessageDB.AddMsgMember(msgDis);
tbxMessage.Text = "";
rptMessages.DataBind();
Response.Redirect(Request.RawUrl);
}
}
protected void btnContactRenter_Click(object sender, EventArgs e)
{
if (Session["user"].ToString() == null)
{
Response.Redirect("Login.aspx");
return;
}
else
{
// If memberInbox doesnt exist
if (MemberInboxDB.searchMemberInbox(MemberDB.getMemberbyEmail(Session["user"].ToString()).MemberID, ItemDB.getItembyID(Request.QueryString["itemID"].ToString()).ItemID) == null)
{
MemberInbox mem = new MemberInbox();
mem.Date = DateTime.Now;
mem.Item = ItemDB.getItembyID(Request.QueryString["itemID"]);
mem.Sender = MemberDB.getMemberbyEmail(Session["user"].ToString());
int memberInboxID = MemberInboxDB.AddMsgMember(mem);
Response.Redirect("/inboxMessage.aspx?memberInboxID=" + memberInboxID);
}
else
{
Response.Redirect("/inboxMessage.aspx?memberInboxID=" + MemberInboxDB.searchMemberInbox(MemberDB.getMemberbyEmail(Session["user"].ToString()).MemberID, ItemDB.getItembyID(Request.QueryString["itemID"].ToString()).ItemID).MemberInboxID);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
foreach (Control control in groupBoxMemberData.Controls)
{
if (string.IsNullOrEmpty(control.Text.Trim()))
{
MessageBox.Show("Please enter a value for " + control.Name.ToString());
control.Focus();
return;
}
}
Member objMember = new Member();
objMember.memberNumber = Convert.ToInt32(lblSelected.Text);
try
{
bool status = MemberDB.DeleteMember(objMember);
if (status) //You can use this syntax as well..if (status ==true)
{
Reload_Data();
MessageBox.Show("Member was deleted from the database.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Member was not deleted from the database.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// method to read the column values in the database (through the referenced reader) and assign it to the correct properties of the referenced MemberInbox object
// allows for easier editing of column names if needed, used only for methods with select statments regarding MemberInbox
private static void readAMsg(ref MemberInbox msg, ref SqlDataReader reader)
{
msg.MemberInboxID = Convert.ToInt32(reader["memberInboxID"]);
msg.Date = Convert.ToDateTime(reader["date"]);
msg.Sender = MemberDB.getMemberbyID(reader["senderID"].ToString());
msg.Item = ItemDB.getItembyID(reader["itemID"].ToString());
}
// method to get rentee from rental record from the database
public static Member getRenteeforRental(string rentalID)
{
Member m = new Member();
try
{
SqlCommand command = new SqlCommand("SELECT * FROM Rental WHERE rentalID = @rentalID");
command.Parameters.AddWithValue("@rentalID", rentalID);
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
m = MemberDB.getMemberbyID(reader["renteeID"].ToString());
}
reader.Close();
}
finally
{
connection.Close();
}
return(m);
}
// gets message regarding inbox
protected string retrieveMessage(string senderID, string reply, string datePosted)
{
if (MemberDB.getMemberbyID(senderID).Email == MemberInboxDB.getMemberInboxID(Request.QueryString["memberInboxID"].ToString()).Sender.Email)
{
return(" <div class='item '> \n" +
" <div class='image'> \n" +
" <img src='assets/images/users/user2.jpg' > \n" +
" </div> \n" +
" <div class='text' > \n" +
" <div class='heading' > \n" +
" <a href='#'>" + MemberDB.getMemberbyID(senderID).Name + "</a> \n" +
" <span class='date' >" + datePosted + "</span> \n" +
" </div> \n" +
reply + " </div> \n" +
" </div> \n");
}
else
{
return(" <div class='item in'> \n" +
" <div class='image' > \n" +
" <img src='assets/images/users/user.jpg'> \n" +
" </div> \n" +
" <div class='text'> \n" +
" <div class='heading' > \n" +
" <a href='#'>" + MemberDB.getMemberbyID(senderID).Name + "</a> \n" +
" <span class='date' >" + datePosted + "</span> \n" +
" </div> \n" +
reply +
" </div> \n" +
" </div> \n");
}
}