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 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 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);
}
