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); }
//public DataSet LoadgridBLL(BExpEntriesBLL objBExpEntriesBLL) //{ // return objBExpEntriesDAL.LoadGrid(objBExpEntriesBLL); //} public int AddRecordBLL(JPostRequirmentBLL objJPostReqBLL) { int k = objJPostReqDAL.AddRecord(objJPostReqBLL); return(k); }