Example #1
0
    public int BLLInsertSearchJobInfo(clsJobPortal objJobPortal)
    {
        using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]))
        {
            try
            {
                SqlParameter[] par = new SqlParameter[10];

                par[0]           = new SqlParameter("@CategoryId", objJobPortal.Category);
                par[1]           = new SqlParameter("@JobTypeId", objJobPortal.JobTypeId);
                par[2]           = new SqlParameter("@ExpYear", objJobPortal.ExpYear);
                par[3]           = new SqlParameter("@ExpMonths", objJobPortal.ExpMonths);
                par[4]           = new SqlParameter("@Salary", objJobPortal.Salary);
                par[5]           = new SqlParameter("@Stateid", objJobPortal.State);
                par[6]           = new SqlParameter("@Distid", objJobPortal.Dist);
                par[7]           = new SqlParameter("@CityName", objJobPortal.CityName);
                par[8]           = new SqlParameter("@usrMobileNo", objJobPortal.usrMobileNo);
                par[9]           = new SqlParameter("@Status", 10);
                par[9].Direction = ParameterDirection.Output;

                SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "Insert_In_SearchJobInfo", par);
                status = (int)par[9].Value;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
            }
        }
        return(status);
    }
Example #2
0
    public DataTable DALJobSelectByCategoryId(clsJobPortal Job, int Cid)
    {
        List <clsJobPortal> dtList = new List <clsJobPortal>();


        using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
        {
            try
            {
                SqlParameter[] par = new SqlParameter[2];
                par[0] = new SqlParameter("@Categoryid", Cid);

                ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "spJobSelectByCategoryId", par);
            }

            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
            }
        }
        return(ds.Tables[0]);
    }
Example #3
0
    public DataSet BLLLoadCategory(clsJobPortal Job)
    {
        string Sql = "Select * from Functions";

        DataSet ds = cc.ExecuteDataset(Sql);

        return(ds);
    }
Example #4
0
    public int BLLInsertPostJobInfo(clsJobPortal objJobPortal)
    {
        using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]))
        {
            try
            {
                SqlParameter[] par = new SqlParameter[15];


                par[0] = new SqlParameter("@Category", objJobPortal.Category);

                par[1]  = new SqlParameter("@JobTypeId", objJobPortal.JobTypeId);
                par[2]  = new SqlParameter("@ExpYear", objJobPortal.ExpYear);
                par[3]  = new SqlParameter("@ExpMonths", objJobPortal.ExpMonths);
                par[4]  = new SqlParameter("@Salary", objJobPortal.Salary);
                par[5]  = new SqlParameter("@State", objJobPortal.State);
                par[6]  = new SqlParameter("@Dist", objJobPortal.Dist);
                par[7]  = new SqlParameter("@Cityid", objJobPortal.Cityid);
                par[8]  = new SqlParameter("@UserId", objJobPortal.UserId);
                par[9]  = new SqlParameter("@Qualification", objJobPortal.Qualification);
                par[10] = new SqlParameter("@Designation", objJobPortal.Designation);
                par[11] = new SqlParameter("@CompanyName", objJobPortal.companyName);
                par[12] = new SqlParameter("@EmpRequired", objJobPortal.EmpRequired);

                par[13]           = new SqlParameter("@pin", objJobPortal.Pincode);
                par[14]           = new SqlParameter("@Status", 15);
                par[14].Direction = ParameterDirection.Output;

                SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "Insert_JobpostInfo", par);
                status = (int)par[14].Value;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
            }
        }
        return(status);
    }
Example #5
0
 public int BLLInsertPostJobInfo(clsJobPortal objJobPortal)
 {
     status = objjob.BLLInsertPostJobInfo(objJobPortal);
     return(status);
 }
Example #6
0
    public DataTable BLLGetSelectedJobBySId(clsJobPortal Job, int i)
    {
        DataTable dtJobSelectByCategoryId = objjob.DALJobSelectByCategoryId(Job, i);

        return(dtJobSelectByCategoryId);
    }