protected void grdComics_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//identify
Int32 ComicID = Convert.ToInt32(grdComics.DataKeys[e.RowIndex].Values["ComicID"]);
//connect
using (DefaultConnection db = new DefaultConnection())
{
Comics track = (from c in db.Comics1
where c.ComicID == ComicID
select c).FirstOrDefault();
//delete
db.Comics1.Remove(track);
db.SaveChanges();
//refresh grid
GetComics();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//connect
using (DefaultConnection db = new DefaultConnection())
{
Comics trac = new Comics();
Int32 ComicID = 0;
//check for url
if (!String.IsNullOrEmpty(Request.QueryString["ComicID"]))
{
//get id from url
ComicID = Convert.ToInt32(Request.QueryString["ComicID"]);
trac = (from c in db.Comics1
where c.ComicID == ComicID
select c).FirstOrDefault();
}
//fill properties
trac.Title = txtTitle.Text;
trac.Author = txtAuthor.Text;
trac.Publisher = txtPublisher.Text;
trac.Issue = Convert.ToInt32(txtIssue.Text);
//no id in the url
if (ComicID == 0)
{
db.Comics1.Add(trac);
}
//save
db.SaveChanges();
//redirect
Response.Redirect("tracker.aspx");
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
//connect to db
using (DefaultConnection db = new DefaultConnection())
{
//create new user
Users objU = new Users();
//fill the form inputs
objU.Firstname = txtFirstname.Text;
objU.Lastname = txtLastname.Text;
objU.Username = txtUsername.Text;
//salt and hash text password
String password = txtPassword.Text;
String salt = CreateSalt(8);
String pass_and_salt = password + salt;
// Create a new instance of the hash crypto service provider.
HashAlgorithm hashAlg = new SHA256CryptoServiceProvider();
// Convert the data to hash to an array of Bytes.
byte[] bytValue = System.Text.Encoding.UTF8.GetBytes(pass_and_salt);
// Compute the Hash. This returns an array of Bytes.
byte[] bytHash = hashAlg.ComputeHash(bytValue);
// Optionally, represent the hash value as a base64-encoded string,
// For example, if you need to display the value or transmit it over a network.
string base64 = Convert.ToBase64String(bytHash);
objU.Password = base64;
objU.Salt = salt;
//save
db.Users1.Add(objU);
db.SaveChanges();
}
}