protected void btnsubmit_Click(object sender, EventArgs e)
{
ProfessionalDetailsEntity professionaldetailentity = new ProfessionalDetailsEntity();
ProfessionalDetailBAL professionaldetailBAL = new ProfessionalDetailBAL();
professionaldetailentity.RecruiterID = "12";
professionaldetailentity.TotalExprience = txttotalexprience.Text.Trim();
professionaldetailentity.Designation = txtdesignation.Text.Trim();
professionaldetailentity.Freelancer = txtfreelancer.Text.Trim();
professionaldetailentity.EmploymentStaus = rbtemploymentstatus.SelectedItem.Text.Trim();
professionaldetailentity.jobtype = rbtjobtype.SelectedItem.Text.Trim();
int result = professionaldetailBAL.InsertDetails(professionaldetailentity);
{
if (result > 0)
{
Response.Write("<script language='javascript'>alert('Recored Inserted ')</script>");
}
else
{
Response.Write("<script language='javascript'>alert('Sorry')</script>");
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ProfessionalDetailBAL professionalDetailBAL = new ProfessionalDetailBAL();
ProfessionalDetailsEntity professionalDetailentity = new ProfessionalDetailsEntity();
professionalDetailentity.TechnicalSkill = txtAddSkill.Text.Trim();
professionalDetailBAL.AddTechnicalSkillBAL(professionalDetailentity);
divAddMoreSkills.Visible = false;
}
public void AddTechnicalSkillDAL(ProfessionalDetailsEntity professionalDetailentity)
{
try
{
Connection.Open();
SqlParameter[] sparams = { new SqlParameter("@SkillName", professionalDetailentity.TechnicalSkill) };
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, Constants.sp_RE_InsertTechnicalSkill, sparams);
}
catch (Exception)
{
throw;
}
}
public void DeleteRoleSkillDAL(int RoleskillId)
{
try
{
ProfessionalDetailsEntity professionalDetailentity = new ProfessionalDetailsEntity();
Connection.Open();
SqlParameter[] sparams = { new SqlParameter("@id", RoleskillId) };
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, Constants.sp_RE_DeleteRoleSkills, sparams);
}
catch (Exception)
{
// throw;
}
finally
{
Connection.Close();
}
}
public DataSet ViewTechnicalskillBAL(string RecruiterID)
{
DataSet ds = new DataSet();
try
{
ProfessionalDetailsEntity professionaldetailentity = new ProfessionalDetailsEntity();
Connection.Open();
SqlParameter[] sparams = { new SqlParameter("@recruiterId", RecruiterID) };
ds = SqlHelper.ExecuteDataset(Connection, CommandType.StoredProcedure, Constants.sp_JS_SelectTechnicalSkills, sparams);
}
catch (Exception)
{
// throw;
}
finally
{
Connection.Close();
}
return ds;
}
public DataSet ViewRoleSkillDetailsDAL(long RecruiterId)
{
DataSet ds = new DataSet();
try
{
ProfessionalDetailsEntity professionalDetailEntity = new ProfessionalDetailsEntity();
Connection.Open();
SqlParameter[] sparams = { new SqlParameter("@recruiterID", RecruiterId) };
ds = SqlHelper.ExecuteDataset(Connection, CommandType.StoredProcedure, Constants.sp_RE_SelectRoleskills, sparams);
}
catch (Exception)
{
// throw;
}
finally
{
Connection.Close();
}
return ds;
}
public void UpdateRoleSkillsDAL(ProfessionalDetailsEntity professionalDetailsentity)
{
try
{
Connection.Open();
SqlParameter[] sparams = new SqlParameter[6];
sparams[0] = new SqlParameter("@roleskillId", professionalDetailsentity.RoleskillId);
sparams[1] = new SqlParameter("@roleSkills", professionalDetailsentity.RoleSkills);
sparams[2] = new SqlParameter("@fromDate", professionalDetailsentity.FromDate);
sparams[3] = new SqlParameter("@tillDate", professionalDetailsentity.TillDate);
sparams[4] = new SqlParameter("@proficiency", professionalDetailsentity.Proficiency);
sparams[5] = new SqlParameter("@totalYear", professionalDetailsentity.TotalExprience);
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, Constants.sp_RE_UpdateRoleSkill, sparams);
}
catch (Exception)
{
// throw;
}
finally
{
Connection.Close();
}
}
public int InsertDetails(ProfessionalDetailsEntity professionaldetailentity)
{
try
{
Connection.Open();
SqlParameter[] sqlparams = {
new SqlParameter ("@RecruiterID",professionaldetailentity.RecruiterID),
new SqlParameter("@TotalExprience",professionaldetailentity.TotalExprience),
new SqlParameter ("@Designation",professionaldetailentity.Designation),
new SqlParameter("@Freelancer",professionaldetailentity.Freelancer),
new SqlParameter("@EmploymentStaus",professionaldetailentity.EmploymentStaus),
new SqlParameter("@jobtype",professionaldetailentity.jobtype)
};
return SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, Constants.sp_RE_InsertProfessionalDetails, sqlparams);
}
catch (Exception)
{
throw;
}
}
public void UpdateRoleSkillsBAL(ProfessionalDetailsEntity professionalDetailsentity)
{
ProfessionalDetailsDAL professionalDetailDAL = new ProfessionalDetailsDAL();
professionalDetailDAL.UpdateRoleSkillsDAL(professionalDetailsentity);
}
public int InsertDetails(ProfessionalDetailsEntity professionaldetailentity)
{
ProfessionalDetailsDAL professionaldetailDAL = new ProfessionalDetailsDAL();
return professionaldetailDAL.InsertDetails(professionaldetailentity);
}
public void AddTechnicalSkillBAL(ProfessionalDetailsEntity professionalDetailentity)
{
ProfessionalDetailsDAL professionalDetailDAL = new ProfessionalDetailsDAL();
professionalDetailDAL.AddTechnicalSkillDAL(professionalDetailentity);
}
public void AddRoleSkills(ProfessionalDetailsEntity professionalDetailentity)
{
ProfessionalDetailsDAL professionalDetailDAL = new ProfessionalDetailsDAL();
professionalDetailDAL.AddRoleSkills(professionalDetailentity);
}