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();
}