Пример #1
0
    public int AddRecord(JPostRequirmentBLL JCRB)
    {
        //SqlCommand cmd = new SqlCommand();
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Connectionstring"]);

        //cmd.Connection = con;
        SqlParameter[] par = new SqlParameter[]
        {
            new SqlParameter("@CName", JCRB.CName1),
            new SqlParameter("@InSector", JCRB.InSector1), new SqlParameter("@JRole", JCRB.JRole1),
            new SqlParameter("@Qualification", JCRB.Qualification1), new SqlParameter("@Skill", JCRB.Skill1),
            new SqlParameter("@JRequirment", JCRB.JRequirment1), new SqlParameter("@VaccancyTill", JCRB.VaccancyTill1),
            new SqlParameter("@SalaryOffered", JCRB.SalaryOffered1), new SqlParameter("@FreExp", JCRB.FreExp1),
            new SqlParameter("@TrainingOffered", JCRB.TrainingOffered1), new SqlParameter("@EntryDate", JCRB.EntryDate1),
            new SqlParameter("@UserId", JCRB.UserId1)
        };
        SqlCommand cmd = new SqlCommand("uspInsertJPostReqMyct", con);

        cmd.Parameters.AddRange(par);
        cmd.CommandType = CommandType.StoredProcedure;
        SqlDataAdapter da = new SqlDataAdapter(cmd);

        con.Open();
        int result = cmd.ExecuteNonQuery();

        return(result);
    }
Пример #2
0
    //public DataSet LoadgridBLL(BExpEntriesBLL objBExpEntriesBLL)
    //{
    //    return objBExpEntriesDAL.LoadGrid(objBExpEntriesBLL);

    //}
    public int AddRecordBLL(JPostRequirmentBLL objJPostReqBLL)
    {
        int k = objJPostReqDAL.AddRecord(objJPostReqBLL);

        return(k);
    }