how to insert data in data base using stored procedure

public int AddPayout(int theaterid, DateTime sdate, DateTime edate, int total, int arears, int dues, int cheque_amt, string cheque_num, string comments, DateTime dt)
    {
       

        con.Open();
        cmd = new SqlCommand("spAddPayout", con);
        cmd.CommandType = CommandType.StoredProcedure;
        SqlParameter[] parms = new SqlParameter[10];
        parms[0] = cmd.Parameters.Add("@theaterid", SqlDbType.Int, 4);
        parms[0].Value = theaterid;
        parms[1] = cmd.Parameters.Add("@sdate ", SqlDbType.DateTime, 8);
        parms[1].Value = sdate.ToString();
        parms[2] = cmd.Parameters.Add("@edate", SqlDbType.DateTime, 8);
        parms[2].Value = edate.ToString();
        parms[3] = cmd.Parameters.Add("@total  ", SqlDbType.Int, 4);
        parms[3].Value = total;
        parms[4] = cmd.Parameters.Add("@arears  ", SqlDbType.Int, 4);
        parms[4].Value = arears;
        parms[5] = cmd.Parameters.Add("@dues  ", SqlDbType.Int, 4);
        parms[5].Value = dues;
        parms[6] = cmd.Parameters.Add("@cheque_amt ", SqlDbType.Int, 4);
        parms[6].Value = cheque_amt;
        parms[7] = cmd.Parameters.Add("@cheque_num ", SqlDbType.NVarChar, 50);
        parms[7].Value = cheque_num.ToString();
        parms[8] = cmd.Parameters.Add("@comments ", SqlDbType.NVarChar, 50);
        parms[8].Value = comments.ToString();
        parms[9] = cmd.Parameters.Add("@dt ", SqlDbType.DateTime, 8);
        parms[9].Value = dt.ToString();
        int i=cmd.ExecuteNonQuery();
        con.Close();
        return i;
    }