public User UpdateUserBL(User objUserBL) // passing Bussiness object Here
{
string spName = "[UpdateInfo]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.VarChar, objUserBL.id));
sqlParameters.Add(DBClient.AddParameters("firstname", SqlDbType.VarChar, objUserBL.FirstName));
sqlParameters.Add(DBClient.AddParameters("lastname", SqlDbType.VarChar, objUserBL.LastName));
sqlParameters.Add(DBClient.AddParameters("email", SqlDbType.VarChar, objUserBL.Email));
sqlParameters.Add(DBClient.AddParameters("phone", SqlDbType.VarChar, objUserBL.Mobile_no));
sqlParameters.Add(DBClient.AddParameters("dob", SqlDbType.VarChar, objUserBL.Dob));
sqlParameters.Add(DBClient.AddParameters("age", SqlDbType.VarChar, objUserBL.Age));
sqlParameters.Add(DBClient.AddParameters("path", SqlDbType.VarChar, objUserBL.Profile_picture_path));
sqlParameters.Add(DBClient.AddParameters("category", SqlDbType.VarChar, objUserBL.Category));
sqlParameters.Add(DBClient.AddParameters("title", SqlDbType.VarChar, objUserBL.Job_title));
sqlParameters.Add(DBClient.AddParameters("experience", SqlDbType.VarChar, objUserBL.Experience));
sqlParameters.Add(DBClient.AddParameters("skills", SqlDbType.VarChar, objUserBL.Skills));
sqlParameters.Add(DBClient.AddParameters("currentsalary", SqlDbType.VarChar, objUserBL.Current_salary));
sqlParameters.Add(DBClient.AddParameters("expectedsalary", SqlDbType.VarChar, objUserBL.Expected_salary));
sqlParameters.Add(DBClient.AddParameters("state", SqlDbType.VarChar, objUserBL.State));
sqlParameters.Add(DBClient.AddParameters("city", SqlDbType.VarChar, objUserBL.City));
sqlParameters.Add(DBClient.AddParameters("address", SqlDbType.VarChar, objUserBL.Address));
User updateinfo = CommonDal.SelectObject <User>(spName, sqlParameters.ToArray());
return(updateinfo);
}
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 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 Language GetLanguage_By_id(int id)
{
string spName = "[GetLanguage_by_id]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
Language jobData = CommonDal.SelectObject <Language>(spName, sqlParameters.ToArray());
return(jobData);
}
public List <Language> GetLanguages(int id)
{
string spName = "[GetLanguage]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.VarChar, Convert.ToInt32(id)));
List <Language> jobData = CommonDal.ExecuteProcedure <Language>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
public User GetData(int id)
{
string spName = "[GetData]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
User jobData = CommonDal.SelectObject <User>(spName, sqlParameters.ToArray());
return(jobData);
}
public Education GetEducation_By_id(int id)
{
string spName = "[GetEducation_by_id]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
Education jobData = CommonDal.SelectObject <Education>(spName, sqlParameters.ToArray());
return(jobData);
}
public List <Education> FetchEducation(int id)
{
string spName = "[GetEducation]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
List <Education> jobData = CommonDal.ExecuteProcedure <Education>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
public List <Category> GetCategory(int id)
{
string spName = "[FetchCategories]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
IList <Category> roleList = CommonDal.ExecuteProcedure <Category>(spName, sqlParameters.ToArray());
return(roleList.ToList());
}
public JobPost GetJobPost_by_id(int id)
{
string spName = "[GetPostJobInfo_By_id]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
JobPost jobData = CommonDal.SelectObject <JobPost>(spName, sqlParameters.ToArray());
return(jobData);
}
public User GetForgotPassword(User ObjUser)
{
string spName = "[ForGotPassword]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("Email", SqlDbType.VarChar, ObjUser.Email));
User jobData = CommonDal.SelectObject <User>(spName, sqlParameters.ToArray());
return(jobData);
}
public List <JobPost> GetAppliedJob_byId(int id)
{
string spName = "[FetchAppliedJob]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("u_id", SqlDbType.VarChar, Convert.ToInt32(id)));
List <JobPost> jobData = CommonDal.ExecuteProcedure <JobPost>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
public List <JobPost> GetJobBy_LocationId(int id)
{
string spName = "[FetchJobByLocationId]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("s_id", SqlDbType.Int, id));
List <JobPost> jobData = CommonDal.ExecuteProcedure <JobPost>(spName, sqlParameters.ToArray()).ToList();
return(jobData);
}
public Company GetCompany_by_id(int id)
{
string spName = "[GetCompanyInfo_By_id]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
Company company = CommonDal.SelectObject <Company>(spName, sqlParameters.ToArray());
return(company);
}
public AddExperienceModel GetExperience_Byid(int id)
{
string spName = "[GetExperience_by_id]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
AddExperienceModel jobData = CommonDal.SelectObject <AddExperienceModel>(spName, sqlParameters.ToArray());
return(jobData);
}
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 DataSet savedJob(int u_id, int job_id)
{
string spName = "[savedjob]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("u_id", SqlDbType.Int, u_id));
sqlParameters.Add(DBClient.AddParameters("job_id", SqlDbType.Int, job_id));
DataSet ds = CommonDal.ExecuteDataSet(spName, sqlParameters.ToArray());
return(ds);
}
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 User ChangePassword(string nPassword, int id)
{
string spName = "[ChnagePassword]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id));
sqlParameters.Add(DBClient.AddParameters("password", SqlDbType.VarChar, nPassword));
User jobData = CommonDal.SelectObject <User>(spName, sqlParameters.ToArray());
return(jobData);
}
public DataSet AppliedJob(int u_id, int job_id, int c_id, string msg)
{
string spName = "[AppliedJob]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("u_id", SqlDbType.Int, u_id));
sqlParameters.Add(DBClient.AddParameters("job_id", SqlDbType.Int, job_id));
sqlParameters.Add(DBClient.AddParameters("c_id", SqlDbType.Int, c_id));
sqlParameters.Add(DBClient.AddParameters("msg", SqlDbType.VarChar, msg));
DataSet ds = CommonDal.ExecuteDataSet(spName, sqlParameters.ToArray());
return(ds);
}
public DataSet SendContact(string username, string email, string subject, string message)
{
string spName = "[SendContact]";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(DBClient.AddParameters("username", SqlDbType.VarChar, username));
sqlParameters.Add(DBClient.AddParameters("email", SqlDbType.VarChar, email));
sqlParameters.Add(DBClient.AddParameters("subject", SqlDbType.VarChar, subject));
sqlParameters.Add(DBClient.AddParameters("message", SqlDbType.VarChar, message));
DataSet ds = CommonDal.ExecuteDataSet(spName, sqlParameters.ToArray());
return(ds);
}
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());
}