public void BindSearch()
{
using (GymModelContainer db = new GymModelContainer())
{
if (db.Users.Count() > 0)
{
gvUsers.DataSource = (from u in db.Users
where u.Name.Contains(txtSearch.Text) || u.Email.Contains(txtSearch.Text) ||
u.Address.Contains(txtSearch.Text) || u.City.Contains(txtSearch.Text)
select new
{ u.UserId,
u.Name,
u.Email,
u.Password,
u.Address,
u.City,
u.Province,
u.PostalCode,
u.Admin }).ToList();
gvUsers.DataBind();
}
else
{
gvUsers.DataSource = null;
gvUsers.DataBind();
}
}
}
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 gvUsers_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
using (GymModelContainer db = new GymModelContainer())
{
int UserId = Convert.ToInt32(gvUsers.DataKeys[e.RowIndex].Value);
User us = db.Users.First(u => u.UserId == UserId);
txtUserId.Text = Convert.ToString(us.UserId);
txtName.Text = us.Name;
txtEmail.Text = us.Email;
txtPassword.Text = us.Password;
txtAddress.Text = us.Address;
txtCity.Text = us.City;
ddlProvince.Text = us.Province;
txtPostalCode.Text = us.PostalCode;
if (us.Admin == "Admin")
{
rdAdmin.Checked = true;
}
else if (us.Admin == "User")
{
rdUser.Checked = true;
}
else if (us.Admin == "Instructor")
{
rdInstructor.Checked = true;
}
}
}
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 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 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 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 gvList_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Present")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = gvList.Rows[index];
int IdCompany = Convert.ToInt32(gvList.DataKeys[index].Value);
GymModelContainer db = new GymModelContainer();
User user = new User();
// user.
}
}
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 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 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 gvClasses_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
using (GymModelContainer db = new GymModelContainer())
{
int ClassId = Convert.ToInt32(gvClasses.DataKeys[e.RowIndex].Value);
Class cl = db.Classes.First(c => c.ClassId == ClassId);
txtClassId.Text = Convert.ToString(cl.ClassId);
txtClassName.Text = cl.ClassName;
txtProfessor.Text = cl.Professor;
ddlWeekDay.Text = cl.WeekDay;
txtClassStarts.Text = cl.Starts;
txtClassFinish.Text = cl.Finish;
}
}
public void BindGrid()
{
using (GymModelContainer db = new GymModelContainer())
{
if (db.Classes.Count() > 0)
{
gvClasses.DataSource = (from c in db.Classes
select new { c.ClassId, c.ClassName, c.Professor, c.WeekDay, c.Starts, c.Finish }).ToList();
gvClasses.DataBind();
}
else
{
gvClasses.DataSource = null;
gvClasses.DataBind();
}
}
}
public void BindGrid()
{
using (GymModelContainer db = new GymModelContainer())
{
if (db.Messages.Count() > 0)
{
gvMessages.DataSource = (from m in db.Messages
select new { m.MessageId, m.Title, m.DescMessage, m.From, m.Posted }).ToList();
gvMessages.DataBind();
}
else
{
gvMessages.DataSource = null;
gvMessages.DataBind();
}
}
}
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();
}
}
public void LoadInstructor()
{
using (GymModelContainer db = new GymModelContainer())
{
if (db.Users.Count() > 0)
{
ddlInstructor.DataSource = (from u in db.Users
where u.Admin == "Instructor"
select u.Name).ToList();
ddlInstructor.DataBind();
}
else
{
ddlInstructor.DataSource = null;
ddlInstructor.DataBind();
}
}
}
public void BindGrid()
{
using (GymModelContainer db = new GymModelContainer())
{
if (db.Classes.Count() > 0)
{
gvList.DataSource = (from t1 in db.Timetables
join t2 in db.Classes on t1.ClassId equals t2.ClassId
join t3 in db.Users on t1.UserId equals t3.UserId
select new { t3.Name, t2.ClassName, t2.Professor }).ToList();
gvList.DataBind();
}
else
{
gvList.DataSource = null;
gvList.DataBind();
}
}
}
public void BindGrid()
{
using (GymModelContainer db = new GymModelContainer())
{
int UserId = Convert.ToInt32(Session["UserId"]);
if (db.Classes.Count() > 0)
{
gvTimetables.DataSource = (from t1 in db.Timetables
where t1.UserId == UserId
join t2 in db.Classes on t1.ClassId equals t2.ClassId
join t3 in db.Users on t1.UserId equals t3.UserId
select new { t3.Name, t2.ClassName, t2.Professor, t2.WeekDay, t2.Starts, t2.Finish, t1.TimetableId }).ToList();
gvTimetables.DataBind();
}
else
{
gvTimetables.DataSource = null;
gvTimetables.DataBind();
}
}
}
protected void btnSignIn_Click(object sender, EventArgs e)
{
using (GymModelContainer db = new GymModelContainer())
{
var checkEmail = (from ce in db.Users
where ce.Email == txtEmail.Text
select ce.Email).SingleOrDefault();
var checkPassword = (from cp in db.Users
where cp.Email == txtEmail.Text
select cp.Password).SingleOrDefault();
var verifyAdmin = (from v in db.Users
where v.Email == txtEmail.Text
select v.Admin).SingleOrDefault();
var verifyId = (from v in db.Users
where v.Email == txtEmail.Text
select v.UserId).SingleOrDefault();
if (checkEmail != txtEmail.Text)
{
lblMsg.Visible = true;
}
else if (checkPassword != txtPassword.Text)
{
lblMsg.Visible = true;
}
else
{
Session["Email"] = txtEmail.Text;
Session["Admin"] = verifyAdmin;
Session["UserId"] = verifyId;
Response.Redirect("ViewMessages.aspx");
}
}
}