public void TestFrFRUpperCaseCharacter() { char ch = 'G'; char expectedChar = 'g'; TextInfo textInfo = new CultureInfo("fr-FR").TextInfo; char actualChar = textInfo.ToLower(ch); Assert.Equal(expectedChar, actualChar); }
public void TestEnUSLowercaseCharacter() { char ch = 'a'; char expectedChar = ch; TextInfo textInfo = new CultureInfo("en-US").TextInfo; char actualChar = textInfo.ToLower(ch); Assert.Equal(expectedChar, actualChar); }
/// <summary> /// Prompts the user for a standard input (AKA console) input to whether they wish to enter a middle name or not /// </summary> private void checkMiddle() { TextInfo ti = new CultureInfo("en-US", false).TextInfo; Console.WriteLine("Do you have a middle name? [Y/N]"); if (String.Compare(ti.ToLower(readString()), "y") == 0) hasMiddle = true; else hasMiddle = false; }
public void TestNonAlphabeticCharacter() { for (int i = 0; i <= 9; i++) { char ch = Convert.ToChar(i); char expectedChar = ch; TextInfo textInfo = new CultureInfo("en-US").TextInfo; char actualChar = textInfo.ToLower(ch); Assert.Equal(expectedChar, actualChar); } }
public static String toProper(String columnString) { // Creates a TextInfo object from which the method will apply the casing rules var myTI = new CultureInfo("en-US", false).TextInfo; // Constructs the proper cased string var retval = myTI.ToTitleCase(myTI.ToLower(columnString)); // Returns the String to the caller return retval; } // End of Method declaration
public void TestTrTRUppercaseCharacter() { char ch = '\u0130'; char expectedChar = 'i'; TextInfo textInfo = new CultureInfo("tr-TR").TextInfo; char actualChar = textInfo.ToLower(ch); Assert.Equal(expectedChar, actualChar); ch = 'I'; expectedChar = '\u0131'; actualChar = textInfo.ToLower(ch); Assert.Equal(expectedChar, actualChar); }
protected void Page_Load(object sender, EventArgs e) { string usernameCookie = ""; if (Request.Cookies["user"] != null) { //If cookie exist, get username HttpCookie getUserCookie = Request.Cookies["user"]; usernameCookie = getUserCookie.Values["username"]; string userType = getUserCookie.Values["usertype"]; switch (userType) { case "s": userProfileHomeID.Attributes["href"] = String.Format("UserProfile.aspx"); break; case "r": userProfileHomeID.Attributes["href"] = String.Format("ReviewerProfile.aspx"); break; case "a": userProfileHomeID.Attributes["href"] = String.Format("Admin_Dashboard_Main.aspx"); break; } } else { Response.Redirect("A_Login.aspx"); } string firstName = ""; string lastName = ""; string finalFirstName = ""; string finalLastName = ""; string finalFullName = ""; string emailAddress = ""; string finalEmailAddress = ""; string collegeDepartment = ""; string finalCollegeDepartment = ""; string username = usernameCookie; string picFileName = ""; //username = Request.QueryString["u.username"]; string connectionString; connectionString = ConfigurationManager.ConnectionStrings["ConnectionStringLocalDB"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = connection.CreateCommand()) { command.CommandText= "SELECT "+ "First_Name, "+ "Last_Name, "+ "College_Dept, "+ "Email, " + "Comment_Box " + "FROM "+ "dbo.USERS "+ "WHERE username = @usernameDB"; command.Parameters.AddWithValue("@usernameDB", username); try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { firstName = reader.GetString(0); lastName = reader.GetString(1); collegeDepartment = reader.GetString(2); emailAddress = reader.GetString(3); picFileName = reader.GetString(4); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } } } //Define object to make string proper case TextInfo titleCase = new CultureInfo("en-US", false).TextInfo; finalFirstName = titleCase.ToTitleCase(firstName.ToLower()); finalLastName = titleCase.ToTitleCase(lastName); finalFullName = finalFirstName + " " + finalLastName; finalEmailAddress = titleCase.ToLower(emailAddress); reviewerUserID.Text = finalFirstName + " " + finalLastName; profileNameID.Text = finalFullName; departmentID.Text = collegeDepartment; useremailID.Text = finalEmailAddress; profPic.InnerHtml = "<img class='userProfileImageBorder' src='UploadImage/" + picFileName + "'></img>"; ; SqlDataSource1.SelectCommand="select username, Project_ID , Project_Name , Course_ID from FILES "+ "WHERE "+ "Comm_Name in "+ "(select First_Name+' '+Last_Name from USERS WHERE username='******') OR "+ "Chair_Name in "+ "(select First_Name+' '+Last_Name from USERS WHERE username='******')"; }
/// <summary> /// Utilises CultureInfo to detect which part of the name the user is attempting to input, as well as resolving any issues with case. /// </summary> /// <param name="control">Switch info: 1 = First Name, 2 = Middle Name (if applicable), 3 = Surname</param> /// <returns>-1 on failure</returns> private int getName(int control) { if (control < 0 || control > 3) return -1; TextInfo ti = new CultureInfo("en-US", false).TextInfo; switch (control) { case 1: { Console.WriteLine("Please enter your first name: "); first = ti.ToTitleCase(ti.ToLower(readString())); return 0; } // 1 case 2: { Console.WriteLine("Please enter your middle name/s: "); middle = ti.ToTitleCase(ti.ToLower(readString())); return 0; } // 2 case 3: { Console.WriteLine("Please enter your surname: "); surname = ti.ToTitleCase(ti.ToLower(readString())); return 0; } // 3 default: return -1; } // switch }
//Made Changes Here protected void Page_Load(object sender, EventArgs e) { string cookieUsername = ""; string userPasswordFromCookie = ""; if (Request.Cookies["user"] != null) { //If cookie exist, get username HttpCookie getUserCookie = Request.Cookies["user"]; cookieUsername = getUserCookie.Values["username"]; userPasswordFromCookie = getUserCookie.Values["userpassword"]; string userType = getUserCookie.Values["usertype"]; switch (userType) { case "s": userProfileHomeID.Attributes["href"] = String.Format("UserProfile.aspx"); break; case "r": userProfileHomeID.Attributes["href"] = String.Format("ReviewerProfile.aspx"); break; case "a": userProfileHomeID.Attributes["href"] = String.Format("Admin_Dashboard_Main.aspx"); break; } } else { Response.Redirect("A_Login.aspx"); } //Arrive from search page if (!String.IsNullOrEmpty(Request.QueryString["usernameFromSearch"])) { cookieUsername = Request.QueryString["usernameFromSearch"]; } string connectionString = ConfigurationManager.ConnectionStrings["ConnectionStringLocalDB"].ConnectionString; string UserUsernameDB = ""; string UserFirst_NameDB = ""; string UserLast_NameDB = ""; string UserEmailDB = ""; string UserSecurity_QuestionDB = ""; string UserSecurity_AnswerDB = ""; string UserAcct_ReasonDB = ""; string UserSemester_CompletionDB = ""; DateTime UserAccount_DateDB = DateTime.Now; int UserProgress_BarDB = 0; string UserComment_BoxDB = ""; string UserComment_StatusDB = ""; string UserReviewer_CommentsDB = ""; string UserCollege_DeptDB = ""; string LoginUsername = ""; string LoginUserpassword = ""; string LoginUser_Type = ""; int Login_Count; DateTime Last_Login = DateTime.Now; string Approve_Status = ""; string Filesusername = ""; string FilesProject_ID = ""; string FilesProject_Name = ""; string FilesCourse_ID = ""; string FilesKeyword1 = ""; string FilesKeyword2 = ""; string FilesKeyword3 = ""; string FilesAbstract = ""; string FilesLive_Link = ""; string FilesVideo_Link = ""; string FilesChair_Name = ""; string FilesChair_Email = ""; string FilesComm_Name = ""; string FilesComm_Email = ""; string FilesGadvisor_Name = ""; string FilesGadvisor_Email = ""; DateTime FilesUpload_Date = DateTime.Now; string FilesReject_Reason = ""; int FilesNum_Views = 0; int FilesNum_Dloads = 0; string FilesPic_File = ""; string FilesProj_Pdf_File = ""; string FilesProj_Zip_File = ""; string FilesPres_Date = ""; int FilesDislike_Count = 0; int FilesLike_Count = 0; string FilesApproval_Status1 = ""; string FilesApproval_Status2 = ""; string FilesApproval_Status3 = ""; string FilesReviewer_Comment1 = ""; string FilesReviewer_Comment2 = ""; string FilesReviewer_Comment3 = ""; string finalCommitteeMemberName = ""; string finalCommitteeChairName = ""; string finalAdvisorName = ""; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "SELECT " + "u.username, " + "u.First_Name, " + "u.Last_Name, " + "u.Email, " + "u.Security_Question, " + "u.Security_Answer, " + "u.Acct_Reason, " + "u.Semester_Completion, " + "u.Account_Date, " + "u.Progress_Bar, " + "u.Comment_Box, " + "u.Comment_Status, " + "u.Reviewer_Comments, " + "u.College_Dept, " + "l.username, " + "l.userpassword, " + "l.User_Type, " + "l.Login_Count, " + "l.Last_Login, " + "l.Approve_Status, " + "f.username, " + "f.Project_ID, " + "f.Project_Name, " + "f.Course_ID, " + "f.Keyword1, " + "f.Keyword2, " + "f.Keyword3, " + "f.Abstract, " + "f.Live_Link, " + "f.Video_Link, " + "f.Chair_Name, " + "f.Chair_Email, " + "f.Comm_Name, " + "f.Comm_Email, " + "f.Gadvisor_Name, " + "f.Gadvisor_Email, " + "f.Upload_Date, " + "f.Reject_Reason, " + "f.Num_Views, " + "f.Num_Dloads, " + "f.Pic_File, " + "f.Proj_Pdf_File, " + "f.Proj_Zip_File, " + "f.Pres_Date, " + "f.Dislike_Count, " + "f.Like_Count, " + "f.Approval_Status1, " + "f.Approval_Status2, " + "f.Approval_Status3, " + "f.Reviewer_Comment1, " + "f.Reviewer_Comment2, " + "f.Reviewer_Comment3 " + "FROM " + "dbo.USERS u JOIN dbo.LOGIN l " + "ON u.username=l.username " + "JOIN dbo.FILES f " + "ON l.username=f.username " + "WHERE u.username = @usernameDB"; command.Parameters.AddWithValue("@usernameDB", cookieUsername); try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { UserUsernameDB = reader.GetString(0); UserFirst_NameDB = reader.GetString(1); UserLast_NameDB = reader.GetString(2); UserEmailDB = reader.GetString(3); UserSecurity_QuestionDB = reader.GetString(4); UserSecurity_AnswerDB = reader.GetString(5); UserAcct_ReasonDB = reader.GetString(6); UserSemester_CompletionDB = reader.GetString(7); UserAccount_DateDB = reader.GetDateTime(8); UserProgress_BarDB = reader.GetInt32(9); UserComment_BoxDB = reader.GetString(10); UserComment_StatusDB = reader.GetString(11); UserReviewer_CommentsDB = reader.GetString(12); UserCollege_DeptDB = reader.GetString(13); LoginUsername = reader.GetString(14); LoginUserpassword = reader.GetString(15); LoginUser_Type = reader.GetString(16); Login_Count = reader.GetInt32(17); Last_Login = reader.GetDateTime(18); Approve_Status = reader.GetString(19); Filesusername = reader.GetString(20); FilesProject_ID = reader.GetString(21); FilesProject_Name = reader.GetString(22); FilesCourse_ID = reader.GetString(23); FilesKeyword1 = reader.GetString(24); FilesKeyword2 = reader.GetString(25); FilesKeyword3 = reader.GetString(26); FilesAbstract = reader.GetString(27); FilesLive_Link = reader.GetString(28); FilesVideo_Link = reader.GetString(29); FilesChair_Name = reader.GetString(30); FilesChair_Email = reader.GetString(31); FilesComm_Name = reader.GetString(32); FilesComm_Email = reader.GetString(33); FilesGadvisor_Name = reader.GetString(34); FilesGadvisor_Email = reader.GetString(35); FilesUpload_Date = reader.GetDateTime(36); FilesReject_Reason = reader.GetString(37); FilesNum_Views = reader.GetInt32(38); FilesNum_Dloads = reader.GetInt32(39); FilesPic_File = reader.GetString(40); FilesProj_Pdf_File = reader.GetString(41); FilesProj_Zip_File = reader.GetString(42); FilesPres_Date = reader.GetString(43); FilesDislike_Count = reader.GetInt32(44); FilesLike_Count = reader.GetInt32(45); FilesApproval_Status1 = reader.GetString(46); FilesApproval_Status2 = reader.GetString(47); FilesApproval_Status3 = reader.GetString(48); FilesReviewer_Comment1 = reader.GetString(49); FilesReviewer_Comment2 = reader.GetString(50); FilesReviewer_Comment3 = reader.GetString(51); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } } //End SqlCommand } //End SqlConnection //Define object to make string proper case TextInfo titleCase = new CultureInfo("en-US", false).TextInfo; rejectID.Text = FilesReviewer_Comment1 + " " + FilesReviewer_Comment2 + " " + FilesReviewer_Comment3; commentSectionID.Text = UserComment_BoxDB; finalAdvisorName = titleCase.ToTitleCase(FilesGadvisor_Name); finalCommitteeChairName = titleCase.ToTitleCase(FilesChair_Name); finalCommitteeMemberName = titleCase.ToTitleCase(FilesComm_Name); string firstNameProperCase = titleCase.ToTitleCase(UserFirst_NameDB.ToLower()); string lastNameProperCase = titleCase.ToTitleCase(UserLast_NameDB); presentationDateID.Text = FilesPres_Date; headerUserNameID.Text = firstNameProperCase + " " + lastNameProperCase; FullNameLabel.Text = titleCase.ToTitleCase(UserFirst_NameDB.ToLower()) + " " + titleCase.ToTitleCase(UserLast_NameDB.ToLower()); LastLoginLabel.Text = Last_Login.ToString("G"); CourseNumberLabel.Text = FilesCourse_ID; DepartmentLabel.Text = UserCollege_DeptDB; SemesterCompletedLabel.Text = UserSemester_CompletionDB; EmailLabel.Text = titleCase.ToLower(UserEmailDB); AccountCreatedDateLabel.Text = UserAccount_DateDB.ToString("G"); AccountReasonLabel.Text = titleCase.ToTitleCase(UserAcct_ReasonDB); string statusString = ""; if (Approve_Status == "y") { statusString = "Approved"; } else { statusString = "Not Approved"; } AccountApprovedLabel.Text = statusString; firstNameId.Text = titleCase.ToTitleCase(UserFirst_NameDB); lastNameId.Text = titleCase.ToTitleCase(UserLast_NameDB); userNameId.Text = UserUsernameDB; passwordId.Attributes.Add("value", userPasswordFromCookie); emailId.Text = UserEmailDB; securityQuestionID.Text = UserSecurity_QuestionDB; securityAnswerID.Text = UserSecurity_AnswerDB; keyword1Id.Text = titleCase.ToTitleCase(FilesKeyword1); keyword2Id.Text = titleCase.ToTitleCase(FilesKeyword2); keyword3Id.Text = titleCase.ToTitleCase(FilesKeyword3); liveLinkId.Text = titleCase.ToLower(FilesLive_Link); videoLinkId.Text = titleCase.ToLower(FilesVideo_Link); researchNameLabel.Text = FilesProject_Name; abstractID.Text = titleCase.ToLower(FilesAbstract); if (FilesLive_Link == "") { projectLiveLinkID.NavigateUrl = ""; string liveLinkMsg = "No LIVE URL was provided."; projectLiveLinkID.Text = liveLinkMsg; projectLiveLinkID.Enabled = false; } else { projectLiveLinkID.NavigateUrl = FilesLive_Link; } if (FilesVideo_Link == "") { projectVideoLinkID.NavigateUrl = ""; string videoLinkMsg = "No VIDEO URL was provided."; projectVideoLinkID.Text = videoLinkMsg; projectVideoLinkID.Enabled = false; } else { projectVideoLinkID.NavigateUrl = FilesVideo_Link; } pdfDownload.NavigateUrl = "UploadPDF\\" + FilesProj_Pdf_File; zipDownload.NavigateUrl = "UploadZIP\\" + FilesProj_Zip_File; committeeChairNameID.Text = "Dr. "+finalCommitteeChairName; committeeChairEmailID.Text = FilesChair_Email; committeeMemberNameID.Text = "Dr. " + finalCommitteeMemberName; committeeMemberEmailID.Text = FilesComm_Email; graduateAdvisorNameID.Text = finalAdvisorName; graduateAdvisorEmailID.Text = FilesGadvisor_Email; userPic.InnerHtml = "<img class='userProfileImageBorder' src='UploadImage/" + FilesPic_File + "'></img>"; if (UserProgress_BarDB >= 0) { progressBarPanel.Visible = true; submissionDeclinedPanel.Visible = false; } else { progressBarPanel.Visible = false; submissionDeclinedPanel.Visible = true; } int progressBarStart = UserProgress_BarDB; switch (progressBarStart) { case 0: progressBarInt.Style.Add("width", "10%"); break; case 1: progressBarInt.Style.Add("width", "33%"); break; case 2: progressBarInt.Style.Add("width", "66%"); break; case 3: progressBarInt.Style.Add("width", "100%"); break; } numberOfViewsID.Text = FilesNum_Views.ToString(); numberOfDownloadID.Text = FilesNum_Dloads.ToString(); likeCountID.Text = FilesLike_Count.ToString(); dislikeCountID.Text = FilesDislike_Count.ToString(); //commentSectionID.Text invitationChairEmail = FilesChair_Email; inivitationCommEmail = FilesComm_Email; invitationAdvisorEmail = FilesGadvisor_Email; invitationFirstName = firstNameProperCase; invitationLastName = lastNameProperCase; invitationProjectName = FilesProject_Name; //Changes made here }
private static void play() { Console.WriteLine("Would you prefer what is behind door number 1, 2, or 3?"); int min = 1; int max = 4; // Load the random numbers ArrayList availableNumbers = new ArrayList(); for (int i = min; i < max; i++) availableNumbers.Add(i); // Assign the first number to the car's door number int carValue = RandomNumber(min, max); availableNumbers.Remove(carValue); int boatValue = carValue; int catValue; string message; // Randomly search for a value for the boat's door number while (!availableNumbers.Contains(boatValue)) boatValue = RandomNumber(min, max); availableNumbers.Remove(boatValue); // Assign the cat value the remaining number catValue = (int)availableNumbers[0]; // DEBUG //Console.WriteLine(String.Format("CarValue: {0} BoatValue: {1} CatValue: {2}",carValue,boatValue,catValue)); // Read the user input int userValue = readNumber(min, max); // The 'CatValue' variable now only holds debug purposes, due to sufficient validation on the integer input if (userValue == carValue) message = "You won a new car!"; else if (userValue == boatValue) message = "You won a new boat!"; else message = "You won a new cat!"; Console.WriteLine(message); Console.WriteLine("Do you want to play again? [Y/N]"); TextInfo ti = new CultureInfo("en-US", false).TextInfo; if (String.Compare(ti.ToLower(readString()), "y") == 0) { // Repeat Console.WriteLine(""); play(); } else // Cleanly exit Environment.Exit(-1); }
public string_advanced_examples() { //escape sequences string tab = "This is a\t tab."; string charLiterals = "This is a\' break."; string newLine = "This is a\n new line."; string backslash = "This is a \\ backslash because otherwise it wouldn't work properly and it would throw an error."; string backspace = "this is a backspace \b"; string carriageReturn = "This is a \r carriage return"; /*----------------------------------------------------- * All escape sequences * ---------------------------------------------------*/ //\' - single quote, needed for character literals //\" - double quote, needed for string literals //\\ - backslash //\0 - Unicode character 0 (ASCII) //\a - Alert (character 7) //\b - Backspace (character 8) //\f - Form feed (character 12) //\n - New line (character 10) //\r - Carriage return (character 13) //\t - Horizontal tab (character 9) //\v - Vertical quote (character 11) //\uxxxx - Unicode escape sequence for character with hex value xxxx //\xn[n][n][n] - Unicode escape sequence for character with hex value nnnn (variable length version of \uxxxx) //\Uxxxxxxxx - Unicode escape sequence for character with hex value xxxxxxxx (for generating surrogates) //verbatims //In a verbatim string literal, the characters between the delimiters are interpreted verbatim, the only exception being a quote-escape-sequence. In particular, simple escape sequences and hexadecimal and Unicode escape sequences are not processed in verbatim string literals. A verbatim string literal may span multiple lines. string verbatim = @"And she said, 'Johnny knows the world is cruel but he loves 'it' anyways'."; Console.WriteLine(verbatim); //verbatims appear "as-is", meaning it is cleaner and easier to program. You don't need to use escape sequences all over the place. //case manipulation Console.WriteLine("\nBegin String case manipulation\n"); string monkey = "monKEYs aRE WILD animals."; Console.WriteLine("\"{0}\" string lower case: {1}", monkey, monkey.ToLower());// this should take the string and put everything in lower case. Console.WriteLine("\"{0}\" string upper case: {1}", monkey, monkey.ToUpper());// this should take the string and put everything in upper case. TextInfo ti = new CultureInfo("en-US", false).TextInfo; Console.WriteLine("\"{0}\" textinfo upper case: {1}", monkey, ti.ToUpper(monkey));// this should take the string and put everything in upper case. Console.WriteLine("\"{0}\" textinfo lower case: {1}", monkey, ti.ToLower(monkey));// this should take the string and put everything in lower case. Console.WriteLine("\"{0}\" textinfo titled case: {1}", monkey, ti.ToTitleCase(monkey));// this should take the string and put everything in titled case. string bubby = " asdf a sdfsd sd f d f f "; bubby = bubby.Trim();// removes all white spaces and non-alphabetic characters. Console.WriteLine("The new and improved bubby is: " + bubby); //i have no idea what these do. bubby = bubby.PadLeft(17, 'a'); Console.WriteLine(bubby); bubby = bubby.PadRight(5, 'u'); Console.WriteLine(bubby); string attack = "Yummy people are awkward to socalize with."; Console.WriteLine("Length of attack var is " + attack.Length);//this returns the number of characters of the string. Cannot be invoked like Java. bool check = true; while (check == true) { if (attack.Contains(':') || attack.Contains('@') || attack.Contains('.') || attack.Contains('=')) { Console.WriteLine("A SQL injection attempt has been detected. Cleaning input now."); attack = attack.Replace('.', ' '); attack = attack.Replace('@', ' '); attack = attack.Replace(':', ' '); attack = attack.Replace('=', ' '); check = true;//this type of logic could be used to check for invalid input that might be used in a SQL injection attack. } else { Console.WriteLine("SQL injection check completed. As you were."); check = false; } } //concationating strings string hank = "Hank Hill"; string peggy = "Peggy Hill"; string married = "are married."; Console.WriteLine(hank + " and " + peggy + " " + married); //similar way to do this: Console.WriteLine("{0} and {1} {2}", hank, peggy, married);// don't have to type as many pluses and "" things. //concatination is slow. Use the String Builder class for larger strings. StringBuilder sbuild = new StringBuilder(); sbuild.Append(hank); sbuild.Append(" and "); sbuild.Append(peggy); sbuild.Append(" "); sbuild.Append(married); Console.WriteLine(sbuild); //although there is no output difference this method is more efficient. }
// regex match evaluator for changing case private string MatchEvalChangeCase( Match match ) { TextInfo ti = new CultureInfo( "en" ).TextInfo; if ( itmChangeCaseUppercase.Checked ) return ti.ToUpper( match.Groups[1].Value ); else if( itmChangeCaseLowercase.Checked ) return ti.ToLower( match.Groups[1].Value ); else if( itmChangeCaseTitlecase.Checked ) return ti.ToTitleCase( match.Groups[1].Value.ToLower() ); else return match.Groups[1].Value; }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user"] != null) { //If cookie exist, get username HttpCookie getUserCookie = Request.Cookies["user"]; string userType = getUserCookie.Values["usertype"]; switch (userType) { case "s": userProfileHomeID.Attributes["href"] = String.Format("UserProfile.aspx"); break; case "r": userProfileHomeID.Attributes["href"] = String.Format("ReviewerProfile.aspx"); break; case "a": userProfileHomeID.Attributes["href"] = String.Format("Admin_Dashboard_Main.aspx"); break; } } else { Response.Redirect("A_Login.aspx"); } string cookieUsername = ""; string userNameToSet = "a"; string userNameToSet2 = "a"; string finalUsername = ""; string finalFirstName = ""; string finalLastName = ""; string finalFullName = ""; string finalEmail = ""; string finalPicFile = ""; string finalLiveLink = ""; string finalVideoLink = ""; string finalZipFile = ""; string finalPdfFile = ""; string courseIDNumber = ""; string collegeDept = ""; string firstName = ""; string lastName = ""; string emailAddress = ""; string imageFile = ""; string researchName = ""; string abstractContent = ""; string liveLink = ""; string videoLink = ""; string pdfFile = ""; string zipFile = ""; string userImage = ""; string committeeChairName = ""; string committeeMemberName = ""; string advisorName = ""; string committeeChairEmail = ""; string committeeMemberEmail = ""; string advisorEmail = ""; string semesterCompleted = ""; string presentationDate = ""; string finalCommitteeMemberName = ""; string finalCommitteeChairName = ""; string finalAdvisorName = ""; if (!String.IsNullOrEmpty(Request.QueryString["username"])) { userNameToSet = Request.QueryString["username"]; finalUsername = userNameToSet; } if (!String.IsNullOrEmpty(Request.QueryString["u.username"])) { userNameToSet2 = Request.QueryString["u.username"]; finalUsername = userNameToSet2; } //try //{ // if (userNameToSet.Length > 1) // { // finalUsername = userNameToSet; // } // if (userNameToSet2.Length > 1) // { // finalUsername = userNameToSet2; // } //} ////Fit the other condition here //catch (Exception ex) //{ // Console.WriteLine(ex.Message); //} //if (Request.Cookies["user"] != null) //{ //If cookie exist, get username // HttpCookie getUserCookie = Request.Cookies["user"]; // cookieUsername = getUserCookie.Values["username"]; //} //else //{ // Response.Redirect("A_Login.aspx"); //} string connectionString; connectionString = ConfigurationManager.ConnectionStrings["ConnectionStringLocalDB"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "SELECT " + "First_Name, " + "Last_Name, " + "Email, " + "Semester_Completion, " + "College_Dept " + "FROM " + "dbo.USERS " + "WHERE username = @usernameDB"; command.Parameters.AddWithValue("@usernameDB", finalUsername); try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { firstName = reader.GetString(0); lastName = reader.GetString(1); emailAddress = reader.GetString(2); semesterCompleted = reader.GetString(3); collegeDept = reader.GetString(4); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } } } connectionString = ConfigurationManager.ConnectionStrings["ConnectionStringLocalDB"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "SELECT " + "Course_ID, " + "Pic_File, " + "Project_Name, " + " Abstract, " + "Live_Link, " + "Video_Link, " + "Proj_Zip_File, " + "Proj_Pdf_File, " + "Chair_Name, " + "Chair_Email, " + "Comm_Name, " + "Comm_Email, " + "Gadvisor_Name, " + "Gadvisor_Email, " + "Pres_Date " + "FROM " + "dbo.FILES " + "WHERE username = @usernameDB"; command.Parameters.AddWithValue("@usernameDB", finalUsername); try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { courseIDNumber = reader.GetString(0); imageFile = reader.GetString(1); researchName = reader.GetString(2); abstractContent = reader.GetString(3); liveLink = reader.GetString(4); videoLink = reader.GetString(5); zipFile = reader.GetString(6); pdfFile = reader.GetString(7); committeeChairName = reader.GetString(8); committeeChairEmail = reader.GetString(9); committeeMemberName = reader.GetString(10); committeeMemberEmail = reader.GetString(11); advisorName = reader.GetString(12); advisorEmail = reader.GetString(13); presentationDate = reader.GetString(14); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } } } //Define object to make string proper case TextInfo titleCase = new CultureInfo("en-US", false).TextInfo; finalAdvisorName = titleCase.ToTitleCase(advisorName); finalCommitteeChairName = titleCase.ToTitleCase(committeeChairName); finalCommitteeMemberName = titleCase.ToTitleCase(committeeMemberName); finalFirstName = titleCase.ToTitleCase(firstName.ToLower()); finalLastName = titleCase.ToTitleCase(lastName); finalFullName = finalFirstName + " " + finalLastName; finalEmail = titleCase.ToLower(emailAddress); finalPicFile = imageFile; finalLiveLink = liveLink; finalVideoLink = videoLink; finalZipFile = zipFile; finalPdfFile = pdfFile; pdfLink.NavigateUrl = "UploadPDF\\" + finalPdfFile; zipLink.NavigateUrl = "UploadZIP\\" + finalZipFile; userHeaderNameID.Text = finalFullName; profileNameID.Text = finalFullName; courseNumberID.Text = courseIDNumber; departmentID.Text = collegeDept; semesterCompletedID.Text = semesterCompleted; userEmailID.Text = finalEmail; researchNameLabel.Text = researchName; abstractID.Text = abstractContent; projectLiveLinkID.NavigateUrl = finalLiveLink; projectLiveLinkID.Text = finalLiveLink; projectVideoLinkID.NavigateUrl = finalVideoLink; projectVideoLinkID.Text = finalVideoLink; committeeChairNameID.Text = "Dr. "+finalCommitteeChairName; committeeChairEmailID.Text = committeeChairEmail; committeeMemberNameID.Text ="Dr. "+finalCommitteeMemberName; committeeMemberEmailID.Text = committeeMemberEmail; graduateAdvisorNameID.Text = finalAdvisorName; graduateAdvisorEmailID.Text = advisorEmail; presentationDateID.Text = presentationDate; userPic.InnerHtml = "<img class='userProfileImageBorder' src='UploadImage/" + finalPicFile + "'></img>"; }
public static string ToTitleCase(this string s) { var textInfo = new CultureInfo("en-US", false).TextInfo; return textInfo.ToTitleCase(textInfo.ToLower(s)); }
public static string FormatMarketFactSourceDates(string strDate) { TextInfo myTI = new CultureInfo("en-US", false).TextInfo; string strFormatted = strDate; //REGULAR EXPRESSION MATCHES //Matches 3.24.02 => YYYY-MM-DD string re_mm_dd_yy = "^(?<Month>\\d{1,2})([./-])(?<Day>\\d{1,2})([./-])(?<Year>(?:\\d{1,2}))$"; Regex objDatePattern1 = new Regex(re_mm_dd_yy, RegexOptions.None); if (objDatePattern1.IsMatch(strDate)) { MatchCollection MatchArray = objDatePattern1.Matches(strDate); Match FirstMatch = MatchArray[0]; string _year = FirstMatch.Groups["Year"].Value; string _month = FirstMatch.Groups["Month"].Value; string _day = FirstMatch.Groups["Day"].Value; Regex objIntPattern = new Regex("^\\d{1}$"); if(objIntPattern.IsMatch(_month)) { _month = "0" + _month; }; strFormatted = getYearFull(_year) + "-" + _month + "-" + _day; } //Matches SPRING 02 => Spring 2002 string re_Season_yy = "^(?<Season>SPRING|SUMMER|FALL|WINTER)([\\s])(?<Year>\\d{1,2})$"; Regex objDatePattern2 = new Regex(re_Season_yy, RegexOptions.None); if (objDatePattern2.IsMatch(strDate)) { MatchCollection MatchArray = objDatePattern2.Matches(strDate); Match FirstMatch = MatchArray[0]; string _season = myTI.ToLower(FirstMatch.Groups["Season"].Value); string _year = FirstMatch.Groups["Year"].Value; strFormatted = myTI.ToTitleCase(_season) + " " + getYearFull(_year); } //Matches 4.02 => April 2002 string re_m_yy = "^(?<Month>\\d{1,2})([.])(?<Year>\\d{1,2})$"; Regex objDatePattern3 = new Regex(re_m_yy, RegexOptions.None); if (objDatePattern3.IsMatch(strDate)) { MatchCollection MatchArray = objDatePattern3.Matches(strDate); Match FirstMatch = MatchArray[0]; string _month = FirstMatch.Groups["Month"].Value; string _year = FirstMatch.Groups["Year"].Value; strFormatted = getMonthFull(_month.TrimStart('0')) + " " + getYearFull(_year); } //Matches 1/2.02 => January/February 2002 string re_M_M_yyyy = "^(?<Month>\\d{1,2})([/])(?<Month2>\\d{1,2})([.])(?<Year>\\d{1,2})$"; Regex objDatePattern4 = new Regex(re_M_M_yyyy, RegexOptions.None); if (objDatePattern4.IsMatch(strDate)) { MatchCollection MatchArray = objDatePattern4.Matches(strDate); Match FirstMatch = MatchArray[0]; string _month = FirstMatch.Groups["Month"].Value; string _month2 = FirstMatch.Groups["Month2"].Value; string _year = FirstMatch.Groups["Year"].Value; strFormatted = getMonthFull(_month.TrimStart('0')) + "/" + getMonthFull(_month2.TrimStart('0')) + " " + getYearFull(_year); } //Matches 2001 => 2001 string re_yyyy = "^(?<Year>\\d{4})$"; Regex objDatePattern5 = new Regex(re_yyyy, RegexOptions.None); if (objDatePattern5.IsMatch(strDate)) { MatchCollection MatchArray = objDatePattern5.Matches(strDate); Match FirstMatch = MatchArray[0]; string _year = FirstMatch.Groups["Year"].Value; strFormatted = _year; } //Matches 6.28-7.4.02 => 28 June-4 July 2002 string re_m_d_m_d_y = "^(?<Month>\\d{1,2})([.])(?<Day>\\d{1,2})([-])(?<Month2>\\d{1,2})([.])(?<Day2>\\d{1,2})([.])(?<Year>\\d{1,2})$"; Regex objDatePattern6 = new Regex(re_m_d_m_d_y, RegexOptions.None); if (objDatePattern6.IsMatch(strDate)) { MatchCollection MatchArray = objDatePattern6.Matches(strDate); Match FirstMatch = MatchArray[0]; string _month = FirstMatch.Groups["Month"].Value; string _month2 = FirstMatch.Groups["Month2"].Value; string _day = FirstMatch.Groups["Day"].Value; string _day2 = FirstMatch.Groups["Day2"].Value; string _year = FirstMatch.Groups["Year"].Value; strFormatted = _day.TrimStart('0') + " " + getMonthFull(_month.TrimStart('0')) + "-" + _day2 + " " + getMonthFull(_day2.TrimStart('0')) + " " + getYearFull(_year); } //Matches 12.01/1.02 => December 2001/January 2002 string re_mm_yy_mm_yy = "^(?<Month>\\d{1,2})([.])(?<Year>\\d{1,2})([/])(?<Month2>\\d{1,2})([.])(?<Year2>\\d{1,2})$"; Regex objDatePattern7 = new Regex(re_mm_yy_mm_yy, RegexOptions.None); if (objDatePattern7.IsMatch(strDate)) { MatchCollection MatchArray = objDatePattern7.Matches(strDate); Match FirstMatch = MatchArray[0]; string _month = FirstMatch.Groups["Month"].Value; string _month2 = FirstMatch.Groups["Month2"].Value; string _year = FirstMatch.Groups["Year"].Value; string _year2 = FirstMatch.Groups["Year2"].Value; strFormatted = getMonthFull(_month.TrimStart('0')) + " " + getYearFull(_year) + "/" + getMonthFull(_month2.TrimStart('0')) + " " + getYearFull(_year); } //Matches WINTER/SPRING 2002 => Winter/Spring 2002 string re_season_season_year = "^(?<Season1>SPRING|SUMMER|FALL|WINTER)([/])(?<Season2>SPRING|SUMMER|FALL|WINTER)([\\s])(?<Year>\\d{4})$"; Regex objDatePattern8 = new Regex(re_season_season_year, RegexOptions.None); if (objDatePattern8.IsMatch(strDate)) { MatchCollection MatchArray = objDatePattern8.Matches(strDate); Match FirstMatch = MatchArray[0]; string _season = myTI.ToLower(FirstMatch.Groups["Season1"].Value); string _season2 = myTI.ToLower(FirstMatch.Groups["Season2"].Value); string _year = FirstMatch.Groups["Year"].Value; strFormatted = myTI.ToTitleCase(_season) + "/" + myTI.ToTitleCase(_season2) + " " + _year; } //Matches WINTER 01-02 => Winter 2001-2002 string re_season_year_year = "^(?<Season>SPRING|SUMMER|FALL|WINTER)([\\s])(?<Year>\\d{1,2})([-])(?<Year2>\\d{1,2})$"; Regex objDatePattern9 = new Regex(re_season_year_year, RegexOptions.None); if (objDatePattern9.IsMatch(strDate)) { MatchCollection MatchArray = objDatePattern9.Matches(strDate); Match FirstMatch = MatchArray[0]; string _season = myTI.ToLower(FirstMatch.Groups["Season"].Value); string _year = FirstMatch.Groups["Year"].Value; string _year2 = FirstMatch.Groups["Year2"].Value; strFormatted = myTI.ToTitleCase(_season) + " " + getYearFull(_year) + "-" + getYearFull(_year2); } return strFormatted; }