protected void ChangeUserBlockedStatus(object sender, EventArgs e) { dbHandler dbh = new dbHandler(); dbh.changeIsBlocked(((Button)sender).Attributes["userName"], (((Button)sender).Text.Equals("Block")) ? 1 : 0); Response.Redirect(@"/ManageUsers.aspx"); }
private void addFileToServer(Hashtable prms) { if (fu_addnewset.PostedFile != null && fu_addnewset.PostedFile.FileName != "") { string fullDestPath = Server.MapPath("~/" + GlobalConsts.setsFolder + fu_addnewset.PostedFile.FileName); string relativeDestPath = GlobalConsts.setsFolder + fu_addnewset.PostedFile.FileName; fu_addnewset.PostedFile.SaveAs(fullDestPath); float speedPerformance = 50; int memoryPerformance = 60; float percentageOfCovered = 22; int sizeOfWord = 3; int amountOfMatch = 5; bool readSuccess = GlobalFunctions.readSetFile(fullDestPath, out sizeOfWord, out amountOfMatch, out speedPerformance, out memoryPerformance, out percentageOfCovered); if (readSuccess) { dbHandler dbh = new dbHandler(); dbh.insertNewSet(sizeOfWord, amountOfMatch, speedPerformance, memoryPerformance, percentageOfCovered, relativeDestPath); prms.Add("speedPerformance", speedPerformance);//speedPerformance,memoryPerformance,percentageOfCovered prms.Add("memoryPerformance", memoryPerformance); prms.Add("percentageOfCovered", percentageOfCovered); prms.Add("sizeOfWord", sizeOfWord); prms.Add("amountOfMatch", amountOfMatch); prms.Add("filepath", relativeDestPath); } else { File.Delete(fullDestPath); } } }
protected void Send_Click(object sender, EventArgs e) // // בדיקה עם המסד נתונים שהסיסמה והיוזר של המשתמש מתאימים { dbHandler dbh = new dbHandler(); string checklogininfo = dbh.checkLogin(UserName.Text, Password.Text); if (checklogininfo.ToLower() == "ok") { handleSession(); if (Session["userInformation"] != null) { clsUser currUser = (clsUser)Session["userInformation"]; if (currUser.IsBlocked) { Response.Write("<script>alert('user is blocked');</script>"); return; } if (currUser.IsManager) { Response.Redirect(@"welcome2!.aspx"); } else { Response.Redirect(@"welcome!.aspx"); } } } else { Response.Write("<script>alert('" + checklogininfo + "');</script>"); } }
protected void deleteUserClick(object sender, EventArgs e) { dbHandler dbh = new dbHandler(); dbh.deleteUser(((Button)sender).Attributes["userName"]); Response.Redirect(@"/ManageUsers.aspx"); }
void fillData() { List <List <string> > topicsList = new List <List <string> >(); List <List <string> > msgsList = new List <List <string> >(); dbHandler dbh = new dbHandler(); clsUser currUser = (clsUser)Session["userInformation"]; if (currUser.UserName == "admin") { currUser.IsManager = true; } if (Request.QueryString["tid"] != null && !Request.QueryString["tid"].Equals("") && !Request.QueryString["tid"].Equals(" ")) { msgsList = dbh.getAllMsgs(Request.QueryString["tid"]); if (msgsList != null) { showMsgsToTable(msgsList, currUser.IsManager); } } else { topicsList = dbh.getAllTopics(); if (topicsList != null) { showTopicsToTable(topicsList, currUser.IsManager); } } }
protected void Get_Click(object sender, EventArgs e) // // בדיקה עם המסד נתונים שהסיסמה והיוזר של המשתמש מתאימים { dbHandler dal = new dbHandler(); Hashtable prms = new Hashtable(); prms.Add("UsernameOrEmail", UserName.Text); DataSet ds = dal.GetData("usp_getUserEmail", prms); if (ds != null && ds.Tables != null && ds.Tables[0].Rows.Count > 0) { //UserName or Email recognized if (clsMail.SendMail(ds.Tables[0].Rows[0]["Email"].ToString(), "Password Reminder", "")) { Response.Write("<script>alert('Your Password will be send to you in a couple of minutes');</script>"); Response.Redirect(@"/Login.aspx"); } else { Response.Write("<script>alert('Sending your password to your email failed. Please Make sure you have SMTP server on you server and try again');</script>"); } } else { Response.Write("<script>alert('The value you have inserted is not an Email not UserName in our dB');</script>"); } //Response.Redirect(@"/ResetPassword.aspx"); }
public static void PUTBook(Book book) { Console.WriteLine("Book added: " + book.Title); dbHandler db = new dbHandler(); db.insertBook(book); bookList.Add(book); return; }
private void makedatatable(bool useSession, Hashtable whereParams) { DataTable tbl = null; dbHandler dbh = new dbHandler(); tbl = dbh.getSets(whereParams, sort.SelectedValue); if (tbl != null) { Session["allSets"] = tbl; } dbh = null; GC.Collect(); StringBuilder sb_html = new StringBuilder(); sb_html.Append("<table class='table table - hover'>"); //Build the column names according to the data came from dB sb_html.Append("<thead><tr>"); foreach (DataColumn col in tbl.Columns) { sb_html.Append("<th>" + col.ColumnName + "</th>"); } sb_html.Append("<th>Search</th>"); sb_html.Append("</tr></thead>"); if (tbl != null) { //data has been found --> show table to client //Build the rows data according to the data came from dB sb_html.Append("<tbody>"); foreach (DataRow row in tbl.Rows) { sb_html.Append("<tr>"); foreach (DataColumn col in tbl.Columns) { if (col.ColumnName != "ViewFile") { sb_html.Append("<td>" + row[col.ColumnName].ToString() + "</td>"); } else { string str = "onclick=\"viewFileData('" + row[col.ColumnName].ToString().Replace(@"\", "\\\\") + "');\""; sb_html.Append("<td><button type='button' class='btn btn-info btn-lg' data-toggle='modal' " + str + " data -target='#myModal'>View</button></td>"); } } sb_html.Append("<td><a href='SearchSpecificWord.aspx?sizeOfWord=" + row["Size_Word"].ToString() + "&filepath=" + row["ViewFile"].ToString() + "' class='btn btn-info btn-lg'>Perform Search</a></td>"); sb_html.Append("</tr>"); } sb_html.Append("</tbody>"); } sb_html.Append("</table>"); tableContainer.Text = sb_html.ToString(); }
private void handleSession() { clsUser currUser = (clsUser)Session["userInformation"]; dbHandler dbh = new dbHandler(); dbh.changeIsStatus(currUser.UserName, 1); if (UserName.Text == "admin") { currUser.IsManager = true; } }
protected void onClickLogOut(object sender, EventArgs e) { clsUser currUser = (clsUser)Session["userInformation"]; if (currUser != null) { dbHandler dbh = new dbHandler(); dbh.changeIsStatus(currUser.UserName, Convert.ToByte(currUser.IsStatus)); Session.Remove("userInformation"); Session.Abandon(); Response.Redirect(@"/Login.aspx"); } }
protected void deleteTopicClick(object sender, EventArgs e) { Button btnDelete = (Button)sender; if (btnDelete != null && btnDelete.Attributes != null && btnDelete.Attributes["ID"] != null) { string msgID = btnDelete.Attributes["ID"].ToString(); dbHandler dbh = new dbHandler(); if (dbh.deleteForumTopic(Convert.ToInt32(msgID))) { //Succesfully Deleted //refresh data so the deleted row wont be shown anymore fillData(); } } }
/// <summary> /// This function change approval status the specific MESSAGE that been clicked in the table. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void changeMsgApprovalClick(object sender, EventArgs e) { Button btn = (Button)sender; if (btn != null && btn.Attributes != null && btn.Attributes["msgID"] != null) { bool isApproved = true; if (btn.Text == "Disapprove") { isApproved = false; } string msgID = btn.Attributes["msgID"].ToString(); dbHandler dbh = new dbHandler(); if (dbh.SetForumMessageApproveDisapprove(Convert.ToInt32(msgID), isApproved)) { //Succesfully change approve/disapproved in db --> change button text btn.Text = (isApproved ? "Disapprove" : "Approve"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["userInformation"] != null) { clsUser currUser = (clsUser)Session["userInformation"]; if (!currUser.IsManager) { Response.Redirect(@"welcome!.aspx"); } else { //current user is manager List <List <string> > usersList = new List <List <string> >(); dbHandler dbh = new dbHandler(); usersList = dbh.getAllUsers(); if (usersList != null) { showUsersToTable(usersList); } } } }
protected void Send_Click(object sender, EventArgs e) // User click on send button { if (MCS.Text == "") { Response.Write("<script>alert('MCS is mandatory. Please fill it and click Send again');</script>"); return; } if (AmmountOfMatch.Text == "") { Response.Write("<script>alert('AmmountOfMatch is mandatory. Please fill it and click Send again');</script>"); return; } if (WordSize.Text == "") { Response.Write("<script>alert('WordSize is mandatory. Please fill it and click Send again');</script>"); return; } int z = Convert.ToInt32(MCS.Text); int x = Convert.ToInt32(AmmountOfMatch.Text); int y = Convert.ToInt32(WordSize.Text); double w = (double)x / y; if (w < 0.6) { Response.Write("<script>alert('(AmmountOfMatch/WordSize) *100 < 60, Please fill it and click Send again');</script>"); return; } if (z > x) { Response.Write("<script>alert('MCS > AmmountOfMatch, Please fill it and click Send again');</script>"); return; } string algorithmPath = Server.MapPath("/BasicAlgorithm/Release/main.exe"); string relativePath = "/SetFiles/forms_" + DateTime.Now.ToString("yyyyMMddHHmmssffff"); string pathToSave = Server.MapPath(relativePath); /// if (MCS.Text == " ") /// { // (MCS.Text = "4"; /// } //string pathToSave = Server.MapPath("/SetFiles/forms_" + DateTime.Now.ToString("yyyyMMddHHmmssffff")); string str = string.Concat(WordSize.Text, " ", AmmountOfMatch.Text, " ", MCS.Text, " ", pathToSave); // string str = "20 12 5 path"; Process.Start(algorithmPath, str);//////לקחת את הקובץ הפעלה של זכריה ולא של לבנת!!!! //Console.ReadKey(); //להמתין עד ליצירת הקובץ. בודקים כל 8 שניות while (!File.Exists(pathToSave)) { System.Threading.Thread.Sleep(8000); } float speedPerformance = 50; int memoryPerformance = 60; float percentageOfCovered = 22; int sizeOfWord = 3; int amountOfMatch = 5; bool readSuccess = GlobalFunctions.readSetFile(pathToSave, out sizeOfWord, out amountOfMatch, out speedPerformance, out memoryPerformance, out percentageOfCovered); if (readSuccess) { dbHandler dbh = new dbHandler(); dbh.insertNewSet(sizeOfWord, amountOfMatch, speedPerformance, memoryPerformance, percentageOfCovered, relativePath); Response.Redirect(@"/PerformanceSetOfFilters.aspx?amountOfMatch=" + amountOfMatch + "&speedPerformance=" + speedPerformance + "&memoryPerformance=" + memoryPerformance + "&percentageOfCovered=" + percentageOfCovered + "&sizeOfWord=" + sizeOfWord + "&filepath=" + relativePath); // עדיין אין מסך כזה - ליצור את המסך הזה } else { File.Delete(pathToSave); } }
private void makedatatable(int WordSize, int NumOfMatches) { DataTable tbl = null; //Table data will be taken from Database dbHandler dbh = new dbHandler(); Hashtable prms = new Hashtable(); prms.Add("WordSize", WordSize); prms.Add("NumOfMatches", NumOfMatches); DataSet ds = dbh.GetData("usp_GetAllSets", prms); if (ds != null && ds.Tables != null) { tbl = ds.Tables[0]; } //dbh = null; GC.Collect(); StringBuilder sb_html = new StringBuilder(); sb_html.Append("<table class='table table - hover'>"); //Build the column names according to the data came from dB sb_html.Append("<thead><tr>"); foreach (DataColumn col in tbl.Columns) { sb_html.Append("<th>" + col.ColumnName + "</th>"); } sb_html.Append("<th>Operation</th>"); sb_html.Append("</tr></thead>"); if (tbl != null) { //data has been found --> show table to client //Build the rows data according to the data came from dB sb_html.Append("<tbody>"); foreach (DataRow row in tbl.Rows) { sb_html.Append("<tr>"); foreach (DataColumn col in tbl.Columns) { if (col.ColumnName != "ViewFile") { sb_html.Append("<td>" + row[col.ColumnName].ToString() + "</td>"); } else { string str = "onclick=\"viewFileData('" + row[col.ColumnName].ToString().Replace(@"\", "\\\\") + "');\""; sb_html.Append("<td><button type='button' class='btn btn - info btn - lg' data-toggle='modal' " + str + " data -target='#myModal'>View</button></td>"); } } string deleteClick = "onclick=\"deleteSet(" + row["Set_Id"].ToString() + ");\""; sb_html.Append("<td><button type='button' class='btn btn - info btn - lg'" + deleteClick + "'>Delete Set</button></td>"); sb_html.Append("</tr>"); } sb_html.Append("</tbody>"); } sb_html.Append("</table>"); tableContainer.Text = sb_html.ToString(); }
protected void Send_Click(object sender, EventArgs e) // User click on send button { // TODO: VALIDATE LENGTHS OF FIELDS AND EMAIL VALIDATION (IS EXISTS) dbHandler dbh = new dbHandler(); if (!UserName.Text.Equals("") && !Password.Text.Equals("") && !ConfirmPassword.Text.Equals("") && !LastName.Text.Equals("") && !FirstName.Text.Equals("") && !Email.Text.Equals("")) { bool isLenghtOK = true; if (UserName.Text.Length > 50) { isLenghtOK = false; UserName.BackColor = Color.Red; UserName.ForeColor = Color.White; Response.Write("<script>alert('שם המשתמש שכתבת ארוך מדי. נא לכתוב מקסימום 50 תווים');</script>"); } else { UserName.BackColor = Color.White; UserName.ForeColor = Color.Black; } if (Password.Text.Length > 10) { isLenghtOK = false; Password.BackColor = Color.Red; Password.ForeColor = Color.White; Response.Write("<script>alert('הסיסמא שכתבת ארוכה מדי. נא לכתוב מקסימום 10 תווים');</script>"); } else { Password.BackColor = Color.White; Password.ForeColor = Color.Black; } if (Password.Text != ConfirmPassword.Text) { isLenghtOK = false; Password.BackColor = Color.Red; Password.ForeColor = Color.White; Response.Write("<script>alert('Password is different than confirm password');</script>"); } else { Password.BackColor = Color.White; Password.ForeColor = Color.Black; } if (isLenghtOK) { string checkUserInDBResult = dbh.isUserExists(UserName.Text, Email.Text); if (checkUserInDBResult != "") { Response.Write("<script>alert('" + checkUserInDBResult + "');</script>"); } else { //user does not exist-->can be saved if (dbh.insertNewUser(UserName.Text, FirstName.Text, LastName.Text, Password.Text, Email.Text)) { Response.Write("<script>alert('הרשמתך הסיימה בהצלחה');window.open('StudentPage.html','_self');</script>"); clsUser currUser = new clsUser(); currUser.Email = Email.Text; currUser.FirstName = FirstName.Text; currUser.IsBlocked = false; currUser.IsManager = false; currUser.IsStatus = 0; currUser.LastName = LastName.Text; currUser.UserName = UserName.Text; Session["userInformation"] = currUser; } else { Response.Write("<script>alert('עכב תקלת מערכת, הרשמתך נכשלה. לנסות שוב');</script>"); } } } } else { Response.Write("<script>alert('Some fields are empty');</script>"); } }
protected void Send_Click(object sender, EventArgs e) // User click on send button { // TODO: VALIDATE LENGTHS OF FIELDS AND EMAIL VALIDATION (IS EXISTS) dbHandler dbh = new dbHandler(); if (!UserName.Text.Equals("") && !Password.Text.Equals("") && !ConfirmPassword.Text.Equals("") && !LastName.Text.Equals("") && !FirstName.Text.Equals("") && !Email.Text.Equals("")) { bool isLenghtOK = true; if (UserName.Text.Length > 50) { isLenghtOK = false; UserName.BackColor = Color.Red; UserName.ForeColor = Color.White; Response.Write("<script>alert('User name is limited to 50 characters');</script>"); } else { UserName.BackColor = Color.White; UserName.ForeColor = Color.Black; } if (Password.Text.Length > 10) { isLenghtOK = false; Password.BackColor = Color.Red; Password.ForeColor = Color.White; Response.Write("<script>alert('Password is limited to 10 characters');</script>"); } else { Password.BackColor = Color.White; Password.ForeColor = Color.Black; } if (Password.Text != ConfirmPassword.Text) { isLenghtOK = false; Password.BackColor = Color.Red; Password.ForeColor = Color.White; Response.Write("<script>alert('Password has to be identical');</script>"); } else { Password.BackColor = Color.White; Password.ForeColor = Color.Black; } if (isLenghtOK) { string checkUserInDBResult = dbh.isUserExists(UserName.Text, Email.Text); if (checkUserInDBResult != "") { Response.Write("<script>alert('" + checkUserInDBResult + "');</script>"); } else { //user does not exist-->can be saved if (dbh.insertNewUser(UserName.Text, FirstName.Text, LastName.Text, Password.Text, Email.Text)) { Response.Write("<script>alert('Register Successful');window.open('WELCOME!.aspx','_self');</script>"); clsUser currUser = new clsUser(); currUser.Email = Email.Text; currUser.FirstName = FirstName.Text; currUser.IsBlocked = false; currUser.IsManager = false; currUser.IsStatus = 0; currUser.LastName = LastName.Text; currUser.UserName = UserName.Text; Session["userInformation"] = currUser; } else { Response.Write("<script>alert('Register Fails');</script>"); } } } } else { Response.Write("<script>alert('Some fields are empty');</script>"); } }