// 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());
}
protected void Page_Load(object sender, EventArgs e)
{
// check if logged in
if (Session["user"] == null) // user not logged in
{
Session["pageRedirectAfterLogin"] = Request.RawUrl;
Response.Redirect("Login.aspx"); // transfer to login page
return;
}
if (Request.QueryString["memberInboxID"] == null) // check if inbox is empty
{
Response.Redirect("Default.aspx"); // empty redirect to default
return;
}
if (MemberInboxDB.isInboxPresentForMember(Request.QueryString["memberInboxID"].ToString(), MemberDB.getMemberbyEmail(Session["user"].ToString()).MemberID))
{
List <MemberMessage> memberMessageList = MemberMessageDB.getMsgforMember(Request.QueryString["memberInboxID"].ToString());
rptMessages.DataSource = memberMessageList;
rptMessages.DataBind();
List <Item> itemInfo = new List <Item>();
itemInfo.Add(ItemDB.getItembyID(MemberInboxDB.getMemberInboxID(Request.QueryString["memberInboxID"].ToString()).Item.ItemID));
rptItemInfo.DataSource = itemInfo;
rptItemInfo.DataBind();
}
else
{
tbxMessage.Enabled = false;
btnSend.Enabled = false;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Inaccessible Page!')", true);
}
}
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 Page_Load(object sender, EventArgs e)
{
// user has selected a message inbox to be viewed. this page displays messages pertaining the message inbox
// 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;
}
// checks if a message inbox is selected
if (Request.QueryString["memberInboxID"] == null) // if nothing is selected, redirect back to messageList page
{
Response.Redirect("~/messageList.aspx");
}
else // if message inbox is selected, display messages pertaining to that message inbox
{
List <MemberMessage> memberMessageList = MemberMessageDB.getMsgforMember(Request.QueryString["memberInboxID"].ToString());
List <MemberInbox> memberInbox = new List <MemberInbox>();
memberInbox.Add(MemberInboxDB.getMemberInboxID(Request.QueryString["memberInboxID"].ToString()));
lblInboxID.Text = MemberInboxDB.getMemberInboxID(Request.QueryString["memberInboxID"].ToString()).MemberInboxID.ToString();
rptMemberInfoRedirect.DataSource = memberInbox;
rptMemberInfoRedirect.DataBind();
rptMessages.DataSource = memberMessageList;
rptMessages.DataBind();
}
}
// 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");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Session["pageRedirectAfterLogin"] = Request.RawUrl;
Response.Redirect("Login.aspx");
return;
}
if (Request.QueryString["memberInboxID"] == null)
{
Response.Redirect("Default.aspx");
return;
}
List <MemberMessage> memberMessageList = MemberMessageDB.getMsgforMember(Request.QueryString["memberInboxID"].ToString());
rptMessages.DataSource = memberMessageList;
rptMessages.DataBind();
List <Item> itemInfo = new List <Item>();
itemInfo.Add(ItemDB.getItembyID(MemberInboxDB.getMemberInboxID(Request.QueryString["memberInboxID"].ToString()).Item.ItemID));
rptItemInfo.DataSource = itemInfo;
rptItemInfo.DataBind();
}
// method to get MemberMessage by memberInboxID from the database
public static List <MemberMessage> getMsgforMember(string memberInboxID)
{
List <MemberMessage> msgDisList = new List <MemberMessage>();
try
{
SqlCommand command = new SqlCommand("SELECT * FROM MemberMessage WHERE memberInboxID = @memberInboxID");
command.Parameters.AddWithValue("@memberInboxID", memberInboxID);
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
MemberMessage msgDis = new MemberMessage();
msgDis.Date = Convert.ToDateTime(reader["date"]);
msgDis.Reply = reader["reply"].ToString();
if (reader["memberInboxID"] != DBNull.Value)
{
msgDis.MemberInbox = MemberInboxDB.getMemberInboxID(reader["memberInboxID"].ToString());
}
else
{
msgDis.MemberInbox = new MemberInbox(0, new DateTime(), new Member(), new Item());
}
if (reader["senderID"] != DBNull.Value)
{
msgDis.Sender = MemberDB.getMemberbyID(reader["senderID"].ToString());
}
else
{
msgDis.Sender = new Member(null, null, null, 0, null, null, 0, null, null, new DateTime(), new DateTime(), null, new DateTime(), null, null);
}
msgDisList.Add(msgDis);
}
reader.Close();
}
finally
{
connection.Close();
}
return(msgDisList);
}
