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");
}
