protected void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { SetSkillsBL.GetNewSkills(rptRPA, rptLangPrg, rptMS, rptFrk, rptDB, rptOther); } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { SetSkillsBL.GetNewSkills(rptRPA, rptLangPrg, rptMS, rptFrk, rptDB, rptOther); ClsCommon.ddlGetSkillddl(ddlPrimary, "Select Primary Skill"); ClsCommon.ddlGetSkillddl(ddlSecondry, "Select Secondary Skill"); ClsCommon.ddlGetSkillddl(ddlTertiary, "Select Ternary Skill"); } }
protected void InsertEmpSkills(object sender, EventArgs e) { try { string SkillIDs = ""; string Skillname = ""; string path = HttpContext.Current.Server.MapPath("Documents/"); string FilePath = "http://gridinfocom-001-site2.ftempurl.com/Documents/"; List <CPT_Certificate> lstCertificates = new List <CPT_Certificate>(); bool flag = SetSkillsBL.CheckEmpID(Convert.ToInt32(EmpID.Text)); if (flag) { foreach (RepeaterItem item in rptRPA.Items) { CPT_Certificate details = new CPT_Certificate(); CheckBox chk = (CheckBox)item.FindControl("chkRPA"); DropDownList ddlRating = (DropDownList)item.FindControl("ddlRPARating"); FileUpload filePath = (FileUpload)item.FindControl("RPACertificate"); if (chk.Checked) { details.EmployeeID = Convert.ToInt32(EmpID.Text); details.SkillID = Convert.ToInt32(chk.Attributes["SkillID"]); SkillIDs += chk.Attributes["SkillID"] + ","; Skillname = chk.Attributes["Skillname"]; details.Rating = Convert.ToInt32(ddlRating.SelectedValue); if (filePath.HasFile) { filePath.SaveAs(path + EmpID.Text + "_" + chk.Attributes["SkillID"] + "_" + filePath.FileName); details.CertificatePath = FilePath + EmpID.Text + "_" + chk.Attributes["SkillID"] + "_" + filePath.FileName; } lstCertificates.Add(details); } } foreach (RepeaterItem item in rptLangPrg.Items) { CPT_Certificate details = new CPT_Certificate(); CheckBox chk = (CheckBox)item.FindControl("chkLangPrg"); DropDownList ddlRating = (DropDownList)item.FindControl("ddlLangPrgRating"); FileUpload filePath = (FileUpload)item.FindControl("LangPrgCertificate"); if (chk.Checked) { details.EmployeeID = Convert.ToInt32(EmpID.Text); details.SkillID = Convert.ToInt32(chk.Attributes["SkillID"]); SkillIDs += chk.Attributes["SkillID"] + ","; Skillname = chk.Attributes["Skillname"]; details.Rating = Convert.ToInt32(ddlRating.SelectedValue); if (filePath.HasFile) { filePath.SaveAs(path + EmpID.Text + "_" + chk.Attributes["SkillID"] + "_" + filePath.FileName); details.CertificatePath = FilePath + EmpID.Text + "_" + chk.Attributes["SkillID"] + "_" + filePath.FileName; } lstCertificates.Add(details); } } foreach (RepeaterItem item in rptMS.Items) { CPT_Certificate details = new CPT_Certificate(); CheckBox chk = (CheckBox)item.FindControl("chkMS"); DropDownList ddlRating = (DropDownList)item.FindControl("ddlMSRating"); FileUpload filePath = (FileUpload)item.FindControl("MSCertificate"); if (chk.Checked) { details.EmployeeID = Convert.ToInt32(EmpID.Text); details.SkillID = Convert.ToInt32(chk.Attributes["SkillID"]); SkillIDs += chk.Attributes["SkillID"] + ","; Skillname = chk.Attributes["Skillname"]; details.Rating = Convert.ToInt32(ddlRating.SelectedValue); if (filePath.HasFile) { filePath.SaveAs(path + EmpID.Text + "_" + chk.Attributes["SkillID"] + "_" + filePath.FileName); details.CertificatePath = FilePath + EmpID.Text + "_" + chk.Attributes["SkillID"] + "_" + filePath.FileName; } lstCertificates.Add(details); } } foreach (RepeaterItem item in rptFrk.Items) { CPT_Certificate details = new CPT_Certificate(); CheckBox chk = (CheckBox)item.FindControl("chkFrk"); DropDownList ddlRating = (DropDownList)item.FindControl("ddlFrkRating"); FileUpload filePath = (FileUpload)item.FindControl("FrkCertificate"); if (chk.Checked) { details.EmployeeID = Convert.ToInt32(EmpID.Text); details.SkillID = Convert.ToInt32(chk.Attributes["SkillID"]); SkillIDs += chk.Attributes["SkillID"] + ","; Skillname = chk.Attributes["Skillname"]; details.Rating = Convert.ToInt32(ddlRating.SelectedValue); if (filePath.HasFile) { filePath.SaveAs(path + EmpID.Text + "_" + chk.Attributes["SkillID"] + "_" + filePath.FileName); details.CertificatePath = FilePath + EmpID.Text + "_" + chk.Attributes["SkillID"] + "_" + filePath.FileName; } lstCertificates.Add(details); } } foreach (RepeaterItem item in rptDB.Items) { CPT_Certificate details = new CPT_Certificate(); CheckBox chk = (CheckBox)item.FindControl("chkDB"); DropDownList ddlRating = (DropDownList)item.FindControl("ddlDBRating"); FileUpload filePath = (FileUpload)item.FindControl("DBCertificate"); if (chk.Checked) { details.EmployeeID = Convert.ToInt32(EmpID.Text); details.SkillID = Convert.ToInt32(chk.Attributes["SkillID"]); SkillIDs += chk.Attributes["SkillID"] + ","; Skillname = chk.Attributes["Skillname"]; details.Rating = Convert.ToInt32(ddlRating.SelectedValue); if (filePath.HasFile) { filePath.SaveAs(path + EmpID.Text + "_" + chk.Attributes["SkillID"] + "_" + filePath.FileName); details.CertificatePath = FilePath + EmpID.Text + "_" + chk.Attributes["SkillID"] + "_" + filePath.FileName; } lstCertificates.Add(details); } } foreach (RepeaterItem item in rptOther.Items) { CPT_Certificate details = new CPT_Certificate(); CheckBox chk = (CheckBox)item.FindControl("chkOther"); DropDownList ddlRating = (DropDownList)item.FindControl("ddlOtherRating"); FileUpload filePath = (FileUpload)item.FindControl("OtherCertificate"); if (chk.Checked) { details.EmployeeID = Convert.ToInt32(EmpID.Text); details.SkillID = Convert.ToInt32(chk.Attributes["SkillID"]); SkillIDs += chk.Attributes["SkillID"] + ","; Skillname = chk.Attributes["Skillname"]; details.Rating = Convert.ToInt32(ddlRating.SelectedValue); if (filePath.HasFile) { filePath.SaveAs(path + EmpID.Text + "_" + chk.Attributes["SkillID"] + "_" + filePath.FileName); details.CertificatePath = FilePath + EmpID.Text + "_" + chk.Attributes["SkillID"] + "_" + filePath.FileName; } lstCertificates.Add(details); } } if (!string.IsNullOrEmpty(SkillIDs)) { SkillIDs = SkillIDs.Remove(SkillIDs.Length - 1); } SetSkillsBL.UpdateSkills(Convert.ToInt32(EmpID.Text), SkillIDs); SetSkillsBL.UpdateSkill(Convert.ToInt32(EmpID.Text), ddlPrimary.SelectedValue, ddlSecondry.SelectedValue, ddlTertiary.SelectedValue); SetSkillsBL.InsertCertificate(lstCertificates); form1.Style.Add("display", "none"); DvSkill.Style.Add("display", "none"); myDIV.Style.Add("display", "block"); } else { lblEmpID.Visible = true; lblEmpID.Text = "Employee ID does not exists !"; } } catch (Exception q) { lblEmpID.Visible = true; lblEmpID.Text = q.Message; Console.Write(q.Message); } }