public int AddRecordSubID(EventMain_IDBLL SPSI) { int row1; SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); DataSet ds = new DataSet(); try { SqlParameter[] par = new SqlParameter[] { new SqlParameter("@Name", SPSI.Name1), new SqlParameter("@Description", SPSI.Description1), new SqlParameter("@UserId", SPSI.UserId1) }; SqlCommand cmd = new SqlCommand("EventSub_IDInsert", con); cmd.Parameters.AddRange(par); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); con.Open(); row1 = cmd.ExecuteNonQuery(); return(row1); } catch (Exception ex) { throw ex; } }
public int AddRecordSubBLL(EventMain_IDBLL objMain_IDBLL) { int i = objMain_IDDAL.AddRecordSubID(objMain_IDBLL); return(i); }