protected void SubmitButton_Click(object sender, EventArgs e) { string lastname = LastNameTextBox.Text; string firstname = FirstNameTextBox.Text; string email = EmailTextBox.Text; string apartment = ApartmentNumberTextBox.Text; string street = StreetTextBox.Text; string city = CityTextBox.Text; string state = StateTextBox.Text; string zip = ZipcodeTextBox.Text; string home = HomePhoneTextBox.Text; string work = WorkPhoneTextBox.Text; string password = PasswordTextBox.Text; Community_AssistEntities cae = new Community_AssistEntities(); int result = cae.usp_Register(lastname, firstname, email, password, apartment, street, city, state, zip, home, work); if (result != -1) { Response.Redirect("Default.aspx"); } else { ResultLabel.Text = "Something Went Horribly Wrong.... With Your Entries"; } }
protected void submitButton_Click(object sender, EventArgs e) { string Last = lastTextBox.Text; string First = firstTextBox.Text; string Email = EmailTextBox.Text; string Password = PasswordTextBox.Text; string Apartmentnumber = ApartmentTextBox.Text; string Street = StreetTextBox.Text; string city = cityTextBox.Text; string state = StateTextBox.Text; string Zipcode = ZipcodeBox.Text; string CellPhone = CellphoneBox.Text; string WorkPhone = WorkphoneBox.Text; Community_AssistEntities db = new Community_AssistEntities(); int result = db.usp_Register(Last, First, Email, Password, Apartmentnumber, Street, city, state, Zipcode, CellPhone, WorkPhone); if (result != -1) { Response.Redirect("Default.aspx"); } else { ErrorLable.Text = ("Try to Register again"); } }
protected void SubmitButton_Click(object sender, EventArgs e) { int key = (int)Session["userKey"]; string lastname = LastNameTextBox.Text; string firstname = FirstNameTextBox.Text; string email = EmailTextBox.Text; string apartment = ApartmentNumberTextBox.Text; string street = StreetTextBox.Text; string city = CityTextBox.Text; string state = StateTextBox.Text; string zip = ZipcodeTextBox.Text; Community_AssistEntities cae = new Community_AssistEntities(); int result = cae.usp_UpdatePersonInfo(key, lastname, firstname, email, apartment, street, city, state, zip); if (result != -1) { Response.Redirect("Default.aspx"); } else { ResultLabel.Text = "Something Went Horribly Wrong.... With Your Entries"; } }
protected void SubmitButton_Click(object sender, EventArgs e) { string date = DateTextBox.Text; string Amount = AmountTextBox.Text; string explains = ExplainTextBox.Text; Community_AssistEntities apply = new Community_AssistEntities(); GrantRequest grant = new GrantRequest(); //CommunityAssistReference.CommunityServiceClient ca = new CommunityAssistReference.CommunityServiceClient(); // CommunityAssistReference.GrantRequest apply = new CommunityAssistReference.GrantRequest(); grant.GrantRequestDate = DateTime.Parse(date); grant.GrantRequestAmount = decimal.Parse(Amount); grant.GrantRequestExplanation = explains; grant.PersonKey = (int)Session["userKey"]; apply.GrantRequests.Add(grant); apply.SaveChanges(); // if (Session["userkey"] == null) // Response.Redirect("grantHistory.aspx"); Response.Redirect("grantHistory.aspx"); }
protected void SubmitButton_Click(object sender, EventArgs e) { string firstname = FirstNameTextBox.Text; string lastname = LastNameTextBox.Text; string email = EmailTextBox.Text; string password = ConfirmTextBox.Text; string apartmentNumber = ApartmentNumberTextBox.Text; string street = StreetTextBox.Text; string city = CityTextBox.Text; string state = StateTextBox.Text; string Zipcode = ZipcodeTextBox.Text; string homePhone = HomePhoneTextBox.Text; string workPhone = WorkPhoneTextBox.Text; Community_AssistEntities db = new Community_AssistEntities(); int result = db.usp_Register(lastname, firstname, email, password, apartmentNumber, street, city, state, Zipcode, homePhone, workPhone); }
protected void SubmitButton_Click(object sender, EventArgs e) { string email = EmailTextBox.Text; string firstname = FirstNameTextBox.Text; string lastname = LastNameTextBox.Text; string password = ConfirmPasswordTextBox.Text; string apartmentNumber = ApartmentNumberTextBox.Text; string street = StreetTextBox.Text; string city = CityTextBox.Text; string state = StateTextBox.Text; string zipcode = ZipcodeTextBox.Text; string homePhone = HomePhoneTextBox.Text; string workPhone = WorkPhoneTextBox.Text; Community_AssistEntities db = new Community_AssistEntities(); int result = db.usp_Register(lastname, firstname, email, password, apartmentNumber, street, city, state, zipcode, homePhone, workPhone); if (result != -1) { Response.Redirect("Donation1.aspx"); } else { ErrorLabel.Text = "Review your information, something is wrong."; } }
protected void SubmitButton_Click(object sender, EventArgs e) { string first = FirstNameTextBox.Text; string last = LastNameTextBox.Text; string email = EmailTextBox.Text; string password = ConfirmPasswordTextBox.Text; string apartment = ApartmentNumberTextBox.Text; string street = StreetNameTextBox.Text; string city = CityTextBox.Text; string state = StateTextBox.Text; string zip = ZipcodeTextBox.Text; string home = HomePhoneTextBox.Text; string work = WorkPhoneTextBox.Text; Community_AssistEntities db = new Community_AssistEntities(); int result = db.usp_Register(first, last, email, password, apartment, street, city, state, zip, home, work); if (result != -1) { Response.Redirect("Default2.aspx"); } else { ErrorLabel.Text = "Try again"; } }
public int LoginPerson(string email, string password) { Community_AssistEntities db = new Community_AssistEntities(); int success = db.usp_Login(email, password); return(success); }
protected void RegisterButton_Click(object sender, EventArgs e) { string first = FirstNameTextBox.Text; string last = LastNameTextBox.Text; string email = EmailTextBox.Text; string pass = ConfirmPasswordTextBox.Text; string street = StreetTextBox.Text; string apt = ApartmentNumberTextBox.Text; string city = CityTextBox.Text; string state = StateTextBox.Text; string zip = ZipCodeTextBox.Text; string homePhone = HomePhoneTextBox.Text; string workPhone = WorkPhoneTextBox.Text; Community_AssistEntities db = new Community_AssistEntities(); int success = db.usp_Register(last, first, email, pass, apt, street, city, state, zip, homePhone, workPhone); if (success != -1) { Response.Redirect("Default.aspx"); } else { ResultLabel.Text = "Something went terribly wrong"; } }
protected void SubmitButton_Click(object sender, EventArgs e) { string last = LastNameTextBox.Text; string first = FirstNameTextBox.Text; string email = EmailTextBox.Text; string password = PasswordTextBox.Text; string apt = HouseNumTextBox.Text; string street = StreetTextBox.Text; string city = CityTextBox.Text; string state = StateTextBox.Text; string zipcode = ZipCodeTextBox.Text; string home = HomePhoneTextBox.Text; string work = WorkPhoneTextBox.Text; Community_AssistEntities db = new Community_AssistEntities(); int result = db.usp_Register(last, first, email, password, apt, street, city, state, zipcode, home, work); if (result != -1) { Response.Redirect("Default.aspx"); } else { ErrorLabel.Text = "Something went terribly wrong"; } }
public int GetPersonKey(string email) { Community_AssistEntities db = new Community_AssistEntities(); var uKey = (from eachEntry in db.People where eachEntry.PersonEmail.Equals(email) select eachEntry.PersonKey).FirstOrDefault(); return((int)uKey); }
protected void SubmitButton_Click(object sender, EventArgs e) { string first = FirstNameTextBox.Text; string last = LastNameTextBox.Text; string email = EmailTextBox.Text; string password = ConfirmTextBox.Text; string address = AddressTextBox.Text; string aptNumber = ApNumTextBox.Text; string city = CityTextBox.Text; string state = StateTextBox.Text; string zipcode = ZipCodeTextBox.Text; string homePhone = HmPhoneTextBox.Text; string workPhone = WkPhoneTextBox.Text; Community_AssistEntities db = new Community_AssistEntities(); int result = db.usp_Register(first, last, email, password, address, aptNumber, city, state, zipcode, homePhone, workPhone); if (result != -1) { Response.Redirect("Default.aspx"); } else { ErrorLabel.Text = "Something went terribly worng"; } }
protected void LoginButton_Click(object sender, EventArgs e) { int key = 0; Community_AssistEntities db = new Community_AssistEntities(); int success = db.usp_Login(UserTextBox.Text, PasswordTextBox.Text); if (success != -1) { var uKey = (from k in db.People where k.PersonEmail.Equals(UserTextBox.Text) select k.PersonKey).FirstOrDefault(); key = (int)uKey; Session["userKey"] = key; Response.Redirect("Donationpage.aspx"); } else { ResultLabel1.Text = "invalid login"; } }
protected void SubmitRegistration() { string lastname = LastNameTextBox.Text; string fristname = FirstNameTextBox.Text; string email = EmailTextBox.Text; string apratment = ApartmentTextBox.Text; string street = StreetTextBox.Text; string city = CityTextBox.Text; string state = StateTextBox.Text; string zip = ZipcodeTextBox.Text; string home = HomeTextBox.Text; string work = WorkTextBox.Text; string password = PasswordTextBox.Text; Community_AssistEntities cae = new Community_AssistEntities(); int result = cae.usp_Register(lastname, FirstNameTextBox, email, password, apartment, street, city, state, zip, home, work); if (result != -1) { Response.Redirect("Default.aspx"); } else { ResultLabel.Text = "something went really wrong"; } }
protected void Page_Load(object sender, EventArgs e) { int personId = ((int)Session["personKey"]); Community_AssistEntities db = new Community_AssistEntities(); List <GrantRequest> queryResult = (from g in db.GrantRequests where g.PersonKey == personId select g).ToList <GrantRequest>(); List <GrantRequest> resultList = new List <GrantRequest>(); foreach (GrantRequest request in queryResult) { GrantRequest g = new GrantRequest(); g.GrantRequestAmount = request.GrantRequestAmount; g.GrantRequestDate = request.GrantRequestDate; g.GrantRequestExplanation = request.GrantRequestExplanation; g.GrantRequestKey = request.GrantRequestKey; g.PersonKey = request.PersonKey; g.GrantTypeKey = request.GrantTypeKey; resultList.Add(g); } GridView1.DataSource = resultList; GridView1.DataBind(); }
protected void SubmitButton_Click(object sender, EventArgs e) { Community_AssistEntities cae = new Community_AssistEntities(); Person p = new Person(); string lastName = LastNameTextBox.Text; string firstName = FirstNameTextBox.Text; string email = EmailTextBox.Text; string password = PasswordTextBox.Text; string apartment = apartmentTextBox.Text; string street = StreetTextBox.Text; string city = CityTextBox.Text; string state = StateTextBox.Text; string zip = ZipcodeTextBox.Text; string home = HomePhoneTextBox.Text; string work = WorkPhoneTextBox.Text; int result = cae.usp_Register(lastName, firstName, email, password, apartment, street, city, state, zip, home, work); if (result != -1) { Response.Redirect("Default.aspx"); } else { ResultLabel.Text = "Error. Inconclusive Information."; } }
protected void SubmitButton_Click(object sender, EventArgs e) { string firstname = FirstNameTextBox.Text; string lastname = LastNameTextBox.Text; string email = EmailTextBox.Text; string streetName = StreetName.Text; string apartmentNumber = ApartmentNumber.Text; string city = City.Text; string state = State.Text; string zipCode = ZipCode.Text; string HomePhone = PhoneNumber.Text; string WorkPhone = WorkNumber.Text; // string user = UserTextBox.Text; string password = ConfirmTextBox.Text; Community_AssistEntities db = new Community_AssistEntities(); int result = db.usp_Register(lastname, firstname, email, password, apartmentNumber, streetName, city, state, zipCode, HomePhone, WorkPhone); if (result != -1) { Response.Redirect("Default.aspx"); } else { ErrorLabel.Text = "Something went terribly wrong"; } }
protected void LoginButton_Click(object sender, EventArgs e) { //we are using the same stored procedure that was //used in the previous assignment but Entites //treats it as a method. It still returns -1 for no match Community_AssistEntities cae = new Community_AssistEntities(); int result = cae.usp_Login(UserNameTextBox.Text, PasswordTextBox.Text); if (result != -1) { //here we do a linq query to get the user key string email = UserNameTextBox.Text; var key = (from p in cae.People where p.PersonEmail.Equals(email) select p.PersonKey).FirstOrDefault(); //cast the result to integer int pKey = (int)key; //assign it to a session variable. Session["userKey"] = key; Response.Redirect("Donate.aspx"); } else { ErrorLabel.Text = "Invalid login"; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["personKey"] == null) { Response.Redirect("Default.aspx"); } Community_AssistEntities db = new Community_AssistEntities(); List <GrantType> queryResult = (from gt in db.GrantTypes select gt).ToList <GrantType>(); foreach (GrantType gt in queryResult) { GrantType grantType = new GrantType(); grantType.GrantTypeKey = gt.GrantTypeKey; grantType.GrantTypeName = gt.GrantTypeName; grantTypes.Add(grantType); } List <string> grantNames = new List <string>(); foreach (var gt in grantTypes) { grantNames.Add(gt.GrantTypeName); } if (!Page.IsPostBack) { DropDownList1.DataSource = grantNames; DropDownList1.DataBind(); } }
protected void SubmitBtn_Click(object sender, EventArgs e) { string first = FirstNameTxt.Text; string last = LastNameTxt.Text; string email = EmailTxt.Text; string street = Address1Txt.Text; string apartmentNumber = AptTxt.Text; string city = CityTxt.Text; string state = StateTxt.Text; string zipcode = ZipTxt.Text; string homePhone = HomePhoneTxt.Text; string workPhone = WorkPhoneTxt.Text; string password = PasswordTxt.Text; Community_AssistEntities db = new Community_AssistEntities(); int result = db.usp_Register(last, first, email, password, apartmentNumber, street, city, state, zipcode, homePhone, workPhone); if (result != -1) { Response.Redirect("Default.aspx"); } else { ErrorLbl.Text = "Something went wrong!"; } }
protected void Page_Load(object sender, EventArgs e) { Community_AssistEntities db = new Community_AssistEntities(); var donat = (from a in db.Donations select a).ToList(); GridView1.DataSource = donat; GridView1.DataBind(); }
protected void SubmitButton_Click(object sender, EventArgs e) { Community_AssistEntities db = new Community_AssistEntities(); Donation d = new Donation(); d.DonationAmount = decimal.Parse(DonationTextBox.Text); db.Donations.Add(d); db.SaveChanges(); Response.Redirect("DonationList.aspx"); }
protected void PopulateDonation() { Community_AssistEntities cae = new Community_AssistEntities(); int key = (int)Session["userKey"]; var dons = from d in cae.Donations where d.PersonKey == key select d; DonationsGridView.DataSource = dons.ToList(); DonationsGridView.DataBind(); }
protected void SubmitButton_Click(object sender, EventArgs e) { Community_AssistEntities db = new Community_AssistEntities(); Donation d = new Donation(); d.DonationAmount = decimal.Parse(DonationTextBox.Text); d.DonationDate = DateTime.Now; d.PersonKey = (int)Session["userKey"]; db.Donations.Add(d); db.SaveChanges(); }
protected void Page_Load(object sender, EventArgs e) { int personKey = Convert.ToInt32(Session["personKey"]); Community_AssistEntities db = new Community_AssistEntities(); var personDonations = (from d in db.Donations where d.PersonKey == personKey select d).ToList <Donation>(); GridView1.DataSource = personDonations; GridView1.DataBind(); }
protected void SubmitButton_Click(object sender, EventArgs e) { Community_AssistEntities db = new Community_AssistEntities(); Donation a = new Donation(); a.DonationName = DonationTextBox; db.Donations.Add(a); db.SaveChanges(); Response.Redirect("DonationList.aspx"); }
public void RegisterPerson(string lastName, string firstName, string email, string password, string apartmentNumber, string street, string city, string state, string zipCode, string homePhone, string workPhone) { int success = GetPersonKey(email); if (success == 0) { Community_AssistEntities db = new Community_AssistEntities(); db.usp_Register(lastName, firstName, email, password, apartmentNumber, street, city, state, zipCode, homePhone, workPhone); } }
protected void SubmitButton_Click(object sender, EventArgs e) { Community_AssistEntities db = new Community_AssistEntities(); Donor d = new Donor(); d.DonorName = DonateTextBox.Text; db.Donors.Add(d); db.SaveChanges(); Response.Redirect("DonationList.aspx"); }
protected void DonateButton_Click(object sender, EventArgs e) { Community_AssistEntities cae = new Community_AssistEntities(); Donation d = new Donation(); d.DonationAmount = decimal.Parse(DonationTextBox.Text); d.DonationDate = DateTime.Now; d.PersonKey = (int)Session["userKey"]; cae.Donations.Add(d); cae.SaveChanges(); Response.Redirect("Donations.aspx"); }
protected void DonationButton_Click(object sender, EventArgs e) { Community_AssistEntities db = new Community_AssistEntities(); Donation a = new Donation(); a.DonationAmount = Decimal.Parse(DonationTextBox.Text); a.DonationDate = DateTime.Now; a.PersonKey = (int)Session["PersonKey"]; db.Donations.Add(a); db.SaveChanges(); Response.Redirect("DonationList.aspx"); }