protected void cmdMakeChanges_Click(object sender, EventArgs e) { CMEDGraduate graduate = new CMEDGraduate { user_id = Int32.Parse(CMEDUsers.SelectedValue), State = drpState.SelectedValue, Region = drpRegion.SelectedValue, Bio = txtBio.Text, URL = txtURL.Text, Photo = lblPhoto.Text }; controller.SaveCMEDUserBio(graduate); //EditBio(); Response.Redirect("CMEDUsersBio.aspx"); }
public void ProcessPhoto() { CMEDGraduate graduate = new CMEDGraduate { user_id = Int32.Parse(CMEDUsers.SelectedValue), State = drpState.SelectedValue, Region = drpRegion.SelectedValue, Bio = txtBio.Text, URL = txtURL.Text, Photo = lblPhoto.Text }; controller.SaveCMEDUserBio(graduate); string url = "CMEDBioImageUpload.aspx?id=" + CMEDUsers.SelectedValue; Response.Redirect(url); }
protected void cmdAddNew_Click(object sender, EventArgs e) { CMEDGraduate graduate = new CMEDGraduate { first_name = txtFirstName.Text, last_name = txtLastName.Text, email = txtEmail.Text, City = txtCity.Text, State = drpState.SelectedValue, Region = drpRegion.SelectedValue, Bio = txtBioGraphy.Text, URL = txtURL.Text, Photo = lblPhoto.Text }; controller.SaveCMEDGraduate(graduate); Response.Redirect("CMEDUsersBio.aspx"); }
public bool SaveCMEDUserBio(CMEDGraduate graduate) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveCMEDUserBio"; cmd.Parameters.AddWithValue("@user_id", graduate.user_id); cmd.Parameters.AddWithValue("@FirstName", graduate.first_name); cmd.Parameters.AddWithValue("@LastName", graduate.last_name); cmd.Parameters.AddWithValue("@Email", graduate.email); cmd.Parameters.AddWithValue("@City", graduate.City); cmd.Parameters.AddWithValue("@State", graduate.State); cmd.Parameters.AddWithValue("@Region", graduate.Region); cmd.Parameters.AddWithValue("@Bio", graduate.Bio); cmd.Parameters.AddWithValue("@url", graduate.URL); cmd.Parameters.AddWithValue("@Photo", graduate.Photo); DataTable dt = db.Execute(cmd); return true; }
public List<CMEDGraduate> GetCMEDUsers() { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetCMEDUsers"; DataTable dt = db.Execute(cmd); List<CMEDGraduate> graduates = new List<CMEDGraduate>(); foreach (DataRow dr in dt.Rows) { CMEDGraduate graduate = new CMEDGraduate { user_id = long.Parse(dr["UserID"].ToString()), full_name = dr["LastName"].ToString() + " , " + dr["FirstName"].ToString() + "- Class " + dr["ClassID"].ToString(), first_name = dr["FirstName"].ToString(), last_name = dr["LastName"].ToString(), email = dr["email"].ToString(), City = dr["city"].ToString(), State = dr["State"].ToString(), class_id = dr["ClassID"].ToString(), }; graduates.Add(graduate); } return graduates; }
public CMEDGraduate GetCMEDUserBio(int UserID) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetCMEDUserBio"; cmd.Parameters.AddWithValue("@user_id", UserID); DataTable dt = db.Execute(cmd); DataRow dr = dt.Rows[0]; CMEDGraduate graduate = new CMEDGraduate { user_id = long.Parse(dr["UserID"].ToString()), bio_id = long.Parse(dr["bio_id"].ToString()), full_name = dr["FirstName"].ToString() + " " + dr["LastName"].ToString(), first_name = dr["FirstName"].ToString(), last_name = dr["LastName"].ToString(), email = dr["email"].ToString(), City = dr["city"].ToString(), State = dr["State"].ToString(), Bio = dr["Bio"].ToString(), Photo = dr["Photo"].ToString(), Region = dr["Region"].ToString(), class_id = dr["ClassID"].ToString(), URL = dr["URL"].ToString(), }; return graduate; }
public List<CMEDGraduate> GetCMEDGraduates(string Value, string Type) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetCMEDGraduates"; cmd.Parameters.AddWithValue("@Value", Value); cmd.Parameters.AddWithValue("@Type", Type); DataTable dt = db.Execute(cmd); List<CMEDGraduate> graduates = new List<CMEDGraduate>(); foreach (DataRow dr in dt.Rows) { CMEDGraduate graduate = new CMEDGraduate { user_id = long.Parse(dr["UserID"].ToString()), bio_id = long.Parse(dr["bio_id"].ToString()), full_name = dr["FirstName"].ToString().ToUpper() + " " + dr["LastName"].ToString().ToUpper(), first_name = dr["FirstName"].ToString(), last_name = dr["LastName"].ToString(), email = dr["email"].ToString(), City = dr["city"].ToString(), State = dr["State"].ToString(), Profile_Url = dr["profile_url"].ToString(), Style = dr["Style"].ToString(), URL = dr["URL"].ToString(), }; graduates.Add(graduate); } return graduates; }