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