Пример #1
0
    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;
        }
    }
Пример #2
0
    public int AddRecordSubBLL(EventMain_IDBLL objMain_IDBLL)
    {
        int i = objMain_IDDAL.AddRecordSubID(objMain_IDBLL);

        return(i);
    }