protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
TrainerDao trainerdao = new TrainerDaoSqlImpl();
List <Trainer> trainer = new List <Trainer>();
// trainer = trainerdao.getTrainerListAdmin();
long tid = 0;
if (e.Row.RowType == DataControlRowType.DataRow)
{
tid = long.Parse(e.Row.Cells[0].Text.ToString());
//string h = e.Row.Cells[0].Text;
DropDownList ddl = (e.Row.FindControl("DropDownList1") as DropDownList);
List <Skill> skillList = new List <Skill>();
skillList = trainerdao.getTrainerSkillList(tid);
if (skillList.Count == 0)
{
ddl.Items.Add("No Skills");
}
else
{
ddl.DataSource = skillList;
ddl.DataTextField = "SkillName";
ddl.DataValueField = "SkillId";
ddl.DataBind();
}
}
}
public void BindData()
{
List <TrainerDetails> trainerDetailsList = new List <TrainerDetails>();
model.TrainerDetails trainerdao = new model.TrainerDetails();
MoreDetails moredetails = new MoreDetailsSqlImpl();
trainerdao = moredetails.getTrainerDetails(long.Parse(Request.QueryString["trainerId"]));
TextBox1.Text = trainerdao.TrainerId.ToString();
TextBox2.Text = trainerdao.First_name;
TextBox3.Text = trainerdao.Last_name;
TextBox4.Text = trainerdao.Gender;
TextBox5.Text = trainerdao.Age.ToString();
TextBox6.Text = trainerdao.Contact_no.ToString();
TextBox7.Text = trainerdao.EmailId;
TextBox11.Text = trainerdao.Description;
TextBox9.Text = trainerdao.StartDate.ToString();
TextBox10.Text = trainerdao.EndDate.ToString();
TextBox8.Text = trainerdao.Availability.ToString();
TrainerDao train = new TrainerDaoSqlImpl();
List <Trainer> trainer = new List <Trainer>();
long tid = 0;
tid = long.Parse(Request.QueryString["trainerId"]);
List <Skill> skillList = new List <Skill>();
skillList = train.getTrainerSkillList(tid);
if (skillList.Count == 0)
{
DropDownList1.Items.Add("No Skills");
}
else
{
DropDownList1.DataSource = skillList;
DropDownList1.DataTextField = "SkillName";
DropDownList1.DataValueField = "SkillId";
DropDownList1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Details d = new Details();
long det = d.trainerdet(Session["adminlogin"].ToString());
if (!IsPostBack)
{
RequestManagementSql trainerDetail = new RequestManagementSql();
model.Trainer trainerDao = new model.Trainer();
trainerDao = trainerDetail.getTrainer(det);
Label1.Text = trainerDao.TrainerId.ToString();
TextBox1.Text = trainerDao.First_name;
TextBox2.Text = trainerDao.Last_name;
TextBox3.Text = trainerDao.Gender;
TextBox4.Text = trainerDao.Age.ToString();
TextBox5.Text = trainerDao.Contact_no.ToString();
TextBox6.Text = trainerDao.EmailId;
TextBox7.Text = trainerDao.Description;
List <Skill> dbdata = new List <Skill>();
RegistrationCheckbox checkboxDetails = new RegistrationCheckbox();
dbdata = checkboxDetails.registrationCheckboxFill();
foreach (Skill s in dbdata)
{
ListItem item = new ListItem();
item.Value = s.SkillId.ToString();
item.Text = s.SkillName;
CheckBoxList1.Items.Add(item);
}
TrainerDao train = new TrainerDaoSqlImpl();
List <Skill> skilllist = new List <Skill>();
skilllist = train.getTrainerSkillList(det);
foreach (ListItem item in CheckBoxList1.Items)
{
foreach (Skill a in skilllist)
{
if (item.Value == a.SkillId.ToString())
{
item.Selected = true;
}
}
}
// foreach (Skill a in skilllist)
// {
// //for (int i = 0; i < skilllist.Count; i++)
// //{
// if (a.SkillId == 1)
// {
// CheckBoxList1.Items[i].Selected = true;
// }
// else if (a.SkillId == 2)
// {
// CheckBoxList1.Items[i].Selected = true;
// }
// else if (a.SkillId == 3)
// {
// CheckBoxList1.Items[i].Selected = true;
// }
// else if (a.SkillId == 4)
// {
// CheckBoxList1.Items[i].Selected = true;
// }
// //}
//}
}
}
