protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "select")
{
int rowindex = Int32.Parse(e.CommandArgument.ToString());
GridViewRow row = GridView3.Rows[rowindex];
long smeid = 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.addSmeAvailability(smeid, date1, date2, status);
SmeDao smedao = new SmeDaoSqlImpl();
smedao.adminApprovedSme(reqId, smeid);
Label3.Visible = true;
Label3.Text = "Approved SME";
Label1.Visible = true;
GridView3.Visible = false;
GridView5.Visible = true;
}
}
}
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 Button1_Click(object sender, EventArgs e)
{
Button1.Visible = false;
Details d = new Details();
long det = d.smedet(Session["adminlogin"].ToString());
SmeDao del = new SmeDaoSqlImpl();
del.deleteSkillsSme(det);
TrainerDao train = new TrainerDaoSqlImpl();
del.updatesmedetails(long.Parse(Label1.Text), TextBox1.Text, TextBox2.Text, TextBox3.Text, long.Parse(TextBox4.Text), long.Parse(TextBox5.Text), TextBox6.Text, TextBox7.Text);
List <SmeSkill> dbcheck = new List <SmeSkill>();
RegistrationCheckbox registrationCheckbox = new RegistrationCheckbox();
foreach (ListItem item in CheckBoxList1.Items)
{
long skillId = long.Parse(item.Value);
if (item.Selected)
{
registrationCheckbox.smeSkillInsert(det, skillId);
}
}
Label2.Text = "Profile Edited Succesfully";
Label2.Visible = true;
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
SmeDao sme = new SmeDaoSqlImpl();
List <SME> trainer = new List <SME>();
// trainer = trainerdao.getTrainerListAdmin();
long smeid = 0;
if (e.Row.RowType == DataControlRowType.DataRow)
{
smeid = 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 = sme.getsmeSkillList(smeid);
if (skillList.Count == 0)
{
ddl.Items.Add("No Skills");
}
else
{
ddl.DataSource = skillList;
ddl.DataTextField = "SkillName";
ddl.DataValueField = "SkillId";
ddl.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
List <SmeNominationsList> listofnominations = new List <SmeNominationsList>();
SmeDao smedao = new SmeDaoSqlImpl();
Details d = new Details();
long det = d.smedet(Session["adminlogin"].ToString());
smedao.smeNominationList(det);
}
public void BindData()
{
List <SME> smeList = new List <SME>();
SmeDao smedao = new SmeDaoSqlImpl();
smeList = smedao.getSmeListAdmin();
GridView1.DataSource = smeList;
GridView1.DataBind();
}
public void BindDataSmeSuggestions()
{
List <SME> smeNominationList = new List <SME>();
SmeDao smedao = new SmeDaoSqlImpl();
smeNominationList = smedao.getSmeListSuggestionsAdmin(long.Parse(Request.QueryString["requestId"]));
GridView4.DataSource = smeNominationList;
GridView4.DataBind();
}
public void BindDataSmeNominations()
{
List <SME> trainersNominationList = new List <SME>();
SmeDao smedao = new SmeDaoSqlImpl();
trainersNominationList = smedao.getSmeNominationList(long.Parse(Request.QueryString["requestId"]));
GridView3.DataSource = trainersNominationList;
GridView3.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Details d = new Details();
long det = d.smedet(Session["adminlogin"].ToString());
List <GetRequest> requestList = new List <GetRequest>();
SmeDao requestDao = new SmeDaoSqlImpl();
requestList = requestDao.getApprovedRequestsme(det);
GridView1.DataSource = requestList;
GridView1.DataBind();
}
//public void searchData()
//{
// List<SME> searchList = new List<SME>();
// SmeDao smedao = new SmeDaoSqlImpl();
// string name = DropDownList2.SelectedValue;
// searchList = smedao.getNameBySearch(name);
// GridView1.DataSource = searchList;
// GridView1.DataBind();
//}
public void searchDataByDate()
{
List <SME> searchList = new List <SME>();
SmeDao smedao = new SmeDaoSqlImpl();
DateTime date1 = DateTime.Parse(TextBox1.Text);
DateTime date2 = DateTime.Parse(TextBox2.Text);
string name = DropDownList2.SelectedValue;
searchList = smedao.getSearchByDate(name, date1, date2);
GridView1.DataSource = searchList;
GridView1.DataBind();
}
protected void GridView4_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "select")
{
int rowindex = Int32.Parse(e.CommandArgument.ToString());
GridViewRow row = GridView4.Rows[rowindex];
long smeid = long.Parse(row.Cells[0].Text);
long reqId = long.Parse(Request.QueryString["requestId"]);
SmeDao smedao = new SmeDaoSqlImpl();
smedao.adminRequestingSme(reqId, smeid);
Label5.Visible = true;
Label5.Text = "Request sent";
}
}
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;
}
}
}
}
}
public void BindData()
{
List <SmeDetails> smeDetailsList = new List <SmeDetails>();
model.SmeDetails smedao = new model.SmeDetails();
MoreDetails moredetails = new MoreDetailsSqlImpl();
smedao = moredetails.getSmeDetails(long.Parse(Request.QueryString["smeId"]));
TextBox1.Text = smedao.SmeId.ToString();
TextBox2.Text = smedao.First_name;
TextBox3.Text = smedao.Last_name;
TextBox4.Text = smedao.Gender;
TextBox5.Text = smedao.Age.ToString();
TextBox6.Text = smedao.Contact_no.ToString();
TextBox7.Text = smedao.EmailId;
TextBox11.Text = smedao.Description;
TextBox9.Text = smedao.StartDate.ToString();
TextBox10.Text = smedao.EndDate.ToString();
TextBox8.Text = smedao.Availability.ToString();
SmeDao sme = new SmeDaoSqlImpl();
List <SME> trainer = new List <SME>();
// trainer = trainerdao.getTrainerListAdmin();
long smeid = long.Parse(Request.QueryString["smeid"]);
List <Skill> skillList = new List <Skill>();
skillList = sme.getsmeSkillList(smeid);
if (skillList.Count == 0)
{
DropDownList1.Items.Add("No Skills");
}
else
{
DropDownList1.DataSource = skillList;
DropDownList1.DataTextField = "SkillName";
DropDownList1.DataValueField = "SkillId";
DropDownList1.DataBind();
}
}
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 Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
Details d = new Details();
long det = d.smedet(Session["adminlogin"].ToString());
SmeDao calendar = new SmeDaoSqlImpl();
List <model.Calender> trainerCal = new List <model.Calender>();
trainerCal = calendar.getDatesSme(det);
foreach (var t in trainerCal)
{
DateTime date1 = t.StartDate;
DateTime date2 = t.Enddate;
string availability = t.Availability_status;
if (e.Day.Date >= date1 && e.Day.Date <= date2 && availability == "Busy")
{
e.Cell.Attributes.Add("onclick", "javascript:alert('Busy')");
e.Cell.ForeColor = System.Drawing.Color.DarkRed;
}
else
{
e.Cell.Attributes.Add("onclick", "javascript:alert('Free')");
}
}
}
