protected void btnDelete_Click(object sender, EventArgs e) { using (LacklusterEntities entity = new LacklusterEntities()) { custID = Int32.Parse(Request.QueryString["ID"]); customer cust = entity.customers.Where(c => c.custID == custID).Single(); cust.active = false; entity.SaveChanges(); } Response.Redirect("EditCustomer.aspx"); }
protected void btnDelete_Click(object sender, EventArgs e) { using (LacklusterEntities entity = new LacklusterEntities()) { empID = Int32.Parse(Request.QueryString["ID"]); employee emp = entity.employees.Where(em => em.empID == empID).Single(); emp.active = false; entity.SaveChanges(); } Response.Redirect("EditEmployee.aspx"); }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Select") { custID = Int32.Parse(Request.QueryString["ID"]); //Determine the RowIndex of the Row whose Button was clicked. int vID = Int32.Parse(e.CommandArgument.ToString()); using (LacklusterEntities entity = new LacklusterEntities()) { video selectedVid = entity.videos.Where(v => v.videoID == vID).SingleOrDefault(); if (selectedVid != null) { selectedVid.rented = true; entity.SaveChanges(); } rental r = new rental(); r.custID = custID; r.dayRented = DateTime.Today; r.dayDue = DateTime.Today.AddDays(3); r.empID = 0; //Need to add later from logged in user r.videoID = vID; r.returned = false; entity.rentals.Add(r); entity.SaveChanges(); } hfTotal.Value = (Int32.Parse(hfTotal.Value) + 3).ToString(); lblTotal.Text = String.Format("{0:C}", Int32.Parse(hfTotal.Value)); reloadMovies(); } }
protected void gvMovies_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Select") { int vID = Int32.Parse(e.CommandArgument.ToString()); using (LacklusterEntities entity = new LacklusterEntities()) { video selectedVid = entity.videos.Where(v => v.videoID == vID && v.rented == true).SingleOrDefault(); if (selectedVid != null) { selectedVid.rented = false; } rental selectedRental = entity.rentals.Where(r => r.videoID == vID && r.returned == false).SingleOrDefault(); if (selectedRental != null) { selectedRental.returned = true; if (selectedRental.dayDue.Value.CompareTo(DateTime.Today) < 0) { customer cust = entity.customers.Where(c => c.custID == selectedRental.custID).SingleOrDefault(); if (cust != null) { cust.balance = cust.balance + 3; } } } entity.SaveChanges(); lblMessage.Text = selectedVid.title + " has been returned"; } reloadMovies(); } }
protected void btnUpload_Click(object sender, EventArgs e) { StreamReader csvreader = new StreamReader(fuMovies.FileContent); string line = csvreader.ReadLine(); string[] values = line.Split(','); StringBuilder sb = new StringBuilder(); while (!csvreader.EndOfStream) { line = csvreader.ReadLine(); values = line.Split(','); try { using (LacklusterEntities entity = new LacklusterEntities()) { video vid = new video(); vid.title = values[0]; vid.studio = values[1]; if (String.IsNullOrWhiteSpace(values[2])) { vid.released = null; } else { DateTime release; if (DateTime.TryParse(values[2], out release)) { vid.released = release; } else { vid.released = null; } } vid.status = values[3]; vid.sound = values[4]; vid.versions = values[5]; if (String.IsNullOrWhiteSpace(values[6])) { vid.price = null; } else { decimal prc; if (Decimal.TryParse(values[6], out prc)) { vid.price = prc; } else { vid.price = null; } } vid.rating = values[7]; vid.year = values[8]; vid.genre = values[9]; vid.aspect = values[10]; vid.UPC = values[11]; if (String.IsNullOrWhiteSpace(values[12])) { vid.releaseDate = null; } else { DateTime release; if (DateTime.TryParse(values[12], out release)) { vid.releaseDate = release; } else { vid.releaseDate = null; } } vid.active = true; entity.videos.Add(vid); entity.SaveChanges(); } } catch (Exception ex) { line += "," + ex.Message.ToString(); sb.AppendLine(line); continue; } Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=UploadErrors.csv"); Response.Charset = ""; Response.ContentType = "application/text"; Response.Output.Write(sb.ToString()); Response.Flush(); Response.End(); } }
protected void btnComplete_Click(object sender, EventArgs e) { string lookupSalt = null; string passwordPlusSalt = null; string passwordString = ePassword.Text.ToString(); string stateStr = eState.Text.ToString(); string zipStr = eZipCode.Text.ToString(); string phoneStr = ePhoneNumber.Text.ToString(); bool pageValid = true; // TODO: Form validator code SaltGenerator salt = new SaltGenerator(); HasherOfPasswords hash = new HasherOfPasswords(); FormValidatorClass fv = new FormValidatorClass(); // validate state, zip and phone bool validState = fv.IsValidState(stateStr); if (!validState) { // invalid state // TODO: notify EditEmployee.aspx of invalid state stateStr = null; rfvState.ErrorMessage = "Required, enter a valid US state initial(CA, IL, GA)"; rfvState.ForeColor = System.Drawing.Color.Red; pageValid = false; } bool validZip = fv.IsValidZip(zipStr); if (!validZip) { // invalid zip // TODO: notify EditEmployee.aspx of invalid zip zipStr = null; rfvZip.ErrorMessage = "Required, enter a valid Zip Code"; rfvZip.ForeColor = System.Drawing.Color.Red; pageValid = false; } bool validPhone = fv.IsValidPhone(phoneStr); if (!validPhone) { // invalid phone // TODO: notify EditEmployee.aspx of invalid phone phoneStr = null; rfvPhone.ErrorMessage = "Required, enter a valid phone number"; rfvPhone.ForeColor = System.Drawing.Color.Red; pageValid = false; } // save to DB only if entries are validated if (pageValid == true) { using (LacklusterEntities entity = new LacklusterEntities()) { empID = Int32.Parse(Request.QueryString["ID"]); employee emp = entity.employees.Where(em => em.empID == empID).Single(); emp.firstName = eFirstName.Text; emp.lastName = eLastName.Text; emp.streetAddress = eAddress.Text; emp.city = eCity.Text; emp.state = stateStr; int zipFromString = 0; int.TryParse(zipStr, out zipFromString); emp.zip = zipFromString; /* * if (zipFromString != 0) * { * emp.zip = zipFromString; * } */ emp.phone = phoneStr; // generate new salt and take new password lookupSalt = salt.SaltMe(emp.firstName, emp.lastName); passwordPlusSalt = passwordString + lookupSalt; emp.llv_password = hash.HashPassword(passwordPlusSalt); emp.salt = lookupSalt; emp.manager = eIsManager.Checked; entity.SaveChanges(); } } else { // redirect } Response.Redirect("EditEmployee.aspx"); }
protected void cAddCustomer_Click(object sender, EventArgs e) { string firstNameStr = cFirstName.Text.ToString(); string lastNameStr = cLastName.Text.ToString(); string stAddressStr = cAddress.Text.ToString(); string stateStr = cState.Text.ToString(); string zipStr = cZipCode.Text.ToString(); string phoneStr = cPhoneNumber.Text.ToString(); bool pageValid = true; // TODO: // Add some code validation, WORK IN PROGRESS FormValidatorClass fv = new FormValidatorClass(); DuplicateCheckerClass dc = new DuplicateCheckerClass(); // validate if customer already exists bool duplicatePerson = dc.AlreadyExists(firstNameStr, lastNameStr, stAddressStr); if (duplicatePerson) { // Customer already exists. // TODO: ccreate code to notify AddCustomer.aspx of duplicate entry // null the values now so none will be passed to DB firstNameStr = null; lastNameStr = null; stAddressStr = null; rfvFirst.ErrorMessage = "Required, person you entered already exists"; rfvLast.ErrorMessage = "Required, person you entered already exists"; rfvFirst.ForeColor = System.Drawing.Color.Red; rfvLast.ForeColor = System.Drawing.Color.Red; pageValid = false; } // No need for else, keep validating.... // validate valid state initials bool validState = fv.IsValidState(stateStr); if (!validState) { // invalid state. // TODO: create code to notify AddCustomer.aspx of invalid state stateStr = null; rfvState.ErrorMessage = "Required, enter a valid US state intial (CA, IL. GA)"; rfvState.ForeColor = System.Drawing.Color.Red; pageValid = false; } // keep validating // validate phone bool validPhone = fv.IsValidPhone(phoneStr); if (!validPhone) { // invalid phone // TODO: notify AddCustomer.aspx of invalid phone phoneStr = null; rfvPhone.ErrorMessage = "Required, enter a valid phone number"; rfvPhone.ForeColor = System.Drawing.Color.Red; pageValid = false; } // validate zip code bool validZip = fv.IsValidZip(zipStr); if (!validZip) { // invalid zip // TODO: notify AddCustomer.aspx of invalid zip zipStr = null; rfvZip.ErrorMessage = "Required, enter a valid Zip Code"; rfvZip.ForeColor = System.Drawing.Color.Red; pageValid = false; } // save to DB only if entries are validated if (pageValid == true) { using (LacklusterEntities entity = new LacklusterEntities()) { customer c = new customer(); c.firstName = firstNameStr; c.lastName = lastNameStr; c.streetAddress = stAddressStr; c.city = cCity.Text.ToString(); c.state = stateStr; c.phone = phoneStr; int zipFromString = 0; int.TryParse(zipStr, out zipFromString); c.zip = zipFromString; /* * if (zipFromString != 0) * { * c.zip = zipFromString; * } * else * { * c.zip = 99999; * } */ c.active = true; entity.customers.Add(c); entity.SaveChanges(); } } else { // redirect? } Response.Redirect("~/Management/ManageCustomer.aspx"); }
protected void eAddEmployee_Click(object sender, EventArgs e) { /* Edited 4/16/18: * passwordPlusSalt is input to Hash algorithm and the output * is saved to the DB */ string lookupSalt = null; string passwordPlusSalt = null; string passwordString = ePassword.Text.ToString(); SaltGenerator salt = new SaltGenerator(); HasherOfPasswords hash = new HasherOfPasswords(); FormValidatorClass fv = new FormValidatorClass(); DuplicateCheckerClass dc = new DuplicateCheckerClass(); /* TODO * These variables will be used to check for validation. * inputs will be stored in here and checked for validation * before being stored as a DB entry. * */ string firstNameStr = eFirstName.Text.ToString(); string lastNameStr = eLastName.Text.ToString(); string stAddressStr = eAddress.Text.ToString(); string stateStr = eState.Text.ToString(); string phoneStr = ePhoneNumber.Text.ToString(); string zipStr = eZipCode.Text.ToString(); string userNameStr = eUsername.Text.ToString(); bool pageValid = true; // validate if person already exists bool duplicatePerson = dc.AlreadyExists(firstNameStr, lastNameStr, stAddressStr, userNameStr); if (duplicatePerson) { // then this person already exists in the records // TODO: write code in here that alerts the AddEmployee.aspx page of a dulpicate // entry attempt. For now, NULL the values so they will not be passed to the DB firstNameStr = null; lastNameStr = null; stAddressStr = null; userNameStr = null; rfvFirst.ErrorMessage = "Required, Person you entered already exists"; rfvLast.ErrorMessage = "Required, Person you entered already exists"; rfvFirst.ForeColor = System.Drawing.Color.Red; rfvLast.ForeColor = System.Drawing.Color.Red; pageValid = false; } // No need for else, keep validating... If entry does not exist in DB, values // won't be nulled. Essentially, values are nulled to force the // ASP:RequiredFieldValidator to throw an error. // validate state intial bool validState = fv.IsValidState(stateStr); if (!validState) { // State is not valid. // TODO: write code in here that alerts the AddEmployee.aspx page of an invalid // state. For now, NULL the values so they will not be passed to the DB stateStr = null; rfvState.ErrorMessage = "Required, Enter a valid US state initial (CA, IL, GA)"; rfvState.ForeColor = System.Drawing.Color.Red; pageValid = false; } // No need for else, keep validating... // validate phone number bool validPhone = fv.IsValidPhone(phoneStr); if (!validPhone) { // Phone number is not valid. // TODO: write code that alerts AddEmployee.aspx page of an invalid phone. // NULL the value so it will not be passed to the DB. phoneStr = null; rfvPhone.ErrorMessage = "Required, Enter a valid phone number"; rfvPhone.ForeColor = System.Drawing.Color.Red; pageValid = false; } // validate zip bool validZip = fv.IsValidZip(zipStr); if (!validZip) { // Zip Code is not valid. // TODO: write code that alerts AddEmployee.aspx page of an invalid zip. // NULL the value so it will not be passed to the DB. zipStr = null; rfvZip.ErrorMessage = "Required, Enter a Valid Zip Code"; rfvZip.ForeColor = System.Drawing.Color.Red; pageValid = false; } // save to DB only if entries are validated. if (pageValid == true) { using (LacklusterEntities entity = new LacklusterEntities()) { employee em = new employee(); em.firstName = firstNameStr; em.lastName = lastNameStr; em.streetAddress = stAddressStr; em.city = eCity.Text.ToString(); em.state = stateStr; em.phone = phoneStr; em.userName = userNameStr; lookupSalt = salt.SaltMe(em.firstName, em.lastName); passwordPlusSalt = passwordString + lookupSalt; em.llv_password = hash.HashPassword(passwordPlusSalt); em.salt = lookupSalt; //em.llv_password = ePassword.Text; //eUsername.Text = passwordPlusSalt; em.manager = eIsManager.Checked; em.active = true; int zipFromString = 0; int.TryParse(zipStr, out zipFromString); em.zip = zipFromString; /* * if (zipFromString != 0) * { * em.zip = zipFromString; * } * else * { * em.zip = 99999; * } */ entity.employees.Add(em); entity.SaveChanges(); } } else { // redirect? } Response.Redirect("~/Management/ManageEmployee.aspx"); }
protected void btnComplete_Click(object sender, EventArgs e) { string stateStr = cState.Text.ToString(); string zipStr = cZipCode.Text.ToString(); string phoneStr = cPhoneNumber.Text.ToString(); bool pageValid = true; FormValidatorClass fv = new FormValidatorClass(); // validate state, zip, phone bool validState = fv.IsValidState(stateStr); if (!validState) { stateStr = null; rfvState.ErrorMessage = "Required, enter valid US state initial (CA, IL, GA)"; rfvState.ForeColor = System.Drawing.Color.Red; pageValid = false; } bool validZip = fv.IsValidZip(zipStr); if (!validZip) { zipStr = null; rfvZip.ErrorMessage = "Required, enter a valid Zip Code"; rfvZip.ForeColor = System.Drawing.Color.Red; pageValid = false; } bool validPhone = fv.IsValidPhone(phoneStr); if (!validPhone) { phoneStr = null; rfvPhone.ErrorMessage = "Required, enter a valid phone number"; rfvPhone.ForeColor = System.Drawing.Color.Red; pageValid = false; } // save to DB only once entries are validated if (pageValid == true) { using (LacklusterEntities entity = new LacklusterEntities()) { custID = Int32.Parse(Request.QueryString["ID"]); customer cust = entity.customers.Where(c => c.custID == custID).Single(); cust.firstName = cFirstName.Text; cust.lastName = cLastName.Text; cust.phone = phoneStr; cust.streetAddress = cAddress.Text; cust.city = cCity.Text; cust.state = stateStr; int zipFromString = 0; int.TryParse(zipStr, out zipFromString); cust.zip = zipFromString; /* * if (zipFromString != 0) * { * cust.zip = zipFromString; * } */ entity.SaveChanges(); } } else { // redirect } Response.Redirect("EditCustomer.aspx"); }