protected void gvUsers_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Admin")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = gvUsers.Rows[index];
int UserId = Convert.ToInt32(gvUsers.DataKeys[index].Value);
GymModelContainer db = new GymModelContainer();
User user = db.Users.First(u => u.UserId == UserId);
user.Admin = "Yes";
db.SaveChanges();
}
else if (e.CommandName == "Undo")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = gvUsers.Rows[index];
int UserId = Convert.ToInt32(gvUsers.DataKeys[index].Value);
GymModelContainer db = new GymModelContainer();
User user = db.Users.First(u => u.UserId == UserId);
user.Admin = "No";
db.SaveChanges();
}
BindGrid();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
GymModelContainer db = new GymModelContainer();
int UserId = Convert.ToInt32(txtUserId.Text);
User user = db.Users.First(u => u.UserId == UserId);
user.Name = txtName.Text;
user.Email = txtEmail.Text;
user.Password = txtPassword.Text;
user.Address = txtAddress.Text;
user.City = txtCity.Text;
user.PostalCode = txtPostalCode.Text;
user.Province = ddlProvince.SelectedValue;
if (rdAdmin.Checked == true)
{
user.Admin = "Admin";
}
else if (rdUser.Checked == true)
{
user.Admin = "User";
}
else if (rdInstructor.Checked == true)
{
user.Admin = "Instructor";
}
else
{
user.Admin = "N/A";
}
db.SaveChanges();
BindGrid();
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (var db = new GymModelContainer())
{
var u = new User();
u.Name = txtName.Text;
u.Email = txtEmail.Text;
u.Password = txtPassword.Text;
u.Address = txtAddress.Text;
u.City = txtCity.Text;
u.PostalCode = txtPostalCode.Text;
u.Province = Convert.ToString(ddlProvince.SelectedValue);
if (rdAdmin.Checked == true)
{
u.Admin = "Admin";
}
else if (rdUser.Checked == true)
{
u.Admin = "User";
}
else if (rdInstructor.Checked == true)
{
u.Admin = "Instructor";
}
else
{
u.Admin = "N/A";
}
db.Users.Add(u);
db.SaveChanges();
}
}
protected void gvClasses_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
using (GymModelContainer db = new GymModelContainer())
{
int ClassId = Convert.ToInt32(gvClasses.DataKeys[e.RowIndex].Value);
Class cl = db.Classes.First(c => c.ClassId == ClassId);
db.Classes.Remove(cl);
db.SaveChanges();
BindGrid();
}
}
protected void gvUsers_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
using (GymModelContainer db = new GymModelContainer())
{
int UserId = Convert.ToInt32(gvUsers.DataKeys[e.RowIndex].Value);
User user = db.Users.First(u => u.UserId == UserId);
db.Users.Remove(user);
db.SaveChanges();
BindGrid();
}
}
protected void gvTimetables_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
using (GymModelContainer db = new GymModelContainer())
{
int TimetableId = Convert.ToInt32(gvTimetables.DataKeys[e.RowIndex].Value);
Timetable time = db.Timetables.First(u => u.TimetableId == TimetableId);
db.Timetables.Remove(time);
db.SaveChanges();
BindGrid();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (GymModelContainer db = new GymModelContainer())
{
var cl = new Class();
cl.ClassName = txtClassName.Text;
cl.Professor = ddlInstructor.SelectedValue;
cl.WeekDay = ddlWeekDay.SelectedValue;
cl.Starts = txtClassStarts.Text;
cl.Finish = txtClassFinish.Text;
db.Classes.Add(cl);
db.SaveChanges();
}
}
protected void btnPost_Click(object sender, EventArgs e)
{
using (GymModelContainer db = new GymModelContainer())
{
var m = new Message();
m.Title = txtTitle.Text;
m.DescMessage = txtMessage.Text;
m.From = Session["Email"].ToString();
m.Posted = Convert.ToString(DateTime.Now);
db.Messages.Add(m);
db.SaveChanges();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
GymModelContainer db = new GymModelContainer();
int ClassId = Convert.ToInt32(txtClassId.Text);
Class cl = db.Classes.First(c => c.ClassId == ClassId);
cl.ClassName = txtClassName.Text;
cl.Professor = txtProfessor.Text;
cl.WeekDay = ddlWeekDay.Text;
cl.Starts = txtClassStarts.Text;
cl.Finish = txtClassFinish.Text;
db.SaveChanges();
BindGrid();
}
protected void gvTimetable_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Add")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = gvTimetable.Rows[index];
int ClassId = Convert.ToInt32(gvTimetable.DataKeys[index].Value);
GymModelContainer db = new GymModelContainer();
var tm = new Timetable();
tm.ClassId = ClassId;
tm.UserId = Convert.ToInt32(Session["UserId"]);
db.Timetables.Add(tm);
db.SaveChanges();
BindGrid();
}
}