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