public void RemoveAppliedJob(int id)
{
string spName = "[RemoveAppliedJob]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
CommonDal.Crud(spName, sqlParameters.ToArray());
}
public void DeleteLanguage(int id)
{
string spName = "[DeleteLanguage]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
CommonDal.Crud(spName, sqlParameters.ToArray());
}
public void AddResume(User ObjUser)
{
string spName = "[UploadResume]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, ObjUser.id));
sqlParameters.Add(DBClient.AddParameters("resume", SqlDbType.VarChar, ObjUser.Resume));
sqlParameters.Add(DBClient.AddParameters("resume_path", SqlDbType.VarChar, ObjUser.resume_path));
CommonDal.Crud(spName, sqlParameters.ToArray());
}
public void EditLanguage(Language Objlanguage, int id)
{
string spName = "[EditLanguage]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, Objlanguage.id));
sqlParameters.Add(DBClient.AddParameters("user_id", SqlDbType.Int, id));
sqlParameters.Add(DBClient.AddParameters("language", SqlDbType.Int, Objlanguage.language));
sqlParameters.Add(DBClient.AddParameters("proficiency", SqlDbType.Int, Objlanguage.proficiency));
CommonDal.Crud(spName, sqlParameters.ToArray());
}
public void EditEducation(Education ObjEducation, int id)
{
string spName = "[EditEducation]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, ObjEducation.id));
sqlParameters.Add(DBClient.AddParameters("user_id", SqlDbType.Int, id));
sqlParameters.Add(DBClient.AddParameters("Degree_Level", SqlDbType.VarChar, ObjEducation.Degree_Level));
sqlParameters.Add(DBClient.AddParameters("Degree_Title", SqlDbType.VarChar, ObjEducation.Degree_Title));
sqlParameters.Add(DBClient.AddParameters("Major_Subject", SqlDbType.VarChar, ObjEducation.Major_Subject));
sqlParameters.Add(DBClient.AddParameters("Institution", SqlDbType.VarChar, ObjEducation.Institution));
sqlParameters.Add(DBClient.AddParameters("Completion_Year", SqlDbType.VarChar, ObjEducation.Completion_Year));
CommonDal.Crud(spName, sqlParameters.ToArray());
}
public void AddExperienceM(AddExperienceModel ObjExperience, int id)
{
string spName = "[AddExperience]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("u_id", SqlDbType.Int, id));
sqlParameters.Add(DBClient.AddParameters("job_title", SqlDbType.VarChar, ObjExperience.job_title));
sqlParameters.Add(DBClient.AddParameters("company", SqlDbType.VarChar, ObjExperience.company));
sqlParameters.Add(DBClient.AddParameters("starting_month", SqlDbType.VarChar, ObjExperience.starting_month));
sqlParameters.Add(DBClient.AddParameters("starting_year", SqlDbType.VarChar, ObjExperience.starting_year));
sqlParameters.Add(DBClient.AddParameters("ending_month", SqlDbType.VarChar, ObjExperience.ending_month));
sqlParameters.Add(DBClient.AddParameters("ending_year", SqlDbType.VarChar, ObjExperience.ending_year));
sqlParameters.Add(DBClient.AddParameters("description ", SqlDbType.VarChar, ObjExperience.description));
sqlParameters.Add(DBClient.AddParameters("currently_working_here", SqlDbType.Bit, ObjExperience.currently_working_here));
CommonDal.Crud(spName, sqlParameters.ToArray());
}