public static ForumUserCommentbyEst getoneForumCommentbyID(string forumcommentID) { ForumUserCommentbyEst fu = new ForumUserCommentbyEst(); try { SqlCommand command = new SqlCommand("Select * from ForumUserCommentbyEst where forumcommentID=@forumcommentID"); command.Parameters.AddWithValue("@forumcommentID", forumcommentID); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { fu.forumcommentID = reader["forumcommentID"].ToString(); AForumUser onef = AForumUserDB.getForumUserbyID(reader["forumID"].ToString()); fu.forumID = onef; fu.comments = reader["comments"].ToString(); Establishment u = EstablishmentDB.getEstablishmentByID(reader["commentby"].ToString()); fu.commentby = u; fu.date = Convert.ToDateTime(reader["date"]); fu.status = reader["status"].ToString(); } reader.Close(); } finally { connection.Close(); } return(fu); }
public static List <EstablishmentBPRequest> getAllEstablishmentRequests() { List <EstablishmentBPRequest> establishmentRequests = new List <EstablishmentBPRequest>(); try { SqlCommand command = new SqlCommand("Select * from BloodPlateletRequestEstab"); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { EstablishmentBPRequest r = new EstablishmentBPRequest(); r.ID = reader["bplEstabRequestID"].ToString(); r.Establishment = EstablishmentDB.getEstablishmentByID(reader["establishmentID"].ToString()); r.Units = Convert.ToInt32(reader["unitsRequired"]); r.MatchedUnits = Convert.ToInt32(reader["unitsMatched"]); r.BloodGroup = reader["bloodGroup"].ToString(); r.Type = reader["bloodOrPlatelet"].ToString(); r.Status = reader["status"].ToString(); r.RequestDate = Convert.ToDateTime(reader["requestDate"]); establishmentRequests.Add(r); } reader.Close(); } finally { connection.Close(); } return(establishmentRequests); }
public static List <ForumEstablishment> getAllForumEstablishment() { List <ForumEstablishment> forumlists = new List <ForumEstablishment>(); try { SqlCommand command = new SqlCommand("Select * from ForumEstablishment"); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ForumEstablishment fu = new ForumEstablishment(); fu.ForumID = reader["forumID"].ToString(); fu.title = reader["title"].ToString(); fu.message = reader["message"].ToString(); fu.date = Convert.ToDateTime(reader["date"]); fu.status = reader["status"].ToString(); Establishment es = EstablishmentDB.getEstablishmentByID(reader["establishmentID"].ToString()); fu.estID = es; forumlists.Add(fu); } reader.Close(); } finally { connection.Close(); } return(forumlists); }
public static ForumEstablishment getForumEstbyID(string id) { ForumEstablishment fu = new ForumEstablishment(); try { SqlCommand command = new SqlCommand("Select * from ForumEstablishment where forumID=@forumID"); command.Parameters.AddWithValue("@forumID", id); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { fu.ForumID = reader["forumID"].ToString(); fu.title = reader["title"].ToString(); fu.message = reader["message"].ToString(); fu.date = Convert.ToDateTime(reader["date"]); fu.status = reader["status"].ToString(); Establishment es = EstablishmentDB.getEstablishmentByID(reader["establishmentID"].ToString()); fu.estID = es; } reader.Close(); } finally { connection.Close(); } return(fu); }
public static BPMatchUserToEstab getBloodRequestsMatchbyID(string ID) { BPMatchUserToEstab m = new BPMatchUserToEstab(); try { SqlCommand command = new SqlCommand("Select * from BPMatchUserToEstab where bpMatchUsrEstID=@UserID"); command.Parameters.AddWithValue("@UserID", ID); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { m.bpMatchUsrEstID = reader["bpMatchUsrEstID"].ToString(); Establishment es = EstablishmentDB.getEstablishmentByID(reader["matchID"].ToString()); m.matchID = es; BloodPlateletRequestUser u = BloodPlateletRequestUserDB.getUserBloodRequestsbyID(reader["bplUserRequestID"].ToString()); m.bpRequestID = u; m.distance = Convert.ToInt32(reader["distance"]); m.status = reader["status"].ToString(); } reader.Close(); } finally { connection.Close(); } return(m); }
//get all blood and platelet match list from database public static List <BPMatchUserToEstab> getAllbpMatchUserToEsta() { List <BPMatchUserToEstab> matches = new List <BPMatchUserToEstab>(); try { SqlCommand command = new SqlCommand("Select * from BPMatchUserToEstab"); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { BPMatchUserToEstab m = new BPMatchUserToEstab(); m.bpMatchUsrEstID = reader["bpMatchUsrEstID"].ToString(); Establishment es = EstablishmentDB.getEstablishmentByID(reader["matchID"].ToString()); m.matchID = es; BloodPlateletRequestUser u = BloodPlateletRequestUserDB.getUserBloodRequestsbyID(reader["bplUserRequestID"].ToString()); m.bpRequestID = u; m.distance = Convert.ToInt32(reader["distance"]); m.status = reader["status"].ToString(); matches.Add(m); } reader.Close(); } finally { connection.Close(); } return(matches); }
public static List <OrganRecipient> getAllRecipients() { List <OrganRecipient> organRecipients = new List <OrganRecipient>(); try { SqlCommand command = new SqlCommand("Select * from organReceiverWaiting"); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { OrganRecipient r = new OrganRecipient(); r.ID = reader["OrganWlID"].ToString(); r.Establishment = EstablishmentDB.getEstablishmentByID(reader["establishmentID"].ToString()); r.Bloodgroup = reader["bloodGroup"].ToString(); r.DOB = Convert.ToDateTime(reader["DOB"]); r.Height = Convert.ToInt32(reader["height"]); r.Weight = Convert.ToInt32(reader["weight"]); r.Addedon = Convert.ToDateTime(reader["addedOn"]); r.Organrequired = reader["organRequired"].ToString(); r.Comments = reader["comments"].ToString(); r.Urgency = Convert.ToInt32(reader["urgency"]); r.Refnumber = reader["hospitalPatientNumber"].ToString(); r.Status = reader["status"].ToString(); organRecipients.Add(r); } reader.Close(); } finally { connection.Close(); } return(organRecipients); }
public static List <ForumUserCommentbyEst> getAlloneForumAllComment() { List <ForumUserCommentbyEst> fulists = new List <ForumUserCommentbyEst>(); try { SqlCommand command = new SqlCommand("Select * from ForumUserCommentbyEst"); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ForumUserCommentbyEst fu = new ForumUserCommentbyEst(); fu.forumcommentID = reader["forumcommentID"].ToString(); AForumUser onef = AForumUserDB.getForumUserbyID(reader["forumID"].ToString()); fu.forumID = onef; fu.comments = reader["comments"].ToString(); Establishment u = EstablishmentDB.getEstablishmentByID(reader["commentby"].ToString()); fu.commentby = u; fu.date = Convert.ToDateTime(reader["date"]); fu.status = reader["status"].ToString(); fulists.Add(fu); } reader.Close(); } finally { connection.Close(); } return(fulists); }
public static EstabEstabMatch getMatchByID(string id) { EstabEstabMatch m = new EstabEstabMatch(); try { SqlCommand command = new SqlCommand("Select * from bpMatchEstabToEstab where bpMatchEstabID = @id"); command.Parameters.AddWithValue("@id", id); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { m.ID = reader["bpMatchEstabID"].ToString(); m.Request = EstablishmentBPRequestDB.getRequestByID(reader["bplEstabRequestID"].ToString()); m.Match = EstablishmentDB.getEstablishmentByID(reader["matchID"].ToString()); m.Status = reader["status"].ToString(); m.Distance = Convert.ToInt32(reader["distance"]); } reader.Close(); } finally { connection.Close(); } return(m); }
public static List <GReportBloodPlatelet> HgetAllBloodUToE() { List <GReportBloodPlatelet> utoelists = new List <GReportBloodPlatelet>(); try { SqlCommand command = new SqlCommand("select bpr.bplUserRequestID , bpr.requestorID,bpr.bloodGroup,bpr.bloodOrPlatelet, bpr.unitsRequird,ue.matchID,tue.unitsPossible,bpr.requestDate,tue.status from BloodPlateletRequestUser bpr, BPMatchUserToEstab ue, BplTransactionUserToEstab tue where bpr.bplUserRequestID = ue.bplUserRequestID and ue.bpMatchUsrEstID = tue.bpMatchUsrEstID and tue.status='complete'"); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { GReportBloodPlatelet fu = new GReportBloodPlatelet(); fu.ID = reader["bplUserRequestID"].ToString(); Users u = UsersDB.getUserbyID(reader["requestorID"].ToString()); fu.Requestor = u.name; fu.BloodGroup = reader["bloodGroup"].ToString(); fu.BloodOrPlatelet = reader["bloodOrPlatelet"].ToString(); fu.UnitRequire = reader["unitsRequird"].ToString(); Establishment es = EstablishmentDB.getEstablishmentByID(reader["matchID"].ToString()); fu.Giver = es.Name; fu.GivenUnit = reader["unitsPossible"].ToString(); fu.Date = Convert.ToDateTime(reader["requestDate"]); fu.Status = reader["status"].ToString(); utoelists.Add(fu); } reader.Close(); } finally { connection.Close(); } return(utoelists); }
protected void Page_Load(object sender, EventArgs e) { if (Session["establishment"] == null) { Server.Transfer("CommonLogin.aspx"); } else { List <Chat> clist = ChatDB.getallChat(); foreach (Chat ch in clist) { Users s = UsersDB.getUserbyID(ch.by); if (s.email == null) { Establishment es = EstablishmentDB.getEstablishmentByID(ch.by); if (ch.status == "allow") { tbxChat.Text += es.Name + " @ " + ch.time + " : " + ch.message + "\r\n"; } } else { if (ch.status == "allow") { tbxChat.Text += s.username + " @ " + ch.time + " : " + ch.message + "\r\n"; } } } } }
public static DeceasedDonor getDonorByID(string id) { DeceasedDonor o = new DeceasedDonor(); try { SqlCommand command = new SqlCommand("Select * from deceasedDonor where deceasedOrganID = @id"); command.Parameters.AddWithValue("@id", id); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { o.ID = reader["deceasedOrganID"].ToString(); o.Establishment = EstablishmentDB.getEstablishmentByID(reader["establishmentID"].ToString()); o.Bloodgroup = reader["bloodGroup"].ToString(); o.DOB = Convert.ToDateTime(reader["DOB"]); o.Donorheight = Convert.ToInt32(reader["height"]); o.Donorweight = Convert.ToInt32(reader["weight"]); o.Deathdate = Convert.ToDateTime(reader["deathDate"]); o.Organtype = reader["organType"].ToString(); o.Comments = reader["comments"].ToString(); o.Refnumber = reader["hospitalPatientNumber"].ToString(); o.Status = reader["status"].ToString(); } reader.Close(); } finally { connection.Close(); } return(o); }
public static List <ShowOrgan> getAllLOrganListByReceiver(string donor) { List <ShowOrgan> organlist = new List <ShowOrgan>(); try { SqlCommand command = new SqlCommand("select ld.ldonorID,ld.userID,ld.organType,rw.establishmentID,rw.hospitalPatientNumber from liveDonor ld, organMatchingLive ml, organReceiverWaiting rw where ld.ldonorID = ml.ldonorID and ml.OrganWlID = rw.OrganWlID and rw.status = 'complete' and rw.establishmentID = @donor"); command.Parameters.AddWithValue("@donor", donor); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ShowOrgan r = new ShowOrgan(); r.DOID = reader["ldonorID"].ToString(); Users es = UsersDB.getUserbyID(reader["ld.userID"].ToString()); r.Donor = es.name; r.OrganType = reader["organType"].ToString(); Establishment es2 = EstablishmentDB.getEstablishmentByID(reader["rw.establishmentID"].ToString()); r.Receiver = es2.Name; r.hospitalRefNum = reader["hospitalPatientNumber"].ToString(); organlist.Add(r); } reader.Close(); } finally { connection.Close(); } return(organlist); }
public static List <BloodPlateletRequestUser> getAllUserBloodRequests() { List <BloodPlateletRequestUser> userrequests = new List <BloodPlateletRequestUser>(); try { SqlCommand command = new SqlCommand("Select * from BloodPlateletRequestUser"); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { BloodPlateletRequestUser br = new BloodPlateletRequestUser(); br.bplUserRequestID = reader["bplUserRequestID"].ToString(); br.Units = Convert.ToInt32(reader["unitsRequird"]); br.unitMatched = Convert.ToInt32(reader["unitsMatched"]); Establishment est = EstablishmentDB.getEstablishmentByID(reader["establishmentID"].ToString()); br.Establishment = est; Users u = UsersDB.getUserbyID(reader["requestorID"].ToString()); br.requestorID = u; br.Type = reader["bloodGroup"].ToString(); br.bloodOrPlatelet = reader["bloodOrPlatelet"].ToString(); br.Status = reader["status"].ToString(); br.Time = Convert.ToDateTime(reader["requestDate"]); userrequests.Add(br); } reader.Close(); } finally { connection.Close(); } return(userrequests); }
public static List <ShowOrgan> getAllDOrganListByReceiver(string donor) { List <ShowOrgan> organlist = new List <ShowOrgan>(); try { SqlCommand command = new SqlCommand("select omd.deceasedOrganMatch,dd.establishmentID,dd.organType,rw.establishmentID,dd.hospitalPatientNumber from organMatchingDeceased omd, deceasedDonor dd, organReceiverWaiting rw where omd.deceasedOrganID = dd.deceasedOrganID and omd.OrganWlID = rw.OrganWlID and omd.status = 'complete' and rw.establishmentID = @donor"); command.Parameters.AddWithValue("@donor", donor); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ShowOrgan r = new ShowOrgan(); r.DOID = reader["deceasedOrganMatch"].ToString(); Establishment es = EstablishmentDB.getEstablishmentByID(reader["dd.establishmentID"].ToString()); r.Donor = es.Name; r.OrganType = reader["organType"].ToString(); Establishment es2 = EstablishmentDB.getEstablishmentByID(reader["rw.establishmentID"].ToString()); r.Receiver = es2.Name; r.hospitalRefNum = reader["hospitalPatientNumber"].ToString(); organlist.Add(r); } reader.Close(); } finally { connection.Close(); } return(organlist); }
protected void BtnSentMessage_Click1(object sender, EventArgs e) { if (Session["echat"] != null) { string eID = Session["echat"].ToString(); Establishment r = EstablishmentDB.getEstablishmentByID(eID); Establishment s = (Establishment)Session["establishment"]; IndividualChatRoom icr = new IndividualChatRoom(s.ID, r.ID, System.DateTime.Now, TextBox1.Text); IndividualChatRoomDB.insertIndChat(icr); } else if (Session["rwEst"] != null) { string eID = Session["rwEst"].ToString(); Establishment r = EstablishmentDB.getEstablishmentByID(eID); Establishment s = (Establishment)Session["establishment"]; IndividualChatRoom icr = new IndividualChatRoom(s.ID, r.ID, System.DateTime.Now, TextBox1.Text); IndividualChatRoomDB.insertIndChat(icr); } else { Users r = UsersDB.getUserbyID(Session["ldID"].ToString()); Establishment s = (Establishment)Session["establishment"]; IndividualChatRoom icr = new IndividualChatRoom(s.ID, r.userId, System.DateTime.Now, TextBox1.Text); IndividualChatRoomDB.insertIndChat(icr); } TextBox1.Text = ""; UpdatePanel1.Update(); }
public static EstablishmentBPRequest getRequestByID(string id) { EstablishmentBPRequest r = new EstablishmentBPRequest(); try { SqlCommand command = new SqlCommand("Select * from bloodPlateletRequestEstab where bplEstabRequestID = @id"); command.Parameters.AddWithValue("@id", id); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { r.ID = reader["bplEstabRequestID"].ToString(); r.Units = Convert.ToInt32(reader["unitsRequired"]); r.MatchedUnits = Convert.ToInt32(reader["unitsMatched"]); r.Establishment = EstablishmentDB.getEstablishmentByID(reader["establishmentID"].ToString()); r.BloodGroup = reader["bloodGroup"].ToString(); r.Type = reader["bloodOrPlatelet"].ToString(); r.Status = reader["status"].ToString(); r.RequestDate = Convert.ToDateTime(reader["requestDate"]); } reader.Close(); } finally { connection.Close(); } return(r); }
public static List <EstabEstabMatch> getAllMatches() { List <EstabEstabMatch> matches = new List <EstabEstabMatch>(); try { SqlCommand command = new SqlCommand("Select * from BPMatchEstabToEstab"); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { EstabEstabMatch m = new EstabEstabMatch(); m.ID = reader["bpMatchEstabID"].ToString(); m.Request = EstablishmentBPRequestDB.getRequestByID(reader["bplEstabRequestID"].ToString()); m.Match = EstablishmentDB.getEstablishmentByID(reader["matchID"].ToString()); m.Status = reader["status"].ToString(); m.Distance = Convert.ToInt32(reader["distance"]); matches.Add(m); } reader.Close(); } finally { connection.Close(); } return(matches); }
protected void Button2_Click(object sender, EventArgs e) { Establishment es = EstablishmentDB.getEstablishmentByID(Session["est"].ToString()); Session["echat"] = es.ID; Session["rwEst"] = null; Session["ldID"] = null; Server.Transfer("IndividualChatE.aspx"); }
protected void BtnSentMessage_Click1(object sender, EventArgs e) { if (Session["chat"] != null) { Users s = UsersDB.getUserbyEmail(Session["email"].ToString()); Users r = UsersDB.getUserbyUsername(lblName.Text); IndividualChatRoom icr = new IndividualChatRoom(s.UserId, r.UserId, System.DateTime.Now, TextBox1.Text); IndividualChatRoomDB.insertIndChat(icr); } else { string eID = Session["echat"].ToString(); Users s = UsersDB.getUserbyEmail(Session["email"].ToString()); Establishment r = EstablishmentDB.getEstablishmentByID(eID); IndividualChatRoom icr = new IndividualChatRoom(s.UserId, r.ID, System.DateTime.Now, TextBox1.Text); IndividualChatRoomDB.insertIndChat(icr); } TextBox1.Text = ""; UpdatePanel1.Update(); }
public static List <GReportBloodPlatelet> getAllBloodUToUWTime(string ID) { List <GReportBloodPlatelet> utoelists = new List <GReportBloodPlatelet>(); try { SqlCommand command = new SqlCommand("select bpr.bplUserRequestID , bpr.requestorID,bpr.bloodGroup,bpr.bloodOrPlatelet, bpr.unitsRequird,uu.matchID,bpr.requestDate,bpr.establishmentID, tuu.status from BloodPlateletRequestUser bpr, BPMatchUserToUser uu, BplTransactionUserToUser tuu where bpr.bplUserRequestID = uu.bplUserRequestID and uu.bpMatchUsrUsr = tuu.bpMatchUsrUsr and bpr.establishmentID=@ID and tuu.status='complete'"); command.Parameters.AddWithValue("@ID", ID); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { GReportBloodPlatelet fu = new GReportBloodPlatelet(); fu.ID = reader["bplUserRequestID"].ToString(); Users u = UsersDB.getUserbyID(reader["requestorID"].ToString()); fu.Requestor = u.name; fu.BloodGroup = reader["bloodGroup"].ToString(); fu.BloodOrPlatelet = reader["bloodOrPlatelet"].ToString(); fu.UnitRequire = reader["unitsRequird"].ToString(); Users u2 = UsersDB.getUserbyID(reader["matchID"].ToString()); fu.Giver = u2.Name; fu.GivenUnit = "1"; fu.Date = Convert.ToDateTime(reader["requestDate"]); Establishment es = EstablishmentDB.getEstablishmentByID(reader["establishmentID"].ToString()); fu.Status = es.Name; utoelists.Add(fu); } reader.Close(); } finally { connection.Close(); } return(utoelists); }
public static List <GReportBloodPlatelet> getAllBloodEToE(DateTime from, DateTime to) { List <GReportBloodPlatelet> utoelists = new List <GReportBloodPlatelet>(); try { SqlCommand command = new SqlCommand("select bpr.bplEstabRequestID , bpr.establishmentID,bpr.bloodGroup,bpr.bloodOrPlatelet, bpr.unitsRequired,uu.matchID,tuu.unitsPossible,bpr.requestDate,tuu.status from BloodPlateletRequestEstab bpr, BPMatchEstabToEstab uu, BplTransactionEstabToEstab tuu where bpr.bplEstabRequestID = uu.bplEstabRequestID and uu.bpMatchEstabID = tuu.bpMatchEstabID and requestDate between @from AND @to"); command.Parameters.AddWithValue("@from", from); command.Parameters.AddWithValue("@to", to); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { GReportBloodPlatelet fu = new GReportBloodPlatelet(); fu.ID = reader["bplEstabRequestID"].ToString(); Establishment es = EstablishmentDB.getEstablishmentByID(reader["establishmentID"].ToString()); fu.Requestor = es.Name; fu.BloodGroup = reader["bloodGroup"].ToString(); fu.BloodOrPlatelet = reader["bloodOrPlatelet"].ToString(); fu.UnitRequire = reader["unitsRequired"].ToString(); Establishment es2 = EstablishmentDB.getEstablishmentByID(reader["matchID"].ToString()); fu.Giver = es2.Name; fu.GivenUnit = reader["unitsPossible"].ToString(); fu.Date = Convert.ToDateTime(reader["requestDate"]); fu.Status = reader["status"].ToString(); utoelists.Add(fu); } reader.Close(); } finally { connection.Close(); } return(utoelists); }
protected void Page_Load(object sender, EventArgs e) { if (Session["chat"] == null) { string eID = Session["echat"].ToString(); Establishment r = EstablishmentDB.getEstablishmentByID(eID); lblName.Text = r.Name; Users s = UsersDB.getUserbyEmail(Session["email"].ToString()); tbxChat.Text = ""; List <IndividualChatRoom> iuu = IndividualChatRoomDB.getAllChatby2ID(r.ID, s.UserId); tbxChat.Style["text-align"] = "left"; if (iuu.Count > 0) { foreach (IndividualChatRoom i in iuu) { if (i.Sender == s.UserId) { tbxChat.Text += s.username + " : " + i.Messages + "\r\n"; } else { tbxChat.Text += r.Name + " : " + i.Messages + "\r\n"; } } } else { tbxChat.Text = "You can start the chat now"; tbxChat.Style["text-align"] = "center"; } } else { uUsername = Session["chat"].ToString(); Users r = UsersDB.getUserbyID(uUsername); lblName.Text = r.username; Users s = UsersDB.getUserbyEmail(Session["email"].ToString()); tbxChat.Text = ""; List <IndividualChatRoom> iuu = IndividualChatRoomDB.getAllChatby2ID(r.UserId, s.UserId); tbxChat.Style["text-align"] = "left"; if (iuu.Count > 0) { foreach (IndividualChatRoom i in iuu) { if (i.Sender == s.userId) { tbxChat.Text += s.username + " : " + i.Messages + "\r\n"; } else { tbxChat.Text += r.username + " : " + i.Messages + "\r\n"; } } } else { tbxChat.Text = "You can start the chat now"; tbxChat.Style["text-align"] = "center"; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["echat"] != null) { string eID = Session["echat"].ToString(); Establishment r = EstablishmentDB.getEstablishmentByID(eID); lblName.Text = r.Name; Establishment s = (Establishment)Session["establishment"]; tbxChat.Text = ""; List <IndividualChatRoom> iuu = IndividualChatRoomDB.getAllChatby2ID(s.ID, r.ID); tbxChat.Style["text-align"] = "left"; if (iuu.Count > 0) { foreach (IndividualChatRoom i in iuu) { if (i.Sender == s.ID) { tbxChat.Text += s.Name + " : " + i.Messages + "\r\n"; } else { tbxChat.Text += r.Name + " : " + i.Messages + "\r\n"; } } } else { tbxChat.Text = "You can start the chat now"; tbxChat.Style["text-align"] = "center"; } } else if (Session["rwEst"] != null) { string eID = Session["rwEst"].ToString(); Establishment re = EstablishmentDB.getEstablishmentByID(eID); lblName.Text = re.Name; Establishment s = (Establishment)Session["establishment"]; tbxChat.Text = ""; List <IndividualChatRoom> iuu = IndividualChatRoomDB.getAllChatby2ID(s.ID, re.ID); tbxChat.Style["text-align"] = "left"; if (iuu.Count > 0) { foreach (IndividualChatRoom i in iuu) { if (i.Sender == s.ID) { tbxChat.Text += s.Name + " : " + i.Messages + "\r\n"; } else { tbxChat.Text += re.Name + " : " + i.Messages + "\r\n"; } } } else { tbxChat.Text = "You can start the chat now"; tbxChat.Style["text-align"] = "center"; } } else if (Session["ldID"] != null) { Users r = UsersDB.getUserbyID(Session["ldID"].ToString()); lblName.Text = r.Name; Establishment s = (Establishment)Session["establishment"]; tbxChat.Text = ""; List <IndividualChatRoom> iuu = IndividualChatRoomDB.getAllChatby2ID(s.ID, r.UserId); tbxChat.Style["text-align"] = "left"; if (iuu.Count > 0) { foreach (IndividualChatRoom i in iuu) { if (i.Sender == s.ID) { tbxChat.Text += s.Name + " : " + i.Messages + "\r\n"; } else { tbxChat.Text += r.Name + " : " + i.Messages + "\r\n"; } } } else { tbxChat.Text = "You can start the chat now"; tbxChat.Style["text-align"] = "center"; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["establishment"] == null) { Server.Transfer("Login.aspx"); } else { tbxChat.Text = ""; List <Chat> clist = ChatDB.getallChat(); foreach (Chat ch in clist) { Users s = UsersDB.getUserbyID(ch.by); if (s.email == null) { Establishment es = EstablishmentDB.getEstablishmentByID(ch.by); if (ch.status == "allow") { tbxChat.Text += es.Name + " @ " + ch.time + " : " + ch.message + "\r\n"; } } else { if (ch.status == "allow") { tbxChat.Text += s.username + " @ " + ch.time + " : " + ch.message + "\r\n"; } } } cnum = clist.Count; currente = (Establishment)(Session["establishment"]); lblOutputPost.Text = ""; List <ForumUser> flist = ForumUserDB.getAllForumUserbyStatus(); if (flist.Count == 0) { Panel1.Visible = false; lblGVOutput.Text = "There is no forum posted by user right now!"; } else { Panel1.Visible = true; gvUser.DataSource = flist; gvUser.DataBind(); lblGVOutput.Text = ""; } List <ForumEstablishment> elist = ForumEstablishmentDB.getAllForumEstbyStatus(); if (elist.Count == 0) { Panel2.Visible = false; lblGVEstOutput.Text = "There is no forum posted by establishment right now!"; } else { lblGVEstOutput.Text = ""; Panel2.Visible = true; gvEst.DataSource = elist; gvEst.DataBind(); } } }