protected void Page_Load(object sender, EventArgs e)
{
DreamWarDataContext dw = new DreamWarDataContext();
if (!IsPostBack)
{
}
}
protected void Bind()
{
DreamWarDataContext dw = new DreamWarDataContext();
var results = from c in dw.User
select c;
gvUsers.DataSource = results;
gvUsers.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
DreamWarDataContext dw = new DreamWarDataContext();
User info = new User();
info.UserName = txtInput.Text;
info.Password = txtPassword.Text;
dw.User.InsertOnSubmit(info);
dw.SubmitChanges();
Response.Redirect("UserList.aspx");
}
protected void Delete_Click(object sender, EventArgs e)
{
DreamWarDataContext dw = new DreamWarDataContext();
var result = from c in dw.User
where c.UserName == txtInput.Text
select c;
dw.User.DeleteAllOnSubmit(result);
dw.SubmitChanges();
Bind();
}
protected void Unnamed_ServerClick(object sender, EventArgs e)
{
DreamWarDataContext dw = new DreamWarDataContext(ConfigurationManager.ConnectionStrings["DreamWarConnectionString"].ToString());
string username = this.UserName.Value.Trim();
string txtArea = this.textArea.Value.Trim();
table info = new table();
info.Username = username;
info.Message = txtArea;
dw.table.InsertOnSubmit(info);
dw.SubmitChanges();
}
protected void BtnSubmit_ServerClick(object sender, EventArgs e)
{
string newpass = this.txtChange.Value.Trim();
DreamWarDataContext dw = new DreamWarDataContext(ConfigurationManager.ConnectionStrings["DreamWarConnectionString"].ToString());
User info = new User();
var result1 = from u in dw.User
where u.UserName == Session["UserName"].ToString()
select u;
foreach (User s in result1)
{
s.Password = newpass;
}
dw.SubmitChanges();
Response.Redirect("~/Login.aspx");
}
protected void Unnamed_ServerClick(object sender, EventArgs e)
{
DreamWarDataContext dw = new DreamWarDataContext();
string name = this.txtName.Value.Trim();
string pwd = this.txtPassword.Value.Trim();
String infro = this.txtInfromation.Value.Trim();
string sex = Request.Form["sex"];
Writers info = new Writers();
info.WriterName = name;
info.Password = pwd;
info.Information = infro;
dw.Writers.InsertOnSubmit(info);
dw.SubmitChanges();
Response.Redirect("~/HomePage.aspx");
}
protected void btn_submit_ServerClick(object sender, EventArgs e)
{
DreamWarDataContext dw = new DreamWarDataContext(ConfigurationManager.ConnectionStrings["DreamWarConnectionString"].ToString());
string name = this.txtUserName.Value.Trim();
string pass = this.txtPassword.Value.Trim();
string conpass = this.txtConfirmation.Value.Trim();
if (pass == conpass)
{
Session["UserName"] = this.txtUserName.Value;
Session["UserPwd"] = this.txtPassword.Value;
User info = new User();
info.UserName = name;
info.Password = pass;
dw.User.InsertOnSubmit(info);
dw.SubmitChanges();
Response.Redirect("~/HomePage.aspx");
}
}
protected void submit_ServerClick(object sender, EventArgs e)
{
string name = this.txtUserName.Value.Trim();
string pwe = this.txtpPssword.Value.Trim();
DreamWarDataContext dw = new DreamWarDataContext();
var result = from v in dw.User
where v.UserName == name && v.Password == pwe
select v;
if (result.Count() > 0)
{
Session["UserName"] = this.txtUserName.Value;
Session["UserPwd"] = this.txtpPssword.Value;
Response.Redirect("~/HomePage.aspx");
}
else
{
Response.Write("<script> alter(Login Failture!); location='javascript:history.go(-1)'</script>");
}
}
