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