public JsonResult DisplayJob()
{
string query = "select job_id,job_info,left(job_description,200) as job_description,jobtype,location from job_description ";
_Employee_CURD = new Employee_CURD();
var data = _Employee_CURD.GetJodDetails(query);
return(new JsonResult {
Data = data, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult CheckEmail(string EmployeeEmail)
{
Query = "select email from candidates where email='" + EmployeeEmail + "'";
_Employee_CURD = new Employee_CURD();
_DataSet = _Employee_CURD.GetDetails(Query);
if (_DataSet.Tables["Table"].Rows.Count <= 0)
{
message = "Fail";
return(new JsonResult {
Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
else
{
message = "success";
return(new JsonResult {
Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult GetEmployeeDetails()
{
EmployeeEmail = Session["UserEmail"].ToString();
_Employee = new Employee();
// string CurrentRole, Firstname, Lastname, Email,City;
Query = "select * from candidates where email='" + EmployeeEmail + "'";
_Employee_CURD = new Employee_CURD();
_DataSet = _Employee_CURD.GetDetails(Query);
var data = new
{
About = _DataSet.Tables["Table"].Rows[0]["profilesummary"].ToString(),
CurrentRole = _DataSet.Tables["Table"].Rows[0]["CurrentRole"].ToString(),
Firstname = _DataSet.Tables["Table"].Rows[0]["FirstName"].ToString(),
Lastname = _DataSet.Tables["Table"].Rows[0]["LastName"].ToString(),
Email = _DataSet.Tables["Table"].Rows[0]["Email"].ToString(),
City = _DataSet.Tables["Table"].Rows[0]["City"].ToString(),
};
if (_DataSet.Tables["Table"].Rows.Count <= 0)
{
message = "Invalid Credentials";
return(new JsonResult {
Data = data, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
else
{
message = "success";
return(new JsonResult {
Data = data, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult UpdateEmployeeDetails(string About, string CurrentRole, string Firstname, string Lastname, string email, string city)
{
bool result;
_Employee = new Employee();
Query = "update candidates set profilesummary='" + About + "',CurrentRole='" + CurrentRole + "',firstname='" + Firstname + "',lastname='" + Lastname + "',email='" + email + "',city='" + city + "'";
_Employee_CURD = new Employee_CURD();
result = _Employee_CURD.UpdateData(Query);
if (result == true)
{
message = "Data Updated seccesfully";
return(new JsonResult {
Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
else
{
message = "Something Went Wrong";
return(new JsonResult {
Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
