protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e) { Details d = new Details(); long det = d.smedet(Session["adminlogin"].ToString()); if (e.CommandName == "Select") { SmeDao smeNomCount = new SmeDaoSqlImpl(); int check = smeNomCount.getSmeNominationsCount(det); if (check < 3) { int rowindex = Int32.Parse(e.CommandArgument.ToString()); GridViewRow row = GridView2.Rows[rowindex]; long requestId = long.Parse(row.Cells[0].Text); RequestManagementDao addNomination = new RequestManagementSql(); addNomination.addSmeNomination(requestId, det); bindgrid2(); Label4.Visible = true; Label4.Text = "Request Accepted"; } else { GridView1.Visible = false; GridView2.Visible = false; Label1.Text = "You already nominated for 3 requests. Please wait for Admin Action"; Label2.Visible = false; Label3.Visible = false; Label1.Visible = true; } } }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "select") { int rowindex = Int32.Parse(e.CommandArgument.ToString()); GridViewRow row = GridView1.Rows[rowindex]; long trainerid = long.Parse(row.Cells[0].Text); long reqId = long.Parse(Request.QueryString["requestId"]); RequestManagementDao calendar = new RequestManagementSql(); List <model.Calender> trainerCal = new List <model.Calender>(); trainerCal = calendar.getDatesRequest(reqId); foreach (var t in trainerCal) { DateTime date1 = t.StartDate; DateTime date2 = t.Enddate; RequestManagementSql request = new RequestManagementSql(); //long trainerid = long.Parse(row.Cells[0].Text); string status = "Busy"; request.addAvailability(trainerid, date1, date2, status); TrainerDao trainerdao = new TrainerDaoSqlImpl(); trainerdao.adminApprovedTrainer(reqId, trainerid); Label2.Visible = true; Label2.Text = "Approved Trainer"; Label1.Visible = true; GridView1.Visible = false; GridView5.Visible = true; } } }
protected void Button1_Click(object sender, EventArgs e) { Label2.Visible = true; Label2.Text = "profiel edited"; RequestManagementSql requestdetail = new RequestManagementSql(); requestdetail.updaterequestordetails(long.Parse(Label1.Text), TextBox1.Text, TextBox2.Text, TextBox3.Text, long.Parse(TextBox4.Text), long.Parse(TextBox5.Text), TextBox6.Text, TextBox7.Text); }
public void bindgrid2() { Details d = new Details(); long det = d.smedet(Session["adminlogin"].ToString()); RequestManagementDao request = new RequestManagementSql(); List <model.GetRequest> smeRequest = new List <model.GetRequest>(); smeRequest = request.getSmeRequest(det); GridView2.DataSource = smeRequest; GridView2.DataBind(); }
public void bindgrid() { Details d = new Details(); long det = d.smedet(Session["adminlogin"].ToString()); RequestManagementDao requestDao = new RequestManagementSql(); List <model.GetRequest> requestorRequest = new List <model.GetRequest>(); requestorRequest = requestDao.getRequestsme(); GridView1.DataSource = requestorRequest; GridView1.DataBind(); }
protected void buttonRequest_Click(object sender, EventArgs e) { Details d = new Details(); long det = d.requestordet(Session["adminlogin"].ToString()); string status = "ON"; RequestManagementSql request = new RequestManagementSql(); request.addRequest(det, long.Parse(RadioButtonList1.SelectedValue), DateTime.Parse(dateStart.Text), DateTime.Parse(dateEnd.Text), txtVenue.Text, status); Label1.Text = "Request Added Successfully"; // Response.Redirect("Registration.aspx"); RadioButtonList1.ClearSelection(); dateStart.Text = dateEnd.Text = txtVenue.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Details d = new Details(); long det = d.requestordet(Session["adminlogin"].ToString()); RequestManagementDao requestDao = new RequestManagementSql(); List <model.req> request = new List <model.req>(); request = requestDao.getRequest(det); GridView1.DataSource = request; GridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Details d = new Details(); long det = d.smedet(Session["adminlogin"].ToString()); RequestManagementSql smeDetail = new RequestManagementSql(); model.SME smeDao = new model.SME(); smeDao = smeDetail.getSme(det); Label1.Text = smeDao.SmeId.ToString(); TextBox1.Text = smeDao.First_name; TextBox2.Text = smeDao.Last_name; TextBox3.Text = smeDao.Gender; TextBox4.Text = smeDao.Age.ToString(); TextBox5.Text = smeDao.Contact_no.ToString(); TextBox6.Text = smeDao.EmailId; TextBox7.Text = smeDao.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); } SmeDao sme = new SmeDaoSqlImpl(); List <Skill> skilllist = new List <Skill>(); skilllist = sme.getsmeSkillList(det); foreach (ListItem item in CheckBoxList1.Items) { foreach (Skill a in skilllist) { if (item.Value == a.SkillId.ToString()) { item.Selected = true; } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Details d = new Details(); long det = d.requestordet(Session["adminlogin"].ToString()); RequestManagementSql requestorDetail = new RequestManagementSql(); model.RequestorDetails requestorDao = new model.RequestorDetails(); requestorDao = requestorDetail.getRequestor(det); Label1.Text = requestorDao.RequestorId.ToString(); TextBox1.Text = requestorDao.FirstName; TextBox2.Text = requestorDao.LastName; TextBox3.Text = requestorDao.Gender; TextBox4.Text = requestorDao.Age.ToString(); TextBox5.Text = requestorDao.ContactNumber.ToString(); TextBox6.Text = requestorDao.EmailId; TextBox7.Text = requestorDao.Description; } }
protected void Button1_Click(object sender, EventArgs e) { Details d = new Details(); long det = d.trainerdet(Session["adminlogin"].ToString()); string status; if (available.Checked == true) { status = "Available"; } else { status = "Busy"; } RequestManagementSql request = new RequestManagementSql(); request.addAvailability(det, DateTime.Parse(txtStartDate.Text), DateTime.Parse(txtEndDate.Text), status); Label1.Text = "Availability saved"; }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { Details d = new Details(); long det = d.smedet(Session["adminlogin"].ToString()); if (e.CommandName == "Select") { if (e.CommandName == "Select") { SmeDao smeNomCount = new SmeDaoSqlImpl(); int check = smeNomCount.getSmeNominationsCount(det); if (check < 3) { int rowindex = Int32.Parse(e.CommandArgument.ToString()); GridViewRow row = GridView1.Rows[rowindex]; long requestId = long.Parse(row.Cells[0].Text); RequestManagementDao addNomination = new RequestManagementSql(); addNomination.addSmeNomination(requestId, det); bindgrid(); LinkButton btnnominate = row.FindControl("LinkButton1") as LinkButton; btnnominate.Enabled = false; //TextBox myTextBox = row.FindControl("MyTextBoxId") as TextBox; Label5.Visible = true; Label5.Text = "Nominated Successfully"; } else { GridView1.Visible = false; GridView2.Visible = false; Label1.Visible = true; Label1.Text = "You already nominated for 3 requests. Please wait for Admin Action"; Label2.Visible = false; Label3.Visible = false; } } } }
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; // } // //} //} } }