internal int UpdateCandidateInfo(PGI_CandidateInfo obj_candidate, string getUserCode)
{
query = "UPDATE PGI_CandidateInfo SET UserFirstName ='" + obj_candidate.UserFirstName + "',UserLastName ='" + obj_candidate.UserLastName + "',UserPhoto= '" + obj_candidate.UserPhoto + "',GoogleConnected= '" + obj_candidate.GoogleConnected + "' ,GoogleID= '" + obj_candidate.GoogleID + "' WHERE UserCode='" + getUserCode + "'";
return(ExecuteNonQuery(query));
}
internal static int UpdateCandidateInfo(PGI_CandidateInfo obj_candidate, string getUserCode)
{
return(new CandidateGateway().UpdateCandidateInfo(obj_candidate, getUserCode));
}
internal int InsertCandidate(PGI_CandidateInfo obj_Candidate)
{
query = @"INSERT INTO PGI_CandidateInfo (UserCode,UserFirstName,UserLastName,UserEmail,UserPhoneNo,UserPassword,role,UserResume) VALUES ('" + obj_Candidate.UserCode + "','" + obj_Candidate.UserFirstName + "','" + obj_Candidate.UserLastName + "','" + obj_Candidate.UserEmail + "','" + obj_Candidate.UserPhoneNo + "','" + obj_Candidate.UserPassword + "','" + obj_Candidate.role + "','" + obj_Candidate.UserResume + "')";
return(ExecuteNonQuery(query));
}
internal static int InsertCandidate(PGI_CandidateInfo obj_Candidate)
{
return(new CandidateGateway().InsertCandidate(obj_Candidate));
}