protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { rowIndex = Convert.ToInt32(e.CommandArgument); if (e.CommandName == "DeleteUser") { RoleEditPnl.Visible = false; changePassword.Visible = false; //delete user from membership Membership.DeleteUser(GridView1.DataKeys[rowIndex].Values[1].ToString()); //delete user data from database var db = new CloudAppDbEntities(); var _User = db.User.Find(GridView1.DataKeys[rowIndex].Values[1].ToString()); db.User.Remove(_User); db.SaveChanges(); //update gridview1 GridView1.DataSource = GetAllUsers(); GridView1.DataBind(); } if (e.CommandName == "EditRole") { RoleEditPnl.Visible = true; changePassword.Visible = false; } if (e.CommandName == "EditPassword") { RoleEditPnl.Visible = false; changePassword.Visible = true; } }
protected void Button3_Click(object sender, EventArgs e) { var db = new CloudAppDbEntities(); var _EditedUser = db.User.Find(GridView1.DataKeys[rowIndex].Values[1].ToString()); int _type2 = 0; switch (RadioButtonList1.SelectedValue) { case "Admin": _type2 = 1; Roles.AddUserToRole(GridView1.DataKeys[rowIndex].Values[1].ToString(), "Admin"); break; case "Faculty Admin": _type2 = 2; Roles.AddUserToRole(GridView1.DataKeys[rowIndex].Values[1].ToString(), "Faculty Admin"); break; case "Teacher": _type2 = 3; Roles.AddUserToRole(GridView1.DataKeys[rowIndex].Values[1].ToString(), "Teacher"); break; case "Student": _type2 = 4; Roles.AddUserToRole(GridView1.DataKeys[rowIndex].Values[1].ToString(), "Student"); break; } //editing data in database _EditedUser.UserType = _type2; if (_type2 == 2) { int _facultyID = db.Faculty.First(f => f.FacultyName == DropDownList5.SelectedValue).FacultyID; _EditedUser.FacultyID = _facultyID; } else if (_type2 == 4) { int _classID = db.Class.First(c => c.ClassName == DropDownList4.SelectedValue).ClassID; _EditedUser.ClassID = _classID; } db.Entry(_EditedUser).State = EntityState.Modified; db.SaveChanges(); //.. // update GridView1 GridView1.DataSource = GetAllUsers(); GridView1.DataBind(); }
protected void RegisterUser_CreatedUser(object sender, EventArgs e) { RegisterUser.LoginCreatedUser = false; if (DropDownList1.SelectedValue == "Admin") { _type = 1; Roles.AddUserToRole(RegisterUser.UserName, "Admin"); } if (DropDownList1.SelectedValue == "Faculty Admin") { _type = 2; Roles.AddUserToRole(RegisterUser.UserName, "FacultyAdmin"); } if (DropDownList1.SelectedValue == "Teacher") { _type = 3; Roles.AddUserToRole(RegisterUser.UserName, "Teacher"); } if (DropDownList1.SelectedValue == "Student") { _type = 4; Roles.AddUserToRole(RegisterUser.UserName, "Student"); } // saving user data in database var db = new CloudAppDbEntities(); _UserEmail = RegisterUser.Email; _UserID = User.Identity.Name; _UserName = FirstName.Text + " " + MiddleName.Text + " " + LastName.Text; var _User = new User(); _User.UserID = _UserID; _User.UserName = _UserName; _User.UserType = _type; _User.UserEmail = _UserEmail; if (_type == 4) { _ClassID = db.Class.First(c => c.ClassName == DropDownList4.SelectedValue).ClassID; _User.ClassID = _ClassID; } else if (_type == 2) { _facultyID = db.Faculty.First(f => f.FacultyName == DropDownList5.SelectedValue).FacultyID; _User.FacultyID = _facultyID; } db.User.Add(_User); db.SaveChanges(); GridView1.DataSource = GetAllUsers(); GridView1.DataBind(); }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex = Convert.ToInt32(e.CommandArgument); var db = new CloudAppDbEntities(); var faculty = new Faculty(); faculty = db.Faculty.Find(GridView1.DataKeys[rowIndex].Values[1].ToString()); db.Faculty.Remove(faculty); db.SaveChanges(); GridView1.DataSource = GetFaculties(); GridView1.DataBind(); }
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex = Convert.ToInt32(e.CommandArgument); var db = new CloudAppDbEntities(); var department = new Department(); department = db.Department.Find(GridView2.DataKeys[rowIndex].Values[1].ToString()); db.Department.Remove(department); db.SaveChanges(); GridView2.DataSource = GetDepartments(); GridView2.DataBind(); }
protected void GridView4_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex = Convert.ToInt32(e.CommandArgument); var db = new CloudAppDbEntities(); var course = new Course(); course = db.Course.Find(GridView3.DataKeys[rowIndex].Values[1].ToString()); db.Course.Remove(course); db.SaveChanges(); int _ClassID = db.Class.First(c => c.ClassName == DropDownList3.SelectedValue).ClassID; GridView4.DataSource = GetCourses(_ClassID); GridView4.DataBind(); }
protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex = Convert.ToInt32(e.CommandArgument); var db = new CloudAppDbEntities(); var _class = new Class(); _class = db.Class.Find(GridView3.DataKeys[rowIndex].Values[1].ToString()); db.Class.Remove(_class); db.SaveChanges(); int _departmentID = db.Department.First(d => d.DepartmentName == DropDownList2.SelectedValue).DepartmentID; GridView3.DataSource = GetClasses(_departmentID); GridView3.DataBind(); }
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex = Convert.ToInt32(e.CommandArgument); var db = new CloudAppDbEntities(); var department = new Department(); department = db.Department.Find(GridView2.DataKeys[rowIndex].Values[1].ToString()); db.Department.Remove(department); db.SaveChanges(); var _facultyID = db.Faculty.First(f => f.FacultyName == DropDownList1.SelectedValue).FacultyID; GridView2.DataSource = GetDepartments(_facultyID); GridView2.DataBind(); }
protected void AddFacultyButton_Click(object sender, EventArgs e) { var db = new CloudAppDbEntities(); //add faculty code.. var _faculty = new Faculty() { FacultyName = TextBox1.Text, //FacultyID = int.Parse(TextBox2.Text) }; db.Faculty.Add(_faculty); db.SaveChanges(); //add faculty code end.. //update gridview1 GridView1.DataSource = GetFaculties(); GridView1.DataBind(); }
protected void AddDepartmentButton_Click(object sender, EventArgs e) { var db = new CloudAppDbEntities(); //add department code .. var _department = new Department() { DepartmentName = DepartmentName.Text, FacultyID = _facultyID }; db.Department.Add(_department); db.SaveChanges(); //add department code end .. // update gridview2 GridView2.DataSource = GetDepartments(); GridView2.DataBind(); }
protected void AddClassButton_Click(object sender, EventArgs e) { var db = new CloudAppDbEntities(); int _departmentID = db.Department.First(d => d.DepartmentName == DropDownList2.SelectedValue).DepartmentID; //add class code .. var _class = new Class() { ClassName = TextBox3.Text, DepartmentID = _departmentID }; db.Class.Add(_class); db.SaveChanges(); //add class code end .. //update gridview3 GridView3.DataSource = GetClasses(_departmentID); GridView3.DataBind(); }
protected void AddCourseButton_Click(object sender, EventArgs e) { var db = new CloudAppDbEntities(); int _ClassID = db.Class.First(c => c.ClassName == DropDownList3.SelectedValue).ClassID; //add course code .. var _course = new Course() { CourseName = TextBox5.Text, ClassID = _ClassID }; db.Course.Add(_course); db.SaveChanges(); //add course code .. //update gridview4 GridView4.DataSource = GetCourses(_ClassID); GridView4.DataBind(); }
protected void AddDepartmentButton_Click(object sender, EventArgs e) { // don't forget to modify autogeneration of departmentid properity in deprtment table, and also or other fields var db = new CloudAppDbEntities(); int _facultyID = db.Faculty.First(f => f.FacultyName == DropDownList1.SelectedValue).FacultyID; //add department code .. var _department = new Department() { //DepartmentID = int.Parse(DepartmentID.Text), DepartmentName = DepartmentName.Text, FacultyID = _facultyID }; db.Department.Add(_department); db.SaveChanges(); //add department code end .. // update gridview2 GridView2.DataSource = GetDepartments(_facultyID); GridView2.DataBind(); }
protected void RegisterUser_CreatedUser(object sender, EventArgs e) { FormsAuthentication.SetAuthCookie(RegisterUser.UserName, createPersistentCookie: false); // SetUserRole Function Roles.AddUserToRole(RegisterUser.UserName, "Student"); // saving user data in database var db = new CloudAppDbEntities(); _UserEmail = RegisterUser.Email; _UserID = RegisterUser.UserName; _UserName = FirstName.Text + " " + MiddleName.Text + " " + LastName.Text; _type = 4; _ClassID = db.Class.First(c => c.ClassName == DropDownList1.SelectedValue).ClassID; var _User = new User() { UserID = _UserID, UserName = _UserName, UserType = _type, ClassID = _ClassID }; db.User.Add(_User); db.SaveChanges(); string continueUrl = RegisterUser.ContinueDestinationPageUrl; if (!OpenAuth.IsLocalUrl(continueUrl)) { continueUrl = "~/Student/StudentHome.aspx"; } Response.Redirect(continueUrl); }
protected void btnUpload_Click(object sender, EventArgs e) { CurrentLocation = ConfigurationManager.AppSettings["RootPath"]; // The file Extension string fileExtension = string.Empty; // The choosed file name string fileName = string.Empty; // The new file name in the server string newFileName = string.Empty; // Check if choosed a file if (!fuChooseFile.HasFile) { lbMessage.Text = "Please choose the file you want to upload. " + "Note: The file size cannot be zero."; return; } fileExtension = Path.GetExtension(fuChooseFile.FileName); fileName = string.Format("{0}\\{1}", CurrentLocation, (string.IsNullOrEmpty(fileExtension) ? fuChooseFile.FileName : fuChooseFile.FileName.Replace(fileExtension, ""))); if (fileExtension.ToLower() == ".exe" || fileExtension.ToLower() == ".msi") { lbMessage.Text = "The file you want to upload cannot be a .exe or .msi file."; return; } newFileName = fileName; // Check file size //if (fuChooseFile.PostedFile.ContentLength >= 1024*1024*40) //{ // lbMessage.Text = // "The file you want to upload cannot be larger than 40 MB."; // return; //} try { // If there is already a file with the same name in the system,rename // and then upload the file . int i = 0; while (File.Exists(newFileName + fileExtension)) { i++; newFileName = string.Format(fileName + "({0})", i); } fuChooseFile.SaveAs(Utilities.FixRoot(newFileName + fileExtension)); lbMessage.Text = string.Format("The file \"{0}\" was uploaded successfully!", Path.GetFileName(fileName)); ShowFolderItems(); } catch (HttpException he) { lbMessage.Text = string.Format("File {0} upload failed because of the following error:{1}.", fuChooseFile.PostedFile.FileName, he.Message); } //the file id var _file2 = new FileInfo(newFileName); var db = new CloudAppDbEntities(); var _file = new UserFile() { FName = Path.GetFileName(newFileName), FileName = Path.GetFileName(fileName), UploaderID = currentUserID, // don't forget to find currentuserID //FileSize = CommonUse.FormatFileSize((long)fuChooseFile.PostedFile.ContentLength) , FileSize = CommonUse.FormatFileSize((long)fuChooseFile.PostedFile.ContentLength), FileType = fileExtension, UploadTime = _file2.CreationTime, CourseID = null, ClassID = classID }; db.UserFile.Add(_file); db.SaveChanges(); }