void CheckForRequestConfirmaion()
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
var res = DB.FileSharingRequests.Where(x => x.ID == int.Parse(Request.QueryString["FSR_ID"]));
foreach (var r in res)
{
if (r.Confirmed == 'N')
{
GridViewSharedFilesDetails.Enabled = true;
CheckBoxSelectAll.Enabled = true;
btnAddFiles.Enabled = true;
btnRejectFiles.Enabled = true;
}
else
{
//lblFileSharedMessage.ForeColor = System.Drawing.Color.Red;
lblFileSharedMessage.Text += " (Already Confirmed)";
GridViewSharedFilesDetails.Enabled = false;
CheckBoxSelectAll.Enabled = false;
btnAddFiles.Enabled = false;
btnRejectFiles.Enabled = false;
}
}
}
void DisplayUserInfo()
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
// var res = from v in DB.GetTable<UserInfo>() where v.Username == txtUsername.Text select v;
var res = DB.UserInfos.Where(x => x.Username == txtUsername.Text);
foreach (var r in res)
{
lblUsername.Text = r.Username;
lblFirstName.Text = r.UserFirstName;
lblMiddleName.Text = r.UserMiddleName;
lblLastName.Text = r.UserLastName;
lblGender.Text = r.UserGender;
lblDOB.Text = r.UserDOB;
lblCountry.Text = r.UserCountry;
lblCity.Text = r.UserCity;
lblPhoneNumber.Text = r.UserPhoneNumber;
imgProfilePic.ImageUrl = r.UserProfilePicFile;
lblGender.Text = r.UserGender;
if (r.UserMartialStatus == "y")
{
lblMartialStatus.Text = "Married";
}
else
{
lblMartialStatus.Text = "Unmarried";
}
lblEMail.Text = r.UserEMail;
lblSecurityQuestion.Text = r.UserSecurityQuestion;
lblSecurityAnswer.Text = r.UserSecurityAnswer;
}
}
void RemoveAllNewNotifications()
{
try
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
string CustUsername = Session["user"].ToString();
var res = DB.UserInfos.Where(x => x.Username == CustUsername);
string oldNotifications = "";
foreach (var r in res)
{
oldNotifications += r.Notifications.ToString();
}
char[] ntfFetched = oldNotifications.ToCharArray();
string newNotifications = "";
foreach (char ch in ntfFetched)
{
if (ch != '*')
{
newNotifications += ch.ToString();
}
}
foreach (var r in res)
{
r.Notifications = newNotifications;
}
DB.SubmitChanges();
}
catch (Exception exc) { Response.Redirect("Homepage.aspx?s=0"); }
}
void ShowPageHeading()
{
try
{
if (!Page.IsPostBack)
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
string CustUsername = Session["user"].ToString();
var res = DB.UserInfos.Where(x => x.Username == CustUsername);
foreach (var r in res)
{
if (r.UserGender == "Male")
{
lblHeading.Text += "Mr. ";
}
else
{
if (r.UserMartialStatus == "n")
{
lblHeading.Text += "Miss ";
}
else
{
lblHeading.Text = "Mrs. ";
}
}
lblHeading.Text += r.UserFirstName + " " + r.UserLastName;
}
}
}
catch (Exception exc) { Response.Redirect("Homepage.aspx?s=0"); }
}
void LoadPanelControls()
{
try
{
lblLoggedInUsername.Text = Session["user"].ToString();
if (Session["user"].ToString() == "Admin")
{
ImageProPic.ImageUrl = "~/Images/NotificationImages/AdminPic.png";
btnPopupVisitUserAcc.PostBackUrl = "~/AdminPage.aspx";
}
else
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
// var res = from v in DB.GetTable<UserInfo>() where v.Username == Session["user"].ToString() select v;
var res = DB.UserInfos.Where(x => x.Username == Session["user"].ToString());
foreach (var r in res)
{
imgPopupUserPic.ImageUrl = r.UserProfilePicFile;
if (ImageProPic.ImageUrl == "")
{
if (r.UserGender == "Male")
{
ImageProPic.ImageUrl = "~/UploadedFiles/UserProfilePictures/NoProfilePicMale.png";
}
else
{
ImageProPic.ImageUrl = "~/UploadedFiles/UserProfilePictures/NoProfilePicFemale.png";
}
}
}
btnPopupVisitUserAcc.PostBackUrl = "CustomerPage.aspx";
}
}
catch (System.NullReferenceException exc) { Response.Redirect("Homepage.aspx?s=0"); }
}
void GetRegisteredUsersList()
{
PanelCheckNewFiles.Visible = false;
PanelCheckNewUsers.Visible = false;
PanelRegisteredUser.Visible = true;
PanelSearchAllFiles.Visible = false;
PanelUpdateAdminInfo.Visible = false;
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
var res = from v in DB.GetTable <UserInfo>() select v;
int UserNo = 0;
foreach (var r in res)
{
UserNo++;
Image UserImg = new Image();
UserImg.ImageUrl = r.UserProfilePicFile;
UserImg.Height = 50; UserImg.Width = 50;
HyperLink UserLink = new HyperLink(); UserLink.CssClass = "BodyStyle";
UserLink.Text = r.Username + " [" + r.UserFirstName + " " + r.UserMiddleName + " " + r.UserLastName + "]";
UserLink.Target = "_blank";
UserLink.NavigateUrl = "AdminUserAccountControl.aspx?User="******" "));
PlaceHolderRegisteredUsers.Controls.Add(UserLink);
PlaceHolderRegisteredUsers.Controls.Add(new LiteralControl("<br />"));
}
lblRegisteredUsersNo.Text = UserNo.ToString() + " registered user(s) found!";
}
void Show_LoggedInAsMsg()
{
try
{
lblLoggedInAs.Text = "Logged In As " + Session["user"];
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
// var res = from v in DB.GetTable<UserInfo>() where v.Username == Session["user"] select v;
var res = DB.UserInfos.Where(x => x.Username == Session["user"]);
foreach (var r in res)
{
ImageProPic.ImageUrl = r.UserProfilePicFile;
if (ImageProPic.ImageUrl == "")
{
if (r.UserGender == "Male")
{
ImageProPic.ImageUrl = "~/UploadedFiles/UserProfilePictures/NoProfilePicMale.png";
}
else
{
ImageProPic.ImageUrl = "~/UploadedFiles/UserProfilePictures/NoProfilePicFemale.png";
}
}
else
{
ImageProPic.ImageUrl = r.UserProfilePicFile;
}
}
HyperLinkVisitAcc.NavigateUrl = "CustomerPage.aspx";
}
catch (System.NullReferenceException exc) { Response.Redirect("Homepage.aspx?s=0"); }
}
void CheckUsernameAvailbility()
{
if (txtUsername.Text.Trim() == "")
{
lblCheckUsernameAvailability.ForeColor = System.Drawing.Color.Red;
lblCheckUsernameAvailability.Text = "Please enter a non-null username!";
txtUsername.Text = "";
return;
}
if (txtUsername.Text.Trim().Length < 5)
{
lblCheckUsernameAvailability.ForeColor = System.Drawing.Color.Red;
lblCheckUsernameAvailability.Text = "Please enter a username atleast 5 characters wide!";
txtUsername.Text = "";
return;
}
char[] username_chars = txtUsername.Text.Trim().ToCharArray();
foreach (char c in username_chars)
{
if (!(((int)c >= (int)'a' && (int)c <= (int)'z') || ((int)c >= (int)'A' && (int)c <= (int)'Z') || ((int)c >= (int)'0' && (int)c <= '9') || (c == '@') || (c == '_')))
{
lblCheckUsernameAvailability.ForeColor = System.Drawing.Color.Red;
lblCheckUsernameAvailability.Text = "Wrong username format! Enter characters between [a-z], [A-Z], [0-9] and special symbols (only '@' and '_')";
txtUsername.Text = "";
return;
}
}
if (txtUsername.Text.Trim().ToLower() == "admin")
{
lblCheckUsernameAvailability.ForeColor = System.Drawing.Color.Red;
lblCheckUsernameAvailability.Text = "The specified username cannot be used! Please enter another username.";
txtUsername.Text = "";
return;
}
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
string ProposedUsername = ((txtUsername.Text).Trim()).ToLower();
bool test = DB.UserInfos.Where(x => (x.Username).ToLower() == ProposedUsername).Count() == 1 ? true : false;
if ((DB.UserInfos.Where(x => (x.Username).ToLower() == ProposedUsername).Count() == 1 ? true : false) || (DB.AdminInfos.Where(x => (x.AdminName).ToLower() == ProposedUsername).Count() == 1 ? true : false))
{
lblCheckUsernameAvailability.ForeColor = System.Drawing.Color.Red;
lblCheckUsernameAvailability.Text = "'" + txtUsername.Text + "' is already registered! Please enter another username.";
txtUsername.Text = "";
PanelAcceptInfos2.Enabled = false;
}
else
{
lblCheckUsernameAvailability.ForeColor = System.Drawing.Color.Blue;
lblCheckUsernameAvailability.Text = "Username accepted! You can proceed.";
PanelAcceptInfos1.Enabled = false;
PanelAcceptInfos2.Enabled = true;
LoadCountries();
}
}
void UpdateUserInfo()
{
if (CheckForAnyErrors())
{
if (CheckBoxAgreeTerms.Checked == true)
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
// var res = from v in DB.GetTable<UserInfo>() where v.Username == txtUsername.Text select v;
var res = DB.UserInfos.Where(x => x.Username == txtUsername.Text);
foreach (var r in res)
{
r.UserFirstName = txtFirstName.Text;
r.UserMiddleName = txtMiddleName.Text;
r.UserLastName = txtLastName.Text;
if (RadioButtonMale.Checked)
{
r.UserGender = "Male";
}
else
{
r.UserGender = "Female";
}
r.UserDOB = txtDOB.Text;
r.UserCountry = DropDownListCountry.SelectedItem.Text;
r.UserCity = DropDownlistCity.SelectedItem.Text;
r.UserPhoneNumber = txtPhNo.Text;
if (RadioButtonMarried.Checked)
{
r.UserMartialStatus = "y";
}
else
{
r.UserMartialStatus = "n";
}
r.UserEMail = txtEMail.Text;
if (TextBoxCustomSecurityQuestion.Visible = true && DropDownListSecurityQuestion.SelectedItem.Text == "Create a question yourself")
{
r.UserSecurityQuestion = TextBoxCustomSecurityQuestion.Text;
}
else
{
r.UserSecurityQuestion = DropDownListSecurityQuestion.SelectedItem.Text;
}
r.UserSecurityAnswer = txtSecurityAnswer.Text;
}
DB.SubmitChanges();
lblInfoUpdateConfirmation.Text = "Congratulation! Information successfully updated!";
lblAgreeConfirmation.Text = "";
}
else
{
lblAgreeConfirmation.Text = "You must check the Terms and Policy checkbox for remaining a user of this site!";
}
}
}
void DeleteUserAccount()
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
var res = DB.UserInfos.Where(x => x.Username == lblUsername.Text);
foreach (var r in res)
{
DB.UserInfos.DeleteOnSubmit(r);
}
DB.SubmitChanges();
Response.Redirect("AdminPage.aspx");
}
void checkForValidAdminSession()
{
try
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
if (!(DB.AdminInfos.Where(y => y.AdminName == Session["user"].ToString()).Count() == 1 ? true : false))
{
throw new Exception();
}
}
catch (Exception exc) { Response.Redirect("Homepage.aspx?s=0"); }
}
void UpdatePanelUsageInfo()
{
lblSearchResultNo.Visible = true;
//GridViewUploadedFiles.Enabled = false;
//CheckBoxSelectAll.Enabled = false;
//ButtonDeleteFile.Enabled = false;
// 90 MB = total Server DB capacity
double totalSpaceConsumed = 0;
lblUsed.Text = ""; lblUnused.Text = "";
//int counter = 0;
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
var res = DB.DBFiles.Select(x => new { x.UploadedFileName_WithExt, x.UploadedFileSize }).Distinct();
string fileSizeInString;
foreach (var r in res)
{
//counter++;
fileSizeInString = r.UploadedFileSize;
string pt1 = fileSizeInString.Substring(0, (fileSizeInString.Length - 2));
string pt2 = fileSizeInString.Substring((fileSizeInString.Length - 2), 2);
if (pt2 == "KB")
{
totalSpaceConsumed += (1024 * Convert.ToDouble(pt1));
}
else if (pt2 == "MB")
{
totalSpaceConsumed += (1024 * 1024 * Convert.ToDouble(pt1));
}
else
{
totalSpaceConsumed += Convert.ToDouble(pt1);
}
}
//Response.Write("counter = " + counter);
// Total File Upload Limit Set : 10 MB
float uploadPercentage = ((float)totalSpaceConsumed / (float)(30.0 * 1024 * 1024)) * 100;
lblUsed.Width = (int)uploadPercentage * 10;
if (uploadPercentage >= 20.00)
{
lblUsed.Text = uploadPercentage.ToString("0.00") + "% (" + convertToProperFormat(totalSpaceConsumed) + "/10MB)";
}
else
{
lblUnused.Width = 500;
lblUnused.Text = uploadPercentage.ToString("0.00") + "% (" + convertToProperFormat(totalSpaceConsumed) + "/10MB)";
lblUsed.Text = " ";
}
}
void checkForValidFSR_ID()
{
try
{
// Checking if the FSR_ID is having the Session["user"] value equal to the RequestedUser value in the FileSharingRequests table
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
if (!(DB.FileSharingRequests.Where(x => (x.ID.ToString() == Request.QueryString["FSR_ID"]) && (x.RequestedUser == Session["user"].ToString())).Count() > 0 ? true : false))
{
Response.Redirect("NotificationsPage.aspx");
}
}
catch (Exception exc) { Response.Redirect("NotificationsPage.aspx"); }
}
protected void Logout()
{
try
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
if (DB.AdminInfos.Where(y => y.AdminName == Session["user"].ToString()).Count() == 1 ? true : false)
{
RecordLastAdminLogoutDateTime();
}
Session.Abandon();
Response.Redirect("Homepage.aspx?s=1");
}
catch (System.NullReferenceException exc) { Response.Redirect("Homepage.aspx?s=0"); }
}
void RecordLastAdminLogoutDateTime()
{
try
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
var res = DB.AdminInfos.Where(x => x.AdminName == Session["user"]);
foreach (var r in res)
{
r.LastLogoutDateTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); // 'YYYY-MM-DD HH:MM:SS'
}
DB.SubmitChanges();
}
catch (System.NullReferenceException exc) { Response.Redirect("Homepage.aspx?s=0"); }
}
protected void Button1_Click(object sender, EventArgs e)
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
var res = from v in DB.GetTable <FileSharingRequest>() select v.ID;
int nextID = 0;
foreach (var r in res)
{
if ((int)r > nextID)
{
nextID = (int)r;
}
}
nextID++;
TextBox1.Text = "nextID = " + nextID;
}
void checkForValidSession()
{
try
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
if ((DB.AdminInfos.Where(x => x.AdminName == Session["user"].ToString()).Count() == 1 ? true : false))
{
PanelAdminControlTools.Visible = true; PanelUserTools.Visible = false; ImageAdminPic.Visible = true; return;
}
if ((DB.UserInfos.Where(y => y.Username == Session["user"].ToString()).Count() == 1 ? true : false))
{
PanelAdminControlTools.Visible = false; PanelUserTools.Visible = true; ImageAdminPic.Visible = false; return;
}
throw new Exception();
}
catch (Exception exc) { Response.Redirect("Homepage.aspx?s=0"); }
}
/* void SearchAllFiles()
* {
* PanelCheckNewFiles.Visible = false;
* PanelCheckNewUsers.Visible = false;
* PanelRegisteredUser.Visible = false;
* PanelSearchAllFiles.Visible = true;
* PanelUpdateAdminInfo.Visible = false;
*
* lblSearchResultNo.Visible = true;
*
* //try
* {
* /*
* Facilities added:
* Searching is not case sensitive
* Seaching is not leading or trailing white spaces sensitive
*/ /*
* int SearchResNo = 0;
* if (txtSearch.Text.Trim() != "")
* {
* FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
* // var SearchedFiles = from v in (from v0 in DB.GetTable<DBFile>() where v0.Mode == "General" select v0) where v.UploadedFileName.Contains(txtSearch.Text.Trim()) select v;
* var SearchedFiles = DB.DBFiles.Where(x => x.UploadedFileName.Contains(txtSearch.Text.Trim()) && x.Mode == "General");
* //DirectoryInfo mydir = new DirectoryInfo(@Server.MapPath("~/UploadedFiles/ServerDatabase/" + (DropDownListSearchCategory.SelectedItem.Text).Trim() + "s/"));
* foreach (var r in SearchedFiles)
* {
* SearchResNo++;
* string FileCategory = r.Category.ToString();
*
* // --- Creating label to show the searched file's info
* Label lbl = new Label();
* lbl.Text = "[ Category: " + FileCategory + " | Size: " + r.UploadedFileSize + " | Uploader's Name: " + r.UploaderUserName + " | Upload Date: " + r.UploadDateTime + " ]";
* lbl.CssClass = "SearchlblStyle"; lbl.BorderWidth = 0;
* // *** Creating label to show the searched file's info
*
* // --- Creating hyperlink to link the file to the database address
* HyperLink FileLink = new HyperLink();
* FileLink.Target = "_blank";
* FileLink.CssClass = "SearchResultsStyle"; FileLink.BorderWidth = 0;
* FileLink.Text = Convert.ToString(r.UploadedFileName);
* FileLink.NavigateUrl = Convert.ToString(r.FileAddressInServerDB);
* // *** Creating hyperlink to link the file to the database address
*
* // --- Creating Image to display the correct icon with respect to the category of the file
* Image ImgIcon = new Image();
* switch (FileCategory)
* {
* case "Image": ImgIcon.ImageUrl = "~/Images/SearchResultsIcon/Image.png"; ImgIcon.Height = 20; ImgIcon.Width = 20; break;
* case "Video": ImgIcon.ImageUrl = "~/Images/SearchResultsIcon/Video.ico"; ImgIcon.Height = 20; ImgIcon.Width = 20; break;
* case "Music": ImgIcon.ImageUrl = "~/Images/SearchResultsIcon/itunes-icon.png.png"; ImgIcon.Height = 20; ImgIcon.Width = 20; break;
* case "Document": ImgIcon.ImageUrl = "~/Images/SearchResultsIcon/Document.png"; ImgIcon.Height = 20; ImgIcon.Width = 20; break;
* case "Executable": ImgIcon.ImageUrl = "~/Images/SearchResultsIcon/Executable.png"; ImgIcon.Height = 20; ImgIcon.Width = 20; break;
* }
* // --- Attatching all Controls (Image, HyperLink, Label) to the Placeholder Control
* PlaceHolder1.Controls.Add(new LiteralControl("<br />"));
* PlaceHolder1.Controls.Add(new LiteralControl(" "));
* PlaceHolder1.Controls.Add(ImgIcon); PlaceHolder1.Controls.Add(new LiteralControl(" "));
* PlaceHolder1.Controls.Add(FileLink); PlaceHolder1.Controls.Add(new LiteralControl(" "));
* PlaceHolder1.Controls.Add(lbl);
* // --- Attatching all Controls (Image, HyperLink, Label) to the Placeholder Control
* }
* }
* lblSearchResultNo.Text = SearchResNo.ToString() + " results returned!";
* }
* } */
void LoadAdminCredentials()
{
PanelCheckNewFiles.Visible = false;
PanelCheckNewUsers.Visible = false;
PanelRegisteredUser.Visible = false;
PanelSearchAllFiles.Visible = false;
PanelUpdateAdminInfo.Visible = true;
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
var res = from v in DB.GetTable <AdminInfo>() select v;
foreach (var r in res)
{
txtAdminUsername.Text = r.AdminName;
txtAdminPassword.Text = r.AdminPwd;
}
}
/* void Wait()
* {
* System.Threading.Thread.Sleep(500);
* }*/
void Show_LoginLogoutOption()
{
try
{
if (Session["user"] != null)
{
btnLogout.Visible = true; btnLogin.Visible = false;
btnLogout.Text = "Welcome " + Session["user"].ToString() + "!";
ImageProPic.Visible = true;
if (Session["user"].ToString() == "Admin")
{
imgPopupUserPic.ImageUrl = "~/Images/NotificationImages/AdminPic.png"; return;
}
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
// var res = from v in DB.GetTable<UserInfo>() where v.Username == Session["user"].ToString() select v;
var res = DB.UserInfos.Where(x => x.Username == Session["user"].ToString());
foreach (var r in res)
{
ImageProPic.ImageUrl = r.UserProfilePicFile;
if (ImageProPic.ImageUrl == "")
{
if (r.UserGender == "Male")
{
ImageProPic.ImageUrl = "~/UploadedFiles/UserProfilePictures/NoProfilePicMale.png";
}
else
{
ImageProPic.ImageUrl = "~/UploadedFiles/UserProfilePictures/NoProfilePicFemale.png";
}
}
}
btnPopupVisitUserAcc.PostBackUrl = "CustomerPage.aspx";
}
else
{
btnLogout.Visible = false;
btnLogout.Text = "";
btnLogin.Visible = true;
ImageProPic.Visible = false;
ImageProPic.ImageUrl = "";
}
}
catch (System.NullReferenceException exc) { Response.Redirect("Homepage.aspx?s=0"); }
}
void ChangeInfo()
{
if (CheckForAnyErrors())
{
PanelAcceptInfos1.Visible = true;
PanelAcceptInfos2.Visible = true;
PanelShowInfos.Visible = false;
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
// var res = from v in DB.GetTable<UserInfo>() where v.Username == txtUsername.Text select v;
var res = DB.UserInfos.Where(x => x.Username == txtUsername.Text);
foreach (var r in res)
{
txtUsername.Text = r.Username;
txtFirstName.Text = r.UserFirstName;
txtMiddleName.Text = r.UserMiddleName;
txtLastName.Text = r.UserLastName;
if (RadioButtonMale.Checked)
{
r.UserGender = "Male";
}
else
{
r.UserGender = "Female";
}
txtDOB.Text = r.UserDOB;
DropDownListCountry.SelectedItem.Text = r.UserCountry;
DropDownListCities.SelectedItem.Text = r.UserCity;
txtPhNo.Text = r.UserPhoneNumber;
txtEMail.Text = r.UserEMail;
DropDownListSecurityQuestion.SelectedItem.Text = r.UserSecurityQuestion;
txtSecurityAnswer.Text = r.UserSecurityAnswer;
}
var delres = from delv in DB.GetTable <UserInfo>() where delv.Username == txtUsername.Text select delv;
foreach (var r in delres)
{
DB.UserInfos.DeleteOnSubmit(r);
}
DB.SubmitChanges();
PanelAcceptInfos1.Enabled = true;
PanelAcceptInfos2.Enabled = false;
CheckUsernameAvailbility();
}
}
void DisplayUserInfo()
{
try
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
// var res = from v in DB.GetTable<UserInfo>() where v.Username == Session["user"] select v;
var res = DB.UserInfos.Where(x => x.Username == Session["user"]);
foreach (var r in res)
{
txtUsername.Text = r.Username;
txtFirstName.Text = r.UserFirstName;
txtMiddleName.Text = r.UserMiddleName;
txtLastName.Text = r.UserLastName;
if (r.UserGender == "Male")
{
RadioButtonMale.Checked = true;
}
else
{
RadioButtonFemale.Checked = true;
}
txtDOB.Text = r.UserDOB;
DropDownListCountry.SelectedItem.Text = r.UserCountry;
DropDownlistCity.Items.Add(r.UserCity);
txtPhNo.Text = r.UserPhoneNumber;
if (r.UserMartialStatus == "y")
{
RadioButtonMarried.Checked = true;
}
else
{
RadioButtonUnmarried.Checked = true;
}
txtEMail.Text = r.UserEMail;
DropDownListSecurityQuestion.SelectedItem.Text = r.UserSecurityQuestion;
txtSecurityAnswer.Text = r.UserSecurityAnswer;
CheckBoxAgreeTerms.Checked = true;
}
}
catch (System.NullReferenceException exc) { Response.Redirect("Homepage.aspx?s=0"); }
}
protected void txtUsername_TextChanged(object sender, EventArgs e)
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
bool test = DB.UserInfos.Where(x => x.Username == txtUsername.Text).Count() == 1?true:false;
if (test == true)
{
txtUsername.Enabled = false;
lblWarning.Text = "";
var qn = from v in DB.GetTable <UserInfo>() where v.Username == txtUsername.Text select v.UserSecurityQuestion;
foreach (var r in qn)
{
txtSecurityQuestion.Text = r;
}
txtSecurityQuestion.Enabled = false;
}
else
{
lblWarning.Text = "No such username was found! Please check the username first!";
}
}
void SendMessageToUser()
{
if (txtMessageToUser.Text.Trim() == "")
{
//lblUserMessageSendingErrorMessage.Visible = true;
lblUserMessageSendingErrorMessage.ForeColor = System.Drawing.Color.Red;
lblUserMessageSendingErrorMessage.Text = "Please enter a message first to send to the user!";
return;
}
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
var res = DB.UserInfos.Where(x => x.Username == Request.QueryString["User"].ToString());
foreach (var r in res)
{
r.Notifications = "* [" + Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).ToString() + "] A message from Site's Administrator: " + txtMessageToUser.Text + "|" + r.Notifications.ToString();
}
DB.SubmitChanges();
lblUserMessageSendingErrorMessage.ForeColor = System.Drawing.Color.DarkBlue;
lblUserMessageSendingErrorMessage.Text = "Message sent to the user successfully!";
txtMessageToUser.Text = "";
}
void m1()
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
string[] names = new string[DB.UserInfos.Count() * 3];
var res = from v in DB.GetTable <UserInfo>() select v;
int i = -1;
foreach (var r in res)
{
names[++i] = r.UserFirstName.ToString().Trim();
names[++i] = r.UserLastName.ToString().Trim();
names[++i] = r.Username.ToString().Trim();
}
TextBox1.Text = "names:\t";
foreach (string s in names)
{
TextBox1.Text += s + " ";
}
}
void DisplayUserInfo()
{
//lblUserMessageSendingErrorMessage.Visible = false;
//lblUserMessageSendingErrorMessage.Text = "";
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
// var res = from v in DB.GetTable<UserInfo>() where v.Username == Request.QueryString["User"].ToString() select v;
var res = DB.UserInfos.Where(x => x.Username == Request.QueryString["User"].ToString());
foreach (var r in res)
{
lblUsername.Text = r.Username;
lblFirstName.Text = r.UserFirstName;
if (r.UserMiddleName == "")
{
Label3.Visible = false; lblMiddleName.Visible = false;
}
else
{
Label3.Visible = true; lblMiddleName.Text = r.UserMiddleName;
}
lblLastName.Text = r.UserLastName;
lblGender.Text = r.UserGender;
lblDOB.Text = r.UserDOB;
lblCountry.Text = r.UserCountry;
lblCity.Text = r.UserCity;
if (r.UserMartialStatus == "y")
{
lblMartialStatus.Text = "Married";
}
else
{
lblMartialStatus.Text = "Unmarried";
}
lblEMail.Text = r.UserEMail;
lblSendUserMessage.Text = "Send a message to " + r.UserFirstName + " " + r.UserLastName + ":";
ImageUserProfilePicture.ImageUrl = r.UserProfilePicFile;
}
}
void ChangeAdminCredentials()
{
try
{
PanelCheckNewFiles.Visible = false;
PanelCheckNewUsers.Visible = false;
PanelRegisteredUser.Visible = false;
PanelSearchAllFiles.Visible = false;
PanelUpdateAdminInfo.Visible = true;
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
// var res = from v in DB.GetTable<AdminInfo>() select v;
var res = DB.AdminInfos.Where(x => x.AdminName == Session["user"]);
foreach (var r in res)
{
r.AdminName = txtAdminUsername.Text;
r.AdminPwd = txtAdminPassword.Text;
}
DB.SubmitChanges();
lblConfirmAdminCredentialsChange.Text = "Admin credentials changed successfully!";
}
catch (System.NullReferenceException exc) { Response.Redirect("Homepage.aspx?s=0"); }
}
void populateGridViewSearchedUsers()
{
if (txtSearchUser.Text.Trim() == "")
{
lblSearchUserErrorMessage.Text = "Please enter a non-null search term!"; return;
}
SqlConnection con = new SqlConnection(constr);
con.Open();
string sqlQuery = "select UserFirstName \"First Name\", UserMiddleName \"Middle Name\", UserLastName \"Last Name\", Username \"Username\" from UserInfos where UserFirstName like '%" + txtSearchUser.Text.Trim() + "%' or UserMiddleName like '%" + txtSearchUser.Text.Trim() + "%' or UserLastName like '%" + txtSearchUser.Text.Trim() + "%' ";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
SqlDataReader reader = cmd.ExecuteReader();
GridViewSearchedUsers.DataSource = reader;
GridViewSearchedUsers.DataBind();
con.Close();
lblSearchUserErrorMessage.Text = GridViewSearchedUsers.Rows.Count + " result(s) returned!";
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
for (int i = 0; i < GridViewSearchedUsers.Rows.Count; i++)
{
ImageButton imgbtnProPic = new ImageButton();
imgbtnProPic = (ImageButton)GridViewSearchedUsers.Rows[i].FindControl("imgbtnUserProPic");
imgbtnProPic.PostBackUrl = "AdminUserAccountControl.aspx?User="******"btnAddUser");
btnAdd.CommandArgument = GridViewSearchedUsers.Rows[i].Cells[4].Text;
}
}
public string[] getUserInfosSuggestionList(string prefixText, int count)
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
string[] names = new string[DB.UserInfos.Count()];
List <string> MatchList = new List <string>();
var res = from v in DB.GetTable <UserInfo>() select v;
int i = 0;
foreach (var r in res)
{
names[i++] = r.UserFirstName + " " + r.UserLastName + " [" + r.Username + "]";
}
foreach (string element in names)
{
if (element.ToLower().Contains(prefixText.ToLower()))
{
MatchList.Add(element);
}
}
return(MatchList.ToArray());
}
protected void btnGetPwd_Click(object sender, EventArgs e)
{
Wait();
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
bool test = DB.UserInfos.Where(x => x.Username == txtUsername.Text && x.UserSecurityQuestion == txtSecurityQuestion.Text && x.UserSecurityAnswer == txtSecurityAnswer.Text).Count() == 1?true:false;
if (test == true)
{
PanelShowUserPwd.Visible = true;
PanelGetUserInputs.Visible = false;
var pwd = from v in DB.GetTable <UserInfo>() where v.Username == txtUsername.Text select v.UserPwd;
foreach (var r in pwd)
{
lblShowUserPwd.Text = "Your account password was: '" + r + "'";
}
}
else
{
if (txtUsername.Text != "" && txtSecurityQuestion.Text != "" && txtSecurityAnswer.Text != "")
{
lblWarning.Text = "Your security answer did not matched with the security answer you provided! Please try again!";
}
}
}
void UploadFile()
{
try
{
DropDownListSearchCategory.Enabled = true;
if (DropDownListUploadMode.SelectedItem.Text == "General Mode")
{
if (FileUpload1.HasFile)
{
FunZoneDatabaseDataContext DB = new FunZoneDatabaseDataContext();
// Inserting values to each column of the uploaded file's record
int NewFileNo = 0;
if (DB.DBFiles.Count() == 0)
{
NewFileNo = 0;
}
else
{
var res = from v in DB.GetTable <DBFile>() select v.FileNo;
foreach (var r in res)
{
NewFileNo = r;
}
}
DBFile record = new DBFile();
record.FileNo = NewFileNo + 1;
// $$$$$$$$$$$$$$$$$$$$$$$$$ record.UploaderUserName = Request.QueryString[""].ToString();
record.UploaderUserName = "******";
record.Mode = "General";
record.SharedWith = "Nobody";
DateTime now = DateTime.Now;
record.UploadDateTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); // 'YYYY-MM-DD HH:MM:SS'
switch (DropDownListSearchCategory.SelectedItem.Text)
{
case "Image":
{
//Response.Write("Image");
record.Category = DropDownListSearchCategory.SelectedItem.Text;
record.UploadedFileName = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
// ++++++++++++++++++++++++++++++
string filenameWithExt = Path.GetFileName(FileUpload1.FileName);
record.UploadedFileName_WithExt = filenameWithExt;
if (Convert.ToInt32(FileUpload1.PostedFile.ContentLength) < 1024)
{
record.UploadedFileSize = Convert.ToString(FileUpload1.PostedFile.ContentLength) + "B";
}
else if (Convert.ToInt32(FileUpload1.PostedFile.ContentLength) >= 1024 && Convert.ToInt32(FileUpload1.PostedFile.ContentLength) <= (1024 * 1024))
{
record.UploadedFileSize = Convert.ToString(FileUpload1.PostedFile.ContentLength / 1024) + "KB";
}
else
{
record.UploadedFileSize = Convert.ToString(FileUpload1.PostedFile.ContentLength / (1024 * 1024)) + "MB";
}
if (FileUpload1.PostedFile.ContentType == "image/jpeg" || FileUpload1.PostedFile.ContentType == "image/png" || FileUpload1.PostedFile.ContentType == "image/jpg" || FileUpload1.PostedFile.ContentType == "image/gif" || FileUpload1.PostedFile.ContentType == "image/x-icon")
{
if (FileUpload1.PostedFile.ContentLength < 10485760)
{
// ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
//record.FileAddressInServerDB = "~/UploadedFiles/ServerDatabase/Images/" + filenameWithExt;
FileUpload1.SaveAs(Server.MapPath("~/UploadedFiles/ServerDatabase/TempFiles/TempUploads/" + filenameWithExt));
// zipping the file and saving it to the appropriate directory of the ServerDatabase
using (var zip = new ZipFile())
{
string fullFileAddress = Server.MapPath(".") + @"/UploadedFiles/ServerDatabase/Images/" + filenameWithExt + ".zip";
zip.AddDirectory(Server.MapPath(".") + @"/UploadedFiles/ServerDatabase/TempFiles/TempUploads/");
zip.Save(fullFileAddress);
string[] files = System.IO.Directory.GetFiles(Server.MapPath("~/UploadedFiles/ServerDatabase/TempFiles/TempUploads/"));
foreach (string f in files)
{
System.IO.File.Delete(f);
}
}
lblUploadStatus.Text = "Upload Status: File '" + filenameWithExt + "' uploaded successfully!";
DB.DBFiles.InsertOnSubmit(record);
DB.SubmitChanges();
DropDownListSearchCategory.ClearSelection();
DropDownListUploadMode.ClearSelection();
//Image1.ImageUrl = "~\\ImageControl Icons\\Tick.ico";
}
else
{
lblUploadStatus.Text = "Upload Status: Error: File size should be less than 10MB!";
//Image1.ImageUrl = "~\\ImageControl Icons\\Warning.ico";
}
}
else
{
lblUploadStatus.Text = "Upload Status: Error: Only " + DropDownListSearchCategory.SelectedItem.Text + " file(*.jpg, *.jpeg, *.png, *.gif, *.ico) can be uploaded!";
}
break;
}
}
}
else
{
lblUploadStatus.Text = "FileUpload1 does not have a file!";
}
}
else
{
lblUploadStatus.Text = "Please choose an upload category!";
}
}
catch (Exception exc)
{
Response.Write("Exc inside UploadFile(): " + exc.Message);
}
}
