protected void btnSubmit_Click1(object sender, EventArgs e) { Models.Profile A = new Models.Profile(); A.FirstName = txtFirstName.Text; A.LastName = txtLastName.Text; A.Image = ""; A.Email = txtEmail.Text; A.Middlename = txtMiddleName.Text; A.schoolid = Convert.ToInt32(txtIdNumber.Text); A.Street = txtstreet.Text; A.Town = txttown.Text; A.Parish = txtparish.Text; // int sid = Models.Business.Profile_Insert(A.FirstName, A.LastName, A.Image, A.Middlename, A.schoolid, A.Street, A.Town, A.Parish,A.Email); Session["Applicant"] = A; Response.Redirect("Next.aspx"); }
public Models.Profile GetEmailById(int studentid) { string cs = ConfigurationManager.ConnectionStrings["UBSConnection"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("SelectEmailById", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameter = new SqlParameter("@id", studentid); cmd.Parameters.Add(parameter); Models.Profile a = new Models.Profile(); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { a.Email = reader["email"].ToString(); } return(a); } }