protected void SRegistrat(object sender, EventArgs e)
{
using (var db = new AssignmentManagerEntities5())
{
if (db.Users.Where(i => i.Email == sEmail.Text || i.Id == sId.Text).Any())
{
userExistsMessage.Visible = true;
}
else
{
/*User newUser = new User
* {
* Id = sId.Text,
* Name = sName.Text,
* Surname = sSurname.Text,
* Passward = sPassward1.Text,
* Email = sEmail.Text
*
* };
* db.Users.Add(newUser);
* db.SaveChangesAsync();*/
string dat = "INSERT INTO [User](Id,Passward,Email,Name,Surname) VALUES('" + sId.Text + "','" + sPassward1.Text + "','" + sEmail.Text + "','" + sName.Text + "','" + sSurname.Text + "')";
SqlCommand com = new SqlCommand(dat, con);
con.Open();
com.ExecuteNonQuery();
con.Close();
Response.Redirect("Login.aspx");
}
}
}
private void FillGrid()
{
using (var bd = new AssignmentManagerEntities5())
{
string dat = "SELECT(CurseName,AssignmentName,Grade,Date,Status) FROM[User] WHERE(Id='" + Session["id"].ToString() + "')";
SqlDataAdapter da;
SqlCommand com = new SqlCommand(dat, con);
DataTable dt = new DataTable();
con.Open();
com.ExecuteNonQuery();
da = new SqlDataAdapter(com);
da.Fill(dt);
con.Close();
Assignmants.DataSource = dt;
Assignmants.DataBind();
}
}
protected void Login_click_student(object sender, EventArgs e)
{
using (var db = new AssignmentManagerEntities5())
{
var user = db.Users.Where(i => i.Email == sEmail.Text && i.Passward == sPassward.Text).FirstOrDefault();
if (user == null)
{
sEmail.Text = "f";
}
else
{
Session["email"] = user.Email;
Session["id"] = user.Id;
Session["name"] = user.Name;
Session["surname"] = user.Surname;
Response.Redirect("studantScreen.aspx");
}
}
}
